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