/// <summary>
/// 更新一条数据
/// </summary>
public DataTable Update(string GUID, string UID, string setreservationid, string stocode, string buscode, string ttcode, string maxdeposit, string methoddeposit, string nolimitdate, string daydeposit, string Duetype, 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", setreservationid, stocode, buscode, ttcode, maxdeposit, methoddeposit, nolimitdate, daydeposit, Duetype, remark, status, cuser, uuser, btime, etime, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
//获取更新前的数据对象
WX_setreservationEntity OldEntity = new WX_setreservationEntity();
OldEntity = GetEntitySigInfo(" where setreservationid='" + setreservationid + "'");
//更新数据
int result = dal.Update(Entity);
//检测执行结果
if (CheckResult(result))
{
//写日志
if (entity != null)
{
blllog.Add <WX_setreservationEntity>(entity, Entity, OldEntity);
}
}
return(dtBase);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref WX_setreservationEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@setreservationid", Entity.setreservationid),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@ttcode", Entity.ttcode),
new SqlParameter("@maxdeposit", Entity.maxdeposit),
new SqlParameter("@methoddeposit", Entity.methoddeposit),
new SqlParameter("@nolimitdate", Entity.nolimitdate),
new SqlParameter("@daydeposit", Entity.daydeposit),
new SqlParameter("@Duetype", Entity.Duetype),
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_setreservation_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.setreservationid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 检验表单数据
/// </summary>
/// <returns></returns>
public string CheckPageInfo(string type, string setreservationid, string stocode, string buscode, string ttcode, string maxdeposit, string methoddeposit, string nolimitdate, string daydeposit, string Duetype, 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_setreservationEntity>(EName, EValue, ref errorCode, ref ControlName, new WX_setreservationEntity());
//特殊验证写在下面
if (errorCode.Count > 0)
{
strRetuen = ErrMessage.GetMessageInfoByListCode(errorCode);
spanids = ListTostring(ControlName);
}
else//组合对象数据
{
Entity = new WX_setreservationEntity();
Entity.setreservationid = Helper.StringToInt(setreservationid);
Entity.stocode = stocode;
Entity.buscode = buscode;
Entity.ttcode = ttcode;
Entity.maxdeposit = Helper.StringToInt(maxdeposit);
Entity.methoddeposit = methoddeposit;
Entity.nolimitdate = Helper.StringToInt(nolimitdate);
Entity.daydeposit = Helper.StringToInt(daydeposit);
Entity.Duetype = Duetype;
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_setreservationEntity Entity)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@setreservationid", Entity.setreservationid),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@ttcode", Entity.ttcode),
new SqlParameter("@maxdeposit", Entity.maxdeposit),
new SqlParameter("@methoddeposit", Entity.methoddeposit),
new SqlParameter("@nolimitdate", Entity.nolimitdate),
new SqlParameter("@daydeposit", Entity.daydeposit),
new SqlParameter("@Duetype", Entity.Duetype),
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_setreservation_Update", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 单行数据转实体对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private WX_setreservationEntity SetEntityInfo(DataRow dr)
{
WX_setreservationEntity Entity = new WX_setreservationEntity();
Entity.setreservationid = Helper.StringToInt(dr["setreservationid"].ToString());
Entity.stocode = dr["stocode"].ToString();
Entity.buscode = dr["buscode"].ToString();
Entity.ttcode = dr["ttcode"].ToString();
Entity.maxdeposit = Helper.StringToInt(dr["maxdeposit"].ToString());
Entity.methoddeposit = dr["methoddeposit"].ToString();
Entity.nolimitdate = Helper.StringToInt(dr["nolimitdate"].ToString());
Entity.daydeposit = Helper.StringToInt(dr["daydeposit"].ToString());
Entity.Duetype = dr["Duetype"].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);
}
