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