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