public ReturnValue Update(Province model) { OleDbParameter[] parameters = { new OleDbParameter("@Name", OleDbType.VarWChar,50), new OleDbParameter("@Code", OleDbType.VarWChar,10),}; parameters[0].Value = model.Name; parameters[1].Value = model.Code; return OleDbHelper.ExecuteSql(Update_SQL, parameters); }
public ReturnValue Add(Province model) { OleDbParameter[] parameters = { new OleDbParameter("@UPDATER_ID", OleDbType.VarWChar,12), new OleDbParameter("@TERMINAL_CD", OleDbType.LongVarWChar), new OleDbParameter("@Code", OleDbType.VarWChar,10), new OleDbParameter("@Name", OleDbType.VarWChar,50)}; parameters[0].Value = model.UPDATER_ID; parameters[1].Value = model.TERMINAL_CD; parameters[2].Value = model.Code; parameters[3].Value = model.Name; return OleDbHelper.ExecuteSql(Add_SQL, parameters); }
public ReturnValue Update(Province model) { SqlParameter[] parameters = { new SqlParameter("@UPDATER_ID", SqlDbType.NVarChar,12), new SqlParameter("@TERMINAL_CD", SqlDbType.NVarChar,255), new SqlParameter("@Name", SqlDbType.NVarChar,50), new SqlParameter("@Code", SqlDbType.NVarChar,50),}; parameters[0].Value = model.UPDATER_ID; parameters[1].Value = model.TERMINAL_CD; parameters[2].Value = model.Name; parameters[3].Value = model.Code; return SqlHelper.ExecuteSql(Update_SQL, parameters); }
/// <summary> /// /// </summary> /// <param name="model"></param> /// <returns></returns> public ReturnValue AddUpdate(Province model) { ReturnValue resoult = dalProvince.Search(model.Code); if (!resoult.ErrorFlag) { return resoult; } if (resoult.Count > 0) { resoult = dalProvince.Update(model); } else { resoult = dalProvince.Add(model); } return resoult; }