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