/// <summary> /// 更新一条数据 /// </summary> public DataTable Update(string GUID, string UID, string id, string stocode, string buscode, string remake, string sort, string cuser, string uuser, string status, operatelogEntity entity) { if (!CheckLogin(GUID, UID)) //非法登录 { return(dtBase); } dtBase.Clear(); string spanids = string.Empty; string strReturn = CheckPageInfo("update", id, stocode, buscode, remake, sort, cuser, uuser, status, out spanids); //数据页面验证 if (!CheckControl(strReturn, spanids)) { return(dtBase); } //获取更新前的数据对象 WX_reserveremakeEntity OldEntity = new WX_reserveremakeEntity(); OldEntity = GetEntitySigInfo(" where id='" + id + "'"); //更新数据 int result = dal.Update(Entity); //检测执行结果 if (CheckResult(result)) { //写日志 if (entity != null) { blllog.Add <WX_reserveremakeEntity>(entity, Entity, OldEntity); } } return(dtBase); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(WX_reserveremakeEntity Entity) { SqlParameter[] sqlParameters = { new SqlParameter("@id", Entity.id), new SqlParameter("@stocode", Entity.stocode), new SqlParameter("@buscode", Entity.buscode), new SqlParameter("@remake", Entity.remake), new SqlParameter("@sort", Entity.sort), new SqlParameter("@cuser", Entity.cuser), new SqlParameter("@uuser", Entity.uuser), new SqlParameter("@status", Entity.status), }; return(DBHelper.ExecuteNonQuery("dbo.p_WX_reserveremake_Update", CommandType.StoredProcedure, sqlParameters)); }
/// <summary> /// 单行数据转实体对象 /// </summary> /// <param name="dr"></param> /// <returns></returns> private WX_reserveremakeEntity SetEntityInfo(DataRow dr) { WX_reserveremakeEntity Entity = new WX_reserveremakeEntity(); Entity.id = Helper.StringToInt(dr["id"].ToString()); Entity.stocode = dr["stocode"].ToString(); Entity.buscode = dr["buscode"].ToString(); Entity.remake = dr["remake"].ToString(); Entity.sort = Helper.StringToInt(dr["sort"].ToString()); Entity.cuser = Helper.StringToLong(dr["cuser"].ToString()); Entity.uuser = Helper.StringToLong(dr["uuser"].ToString()); Entity.status = dr["status"].ToString(); return(Entity); }
/// <summary> /// 检验表单数据 /// </summary> /// <returns></returns> public string CheckPageInfo(string type, string id, string stocode, string buscode, string remake, string sort, string cuser, string uuser, string status, out string spanids) { string strRetuen = string.Empty; spanids = string.Empty; //要验证的实体属性 List <string> EName = new List <string>() { }; //要验证的实体属性值 List <string> EValue = new List <string>() { }; //错误信息 List <string> errorCode = new List <string>(); List <string> ControlName = new List <string>(); //验证数据 CheckValue <WX_reserveremakeEntity>(EName, EValue, ref errorCode, ref ControlName, new WX_reserveremakeEntity()); //特殊验证写在下面 if (errorCode.Count > 0) { strRetuen = ErrMessage.GetMessageInfoByListCode(errorCode); spanids = ListTostring(ControlName); } else//组合对象数据 { Entity = new WX_reserveremakeEntity(); Entity.id = Helper.StringToInt(id); Entity.stocode = stocode; Entity.buscode = buscode; Entity.remake = remake; Entity.sort = Helper.StringToInt(sort); Entity.cuser = Helper.StringToLong(cuser); Entity.uuser = Helper.StringToLong(uuser); Entity.status = status; } return(strRetuen); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ref WX_reserveremakeEntity Entity) { intReturn = 0; SqlParameter[] sqlParameters = { new SqlParameter("@id", Entity.id), new SqlParameter("@stocode", Entity.stocode), new SqlParameter("@buscode", Entity.buscode), new SqlParameter("@remake", Entity.remake), new SqlParameter("@sort", Entity.sort), new SqlParameter("@cuser", Entity.cuser), new SqlParameter("@uuser", Entity.uuser), new SqlParameter("@status", Entity.status), }; sqlParameters[0].Direction = ParameterDirection.Output; intReturn = DBHelper.ExecuteNonQuery("dbo.p_WX_reserveremake_Add", CommandType.StoredProcedure, sqlParameters); if (intReturn == 0) { Entity.id = int.Parse(sqlParameters[0].Value.ToString()); } return(intReturn); }