/// <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); } } }
/// <summary> ///添加记录 /// </summary> /// <param name="UserBank"></param> /// <returns></returns> public int GetInsert(M_UserBank model) { return(DBCenter.Insert(model)); }
/// <summary> ///更新记录 /// </summary> /// <param name="UserBank"></param> /// <returns></returns> public bool GetUpdate(M_UserBank model) { return(DBCenter.UpdateByID(model, model.Bank_ID)); }
/// <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())); }