コード例 #1
0
        /// <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);
            }
        }