Exemple #1
0
        /// <summary>
        ///不存在则添加否则更新
        /// </summary>
        /// <param name="UserBank"></param>
        /// <returns></returns>
        public bool InsertUpdate(M_UserBank userBank)
        {
            DataTable dt = SqlHelper.ExecuteTable(CommandType.Text, "Select * From " + TbName + " Where Bank_ID=" + userBank.Bank_ID);

            if (dt.Rows.Count > 0)
            {
                return(GetUpdate(userBank));
            }
            else
            {
                if (GetInsert(userBank) > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
        }
Exemple #2
0
 /// <summary>
 ///添加记录
 /// </summary>
 /// <param name="UserBank"></param>
 /// <returns></returns>
 public int GetInsert(M_UserBank model)
 {
     return(DBCenter.Insert(model));
 }
Exemple #3
0
 /// <summary>
 ///更新记录
 /// </summary>
 /// <param name="UserBank"></param>
 /// <returns></returns>
 public bool GetUpdate(M_UserBank model)
 {
     return(DBCenter.UpdateByID(model, model.Bank_ID));
 }
Exemple #4
0
 /// <summary>
 ///更新记录
 /// </summary>
 /// <param name="UserBank"></param>
 /// <returns></returns>
 public bool GetUpdate(M_UserBank model)
 {
     return(Sql.UpdateByIDs(TbName, PK, model.Bank_ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
 }