/// <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);
}
