/// <summary> /// 修改默认银行卡 /// </summary> public bool SetDefault(int userBankId, int userId, int editId) { List <String> tsql = new List <String>(); StringBuilder tableSql = new StringBuilder(); tableSql.AppendFormat("update UserBank set IsDefault=0,EditId={0},EditDate='{1}' where UserId={2}", editId, DateTime.Now, userId); tsql.Add(tableSql.ToString()); tableSql = new StringBuilder(); tableSql.AppendFormat("update UserBank set IsDefault=1,EditId={0},EditDate='{1}' where UserBankId={2}", editId, DateTime.Now, userBankId); tsql.Add(tableSql.ToString()); int rows = BWJSHelperSQL.ExecuteSqlTran(tsql); if (rows > 0) { return(true); } else { return(false); } }