try

             {

                 DBUtility.CommandInfo dbcom = new DBUtility.CommandInfo();

                 List<DBUtility.CommandInfo> strStranList = new List<DBUtility.CommandInfo>();             

                 StringBuilder strSql = new StringBuilder();

                 strSql.Append("Update Jia72_Members Set ");

                 strSql.Append("UserName=@UserName,");

                 strSql.Append("YTCardId=@YTCardId,");

                 strSql.Append("CardNum=@CardNum,");

                 strSql.Append("Bank=@Bank,");

                 strSql.Append("BankNumber=@BankNumber,");

                 strSql.Append("QQNumber=@QQNumber,");

                 strSql.Append("RealName=@RealName,");

                 strSql.Append("SavedOn=@SavedOn");

                 strSql.Append(" Where Id=@Id ");

                 string strSQLM = strSql.ToString();

                 SqlParameter[] parameters = {

                     new SqlParameter("@Id",SqlDbType.Int,),

                     new SqlParameter("@UserName",SqlDbType.NVarChar,),

                     new SqlParameter("@YTCardId",SqlDbType.Int,),

                     new SqlParameter("@CardNum",SqlDbType.NVarChar,),

                     new SqlParameter("@Bank",SqlDbType.NVarChar,),

                     new SqlParameter("@BankNumber",SqlDbType.NVarChar,),

                     new SqlParameter("@QQNumber",SqlDbType.NVarChar,),

                     new SqlParameter("@RealName",SqlDbType.NVarChar,),

                     new SqlParameter("@SavedOn",SqlDbType.DateTime)

                      };

                 parameters[].Value = model.Id;

                 parameters[].Value = model.UserName;

                 parameters[].Value = model.YTCardId;

                 parameters[].Value = model.CardNum;

                 parameters[].Value = model.Bank;

                 parameters[].Value = model.BankNumber;

                 parameters[].Value = model.QQNumber;

                 parameters[].Value = model.RealName;

                 parameters[].Value = model.SavedOn;

                 dbcom.CommandText = strSql.ToString();

                 dbcom.Parameters = parameters;

                 strStranList.Add(dbcom);//绑定会员信息              

                 //更新卡表

                 strSql.Clear();

                 strSql.Append("update Jia72_YTCard set ");

                 strSql.Append("IsBind=1,");

                 strSql.Append("SavedOn=getdate()");

                 strSql.Append(" where Id=" + model.YTCardId);

                 dbcom.CommandText = strSql.ToString();

                 dbcom.Parameters = null;

                 strStranList.Add(dbcom);//更新卡表绑定            

                 if (DBUtility.DbHelperSQL.ExecuteSqlTran(strStranList) > )

                 {

                     DotNet.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "UserManages.aspx");

                 }

                 else

                 {

                     MessageBox.Show(this, "操作失败,请联系管理员!");

                 }

             }

             catch (Exception ex)

             {

                 LogHelper.WriteWebExLogInfo(this, ex);

                 MessageBox.Show(this, "操作失败,请联系管理员!");

                 return;

             }