/// <summary> /// 供應商出貨單 /// </summary> /// <returns></returns> public HttpResponseBase OrderWaitDeliverList() { string jsonStr = String.Empty; StringBuilder sb = new StringBuilder(); HashEncrypt hmd5 = new HashEncrypt(); _IOrderSlaveMgr = new OrderSlaveMgr(mySqlConnectionString); _OrderPaymentNcccMgr = new OrderPaymentNcccMgr(mySqlConnectionString); _SinopacMgr = new SinopacDetailMgr(mySqlConnectionString); _vendorImp = new VendorMgr(mySqlConnectionString); try { #region 前提查詢條件 if (!string.IsNullOrEmpty(Request.Params["search_type"]))//查詢條件 { int search_type = int.Parse(Request.Params["search_type"]); string searchcontent = ""; if (!string.IsNullOrEmpty(Request.Params["searchcontent"])) { searchcontent = Request.Params["searchcontent"]; } switch (search_type) { case 1: sb.AppendFormat(" and om.order_id LIKE '%{0}%' ", searchcontent); break; case 2: sb.AppendFormat(" AND om.order_name LIKE '%{0}%' ", searchcontent); break; case 3: sb.AppendFormat(" AND u.user_email LIKE '%{0}%' ", searchcontent); break; case 4: sb.AppendFormat(" AND om.delivery_name LIKE '%{0}%' ", searchcontent); break; case 5: sb.AppendFormat(" AND om.source_trace LIKE '%{0}%' ", searchcontent); break; default: sb.Append(" "); break; } } if (!string.IsNullOrEmpty(Request.Params["search_vendor"]))//供應商條件 { if (int.Parse(Request.Params["search_vendor"]) != 0) { sb.AppendFormat(" AND os.vendor_id = '{0}' ", Request.Params["search_vendor"]); } } #endregion List<OrderSlaveQuery> store = new List<OrderSlaveQuery>(); OrderSlaveQuery query = new OrderSlaveQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量 int totalCount = 0; store = _IOrderSlaveMgr.GetOrderWaitDeliver(query, sb.ToString(), out totalCount);//查询出供應商出貨單 int vendor_id = 0; string loginIdStr = string.Empty; string mdlogin_id = string.Empty; StringBuilder Order_id_store = new StringBuilder(); foreach (var item in store) { Order_id_store.AppendFormat("{0},", item.order_id); } string dtSql = "and order_id in(" + Order_id_store.ToString().TrimEnd(',') + ") ";//去查詢DataTable DataTable _dtNccc = _OrderPaymentNcccMgr.OrderPaymentNccc(null, dtSql); DataTable _dtSino = _SinopacMgr.GetSinopacDetai(null, dtSql); // String Sql = "123"; foreach (var item in store) { //組裝用於登錄到供應商後臺的金鑰 vendor_id = Convert.ToInt32(item.vendor_id); loginIdStr = _vendorImp.GetLoginId(vendor_id); mdlogin_id = hmd5.Md5Encrypt(loginIdStr, "MD5"); //http://localhost:32088/?vendor_id=2&key=f32bef1b57de24330d8bf900cee4ba5e item.key = vendorServerPath + "?vendor_id=" + item.vendor_id + "&key=" + hmd5.Md5Encrypt(mdlogin_id + loginIdStr, "MD5"); item.status = "待出貨"; if (item.order_payment == 1)//付款方式为ATM { DataRow[] rows = _dtSino.Select("order_id='" + item.order_id + "'"); if (rows.Count() != 0) { item.pay_time = DateTime.Parse(rows[0]["pay_time"].ToString()).ToString("yyyy/MM/dd HH:mm:ss"); } else { item.pay_time = ""; } } else { DataRow[] rows = _dtNccc.Select("order_id='" + item.order_id + "'"); if (rows.Count() != 0) { item.pay_time = DateTime.Parse(rows[0]["pay_time"].ToString()).ToString("yyyy/MM/dd HH:mm:ss"); } else { item.pay_time = ""; } } } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd"; jsonStr = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據 } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); jsonStr = "{success:false,msg:0}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
/// <summary> /// 匯出供應商出貨單 /// </summary> public void OrderWaitDeliverExport() { string json = string.Empty; StringBuilder sb = new StringBuilder(); try { #region 前提查詢條件 string type = Request.Params["search_type"]; if (!string.IsNullOrEmpty(type.Trim()) && !type.Equals("null"))//查詢條件 || { int search_type = int.Parse(Request.Params["search_type"]); string searchcontent = ""; if (!string.IsNullOrEmpty(Request.Params["search_type"])) { searchcontent = Request.Params["searchcontent"]; } switch (search_type) { case 1: sb.AppendFormat(" and om.order_id LIKE '%{0}%' ", searchcontent); break; case 2: sb.AppendFormat(" AND om.order_name LIKE '%{0}%' ", searchcontent); break; case 3: sb.AppendFormat(" AND u.user_email LIKE '%{0}%' ", searchcontent); break; case 4: sb.AppendFormat(" AND om.delivery_name LIKE '%{0}%' ", searchcontent); break; case 5: sb.AppendFormat(" AND om.source_trace LIKE '%{0}%' ", searchcontent); break; default: sb.Append(" "); break; } } type = Request.Params["search_vendor"]; if (!string.IsNullOrEmpty(Request.Params["search_vendor"]) && !type.Equals("null"))//供應商條件 { if (int.Parse(Request.Params["search_vendor"]) != 0) { sb.AppendFormat(" AND os.vendor_id = '{0}' ", Request.Params["search_vendor"]); } } #endregion string fileName = "order_deliver" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv"; List<OrderSlaveQuery> store = new List<OrderSlaveQuery>(); DataTable _dtZip = new DataTable(); _zipMgr = new ZipMgr(mySqlConnectionString); _dtZip = _zipMgr.ZipTable(null, null); OrderSlaveQuery query = new OrderSlaveQuery(); int totalCount = 0; _IOrderSlaveMgr = new OrderSlaveMgr(mySqlConnectionString); query.IsPage = false; store = _IOrderSlaveMgr.GetOrderWaitDeliver(query, sb.ToString(), out totalCount);//匯出出供應商出貨單 DataTable dtHZ = new DataTable(); string newExcelName = string.Empty; dtHZ.Columns.Add("付款單號", typeof(String)); dtHZ.Columns.Add("轉單時間", typeof(String)); dtHZ.Columns.Add("供應商", typeof(String)); dtHZ.Columns.Add("收貨人", typeof(String)); // dtHZ.Columns.Add("收貨人手機", typeof(String)); //dtHZ.Columns.Add("收貨人地址", typeof(String)); dtHZ.Columns.Add("備註", typeof(String)); for (int i = 0; i < store.Count; i++) { DataRow dr = dtHZ.NewRow(); dr[0] = store[i].order_id; dr[1] = store[i].order_date_pay; dr[2] = store[i].vendor_name_simple; dr[3] = store[i].delivery_name; //dr[4] = store[i].delivery_mobile; //DataRow[] rows = _dtZip.Select("zipcode='" + store[i].delivery_zip + "'"); //StringBuilder sbaddress = new StringBuilder(); //if (rows.Count() != 0) //{ // dr[5] = sbaddress.Append(rows[0]["middle"].ToString() + rows[0]["small"].ToString()); //} //sbaddress.Append(store[i].delivery_address); //string address = sbaddress.ToString(); //address = address.Replace(',', ','); //address = address.Replace("\n", ""); //dr[5] = address; store[i].note_order = store[i].note_order.Replace(',', ','); store[i].note_order = store[i].note_order.Replace("\n", ""); dr[4] = store[i].note_order; dtHZ.Rows.Add(dr); } if (!System.IO.Directory.Exists(Server.MapPath(excelPath))) { System.IO.Directory.CreateDirectory(Server.MapPath(excelPath)); } string newName = string.Empty; newName = Server.MapPath(excelPath) + fileName; if (System.IO.File.Exists(newName)) { //設置文件的屬性,以防刪除文件的時候因為文件的屬性造成無法刪除 System.IO.File.SetAttributes(newName, FileAttributes.Normal); System.IO.File.Delete(newName); } StringWriter sw = ExcelHelperXhf.SetCsvFromData(dtHZ, fileName); Response.Clear(); Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName); Response.ContentType = "application/ms-excel"; Response.ContentEncoding = Encoding.Default; Response.Write(sw); Response.End(); //StringWriter sw = ExcelHelperXhf.SetCsvFromData(dtHZ, fileName); //Response.Clear(); //Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(fileName)); //Response.ContentType = "application/ms-excel"; //Response.ContentEncoding = Encoding.Default; //Response.Write(sw); //Response.End(); //MemoryStream ms = ExcelHelperXhf.ExportDT(dtHZ, "order_deliver" + "_" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); //Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName); //Response.BinaryWrite(ms.ToArray()); } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,data:[]}"; } //this.Response.Clear(); //this.Response.Write(jsonStr.ToString()); //this.Response.End(); //return this.Response; }
/// <summary> /// 供應商後台:訂單管理>供應商調度出貨>要出的貨物信息 /// </summary> /// <returns></returns> public HttpResponseBase AllOrderDeliver() { uint Normal_Subtotal = 0;//常溫商品總額-- uint Hypothermia_Subtotal = 0;//低溫商品總額--- uint All_Normal_Subtotal = 0;//當日常溫運費總額 uint All_Hypothermia_Subtotal = 0;//當日低溫運費總額 uint Order_Freight_Normal = 0;//常溫運費 uint Order_Freight_Low = 0;//低溫運費 uint All_Order_Freight_Normal = 0;//當日常溫運費-- uint All_Order_Freight_Low = 0;//當日低溫運費-- string json = string.Empty; try { string detail_id = ""; if (!string.IsNullOrEmpty(Request.Params["rowIDs"])) { detail_id = Request.Params["rowIDs"]; } detail_id = detail_id.TrimEnd(',');//去掉最後一個分割符號 string[] Sid_Row = detail_id.Split(',');//拆分 string Sid = Sid_Row[Sid_Row.Length - 1];//獲取最後一個計算出出貨時間 //通過sid去order_slave查詢order_id; //通過order_id查詢在order_master中order_date_pay。 OrderSlaveQuery query = new OrderSlaveQuery(); query.Slave_Id = uint.Parse(Sid); _IOrderSlaveMgr = new OrderSlaveMgr(mySqlConnectionString); DateTime time = _IOrderSlaveMgr.GetOrderDatePay(query).order_date_pay; long endtime = CommonFunction.GetPHPTime(time.ToString("yyyy/MM/dd 23:59:59")); uint vendor_id = (Session["vendor"] as BLL.gigade.Model.Vendor).vendor_id; //(計算這些數據參照自vendor.gigade100.com/order/all_order_deliver.php 第209~266行) #region 計算供應商當天的常溫和冷凍的總運費 List<OrderDetailQuery> query1 = new List<OrderDetailQuery>(); _OrderDetailMgr = new OrderDetailMgr(mySqlConnectionString); query1 = _OrderDetailMgr.GetOrderDetailToSum(vendor_id, endtime); foreach (var item in query1) { if (item.item_mode == 1) continue; if (item.Product_Freight_Set == PRODUCT_FREIGHT_NORMAL || item.Product_Freight_Set == PRODUCT_FREIGHT_NO_NORMAL)//常溫,常溫免運 { if (item.item_mode == 2)//組合商品 { All_Normal_Subtotal += item.Single_Price * item.parent_num; } else { All_Normal_Subtotal += item.Single_Price * item.Buy_Num; } } else if (item.Product_Freight_Set == PRODUCT_FREIGHT_LOW || item.Product_Freight_Set == PRODUCT_FREIGHT_NO_LOW) //冷凍,冷凍免運 { if (item.item_mode == 2)//組合商品 { All_Hypothermia_Subtotal += item.Single_Price * item.parent_num; } else { All_Hypothermia_Subtotal += item.Single_Price * item.Buy_Num; } } } #endregion #region 計算運費 OrderDetailQuery oddquery = new OrderDetailQuery(); oddquery.Vendor_Id = vendor_id; _OrderDetailMgr = new OrderDetailMgr(mySqlConnectionString); int total = 0; string sq = string.Format(" AND os.slave_id in ({0}) ORDER BY od.slave_id ASC ,od. combined_mode ASC , od.item_mode ASC ", detail_id); List<OrderDetailQuery> query2 = new List<OrderDetailQuery>(); oddquery.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 oddquery.Limit = Convert.ToInt32(Request.Params["limit"] ?? "10");//用於分頁的變量 query1 = _OrderDetailMgr.AllOrderDeliver(oddquery, out total, sq); //uint Normal_Subtotal = 0;//常溫商品總額-- //uint Hypothermia_Subtotal = 0;//低溫商品總額--- //uint All_Normal_Subtotal = 0;//當日常溫運費總額 //uint All_Hypothermia_Subtotal = 0;//當日低溫運費總額 //uint Order_Freight_Normal = 0;//常溫運費 //uint Order_Freight_Low = 0;//低溫運費 //uint All_Order_Freight_Normal = 0;//當日常溫運費-- //uint All_Order_Freight_Low = 0;//當日低溫運費-- foreach (var item in query1) { if (item.item_mode == 1) continue; //商品總額計算(當下出貨金額與運費) if (item.Product_Freight_Set == PRODUCT_FREIGHT_NORMAL || item.Product_Freight_Set == PRODUCT_FREIGHT_NO_NORMAL)//常溫,常溫免運 { if (item.item_mode == 2) { Normal_Subtotal += item.Single_Price * item.parent_num; item.Buy_Num = item.Buy_Num * item.parent_num; item.Single_Price = item.Single_Price * item.parent_num; //Normal_Subtotal += item.Single_Price * item.parent_num;//--- //item.Buy_Num = item.Buy_Num * item.parent_num;//------- //item.Single_Money = item.Single_Price * item.Buy_Num;//--------- } else { Normal_Subtotal += item.Single_Price * item.Buy_Num; item.Single_Money = item.Single_Price * item.Buy_Num; } } else if (item.Product_Freight_Set == PRODUCT_FREIGHT_LOW || item.Product_Freight_Set == PRODUCT_FREIGHT_NO_LOW)//低溫,低溫免運 { if (item.item_mode == 2) { Hypothermia_Subtotal += item.Single_Price * item.parent_num; item.Buy_Num = item.Buy_Num * item.parent_num; item.Single_Price = item.Single_Price * item.parent_num; //Hypothermia_Subtotal += item.Single_Price * item.parent_num;//-------- //item.Buy_Num = item.Buy_Num * item.parent_num;//------------ //item.Single_Money = item.Single_Price * item.Buy_Num;//--------- } else { Hypothermia_Subtotal += item.Single_Price * item.Buy_Num; item.Single_Money = item.Single_Price * item.Buy_Num; } } query2.Add(item); } _VendorMgr = new VendorMgr(mySqlConnectionString); BLL.gigade.Model.Vendor vendor = new BLL.gigade.Model.Vendor(); vendor.vendor_id = vendor_id; vendor = _VendorMgr.GetSingle(vendor); //當下運費計算 if (Normal_Subtotal != 0) { if (vendor.freight_normal_limit > Normal_Subtotal) { Order_Freight_Normal = vendor.freight_normal_money; } } if (Hypothermia_Subtotal != 0) { if (vendor.freight_low_limit > Hypothermia_Subtotal && Hypothermia_Subtotal > 0) { Order_Freight_Low = vendor.freight_low_money; } } //批次單總額運費 if (All_Normal_Subtotal != 0) { if (vendor.freight_normal_limit > All_Normal_Subtotal) { All_Order_Freight_Normal = vendor.freight_normal_money; } } if (All_Hypothermia_Subtotal != 0) { if (vendor.freight_low_limit > All_Order_Freight_Low) { All_Order_Freight_Low = vendor.freight_low_money; } } #endregion IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd"; json = "{success:true,Normal_Subtotal:" + Normal_Subtotal + ",Hypothermia_Subtotal:" + Hypothermia_Subtotal + ",Order_Freight_Normal:" + Order_Freight_Normal + ",Order_Freight_Low:" + Order_Freight_Low; json += ",All_Order_Freight_Normal:" + All_Order_Freight_Normal + ",All_Order_Freight_Low:" + All_Order_Freight_Low + ",data:" + JsonConvert.SerializeObject(query2, Formatting.Indented, timeConverter) + "}";//返回json數據 } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,msg:0}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// 供應商後台:訂單管理>供應商調度出貨 /// </summary> /// <returns></returns> public HttpResponseBase GetDeliverList() { BLL.gigade.Model.Vendor vendor = Session["vendor"] as BLL.gigade.Model.Vendor; uint vendor_id = vendor.vendor_id; string json = String.Empty; StringBuilder sb = new StringBuilder(); List<OrderSlaveQuery> store = new List<OrderSlaveQuery>(); OrderSlaveQuery query = new OrderSlaveQuery(); string jsonStr = String.Empty; try { if (!string.IsNullOrEmpty(Request.Params["Search"])) { sb.AppendFormat(" AND ( om.order_id = '{0}')", Request.Params["Search"]); } if (!string.IsNullOrEmpty(vendor_id.ToString())) { query.vendor_id = vendor_id; } query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量 _IOrderSlaveMgr = new OrderSlaveMgr(mySqlConnectionString); int totalCount = 0; store = _IOrderSlaveMgr.GetAllOrderWait(query, sb.ToString(), out totalCount);//查询出供應商出貨單 for (int i = 0; i < store.Count; i++) { store[i].pay_time = store[i].order_date_pay.ToString("yyyy/MM/dd HH:mm:ss");//轉單日期 store[i].status = "待出貨"; store[i].code = store[i].order_date_pay.AddDays(1).ToString("yyyyMMdd");//批次編號 (參照php:/vendor.gigade100.com/order/all_order_deliver.php第67行) store[i].order_createdate = store[i].code; if (i > 0) { for (int j = 0; j < i; j++) { if (store[j].code == store[i].code) { store[i].code = "—"; break; } } } } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd"; jsonStr = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據 } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); jsonStr = "{success:false,msg:0}"; } this.Response.Clear(); this.Response.Write(jsonStr); this.Response.End(); return this.Response; }
/// <summary> /// 自出商品列表 /// </summary> /// <returns></returns> public HttpResponseBase VendorWaitDeliverList() { string jsonStr = String.Empty; StringBuilder sb = new StringBuilder(); _IOrderSlaveMgr = new OrderSlaveMgr(mySqlConnectionString); try { List<OrderSlaveQuery> store = new List<OrderSlaveQuery>(); OrderSlaveQuery query = new OrderSlaveQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量 query.vendor_id = ((BLL.gigade.Model.Vendor)Session["vendor"]).vendor_id;//Convert.ToUInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id); int totalCount = 0; store = _IOrderSlaveMgr.GetVendorWaitDeliver(query, sb.ToString(), out totalCount);//查询出供應商出貨單Vendor delivery int[] map = { 4, 1, 2, 3 }; Dictionary<int, int[]> delivery_store_arrival_period = new Dictionary<int, int[]>();//參考路径:vendor.gigade100.com/order/order_wait_deliver.php第100行 delivery_store_arrival_period.Add(1, map); delivery_store_arrival_period.Add(10, map); delivery_store_arrival_period.Add(16, map); delivery_store_arrival_period.Add(17, map); #region 到貨時段//0,不限時1,12:00以前 List<Parametersrc> paramentTime = new List<Parametersrc>();//到貨時段 _ptersrc = new ParameterMgr(mySqlConnectionString); paramentTime = _ptersrc.GetAllKindType("Estimated_Arrival_Period");//物流業者 DataTable _dtDelivery = new DataTable(); _dtDelivery.Columns.Add("parametercode", typeof(String)); _dtDelivery.Columns.Add("parameterName", typeof(String)); _dtDelivery.Columns.Add("remark", typeof(String)); foreach (var item in paramentTime) { DataRow dr = _dtDelivery.NewRow(); dr[0] = item.ParameterCode; dr[1] = item.parameterName; dr[2] = item.remark; _dtDelivery.Rows.Add(dr); } #endregion #region 台灣地區的參數 DataTable _dtZip = new DataTable(); _zipMgr = new ZipMgr(mySqlConnectionString); _dtZip = _zipMgr.ZipTable(null, null); #endregion foreach (var item in store)//為什麼是待出貨能,因為查詢的條件就是狀態為待出貨的 { item.status = "待出貨"; item.delivery = ""; item.pay_time = item.order_date_pay.ToString("yyyy/MM/dd HH:mm:ss"); if (delivery_store_arrival_period.Keys.Contains(item.delivery_store)) { DataRow[] rows = _dtDelivery.Select("ParameterCode='" + item.estimated_arrival_period + "'"); foreach (DataRow row in rows)//篩選出的最多只有一條數據, { item.delivery = ""; if (!string.IsNullOrEmpty(row["ParameterCode"].ToString())) { item.delivery = row["ParameterName"].ToString();//---送貨時段 } } } DataRow[] ziprows = _dtZip.Select("zipcode='" + item.delivery_zip + "'"); foreach (var ziprow in ziprows) { if (!string.IsNullOrEmpty(ziprow["zipcode"].ToString())) { item.delivery_address = item.delivery_zip + " " + ziprow["middle"].ToString() + ziprow["small"].ToString() + item.delivery_address; } } } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd"; jsonStr = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據 } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); jsonStr = "{success:false,msg:0}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase GetOrderDeliverDetailList() { StringBuilder addsql = new StringBuilder(); string json = string.Empty; string startTime = Request.Params["start_time"]; string endTime = Request.Params["end_time"]; if (!string.IsNullOrEmpty(startTime)) { addsql.AppendFormat(" and om.order_date_pay>='{0}' ", CommonFunction.GetPHPTime(DateTime.Parse(startTime).ToString("yyyy/MM/dd 00:00:00"))); } if (!string.IsNullOrEmpty(endTime)) { addsql.AppendFormat(" and om.order_date_pay<='{0}' ", CommonFunction.GetPHPTime(DateTime.Parse(endTime).ToString("yyyy/MM/dd 23:59:59"))); } addsql.Append(" AND od.detail_status = 2 AND product_mode = 1 "); BLL.gigade.Model.Vendor modelVendor = Session["vendor"] as BLL.gigade.Model.Vendor; StringBuilder sbHtml = new StringBuilder(); try { //OrderSlave OrderSlaveQuery orderSlaveQuery = new OrderSlaveQuery() { vendor_id = modelVendor.vendor_id, Slave_Status = 2,//待出貨 IsPage = false }; OrderSlaveQuery orderSlave = new OrderSlaveQuery(); DataTable dtOrderSlave = new DataTable(); _OrderSlaveMgr = new OrderSlaveMgr(mySqlConnectionString); //OrderDetail OrderDetailQuery orderDetailQuery = new OrderDetailQuery(); List<OrderDetailQuery> list = new List<OrderDetailQuery>(); _OrderDetailMgr = new OrderDetailMgr(mySqlConnectionString); int totalCount_OrderDetail = 0; Dictionary<OrderDetailQuery, List<OrderDetailQuery>> product_freight_set_mapping = new Dictionary<OrderDetailQuery, List<OrderDetailQuery>>(); //根據時間搜索order_id dtOrderSlave = _OrderSlaveMgr.GetListPrint(orderSlaveQuery, addsql.ToString()); if (dtOrderSlave.Rows.Count > 0) { //循環order_id foreach (DataRow item in dtOrderSlave.Rows) { //orderSlave orderSlave.order_id = Convert.ToUInt32(item["order_id"]); orderSlave.order_createdate = Convert.ToDateTime(item["order_createdate"]).ToString("yyyy-MM-dd HH:mm:ss"); orderSlave.pay_time = Convert.ToDateTime(item["order_date_pay"]).ToString("yyyy-MM-dd HH:mm:ss"); orderSlave.order_name = item["order_name"].ToString(); orderSlave.delivery_name = item["delivery_name"].ToString(); orderSlave.estimated_arrival_period = Convert.ToInt32(item["estimated_arrival_period"]); orderSlave.note_order = item["note_order"].ToString(); orderSlave.dispatch = 0; orderSlave.delivery_zip = Convert.ToUInt32(item["delivery_zip"]); orderSlave.delivery_address = item["delivery_address"].ToString(); orderSlave.delivery_mobile = item["delivery_mobile"].ToString(); //供查詢列表使用 orderDetailQuery.Slave_Id = Convert.ToUInt32(item["slave_id"]); list = _OrderDetailMgr.GetOrderDetailList(orderDetailQuery, out totalCount_OrderDetail); sbHtml.Append(GetOrderDeliverDetailHtml(orderSlave, list)); } } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd"; //json = "{success:true,data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據 json = "{success:true,msg:\"" + sbHtml.ToString() + "\"}"; } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,msg:0}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetOrderDeliverDetail() { string json = string.Empty; string order_id = Request.Params["oid"]; string p_mode = Request.Params["p_mode"]; BLL.gigade.Model.Vendor modelVendor = Session["vendor"] as BLL.gigade.Model.Vendor; //OrderSlave OrderSlaveQuery orderSlaveQuery = new OrderSlaveQuery() { order_id = Convert.ToUInt32(order_id), vendor_id = modelVendor.vendor_id, Slave_Status = 2,//待出貨 IsPage = false }; OrderSlaveQuery orderSlave = new OrderSlaveQuery(); DataTable dtOrderSlave = new DataTable(); _OrderSlaveMgr = new OrderSlaveMgr(mySqlConnectionString); int totalCount_OrderSlave = 0; //OrderDetail OrderDetailQuery orderDetailQuery = new OrderDetailQuery(); //orderDetailQuery.Order_Id = uint.Parse(order_id); List<OrderDetailQuery> list = new List<OrderDetailQuery>(); _OrderDetailMgr = new OrderDetailMgr(mySqlConnectionString); int totalCount_OrderDetail = 0; try { dtOrderSlave = _OrderSlaveMgr.GetList(orderSlaveQuery, out totalCount_OrderSlave); if (dtOrderSlave.Rows.Count > 0) { //orderSlave orderSlave.order_id = Convert.ToUInt32(dtOrderSlave.Rows[0]["order_id"]); orderSlave.order_createdate = dtOrderSlave.Rows[0]["order_createdate"].ToString(); orderSlave.pay_time = dtOrderSlave.Rows[0]["order_date_pay"].ToString(); orderSlave.order_name = dtOrderSlave.Rows[0]["order_name"].ToString(); orderSlave.delivery_name = dtOrderSlave.Rows[0]["delivery_name"].ToString(); orderSlave.estimated_arrival_period = Convert.ToInt32(dtOrderSlave.Rows[0]["estimated_arrival_period"]); orderSlave.note_order = dtOrderSlave.Rows[0]["note_order"].ToString(); orderSlave.dispatch = modelVendor.dispatch; orderSlave.delivery_zip = Convert.ToUInt32(dtOrderSlave.Rows[0]["delivery_zip"]); orderSlave.delivery_address = dtOrderSlave.Rows[0]["delivery_address"].ToString(); orderSlave.delivery_mobile = dtOrderSlave.Rows[0]["delivery_mobile"].ToString(); //供查詢列表使用 orderDetailQuery.Slave_Id = Convert.ToUInt32(dtOrderSlave.Rows[0]["slave_id"]); } list = _OrderDetailMgr.GetOrderDetailList(orderDetailQuery, out totalCount_OrderDetail); List<OrderDetailQuery> stroes = new List<OrderDetailQuery>(); stroes = getList(list); string html = GetOrderDeliverDetailHtml(orderSlave, stroes); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd"; //json = "{success:true,data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據 json = "{success:true,msg:\"" + html + "\"}"; } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,msg:0}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }