/// <summary>
/// Order_删除订单
/// </summary>
/// <param name="OrderID">订单ID</param>
public static ReturnClass DeleteOrder(string OrderID)
{
ReturnClass err = new ReturnClass();
if (StaticInfo.hasNoZhuRu(OrderID))
{
try
{
err.result = DBConnection.OrderData.DeleteOrderData(OrderID);
if (Convert.ToInt32(err.result) > 0)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("DeleteOrder", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// Order_查询单条订单详情
/// </summary>
/// <param name="OrderID">订单ID</param>
public static ReturnClass SelectOrderInfo(string OrderID)
{
ReturnClass err = new ReturnClass();
if (StaticInfo.hasNoZhuRu(OrderID))
{
try
{
err.result = DBConnection.OrderInfo.SelectOrder(OrderID);
if (err.result != null)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("SelectOrderInfo", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// 查询销量
/// </summary>
/// <param name="BgTime">开始时间</param>
/// <param name="EndTime">结束时间</param>
/// <param name="ShopID">店铺ID</param>
public static ReturnTableClass SelectXiaoLiang(DateTime BgTime, DateTime EndTime, int ShopID)
{
ReturnTableClass err = new ReturnTableClass();
if (StaticInfo.hasNoZhuRu("ShopID"))
{
try
{
err.result = DBConnection.OrderInfo.SelectXiaoLiang(Convert.ToInt32(BgTime.ToString("yyyyMMdd00")), Convert.ToInt32(EndTime.ToString("yyyyMMdd24")), ShopID);
if (err.result != null)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("SelectXiaoLiang", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// 修改员工信息
/// </summary>
/// <param name="YuanGongID">员工ID</param>
/// <param name="Password">密码</param>
/// <param name="Name">姓名</param>
/// <param name="YuanGongType">工种</param>
/// <param name="WorkGroup">工作组</param>
/// <param name="Phone">电话</param>
/// <param name="CategoryID">厨师用的类别</param>
public static ReturnClass UpDateYuanGong(string YuanGongID, string Password, string Name, int ShopID, int YuanGongType, int WorkGroup, string Phone, int CategoryID)
{
ReturnClass err = new ReturnClass();
if (StaticInfo.hasNoZhuRu(YuanGongID) && StaticInfo.hasNoZhuRu(Name) && StaticInfo.hasNoZhuRu(Password) && StaticInfo.hasNoZhuRu(Phone))
{
try
{
err.result = DBConnection.YuanGongInfo.UpdateYuanGongInfo(YuanGongID, Password, Name, ShopID, YuanGongType, WorkGroup, Phone, CategoryID);
if (Convert.ToInt32(err.result) > 0)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("UpdateYuanGong", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// 查询所有单品类别
/// </summary>
/// <param name="ID">ID</param>
public static ReturnClass SelectTotalCategory()
{
ReturnClass err = new ReturnClass();
if (StaticInfo.hasNoZhuRu("aa"))
{
try
{
err.result = DBConnection.SystemConfig.SelectTotalCategory();
if (err.result != null)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("SelectTotalCategory", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// 添加系统设置
/// </summary>
/// <param name="Value">账号</param>
/// <param name="Name">姓名</param>
/// <param name="ConfigID">系统设置ID</param>
/// <param name="ConfigName">系统设置名称</param>
public static ReturnClass AddSystemConfig(string Value, string Name, int ConfigID, string ConfigName)
{
ReturnClass err = new ReturnClass();
if (StaticInfo.hasNoZhuRu(Value) && StaticInfo.hasNoZhuRu(ConfigName))
{
try
{
err.result = DBConnection.SystemConfig.InsertSystemConfig(Value, Name, ConfigID, ConfigName);
if (Convert.ToInt32(err.result) > 0)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("AddSystemConfig", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// 修改餐品信息
/// </summary>
/// <param name="ID">餐品ID</param>
/// <param name="FoodName">菜名</param>
/// <param name="Category">种类</param>
/// <param name="pic">图片地址</param>
/// <param name="ShopID">商店ID</param>
/// <param name="MenuID">菜单ID</param>
/// <param name="Des">描述</param>
/// <param name="Price">单价</param>
/// <param name="AdminID">添加人ID</param>
/// <param name="IsShow">是否显示</param>
public static ReturnClass UpDateFood(int ID, string FoodName, int Category, string pic, int ShopID, int MenuID, string Des, string Price, string AdminID, int IsShow)
{
ReturnClass err = new ReturnClass();
if (StaticInfo.hasNoZhuRu(FoodName) && StaticInfo.hasNoZhuRu(pic) && StaticInfo.hasNoZhuRu(Des) && StaticInfo.hasNoZhuRu(Price) && StaticInfo.hasNoZhuRu(AdminID))
{
try
{
err.result = DBConnection.FoodInfo.UpdateFoodInfo(ID, FoodName, Category, pic, ShopID, MenuID, Des, Price, AdminID, IsShow);
if (Convert.ToInt32(err.result) > 0)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("UpdateFood", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// 修改管理员密码
/// </summary>
/// <param name="Phone">电话号码</param>
/// <param name="OldPsd">旧密码</param>
/// <param name="NewPsd">新密码</param>
public static ReturnClass RestPwd(string Phone, string OldPwd, string NewPwd)
{
ReturnClass err = new ReturnClass();
if (StaticInfo.hasNoZhuRu(Phone) && StaticInfo.hasNoZhuRu(OldPwd) && StaticInfo.hasNoZhuRu(NewPwd))
{
try
{
err.result = DBConnection.YuanGongInfo.RestPwd(Phone, OldPwd, NewPwd);
if (Convert.ToInt32(err.result) > 0)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("RestYuanGongPwd", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// 添加管理员
/// </summary>
/// <param name="AdminID">账号</param>
/// <param name="Name">姓名</param>
/// <param name="AdminType">管理员类型</param>
/// <param name="Password">密码</param>
/// <param name="Phone">电话</param>
public static ReturnClass AddAdmin(string AdminID, string Name, int AdminType, string Password, string Phone)
{
ReturnClass err = new ReturnClass();
if (StaticInfo.hasNoZhuRu(AdminID) && StaticInfo.hasNoZhuRu(Name) && StaticInfo.hasNoZhuRu(Password) && StaticInfo.hasNoZhuRu(Phone))
{
try
{
err.result = DBConnection.AdminInfo.InsertAdminInfo(AdminID, Name, AdminType, Password, Phone);
if (Convert.ToInt32(err.result) > 0)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("AddAdmin", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// 查询送餐员绩效
/// </summary>
/// <param name="intOrderTime">0上月 1本月</param>
/// <param name="ShopID">店铺ID</param>
public static ReturnTableClass SelectSongCanRen(int intOrderTime, int ShopID)
{
ReturnTableClass err = new ReturnTableClass();
int bgTime = 0; //开始时间
int endTime = 0; //结束时间
if (intOrderTime == 0)
{
bgTime = Convert.ToInt32(DateTime.Now.AddMonths(-1).ToString("yyyyMM0000"));
endTime = Convert.ToInt32(DateTime.Now.ToString("yyyyMM0000"));
}
else if (intOrderTime == 1)
{
bgTime = Convert.ToInt32(DateTime.Now.ToString("yyyyMM0000"));
endTime = Convert.ToInt32(DateTime.Now.AddMonths(1).ToString("yyyyMM0000"));
}
if (StaticInfo.hasNoZhuRu("ShopID"))
{
try
{
err.result = DBConnection.OrderData.SelectSongCanRen(bgTime, endTime, ShopID);
if (err.result != null)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("SelectSongCanRen", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// 修改系统设置
/// </summary>
/// <param name="ID">编号</param>
/// <param name="Value">内容</param>
public static ReturnClass UpdateSystemConfig(string ID, string Value)
{
ReturnClass err = new ReturnClass();
string[] strID = ID.Split(',');
int countSussed = 0;
if (StaticInfo.hasNoZhuRu(Value))
{
try
{
foreach (string sid in strID)
{
if (sid != "")
{
countSussed += DBConnection.SystemConfig.UpdateSystemConfig(Convert.ToInt32(sid), Value);
}
}
err.result = countSussed;
if (Convert.ToInt32(err.result) > 0)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("AddSystemConfig", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// Order_修改状态
/// </summary>
/// <param name="OrderID">订单ID</param>
/// <param name="State">状态</param>
public static ReturnClass UpDateOrderState(string OrderID, int State)
{
ReturnClass err = new ReturnClass();
string[] strOrderID = OrderID.Split(',');
int CountRows = 0;
if (StaticInfo.hasNoZhuRu(OrderID))
{
try
{
foreach (string oid in strOrderID)
{
CountRows += DBConnection.OrderData.UpdateOrderState(oid, State);
}
err.result = CountRows;
if (Convert.ToInt32(err.result) > 0)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("UpdateOrderState", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// Order_厨师查看自己的订单详情
/// </summary>
/// <param name="ShopID">店铺ID</param>
public static ReturnClass SelectTotalOrderDataFenCan(int ShopID)
{
////看一下当前时间应该是查看什么时间段的订餐
DateTime OrderTime = DateTime.Now;
int intTime = 0;
int intOrderTime = Convert.ToInt32(DateTime.Now.ToString("yyyyMMddHH"));
if (intOrderTime <= Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd06")))//当日早餐
{
intTime = 1;
}
else if (intOrderTime >= Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd06")) && intOrderTime < Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd12")))//当日午餐
{
intTime = 2;
}
else if (intOrderTime >= Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd12")) && intOrderTime < Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd18")))//当日晚餐
{
intTime = 3;
}
else if (intOrderTime >= Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd18")) && intOrderTime > Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd24")))//明天早餐
{
OrderTime.AddDays(1);
intTime = 1;
}
ReturnClass err = new ReturnClass();
int thisTime = Convert.ToInt32(OrderTime.ToString("yyyyMMdd00"));
if (StaticInfo.hasNoZhuRu("aa"))
{
try
{
if (intTime == 0)
{
int Btime = Convert.ToInt32(OrderTime.ToString("yyyyMMdd00")); //开始的时间 2016082500
int Etime = Convert.ToInt32(OrderTime.AddDays(1).ToString("yyyyMMdd00")); //结束的时间 2016082600
}
else if (intTime == 1) //早餐
{
thisTime = thisTime + Convert.ToInt32(DBConnection.SystemConfig.SelectSystemConfig(1).Rows[0]["Value"]); //早晨6:00
}
else if (intTime == 2) //午餐
{
thisTime = thisTime + Convert.ToInt32(DBConnection.SystemConfig.SelectSystemConfig(2).Rows[0]["Value"]); //中午12:00
}
else if (intTime == 3) //晚餐
{
thisTime = thisTime + Convert.ToInt32(DBConnection.SystemConfig.SelectSystemConfig(3).Rows[0]["Value"]); //下午18:00
}
DataTable dt1 = DBConnection.OrderInfo.SelectTotalFenCanNum(thisTime, ShopID);
DataTable dt2 = DBConnection.OrderInfo.SelectTotalFenCanNumBySongCanYuan(thisTime, ShopID);
dt1.Columns.Add("NumByYuanGong");
foreach (DataRow dr in dt1.Rows)
{
string s = "";
foreach (DataRow drr in dt2.Rows)
{
if (dr["FoodID"].ToString() == drr["FoodID"].ToString())
{
if (drr["YuanGongName"].ToString() != "")
{
s += drr["YuanGongName"].ToString() + ":" + drr["totalNum"].ToString() + "份 ";
}
else
{
s += "未知人" + ":" + drr["totalNum"].ToString() + "份 ";
}
}
}
dr["NumByYuanGong"] = s;
}
err.result = dt1;
if (err.result != null)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("SelectTotalOrderInfoChuShi", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// Order插入数据
/// </summary>
/// <param name="Name">姓名</param>
/// <param name="Phone">电话</param>
/// <param name="Address">地址</param>
/// <param name="ShopID">商店ID</param>
/// <param name="List">订单详情</param>
/// <param name="OrderTime">预定时间</param>
/// <param name="OrderDate">预定日期</param>
///
/// 插入orderData 表->插入单品到orderInfo表->计算价格->返回清单给顾客->付款
/// list foodID num Price OrderTime 例如:1,红烧肉,2,30|3,尖椒炒鸡蛋,1,18
/// Address格式为 楼号层数,床号 例如:108,0812床 1号楼8楼,0812床号
public static ReturnClass AddOrder(string Name, string Phone, string Address, int ShopID, string List, string OrderTime, string OrderDate)
{
int YuanGongID = 0; //员工ID
int LouHao = Convert.ToInt32(Address.Split(',')[0]); //楼号
string ChuangHao = Address.Split(',')[1]; //床号
if (DBConnection.SystemConfig.SelectValueByConfigIDAndValue(1002, LouHao.ToString()) != null) //说明有值
{
//查询相应的送餐员ID
YuanGongID = Convert.ToInt32(DBConnection.SystemConfig.SelectValueByConfigIDAndValue(1002, LouHao.ToString()));
}
if (DBConnection.SystemConfig.SelectConfigNameByConfigIDAndName(1002, LouHao.ToString()) != null)//说明有值
{
//如果有这座楼，重新组建Address用中文的形式，理论上应该为 例： 门诊楼8楼，0828床
Address = DBConnection.SystemConfig.SelectConfigNameByConfigIDAndName(1002, LouHao.ToString()) + "," + ChuangHao;
}
else//没有这层
{
}
//处理一下订餐的日期和时间 日期处理成yyyyMMddHH00的int型,时间处理成yyyyMMdd(06|12|18)分别代表早餐 午餐 晚餐,方便比较大小
string[] date = OrderDate.Split('-');
int intOrderDate = Convert.ToInt32(date[0] + date[1] + date[2] + "00"); //当前订餐日期
int intOrderTime = intOrderDate + Convert.ToInt32(OrderTime); //当前订餐时间 格式2016090806 2016090812 2016090818
int intTimeNow = Convert.ToInt32(DateTime.Now.ToString("yyyyMMddHH")); //当前时间,为了判断订餐时间是否合法
ReturnClass err = new ReturnClass();
//判断订餐是否合法
if (intTimeNow > intOrderTime - 2)//说明超出了此次就餐时间
{
err.result = -2;
err.Code = ErrorCode.FAIL;
err.Msg = "订单添加失败了!原因是当前时间超过了预定时间！";
return(err);
}
if (StaticInfo.hasNoZhuRu(Name) && StaticInfo.hasNoZhuRu(Phone) && StaticInfo.hasNoZhuRu(Address) && StaticInfo.hasNoZhuRu(List)) //判断是否sql注入
{
string OrderID = StaticInfo.CreatOrderID(); //生成订单号
//拆分字符串 获取详细订单
string[] OrderInfoArray = List.Split('|');
int CountRow = 0; //成功插入的条数
string ListDetail = ""; //方便打印存储一下订单详情内容
decimal TotalPrice = 0.00M; //订单的总价格
//初始化一个表格 为了订单详情生成 逻辑为如果有一点数据不合法，那么这个datatable就=null，数据库不做任何处理
#region 初始化datatalbe
DataTable dtList = new DataTable("dtList");
DataColumn dtc = new DataColumn("FoodID", typeof(string));
dtList.Columns.Add(dtc);
dtc = new DataColumn("FoodName", typeof(string));
dtList.Columns.Add(dtc);
dtc = new DataColumn("Num", typeof(string));
dtList.Columns.Add(dtc);
dtc = new DataColumn("Price", typeof(string));
dtList.Columns.Add(dtc);
#endregion
try
{
if (OrderInfoArray != null)
{
foreach (string strOrderData in OrderInfoArray)
{
if (strOrderData == null || strOrderData == "")
{
continue;
}
else
{
string[] OrderData = strOrderData.Split(','); //订单详情通过','拆分成数组便于取值
int FoodID = Convert.ToInt32(OrderData[0]); //商品ID
string FoodName = Convert.ToString(OrderData[1]); //商品名称
int Num = Convert.ToInt32(OrderData[2]); //商品数量
decimal Price = Convert.ToDecimal(OrderData[3]); //单条商品的总价
DataTable dtNeed = DBConnection.FoodInfo.SelectFoodInfo(FoodID);
if (dtNeed != null && Num > 0 && Price > 0.00M) //说明这是合法的数据,只能为正数
{
FoodName = Convert.ToString(dtNeed.Rows[0]["FoodName"]); //商品名称
DataRow dr = dtList.NewRow();
dr["FoodID"] = Convert.ToString(FoodID); //ID
dr["FoodName"] = Convert.ToString(FoodName); //名称
dr["Num"] = Convert.ToString(Num); //数量
dr["Price"] = Convert.ToDecimal(Num) * Convert.ToDecimal(dtNeed.Rows[0]["Price"]); //总价
dtList.Rows.Add(dr);
}
else
{
dtList = null;
break;
}
}
}
if (dtList != null)
{
foreach (DataRow drr in dtList.Rows)
{
ListDetail += "品名:" + Convert.ToString(drr["FoodName"]) + " 数量:" + Convert.ToString(drr["Num"]) + " 价格:" + Convert.ToString(drr["Price"]) + "|"; //方便打印存储一下订单详情内容
TotalPrice += Convert.ToDecimal(drr["Price"]); //计算总价格
//CountRow += 1;// 成功插入的条数+1
}
//
if (DBConnection.OrderInfo.InsertOrderInfo(OrderID, dtList, intOrderTime, Convert.ToString(TotalPrice), DateTime.Now, Name, Phone
, Address, 0, YuanGongID, 0, 0, "", 1, ListDetail) > 0)
{
//说明订单生成成功了
err.result = 1;
err.Code = ErrorCode.SUSCCED;
err.Msg = "订单生成成功!";
}
else//说明失败了
{
err.result = 0;
err.Code = ErrorCode.FAIL;
err.Msg = "订单添加失败了!";
}
}
//if(dtList!=null)
//{
// foreach (DataRow drr in dtList.Rows)
// {
// if (DBConnection.OrderInfo.InsertOrderInfo(OrderID,Convert.ToInt32(drr["FoodID"]),Convert.ToInt32(drr["Num"]),Convert.ToDecimal(drr["Price"]), OrderTime) > 0) //说明插入成功了
// {
// ListDetail += "品名:" +Convert.ToString(drr["FoodName"]) + " 数量:" + Convert.ToString(drr["Num"]) + " 价格:" + Convert.ToString(drr["Price"]) + "|";//方便打印存储一下订单详情内容
// TotalPrice +=Convert.ToDecimal(drr["Price"]);//计算总价格
// CountRow += 1;// 成功插入的条数+1
// }
// }
//}
else
{
err.Code = ErrorCode.FAIL;
err.result = 0;
err.Msg = "添加订单的数量或者价格参数不合法!";
return(err);
}
}
else//说明订单中并没有商品详情
{
err.result = 0;
err.Code = ErrorCode.FAIL;
err.Msg = "请选择餐品加入订单,再提交订单!";
return(err);
}
//要查询今天当班的送餐员（待定也可能由管理员指定）
//if (CountRow == OrderInfoArray.Length)//这说明全部插入成功了
//{
// //添加一条新记录到OrderInfo表
// if (DBConnection.OrderData.InsertOrderData(OrderID, Convert.ToString(TotalPrice), DateTime.Now, Name, Phone, Address, 0, 0, 0, 0, "", 1, ListDetail, OrderTime) > 0)
// {
// //说明订单生成成功了
// err.result = 1;
// err.Code = ErrorCode.SUSCCED;
// err.Msg = "订单生成成功!";
// }
// else//说明失败了
// {
// err.result = 0;
// err.Code = ErrorCode.FAIL;
// err.Msg = "订单添加失败了!";
// }
//}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("AddOrder", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// Order_送餐员查看自己要送的订单
/// </summary>
/// <param name="intTime">哪个时间段的订餐 0:全天 1:早餐 2:午餐 3：晚餐</param>
/// <param name="State">订单的状态 0:未结束 1:已结束</param>
/// <param name="ShopID">店铺ID</param>
/// <param name="OrderTime">要查询的订单送餐时间</param>
/// where OrderTime = 2016082418 and y.YuanGongID = 2 and d.ShopID = 1 and d.State = 0
public static ReturnClass SelectTotalOrderDataSongCan(int intTime, int State, int ShopID, DateTime OrderTime, int YuanGongID)
{
ReturnClass err = new ReturnClass();
string sqlWhere = "where 1=1 and d.ShopID=" + Convert.ToString(ShopID) + " ";//where OrderTime = 2016082418 and y.YuanGongID = 2 and d.ShopID = 1 and d.State = 0
int thisTime = Convert.ToInt32(OrderTime.ToString("yyyyMMdd00"));
if (StaticInfo.hasNoZhuRu("aa"))
{
try
{
if (intTime == 0)
{
int Btime = Convert.ToInt32(OrderTime.ToString("yyyyMMdd00")); //开始的时间 2016082500
int Etime = Convert.ToInt32(OrderTime.AddDays(1).ToString("yyyyMMdd00")); //结束的时间 2016082600
sqlWhere += " and d.OrderTime between " + Btime + " and " + Etime + " ";
}
else if (intTime == 1) //早餐
{
thisTime = thisTime + Convert.ToInt32(DBConnection.SystemConfig.SelectSystemConfig(1).Rows[0]["Value"]); //早晨6:00
sqlWhere += " and d.OrderTime =" + Convert.ToString(thisTime) + " ";
}
else if (intTime == 2) //午餐
{
thisTime = thisTime + Convert.ToInt32(DBConnection.SystemConfig.SelectSystemConfig(2).Rows[0]["Value"]); //中午12:00
sqlWhere += " and d.OrderTime =" + Convert.ToString(thisTime) + " ";
}
else if (intTime == 3) //晚餐
{
thisTime = thisTime + Convert.ToInt32(DBConnection.SystemConfig.SelectSystemConfig(3).Rows[0]["Value"]); //下午18:00
sqlWhere += " and d.OrderTime =" + Convert.ToString(thisTime) + " ";
}
if (State != -1)
{
sqlWhere += " and d.State=" + Convert.ToString(State) + " ";
}
if (YuanGongID != -1)
{
sqlWhere += " and d.YuanGongID=" + Convert.ToString(YuanGongID) + " ";
}
err.result = DBConnection.OrderData.SelectTotalOrderDataSongCan(sqlWhere);
if (err.result != null)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("SelectTotalOrderInfoChuShi", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// Order_查询当日所有订单分页
/// </summary>
/// <param name="intPageIndex">第几页</param>
/// <param name="eachPageNum">每页显示几条</param>
/// <param name="intTime">哪个时间段的订餐 0:全天 1:早餐 2:午餐 3：晚餐</param>
/// <param name="State">订单的状态 0:未结束 1:已结束</param>
/// <param name="ShopID">店铺ID</param>
public static ReturnTableClass SelectOrderByPageIndex(int intPageIndex, int eachPageNum, int intTime, int State, DateTime OrderTime, int ShopID, string Name)
{
ReturnTableClass err = new ReturnTableClass();
DataTable dtRow = null;
string sqlWhere = "where 1=1 and d.ShopID=" + Convert.ToString(ShopID) + " ";
int thisTime = Convert.ToInt32(OrderTime.ToString("yyyyMMdd00"));
if (StaticInfo.hasNoZhuRu("aa"))
{
try
{
if (intTime == 0)
{
int Btime = Convert.ToInt32(OrderTime.ToString("yyyyMMdd00")); //开始的时间 2016082500
int Etime = Convert.ToInt32(OrderTime.AddDays(1).ToString("yyyyMMdd00")); //结束的时间 2016082600
sqlWhere += " and d.OrderTime between " + Btime + " and " + Etime + " ";
}
else if (intTime == 1) //早餐
{
thisTime = thisTime + Convert.ToInt32(DBConnection.SystemConfig.SelectSystemConfig(1).Rows[0]["Value"]); //早晨6:00
sqlWhere += " and d.OrderTime =" + Convert.ToString(thisTime) + " ";
}
else if (intTime == 2) //午餐
{
thisTime = thisTime + Convert.ToInt32(DBConnection.SystemConfig.SelectSystemConfig(2).Rows[0]["Value"]); //中午12:00
sqlWhere += " and d.OrderTime =" + Convert.ToString(thisTime) + " ";
}
else if (intTime == 3) //晚餐
{
thisTime = thisTime + Convert.ToInt32(DBConnection.SystemConfig.SelectSystemConfig(3).Rows[0]["Value"]); //下午18:00
sqlWhere += " and d.OrderTime =" + Convert.ToString(thisTime) + " ";
}
if (State != -1)
{
sqlWhere += " and d.State=" + Convert.ToString(State) + " ";
}
if (Name != "-1")
{
sqlWhere += " and d.Name like '%" + Name + "%'";
}
err.result = DBConnection.OrderData.SelectTotalOrderDataByPageIndex(intPageIndex, eachPageNum, sqlWhere, out dtRow);
err.RowCount = dtRow;
if (err.result != null)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("SelectOrderInfo", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}
/// <summary>
/// Order_厨师查看自己的订单详情
/// </summary>
/// /// <param name="intTime">哪个时间段的订餐 0:全天 1:早餐 2:午餐 3：晚餐</param>
/// <param name="State">订单的状态 0:未结束 1:已结束</param>
/// <param name="ShopID">店铺ID</param>
/// <param name="OrderTime">查询的日期</param>
/// <param name="Category">种类 1：肉类2：蔬菜类3：面食</param>
public static ReturnClass SelectTotalOrderInfoChuShi(int intTime, int State, int ShopID, DateTime OrderTime, int Category)
{
////看一下当前时间应该是查看什么时间段的订餐
OrderTime = DateTime.Now;
//int intOrderTime =Convert.ToInt32(DateTime.Now.ToString("yyyyMMddHH"));
//if(intOrderTime<Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd06")))//当日早餐
//{
// intTime = 1;
//}
//else if(intOrderTime > Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd06"))&& intOrderTime < Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd12")))//当日午餐
//{
// intTime = 2;
//}
//else if (intOrderTime > Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd12")) && intOrderTime < Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd18")))//当日晚餐
//{
// intTime = 3;
//}
//else if(intOrderTime > Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd18"))&& intOrderTime > Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd24")))//明天早餐
//{
// OrderTime.AddDays(1);
// intTime = 1;
//}
ReturnClass err = new ReturnClass();
string sqlWhere = "where 1=1 and f.ShopID=" + Convert.ToString(ShopID) + " ";//where i.OrderTime =2016082418 and c.ID=1 and f.ShopID=1 and d.State=0
int thisTime = Convert.ToInt32(OrderTime.ToString("yyyyMMdd00"));
if (StaticInfo.hasNoZhuRu("aa"))
{
try
{
if (intTime == 0)
{
int Btime = Convert.ToInt32(OrderTime.ToString("yyyyMMdd00")); //开始的时间 2016082500
int Etime = Convert.ToInt32(OrderTime.AddDays(1).ToString("yyyyMMdd00")); //结束的时间 2016082600
sqlWhere += " and i.OrderTime between " + Btime + " and " + Etime + " ";
}
else if (intTime == 1) //早餐
{
thisTime = thisTime + Convert.ToInt32(DBConnection.SystemConfig.SelectSystemConfig(1).Rows[0]["Value"]); //早晨6:00
sqlWhere += " and i.OrderTime =" + Convert.ToString(thisTime) + " ";
}
else if (intTime == 2) //午餐
{
thisTime = thisTime + Convert.ToInt32(DBConnection.SystemConfig.SelectSystemConfig(2).Rows[0]["Value"]); //中午12:00
sqlWhere += " and i.OrderTime =" + Convert.ToString(thisTime) + " ";
}
else if (intTime == 3) //晚餐
{
thisTime = thisTime + Convert.ToInt32(DBConnection.SystemConfig.SelectSystemConfig(3).Rows[0]["Value"]); //下午18:00
sqlWhere += " and i.OrderTime =" + Convert.ToString(thisTime) + " ";
}
if (State != -1)
{
sqlWhere += " and d.State=" + Convert.ToString(State) + " ";
}
if (Category != -1)
{
sqlWhere += " and c.ID=" + Convert.ToString(Category) + " ";
}
err.result = DBConnection.OrderInfo.SelectTotalOrderInfoChuShi(sqlWhere);
if (err.result != null)
{
err.Code = ErrorCode.SUSCCED;
}
else
{
err.Code = ErrorCode.FAIL;
}
}
catch (Exception ex)
{
DBConnection.LogHelper.insertLogError("SelectTotalOrderInfoChuShi", ex.ToString(), DateTime.Now);
}
}
else
{
err.result = 0;
err.Code = ErrorCode.ERR_ZHURU;
err.Msg = "sql注入!";
}
return(err);
}