public string GetOrderBaoBiaoByWhere() { ResultInfo <List <object> > data = new ResultInfo <List <object> >(); string customerId = Request.Params["customerId"]; string datest = Request.Params["datest"]; string dateed = Request.Params["dateed"]; //查询条件组织 string where = string.Empty; where += " is_del=0 and "; if (!string.IsNullOrEmpty(customerId)) { where += " customer_id=" + customerId + " and "; } if (!string.IsNullOrEmpty(datest)) { where += " delivery_time>='" + DateTime.Parse(datest).ToString("yyyy-MM-dd") + "' and "; } if (!string.IsNullOrEmpty(dateed)) { where += " delivery_time<='" + DateTime.Parse(dateed).ToString("yyyy-MM-dd") + "' and "; } if (!string.IsNullOrEmpty(where)) { where = where.Substring(0, where.Length - 4); } var dt = new MultiColorPen.BLL.order_info().GetBaoBiaoList(where).Tables[0]; data.IsSucceed = true; data.Entity = JsonHelper.DataTableToList(dt); return(JsonConvert.SerializeObject(data)); }
//public string DeleteCommodity(int id) //{ // ResultInfo result = new ResultInfo(false); // var bll = new MultiColorPen.BLL.commodity(); // var umodel = bll.GetModel(id); // umodel.is_del = "1"; // if (bll.Update(umodel)) // { // result.IsSucceed = true; // result.Message = "操作成功!"; // PublicClass.AddLog("Operating", "删除商品信息" + umodel.name + "!"); // } // else // { // result.IsSucceed = false; // result.Message = "删除失败!"; // } // return JsonConvert.SerializeObject(result); //} public string DeleteOrder(int id) { ResultInfo result = new ResultInfo(false); var bll = new MultiColorPen.BLL.order_info(); var umodel = bll.GetModel(id); umodel.is_del = "1"; if (bll.Update(umodel)) { result.IsSucceed = true; result.Message = "操作成功!"; PublicClass.AddLog("Operating", "删除订单" + umodel.id + "!"); } else { result.IsSucceed = false; result.Message = "删除失败!"; } return(JsonConvert.SerializeObject(result)); }
//public string GetAllOrder() //{ // ResultInfo<List<object>> data = new ResultInfo<List<object>>(); // var dt = new MultiColorPen.BLL.order_info().GetList(" is_del='0' ").Tables[0]; // if (dt != null && dt.Rows.Count > 0) // { // data.IsSucceed = true; // data.Message = "Get Data!"; // data.TotalCount = dt.Rows.Count; // } // else // { // data.IsSucceed = false; // data.Message = "没有可展示的数据!"; // data.TotalCount = 0; // } // data.Entity = JsonHelper.DataTableToList(dt); // return JsonConvert.SerializeObject(data); //} public string GetAllOrder() { ResultInfo <List <object> > data = new ResultInfo <List <object> >(); int pageSize = int.Parse(Request.Params["pagesize"]); int pageNo = int.Parse(Request.Params["pageno"]); string order = Request.Params["order"]; string customerId = Request.Params["customerId"]; string datest = Request.Params["datest"]; string dateed = Request.Params["dateed"]; //查询条件组织 string where = string.Empty; where += " is_del=0 and "; if (!string.IsNullOrEmpty(customerId)) { where += " customer_id=" + customerId + " and "; } if (!string.IsNullOrEmpty(datest)) { where += " delivery_time>='" + DateTime.Parse(datest).ToString("yyyy-MM-dd") + "' and "; } if (!string.IsNullOrEmpty(dateed)) { where += " delivery_time<='" + DateTime.Parse(dateed).ToString("yyyy-MM-dd") + "' and "; } if (!string.IsNullOrEmpty(where)) { where = where.Substring(0, where.Length - 4); } int startIndex = pageSize * (pageNo - 1) + 1; int endIndex = pageSize * pageNo; var dt = new MultiColorPen.BLL.order_info().GetListByPage(where, order, startIndex, endIndex).Tables[0]; data.IsSucceed = true; data.TotalCount = new MultiColorPen.BLL.order_info().GetRecordCount(where); data.Entity = JsonHelper.DataTableToList(dt); return(JsonConvert.SerializeObject(data)); }
public string SaveOrder(string json, string orderInfo) { //json = json.Replace("[","").Replace("]",""); orderInfo = orderInfo.Replace("[", "").Replace("]", ""); var bllOrder = new MultiColorPen.BLL.order_info(); var bllDetail = new MultiColorPen.BLL.order_detail(); var bllCommo = new MultiColorPen.BLL.commodity(); var bllCustomer = new MultiColorPen.BLL.customer(); bool isSuccess = true; string orderNumber = "";//订单编号 JArray jArray = JArray.Parse(json); var oldOrderInfo = new MultiColorPen.Model.order_info(); ResultInfo result = new ResultInfo(false); JObject jo = JObject.Parse(orderInfo); //解析order信息 if (jo["orderId"].ToString() == "-1") //新增订单 { orderNumber = "ORDER" + DateTime.Now.ToString("yyyyMMddHHmmss"); } else { oldOrderInfo = bllOrder.GetModel((int)jo["orderId"]); //获取旧的订单信息 orderNumber = oldOrderInfo.number; //编辑时使用旧的订单编号 oldOrderInfo.is_del = "1"; if (!bllOrder.Update(oldOrderInfo)) //删除旧的订单信息 { isSuccess = false; } if (!bllDetail.DeleteByWhere(" order_number='" + orderNumber + "'")) //删除详细商品的对应数据 { isSuccess = false; } } foreach (var jj in jArray) { JObject jdata = (JObject)jj; var commodityModel = bllCommo.GetModel((int)jdata["name"]); var orderDetailModel = new MultiColorPen.Model.order_detail(); orderDetailModel.commodity_count = (int)jdata["count"]; orderDetailModel.commodity_id = (int)jdata["name"]; orderDetailModel.commodity_price = commodityModel.price; orderDetailModel.commodity_unit = commodityModel.unit; orderDetailModel.order_number = orderNumber; orderDetailModel.commodity_name = commodityModel.name; orderDetailModel.mark = jdata["mark"].ToString(); orderDetailModel.is_del = "0"; if (!bllDetail.Add(orderDetailModel)) //插入商品详情 { isSuccess = false; } } var customerModel = bllCustomer.GetModel((int)jo["customerId"]); var orderModel = new MultiColorPen.Model.order_info(); orderModel.create_time = DateTime.Now.ToString("yyyy-MM-dd HH-mm-ss"); orderModel.customer_id = (int)jo["customerId"]; orderModel.customer_address = customerModel.address; orderModel.customer_name = customerModel.name; orderModel.customer_person = customerModel.person; orderModel.customer_tel = customerModel.tel; orderModel.delivery_time = jo["deliverTime"].ToString(); orderModel.is_del = "0"; orderModel.status = "已下单"; orderModel.number = orderNumber; orderModel.mark = jo["orderMark"].ToString(); if (!bllOrder.Add(orderModel)) //插入订单信息 { isSuccess = false; } if (isSuccess) { result.IsSucceed = true; result.Message = "操作成功!"; } else { result.IsSucceed = false; result.Message = "修改失败!"; } return(JsonConvert.SerializeObject(result)); }