/// <summary>
///
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="Entity"></param>
/// <param name="NewEntity"></param>
/// <param name="OldEntity"></param>
/// <returns></returns>
public int Add <T>(operatelogEntity Entity, T NewEntity, T OldEntity)
{
if (NewEntity == null || OldEntity == null)
{
return(1);
}
StringBuilder sb = new StringBuilder();
PropertyInfo[] PropertyList = NewEntity.GetType().GetProperties();
if (PropertyList.Length > 0)
{
ModelInfoAttribute myAttr;
foreach (PropertyInfo item in PropertyList)
{
try
{
switch (item.Name)
{
case "cuser":
case "ctime":
case "uuser":
case "utime":
case "isdelete":
continue;
break;
}
string NewVal = NewEntity.GetType().GetProperty(item.Name).GetValue(NewEntity, null).ToString();
string OldVal = OldEntity.GetType().GetProperty(item.Name).GetValue(OldEntity, null).ToString();
if (NewVal != OldVal)
{
myAttr = (ModelInfoAttribute)Attribute.GetCustomAttribute(NewEntity.GetType().GetProperty(item.Name), typeof(ModelInfoAttribute));
if (myAttr != null)
{
sb.AppendLine(myAttr.Name + ":" + OldVal + " -> " + NewVal + "；");
}
}
}
catch (Exception ex)
{
ErrorLog.WriteErrorMessage(ex);
}
}
}
if (sb.Length > 0)
{
Entity.logcontent = sb.ToString();
Entity.ip = IPHelp.GetClientIP();
return(dal.Add(Entity));
}
else
{
return(0);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(operatelogEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@module", Entity.module),
new SqlParameter("@pageurl", Entity.pageurl),
new SqlParameter("@otype", Entity.otype),
new SqlParameter("@logcontent", Entity.logcontent),
new SqlParameter("@ip", Entity.ip),
new SqlParameter("@cuser", Entity.cuser)
};
intReturn = DBHelper.ExecuteNonQuery("dbo.p_operatelog_Add", CommandType.StoredProcedure, sqlParameters);
return(intReturn);
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="ID">主键ID</param>
/// <returns>返回操作结果</returns>
public DataTable Delete(string GUID, string UID, string lineid, operatelogEntity entity)
{
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string Mescode = string.Empty;
int result = dal.Delete(lineid, ref Mescode);
//检测执行结果
if (CheckDeleteResult(result, Mescode))
{
//写日志
if (entity != null)
{
blllog.Add(entity);
}
}
return(dtBase);
}
/// <summary>
/// 更新一条数据
/// </summary>
public DataTable Update(string GUID, string UID, string ID, string stocode, string buscode, string desDate, string desTime, string dicid, string personNum, string metcode, string userName, string tel, string remark, string status, string dishesremark, string TerminalType, string openid, operatelogEntity entity)
{
if (!CheckLogin(GUID, UID))//非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("update", ID, stocode, buscode, desDate, desTime, dicid, personNum, metcode, userName, tel, remark, status, dishesremark, TerminalType, openid, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
//获取更新前的数据对象
WX_busDestineEntity OldEntity = new WX_busDestineEntity();
OldEntity = GetEntitySigInfo(" where ID='" + ID + "'");
//更新数据
int result = dal.Update(Entity);
//检测执行结果
if (CheckResult(result))
{
//写日志
if (entity != null)
{
blllog.Add <WX_busDestineEntity>(entity, Entity, OldEntity);
}
}
return(dtBase);
}
/// <summary>
/// 增加一条数据
/// </summary>
public DataTable Add(string GUID, string UID, out string lineid, string linecode, string stocode, string buscode, string ttcode, string maxperson, string minperosn, string Turncycle, string remark, string status, string cuser, string uuser, operatelogEntity entity)
{
lineid = "0";
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("add", lineid, linecode, stocode, buscode, ttcode, maxperson, minperosn, Turncycle, remark, status, cuser, uuser, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
int result = dal.Add(ref Entity);
//检测执行结果
CheckResult(result);
return(dtBase);
}
/// <summary>
/// 更新一条数据
/// </summary>
public DataTable Update(string GUID, string UID, string lsid, string distypeid, string buscode, string stocode, string pdistypecode, string distypecode, string dispath, string distypename, string metcode, string fincode, string maxdiscount, string busSort, string status, string cuser, string uuser, operatelogEntity entity)
{
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("update", lsid, distypeid, buscode, stocode, pdistypecode, distypecode, dispath, distypename, metcode, fincode, maxdiscount, busSort, status, cuser, uuser, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
//获取更新前的数据对象
DisheTypeEntity OldEntity = new DisheTypeEntity();
OldEntity = GetEntitySigInfo(" where lsid='" + lsid + "'");
//更新数据
int result = dal.Update(Entity);
//检测执行结果
if (CheckResult(result))
{
//写日志
if (entity != null)
{
blllog.Add <DisheTypeEntity>(entity, Entity, OldEntity);
}
}
return(dtBase);
}
/// <summary>
/// 更新一条数据
/// </summary>
public DataTable Update(string GUID, string UID, string lsid, string disid, string buscode, string stocode, string discode, string disname, string melcode, string disothername, string distypecode, string quickcode, string customcode, string unit, string price, string memberprice, string ismultiprice, string costprice, string iscostbyingredient, string pushmoney, string matclscode, string matcode, string extcode, string fincode, string dcode, string kitcode, string ecode, string maketime, string qrcode, string dispicture, string remark, string isentity, string entitydefcount, string entityprice, string iscanmodifyprice, string isneedweigh, string isneedmethod, string iscaninventory, string iscancustom, string iscandeposit, string isallowmemberprice, string isattachcalculate, string isclipcoupons, string iscombo, string iscombooptional, string isnonoperating, string status, string busSort, string warcode, string cuser, string uuser, operatelogEntity entity)
{
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("update", lsid, disid, buscode, stocode, discode, disname, melcode, disothername, distypecode, quickcode, customcode, unit, price, memberprice, ismultiprice, costprice, iscostbyingredient, pushmoney, matclscode, matcode, extcode, fincode, dcode, kitcode, ecode, maketime, qrcode, dispicture, remark, isentity, entitydefcount, entityprice, iscanmodifyprice, isneedweigh, isneedmethod, iscaninventory, iscancustom, iscandeposit, isallowmemberprice, isattachcalculate, isclipcoupons, iscombo, iscombooptional, isnonoperating, status, busSort, warcode, cuser, uuser, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
//获取更新前的数据对象
dishesEntity OldEntity = new dishesEntity();
OldEntity = GetEntitySigInfo(" where lsid='" + lsid + "'");
//更新数据
int result = dal.Update(Entity);
//检测执行结果
if (CheckResult(result))
{
//写日志
if (entity != null)
{
blllog.Add <dishesEntity>(entity, Entity, OldEntity);
}
}
return(dtBase);
}
/// <summary>
/// 更新一条数据
/// </summary>
public DataTable Update(string GUID, string UID, string id, string detailid, string buscode, string stocode, string orderid, string personcount, string opentime, string checkouttime, string alltime, string endtime, string shiftid, string tmcode, string tmname, string tablecodes, string combinenum, string allfoodtime, string pushfoodtime, string pushfoodstate, string closeaccount, string closeCodes, string calltime, string userid, string ordertime, string surchargeamount, string ocostprice, string conmoney, string status, string detailcode, string memcode, string desCode, string desctime, string printcount, string remark, string metname, string pushid, string pushname, string cuser, string ispresented, string presentedcode, string cardcode, string mobile, string coupons, string metcode, string ttcode, string customer, string amanagerid, string amanagername, string olossmoney, string detailtype, string predishemoney, string TerminalType, string depcode, string depname, operatelogEntity entity)
{
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("update", id, detailid, buscode, stocode, orderid, personcount, opentime, checkouttime, alltime, endtime, shiftid, tmcode, tmname, tablecodes, combinenum, allfoodtime, pushfoodtime, pushfoodstate, closeaccount, closeCodes, calltime, userid, ordertime, surchargeamount, ocostprice, conmoney, status, detailcode, memcode, desCode, desctime, printcount, remark, metname, pushid, pushname, cuser, ispresented, presentedcode, cardcode, mobile, coupons, metcode, ttcode, customer, amanagerid, amanagername, olossmoney, detailtype, predishemoney, TerminalType, depcode, depname, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
//获取更新前的数据对象
choorderdetailEntity OldEntity = new choorderdetailEntity();
OldEntity = GetEntitySigInfo(" where id='" + id + "'");
//更新数据
int result = dal.Update(Entity);
//检测执行结果
if (CheckResult(result))
{
//写日志
if (entity != null)
{
blllog.Add <choorderdetailEntity>(entity, Entity, OldEntity);
}
}
return(dtBase);
}
/// <summary>
/// 增加一条数据
/// </summary>
public DataTable Add(string GUID, string UID, out string timeid, string stocode, string buscode, string timename, string timevalue, string remark, string status, string cuser, string uuser, string btime, string etime, operatelogEntity entity)
{
timeid = "0";
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("add", timeid, stocode, buscode, timename, timevalue, remark, status, cuser, uuser, btime, etime, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
int result = dal.Add(ref Entity);
//检测执行结果
CheckResult(result);
return(dtBase);
}
/// <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>
public DataTable Add(string GUID, string UID, out string id, string openid, string msgtype, string status, string msgdetails, string title, operatelogEntity entity)
{
id = "0";
if (!CheckLogin(GUID, UID))//非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("add", id, openid, msgtype, status, msgdetails, title, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
int result = dal.Add(ref Entity);
//检测执行结果
CheckResult(result);
return(dtBase);
}
/// <summary>
/// 插入操作日志
/// </summary>
/// <param name="Entity">日志对象</param>
/// <returns></returns>
public int Add(operatelogEntity Entity)
{
Entity.ip = IPHelp.GetClientIP();
return(dal.Add(Entity));
}
/// <summary>
/// 增加一条数据
/// </summary>
public DataTable Add(string GUID, string UID, out string bwid, string serialNumber, string buscode, string strcode, string busTop, string sortNum, string busDate, string waitType, string userName, string tel, string waitTime, string remark, string status, string cuser, string uuser, string openid, operatelogEntity entity)
{
bwid = "0";
if (!CheckLogin(GUID, UID))//非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("add", bwid, serialNumber, buscode, strcode, busTop, sortNum, busDate, waitType, userName, tel, waitTime, remark, status, cuser, uuser, openid, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
int result = dal.Add(ref Entity);
//检测执行结果
CheckResult(result);
return(dtBase);
}
/// <summary>
/// 更新一条数据
/// </summary>
public DataTable Update(string GUID, string UID, string bwid, string serialNumber, string buscode, string strcode, string busTop, string sortNum, string busDate, string waitType, string userName, string tel, string waitTime, string remark, string status, string cuser, string uuser, string openid, operatelogEntity entity)
{
if (!CheckLogin(GUID, UID))//非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("update", bwid, serialNumber, buscode, strcode, busTop, sortNum, busDate, waitType, userName, tel, waitTime, remark, status, cuser, uuser, openid, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
//获取更新前的数据对象
WX_busWaitEntity OldEntity = new WX_busWaitEntity();
OldEntity = GetEntitySigInfo(" where bwid='" + bwid + "'");
//更新数据
int result = dal.Update(Entity);
//检测执行结果
if (CheckResult(result))
{
//写日志
if (entity != null)
{
blllog.Add <WX_busWaitEntity>(entity, Entity, OldEntity);
}
}
return(dtBase);
}
/// <summary>
/// 增加一条数据
/// </summary>
public DataTable Add(string GUID, string UID, out string setreservationid, string stocode, string buscode, string isnetwork, string isqueue, string isaddfood, string festival, string weekend, string ntime, operatelogEntity entity)
{
setreservationid = "0";
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("add", setreservationid, stocode, buscode, isnetwork, isqueue, isaddfood, festival, weekend, ntime, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
int result = dal.Add(ref Entity);
//检测执行结果
CheckResult(result);
return(dtBase);
}
/// <summary>
/// 更新一条数据
/// </summary>
public DataTable Update(string GUID, string UID, string setreservationid, string stocode, string buscode, string isnetwork, string isqueue, string isaddfood, string festival, string weekend, string ntime, operatelogEntity entity)
{
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("update", setreservationid, stocode, buscode, isnetwork, isqueue, isaddfood, festival, weekend, ntime, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
//获取更新前的数据对象
WX_stosetEntity OldEntity = new WX_stosetEntity();
OldEntity = GetEntitySigInfo(" where setreservationid='" + setreservationid + "'");
//更新数据
int result = dal.Update(Entity);
//检测执行结果
if (CheckResult(result))
{
//写日志
if (entity != null)
{
blllog.Add <WX_stosetEntity>(entity, Entity, OldEntity);
}
}
return(dtBase);
}
/// <summary>
/// 更新一条数据
/// </summary>
public DataTable Update(string GUID, string UID, string lsid, string orderdishesid, string buscode, string stocode, string orderid, string detailid, string distypecode, string dtypecode, string melcode, string discode, string disname, string disothername, string disnum, string disnumconst, string addnum, string isneedmethod, string distacode, string distaname, string ordertime, string addtime, string calltime, string pushfoodtime, string pushfoodstate, string isentity, string entitydefcount, string entityprice, string singlenum, string singleAllmoney, string totaladdmoney, string totaladdmoneydiscount, string allmoney, string allmoneydiscount, string memberallmoney, string resultallmoney, string packageaddmoney, string ispackage, string iscanout, string isout, string refundNum, string refundaddnum, string oneprice, string memberprice, string costprice, string methodmoney, string methodmoneydiscount, string attachmoney, string pushmoney, string ismember, string ispre, string pretype, string dispcode, string discountratemax, string discountrate, string premoney, string precheck, string checktime, string ismustconsume, string mustconsumenum, string iscaninventory, string isallowmemberprice, string isattachcalculate, string isclipcoupons, string isnonoperating, string iscombooptional, string isneedweigh, string iscanmodifyprice, string matcode, string cguid, string pcguid, string porderdishesid, string comdiscode, string comgcode, string composetype, string allowkinds, string allowcount, string allowamount, string usedisdefaultamount, string usedismaxamount, string unit, string extcode, string fincode, string dcode, string kitcode, string ecode, string warcode, string totmcode, string totmname, string todetailid, string status, string makestatus, string operaretype, string isdiscount, string priceispre, string ispresented, string pecode, string pename, string prereason, string prereasontype, string remark, string orderremark, string gguid, string nopreremark, string storeupdated, string cuser, string comprice, string cusername, string tottcode, string metname, string metcode, string detailcode, string tmopentime, string chomac, string orderno, string subtype, operatelogEntity entity)
{
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("update", lsid, orderdishesid, buscode, stocode, orderid, detailid, distypecode, dtypecode, melcode, discode, disname, disothername, disnum, disnumconst, addnum, isneedmethod, distacode, distaname, ordertime, addtime, calltime, pushfoodtime, pushfoodstate, isentity, entitydefcount, entityprice, singlenum, singleAllmoney, totaladdmoney, totaladdmoneydiscount, allmoney, allmoneydiscount, memberallmoney, resultallmoney, packageaddmoney, ispackage, iscanout, isout, refundNum, refundaddnum, oneprice, memberprice, costprice, methodmoney, methodmoneydiscount, attachmoney, pushmoney, ismember, ispre, pretype, dispcode, discountratemax, discountrate, premoney, precheck, checktime, ismustconsume, mustconsumenum, iscaninventory, isallowmemberprice, isattachcalculate, isclipcoupons, isnonoperating, iscombooptional, isneedweigh, iscanmodifyprice, matcode, cguid, pcguid, porderdishesid, comdiscode, comgcode, composetype, allowkinds, allowcount, allowamount, usedisdefaultamount, usedismaxamount, unit, extcode, fincode, dcode, kitcode, ecode, warcode, totmcode, totmname, todetailid, status, makestatus, operaretype, isdiscount, priceispre, ispresented, pecode, pename, prereason, prereasontype, remark, orderremark, gguid, nopreremark, storeupdated, cuser, comprice, cusername, tottcode, metname, metcode, detailcode, tmopentime, chomac, orderno, subtype, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
//获取更新前的数据对象
choorderdishesEntity OldEntity = new choorderdishesEntity();
OldEntity = GetEntitySigInfo(" where lsid='" + lsid + "'");
//更新数据
int result = dal.Update(Entity);
//检测执行结果
if (CheckResult(result))
{
//写日志
if (entity != null)
{
blllog.Add <choorderdishesEntity>(entity, Entity, OldEntity);
}
}
return(dtBase);
}
/// <summary>
/// 增加一条数据
/// </summary>
public DataTable Add(string GUID, string UID, out string id, string detailid, string buscode, string stocode, string orderid, string personcount, string opentime, string checkouttime, string alltime, string endtime, string shiftid, string tmcode, string tmname, string tablecodes, string combinenum, string allfoodtime, string pushfoodtime, string pushfoodstate, string closeaccount, string closeCodes, string calltime, string userid, string ordertime, string surchargeamount, string ocostprice, string conmoney, string status, string detailcode, string memcode, string desCode, string desctime, string printcount, string remark, string metname, string pushid, string pushname, string cuser, string ispresented, string presentedcode, string cardcode, string mobile, string coupons, string metcode, string ttcode, string customer, string amanagerid, string amanagername, string olossmoney, string detailtype, string predishemoney, string TerminalType, string depcode, string depname, operatelogEntity entity)
{
id = "0";
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("add", id, detailid, buscode, stocode, orderid, personcount, opentime, checkouttime, alltime, endtime, shiftid, tmcode, tmname, tablecodes, combinenum, allfoodtime, pushfoodtime, pushfoodstate, closeaccount, closeCodes, calltime, userid, ordertime, surchargeamount, ocostprice, conmoney, status, detailcode, memcode, desCode, desctime, printcount, remark, metname, pushid, pushname, cuser, ispresented, presentedcode, cardcode, mobile, coupons, metcode, ttcode, customer, amanagerid, amanagername, olossmoney, detailtype, predishemoney, TerminalType, depcode, depname, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
int result = dal.Add(ref Entity);
//检测执行结果
CheckResult(result);
return(dtBase);
}
/// <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 DataTable Add(string GUID, string UID, out string lsid, string disid, string buscode, string stocode, string discode, string disname, string melcode, string disothername, string distypecode, string quickcode, string customcode, string unit, string price, string memberprice, string ismultiprice, string costprice, string iscostbyingredient, string pushmoney, string matclscode, string matcode, string extcode, string fincode, string dcode, string kitcode, string ecode, string maketime, string qrcode, string dispicture, string remark, string isentity, string entitydefcount, string entityprice, string iscanmodifyprice, string isneedweigh, string isneedmethod, string iscaninventory, string iscancustom, string iscandeposit, string isallowmemberprice, string isattachcalculate, string isclipcoupons, string iscombo, string iscombooptional, string isnonoperating, string status, string busSort, string warcode, string cuser, string uuser, operatelogEntity entity)
{
lsid = "0";
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("add", lsid, disid, buscode, stocode, discode, disname, melcode, disothername, distypecode, quickcode, customcode, unit, price, memberprice, ismultiprice, costprice, iscostbyingredient, pushmoney, matclscode, matcode, extcode, fincode, dcode, kitcode, ecode, maketime, qrcode, dispicture, remark, isentity, entitydefcount, entityprice, iscanmodifyprice, isneedweigh, isneedmethod, iscaninventory, iscancustom, iscandeposit, isallowmemberprice, isattachcalculate, isclipcoupons, iscombo, iscombooptional, isnonoperating, status, busSort, warcode, cuser, uuser, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
int result = dal.Add(ref Entity);
//检测执行结果
CheckResult(result);
return(dtBase);
}
/// <summary>
/// 增加一条数据
/// </summary>
public DataTable Add(string GUID, string UID, out 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)
{
setreservationid = "0";
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("add", setreservationid, stocode, buscode, ttcode, maxdeposit, methoddeposit, nolimitdate, daydeposit, Duetype, remark, status, cuser, uuser, btime, etime, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
int result = dal.Add(ref Entity);
//检测执行结果
CheckResult(result);
return(dtBase);
}
/// <summary>
/// 增加一条数据
/// </summary>
public DataTable Add(string GUID, string UID, out string lsid, string distypeid, string buscode, string stocode, string pdistypecode, string distypecode, string dispath, string distypename, string metcode, string fincode, string maxdiscount, string busSort, string status, string cuser, string uuser, operatelogEntity entity)
{
lsid = "0";
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("add", lsid, distypeid, buscode, stocode, pdistypecode, distypecode, dispath, distypename, metcode, fincode, maxdiscount, busSort, status, cuser, uuser, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
int result = dal.Add(ref Entity);
//检测执行结果
CheckResult(result);
return(dtBase);
}
/// <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 DataTable Update(string GUID, string UID, string lsid, string orderid, string buscode, string strcode, string shiftid, string tmcode, string personnum, string username, string userphone, string arrivetime, string opentime, string restime, string checkouttime, string gusetleavetime, string alltime, string allfoodtime, string conmoney, string status, string remark, string cuser, string uuser, operatelogEntity entity)
{
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("update", lsid, orderid, buscode, strcode, shiftid, tmcode, personnum, username, userphone, arrivetime, opentime, restime, checkouttime, gusetleavetime, alltime, allfoodtime, conmoney, status, remark, cuser, uuser, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
//获取更新前的数据对象
choorderEntity OldEntity = new choorderEntity();
OldEntity = GetEntitySigInfo(" where lsid='" + lsid + "'");
//更新数据
int result = dal.Update(Entity);
//检测执行结果
if (CheckResult(result))
{
//写日志
if (entity != null)
{
blllog.Add <choorderEntity>(entity, Entity, OldEntity);
}
}
return(dtBase);
}
/// <summary>
/// 增加一条数据
/// </summary>
public DataTable Add(string GUID, string UID, out string lsid, string orderid, string buscode, string strcode, string shiftid, string tmcode, string personnum, string username, string userphone, string arrivetime, string opentime, string restime, string checkouttime, string gusetleavetime, string alltime, string allfoodtime, string conmoney, string status, string remark, string cuser, string uuser, operatelogEntity entity)
{
lsid = "0";
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("add", lsid, orderid, buscode, strcode, shiftid, tmcode, personnum, username, userphone, arrivetime, opentime, restime, checkouttime, gusetleavetime, alltime, allfoodtime, conmoney, status, remark, cuser, uuser, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
int result = dal.Add(ref Entity);
//检测执行结果
CheckResult(result);
return(dtBase);
}
/// <summary>
/// 更新一条数据
/// </summary>
public DataTable Update(string GUID, string UID, string lineid, string linecode, string stocode, string buscode, string ttcode, string maxperson, string minperosn, string Turncycle, string remark, string status, string cuser, string uuser, operatelogEntity entity)
{
if (!CheckLogin(GUID, UID)) //非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("update", lineid, linecode, stocode, buscode, ttcode, maxperson, minperosn, Turncycle, remark, status, cuser, uuser, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
//获取更新前的数据对象
WX_setlineUpEntity OldEntity = new WX_setlineUpEntity();
OldEntity = GetEntitySigInfo(" where lineid='" + lineid + "'");
//更新数据
int result = dal.Update(Entity);
//检测执行结果
if (CheckResult(result))
{
//写日志
if (entity != null)
{
blllog.Add <WX_setlineUpEntity>(entity, Entity, OldEntity);
}
}
return(dtBase);
}
/// <summary>
/// 增加一条数据
/// </summary>
public DataTable Add(string GUID, string UID, out string ID, string stocode, string buscode, string desDate, string desTime, string dicid, string personNum, string metcode, string userName, string tel, string remark, string status, string dishesremark, string TerminalType, string openid, operatelogEntity entity)
{
ID = "0";
if (!CheckLogin(GUID, UID))//非法登录
{
return(dtBase);
}
dtBase.Clear();
string spanids = string.Empty;
string strReturn = CheckPageInfo("add", ID, stocode, buscode, desDate, desTime, dicid, personNum, metcode, userName, tel, remark, status, dishesremark, TerminalType, openid, out spanids);
//数据页面验证
if (!CheckControl(strReturn, spanids))
{
return(dtBase);
}
int result = dal.Add(ref Entity);
//检测执行结果
CheckResult(result);
return(dtBase);
}
