private void initLocalPickUpAddr(AutoOrderList auto_orderlist) { txt_send_addr_contact.Text = auto_orderlist.CollectionContactName; txt_send_addr_company.Text = auto_orderlist.CollectionCompanyName; txt_send_addr_line1.Text = auto_orderlist.CollectionAddressLine; txt_send_addr_phone.Text = auto_orderlist.CollectionPhone; txt_send_addr_postcode.Text = auto_orderlist.CollectionPostCode; txt_send_addr_city.Text = auto_orderlist.CollectionTown; txt_send_addr_country.Text = "UK"; string today_time = DateTime.Now.ToString("yyyy-MM-dd"); //判断今天星期 几 int k = (int)DateTime.Parse(today_time).DayOfWeek; if (k == 5) { txt_shipdate.Text = DateTime.Now.AddDays(3).ToString("yyyy-MM-dd"); } else if (k == 6) { txt_shipdate.Text = DateTime.Now.AddDays(2).ToString("yyyy-MM-dd"); } else { txt_shipdate.Text = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["admin"] == null && Session["manager"] == null && Session["staff"] == null) { Response.Redirect("error-page.aspx"); } else { string type = Request.QueryString["type"]; order_number = Request.QueryString["order_number"]; if (order_number == null || type == null) { Response.Redirect("error-page.aspx"); } else { if (type == "detail") { order = new AutoOrderListDAO().getAutoOrderList(order_number); has_addr_id.Visible = true; //初始化发件地址 txt_send_addr_contact.Text = order.CollectionContactName; txt_send_addr_company.Text = order.CollectionCompanyName; txt_send_addr_line1.Text = order.CollectionAddressLine; txt_send_addr_city.Text = order.CollectionTown; txt_send_addr_postcode.Text = order.CollectionPostCode; txt_send_addr_country.Text = order.CollectionCountry; txt_send_addr_phone.Text = order.CollectionPhone; //初始化收件地址 txt_receive_addr_contact.Text = order.RecipientContactName; txt_receive_addr_company.Text = order.RecipientCompanyName; txt_receive_addr_line1.Text = order.RecipientAddressLine; txt_receive_addr_city.Text = order.RecipientTown; txt_receive_addr_postcode.Text = order.RecipeintPostCode; txt_receive_addr_country.Text = order.RecipientCountry; txt_receive_addr_phone.Text = order.RecipientPhone; } else if (type == "download") { string filename = Server.MapPath("\\views\\pdf\\" + order_number + "2.pdf"); HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + order_number + ".pdf"); HttpContext.Current.Response.WriteFile(filename); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.Close(); } } } } }
private DataTable createBarCodeTable(ArrayList orders) { DataTable table = new DataTable(); //订单号 DataColumn dc = new DataColumn("order_number", typeof(string)); table.Columns.Add(dc); //包裹个数 dc = new DataColumn("quantity", typeof(int)); table.Columns.Add(dc); //发件人 dc = new DataColumn("sender", typeof(string)); table.Columns.Add(dc); //收件人 dc = new DataColumn("receiver", typeof(string)); table.Columns.Add(dc); //服务方式 dc = new DataColumn("postway", typeof(string)); table.Columns.Add(dc); //付款金额 dc = new DataColumn("pay", typeof(string)); table.Columns.Add(dc); //下单时间 dc = new DataColumn("time", typeof(string)); table.Columns.Add(dc); for (int i = 0; i < orders.Count; i++) { AutoOrderList order = (AutoOrderList)orders[i]; DataRow dr = table.NewRow(); dr["order_number"] = order.Order_no; dr["quantity"] = 1; dr["sender"] = order.CollectionContactName; dr["receiver"] = order.RecipientContactName; dr["postway"] = order.ServiceCode; dr["pay"] = order.Pay_after_discount; dr["time"] = order.Pay_time; table.Rows.Add(dr); } return(table); }
private ArrayList getCartPackageInfo(AutoOrderList autoorder) { ArrayList packages = new ArrayList(); PackageCartInfo cartinfo = new PackageCartInfo(); cartinfo.Description = autoorder.PackageDescription; cartinfo.Value = autoorder.PackageValue; cartinfo.Weight = autoorder.Weight; cartinfo.Length = autoorder.Length; cartinfo.Width = autoorder.Width; cartinfo.Height = autoorder.Height; packages.Add(cartinfo); return(packages); }
/// <summary> /// 初始化Excel导入时的地址 /// </summary> /// <param name="autolist"></param> private void initExcelAddress(AutoOrderList autolist) { txt_send_addr_contact.Text = autolist.CollectionContactName; txt_send_addr_company.Text = autolist.CollectionCompanyName; txt_send_addr_line1.Text = autolist.CollectionAddressLine; txt_send_addr_line2.Text = ""; txt_send_addr_line3.Text = ""; txt_send_addr_city.Text = autolist.CollectionTown; txt_send_addr_postcode.Text = autolist.CollectionPostCode; txt_send_addr_country.Text = autolist.CollectionCountry; txt_send_addr_phone.Text = autolist.CollectionPhone; txt_receive_addr_contact.Text = autolist.RecipientContactName; txt_receive_addr_company.Text = autolist.RecipientCompanyName; txt_receive_addr_line1.Text = autolist.RecipientAddressLine; txt_receive_addr_line2.Text = ""; txt_receive_addr_line3.Text = ""; txt_receive_addr_city.Text = autolist.RecipientTown; txt_receive_addr_postcode.Text = autolist.RecipeintPostCode; txt_receive_addr_country.Text = autolist.RecipientCountry; txt_receive_addr_phone.Text = autolist.RecipientPhone; }
/// <summary> /// 根据订单号查找订单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_query_order_Click(object sender, EventArgs e) { string track_no = txt_number.Text; // 首先查找 Excel 下单的订单 AutoOrderList autolist = new AutoOrderList(); autolist = new AutoOrderListDAO().getAutoOrderListByTrackNo(track_no); if (autolist.Ea_track_no != track_no) { Package package = new PackageDAO().getPackageByTrackNo(track_no); if (package.Ea_track_no != track_no) { alert("不存在该订单!!"); } else { Order order = new OrderDAO().getOrder(package.Order_number); autolist.Order_no = package.Wp_track_no; autolist.Ea_track_no = track_no; autolist.CollectionContactName = order.CollectionContactName; autolist.RecipientContactName = order.RecipientContactName; autolist.Weight = package.Weight; autolist.Pay_after_discount = package.Pay; autolist.Pay_time = order.Pay_time; packages.Add(autolist); } } else { packages.Add(autolist); } }
private DataTable createMyCartTable(string flag) { DataTable table = new DataTable(); //订单号 DataColumn dc = new DataColumn("order_number", typeof(string)); table.Columns.Add(dc); //包裹个数 dc = new DataColumn("quantity", typeof(float)); table.Columns.Add(dc); //包裹个数 dc = new DataColumn("weight", typeof(float)); table.Columns.Add(dc); //发件人 dc = new DataColumn("sender", typeof(string)); table.Columns.Add(dc); //收件人 dc = new DataColumn("receiver", typeof(string)); table.Columns.Add(dc); //收件人电话 dc = new DataColumn("phone", typeof(string)); table.Columns.Add(dc); //服务方式 dc = new DataColumn("postway", typeof(string)); table.Columns.Add(dc); //付款金额 dc = new DataColumn("pay", typeof(string)); table.Columns.Add(dc); //下单时间 dc = new DataColumn("time", typeof(string)); table.Columns.Add(dc); if (flag == "excel") { ArrayList auto_orders = new AutoOrderListDAO().getAutoOrderListArray(Session["name"].ToString(), "unpay"); for (int i = 0; i < auto_orders.Count; i++) { AutoOrderList order = (AutoOrderList)auto_orders[i]; DataRow dr = table.NewRow(); dr["order_number"] = order.Order_no; dr["quantity"] = 1; dr["weight"] = order.Weight; dr["sender"] = order.CollectionContactName; dr["receiver"] = order.RecipientContactName; dr["phone"] = order.RecipientPhone; dr["postway"] = getPostWay(order.ServiceCode); dr["pay"] = order.Pay_after_discount; dr["time"] = order.Order_time; table.Rows.Add(dr); } ArrayList orders = new OrderDAO().getOrders(Session["name"].ToString(), "unpay"); for (int i = 0; i < orders.Count; i++) { Order order = (Order)orders[i]; DataRow dr = table.NewRow(); dr["order_number"] = order.Order_number; dr["quantity"] = order.Quantity; dr["weight"] = order.Weight; dr["sender"] = order.CollectionContactName; dr["receiver"] = order.RecipientContactName; dr["phone"] = order.RecipientPhone; dr["postway"] = getPostWay(order.Post_way); dr["pay"] = order.Pay_after_discount; dr["time"] = order.Order_time.ToString("yyyy-MM-dd hh:mm"); table.Rows.Add(dr); } } else if (flag == "interface") { ArrayList orders = new OrderDAO().getOrders(Session["name"].ToString(), "unpay"); for (int i = 0; i < orders.Count; i++) { Order order = (Order)orders[i]; DataRow dr = table.NewRow(); dr["order_number"] = order.Order_number; dr["quantity"] = order.Quantity; dr["weight"] = order.Weight; dr["sender"] = order.CollectionContactName; dr["receiver"] = order.RecipientContactName; dr["phone"] = order.RecipientPhone; dr["postway"] = getPostWay(order.Post_way); dr["pay"] = order.Pay_after_discount; dr["time"] = order.Order_time.ToString("yyyy-MM-dd hh:mm"); table.Rows.Add(dr); } ArrayList auro_orders = new AutoOrderListDAO().getAutoOrderListArray(Session["name"].ToString(), "unpay"); for (int i = 0; i < auro_orders.Count; i++) { AutoOrderList order = (AutoOrderList)auro_orders[i]; DataRow dr = table.NewRow(); dr["order_number"] = order.Order_no; dr["quantity"] = 1; dr["weight"] = order.Weight; dr["sender"] = order.CollectionContactName; dr["receiver"] = order.RecipientContactName; dr["phone"] = order.RecipientPhone; dr["postway"] = getPostWay(order.ServiceCode); dr["pay"] = order.Pay_after_discount; dr["time"] = order.Order_time; table.Rows.Add(dr); } } return(table); }
//上传Excel文件的实现 protected void btn_upload_Click(object sender, EventArgs e) { int line_count = 0; string username = ""; string path = upload_ems_excel.FileName; if (path == "") { alert("请选择文件!!"); return; } else { username = Session["name"].ToString(); string file_path = saveUploadFile(); if (file_path == "error") { return; } DataSet ds = new DataSet(); string strConn = "Provider=ACE.OLEDB.12.0;" + "Data Source=" + file_path + ";" + "Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = ""; OleDbDataAdapter myCommand = null; OleDbCommandBuilder cb = new OleDbCommandBuilder(myCommand); strExcel = "select * from [Sheet1$] "; myCommand = new OleDbDataAdapter(strExcel, strConn); myCommand.Fill(ds, "table1"); ArrayList order_array = new ArrayList(); ArrayList package_array = new ArrayList(); DateTime temp_time = DateTime.Now; AutoOrder order = new AutoOrder(); DateTime time = DateTime.Now; Application.Lock(); string autoOrderNo = Application["orderNo"].ToString(); Application["orderNo"] = (int)Application["orderNo"] + 1; Application.UnLock(); string auto_no = "AU" + time.ToString("yyMMddHHmm") + autoOrderNo.PadLeft(8, '0'); order.Auto_no = auto_no; order.Name = Session["name"].ToString(); order.Order_time = time.ToString("yyyy-MM-dd HH:mm"); order.Is_pay = "unpay"; order.Pay_before_discount = 0; order.Excel_path = intablename; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i][4].ToString().Trim() != "" && (!ds.Tables[0].Rows[i][0].ToString().Trim().Contains("取件还是投送") && !ds.Tables[0].Rows[i][1].ToString().Trim().Contains("发件时间"))) { //判断Excel是否为空 string delivery_way = ds.Tables[0].Rows[i][0].ToString().Trim(); string delivery_time = ds.Tables[0].Rows[i][1].ToString().Trim(); string receive_company = ds.Tables[0].Rows[i][2].ToString().Trim(); string receive_name = ds.Tables[0].Rows[i][3].ToString().Trim(); string receive_phone = ds.Tables[0].Rows[i][4].ToString().Trim(); string receive_address_line = ds.Tables[0].Rows[i][5].ToString().Trim(); string receive_city = ds.Tables[0].Rows[i][6].ToString().Trim(); string receive_postcode = ds.Tables[0].Rows[i][7].ToString().Trim(); string receive_country = ds.Tables[0].Rows[i][8].ToString().Trim(); string send_company = ds.Tables[0].Rows[i][9].ToString().Trim(); string send_name = ds.Tables[0].Rows[i][10].ToString().Trim(); string send_phone = ds.Tables[0].Rows[i][11].ToString().Trim(); string send_addressline = ds.Tables[0].Rows[i][12].ToString().Trim(); string send_city = ds.Tables[0].Rows[i][13].ToString().Trim(); string send_postcode = ds.Tables[0].Rows[i][14].ToString().Trim(); string insurance = ds.Tables[0].Rows[i][15].ToString().Trim(); string comment = ds.Tables[0].Rows[i][16].ToString().Trim(); string parcel_number = ds.Tables[0].Rows[i][17].ToString().Trim(); string weight = ds.Tables[0].Rows[i][18].ToString().Trim(); string length = ds.Tables[0].Rows[i][19].ToString().Trim(); string width = ds.Tables[0].Rows[i][20].ToString().Trim(); string height = ds.Tables[0].Rows[i][21].ToString().Trim(); string description = ds.Tables[0].Rows[i][22].ToString().Trim(); string package_value = ds.Tables[0].Rows[i][23].ToString().Trim(); //判断重量、长、宽、高是否有效 { if (delivery_way == "") { alert("您好,包裹的取件方式不能为空,请仔细检查 Excel !!"); return; } else if (delivery_time == "") { alert("您好,包裹的取件时间不能为空,请仔细检查 Excel!!"); return; } else if (receive_company == "") { alert("您好,收件公司不能为空,如果没有收件公司,请写上收件人名 !!"); return; } else if (receive_name == "") { alert("您好,收件人名不能为空,请仔细检查 Excel!!"); return; } else if (receive_phone == "") { alert("您好,收件人 号码 不能为空,请仔细检查 Excel!!"); return; } else if (receive_address_line == "") { alert("您好,收件 地址 不能为空 ,请仔细检查 Excel!!"); return; } else if (receive_city == "") { alert("您好,收件人 城市 不能为空,请仔细检查 Excel!!"); return; } else if (receive_postcode == "") { alert("您好,收件人 邮编不能为空,请仔细检查 Excel !!"); return; } else if (receive_country == "") { alert("您好,收件人国家不能为空,必须是 China-NL 、 China-IPE 、 China-GPR , 请仔细检查 Excel !!"); return; } else if (send_company == "") { alert("您好,发件人公司不能为空,如果无发件人公司 就 填写发件人名 !!"); return; } else if (send_name == "") { alert("发件人名不能为空 , 请仔细检查 Excel!!"); return; } else if (send_phone == "") { alert("您好,发件人 电话 不能为空,请仔细检查!!"); return; } else if (send_addressline == "") { alert("您好,发件人地址不能为空,请仔细检查 !! "); return; } else if (send_city == "") { alert("您好,发件人城市不能为空,请仔细检查 !!"); return; } else if (send_postcode == "") { alert("您好,发件人 邮编不能为空, 请仔细检查 !! "); return; } else if (insurance == "") { alert("您好,是否购买保险字段不能为空,请填上 0 "); } else if (comment == "") { alert("您好,发货目的不能为空 , 请仔细检查 Excel!!"); return; } else if (weight == "") { alert("您好,包裹的重量不能为空 , 请仔细检查 Excel!!"); return; } else if (length == "") { alert("您好,包裹的长度不能为空 , 请仔细检查 Excel!!"); return; } else if (width == "") { alert("您好,包裹的宽度不能为空 , 请仔细检查 Excel!!"); return; } else if (height == "") { alert("您好,包裹的 高度不能为空,请仔细检查 !!"); return; } else if (description == "") { alert("您好,包裹的 描述不能为空,请仔细检查!!"); return; } else if (package_value == "") { alert("您好,包裹的价值不能为空,请仔细检查 !!"); return; } } //判断中文字符 。 { receive_company = receive_company.Replace('。', '.'); receive_name = receive_name.Replace('。', '.'); receive_address_line = receive_address_line.Replace('。', '.'); receive_city = receive_city.Replace('。', '.'); receive_postcode = receive_postcode.Replace('。', '.'); receive_country = receive_country.Replace('。', '.'); send_company = send_company.Replace('。', '.'); send_name = send_name.Replace('。', '.'); send_addressline = send_addressline.Replace('。', '.'); send_city = send_city.Replace('。', '.'); send_postcode = send_postcode.Replace('。', '.'); description = description.Replace('。', '.'); } try { Convert.ToSingle(weight); Convert.ToSingle(length); Convert.ToSingle(width); Convert.ToSingle(height); Convert.ToSingle(package_value); } catch (System.Exception ex) { alert("包裹的重量、长、宽、高、价值 信息必须位数字"); return; } if (receive_postcode.Length != 6) { alert("收件人邮编必须为 6 位!!"); return; } try { if (receive_phone.Contains("e") || send_phone.Contains("e")) { receive_phone = Convert.ToInt64(Convert.ToSingle(receive_phone)).ToString(); send_phone = Convert.ToInt64(Convert.ToSingle(send_phone)).ToString(); } } catch (System.Exception ex) { alert("收件人或者发件人电话格式错误"); return; } AutoOrderList package = new AutoOrderList(); //如果是 PostNL if (receive_country.ToLower().Equals("china-nl")) { line_count++; Application.Lock(); string orderNo = Application["packageNo"].ToString(); Application["packageNo"] = (int)Application["packageNo"] + 1; Application.UnLock(); package.Auto_no = auto_no; package.Order_no = "WA" + time.ToString("yyMMddHHmm") + orderNo.PadLeft(8, '0'); package.Name = Session["name"].ToString(); package.CollectionCompanyName = send_company; package.CollectionContactName = send_name; package.CollectionPhone = send_phone; package.CollectionAddressLine = send_addressline; package.CollectionTown = send_city; package.CollectionPostCode = send_postcode; package.CollectionCountry = "UK"; package.RecipientCompanyName = receive_company; package.RecipientContactName = receive_name; package.RecipientPhone = receive_phone; package.RecipientAddressLine = receive_address_line; package.RecipientTown = receive_city; package.RecipeintPostCode = receive_postcode; package.RecipientCountry = "China"; package.Shippingdate = delivery_time; package.Shippingtype = delivery_way; package.Shippingpurpose = comment; package.PackageDescription = description; package.PackageValue = Convert.ToSingle(package_value); package.Insurance = Convert.ToSingle(insurance); package.ServiceCode = "PostNL"; package.Weight = Convert.ToSingle(weight); package.Length = Convert.ToSingle(length); package.Width = Convert.ToSingle(width); package.Height = Convert.ToSingle(height); if (package.PackageDescription.Contains("推车") || package.PackageDescription.Contains("trolly") || package.PackageDescription.Contains("坐椅") || package.PackageDescription.Contains("baby sit") || package.PackageDescription.Contains("babysit") || package.PackageDescription.Contains("sit")) { package.Volumetric = package.Length * package.Width * package.Height / 6000; } else { package.Volumetric = package.Weight; } if (package.Weight >= package.Volumetric) { package.Chargeable = package.Weight; } else { package.Chargeable = package.Volumetric; } package.Pay_status = "unpay"; package.Pay_before_discount = new BatchQuoteDAO().getQuote(username, package.ServiceCode, package.Weight, package.Chargeable); package.Pay_before_discount += package.Insurance; package.Discount = 0; package.Pay_after_discount = package.Pay_before_discount; package.Order_time = order.Order_time; package.Less_pay = 0; package.Is_delivery = 0; order.Pay_before_discount += package.Pay_before_discount; package_array.Add(package); } //如果是 PF-IPE 类别 else if (receive_country.ToLower().Equals("china-ipe")) { line_count++; if ((Hz2Py.Convert(receive_company)).Length > 24) { alert("第" + line_count + "个包裹的收件公司长度超过了24字节,请更改!!"); return; } if ((Hz2Py.Convert(receive_name)).Length > 24) { alert("第" + line_count + "个包裹的收件人英文名长度或者中文名转化为拼音后超过了24字符,请更改!!"); return; } if ((Hz2Py.Convert(receive_phone)).Length > 15) { alert("第" + line_count + "个包裹的收件人电话长度超过了15字符,ParcelForce 不能处理,请缩短!!"); return; } if ((Hz2Py.Convert(receive_address_line)).Length > 67) { alert("抱歉,您的第 " + line_count + " 个订单由于英文收件地址或者中文收件地址转化为拼音后超过66个字符,ParcelForce 不能处理,请缩短地址,请更改!!"); return; } if ((Hz2Py.Convert(receive_city)).Length > 24) { alert("第" + line_count + "个包裹的收件人 City 长度超过了24个字符,ParcelForce 不能处理,请缩短!!"); return; } if ((Hz2Py.Convert(send_company)).Length > 24) { alert("第" + line_count + "个包裹的发件人公司英文长度或中文转换为拼音后长度超过了24字节,ParcelForce 不能处理,请缩短!!"); return; } if ((Hz2Py.Convert(send_name)).Length > 24) { alert("第" + line_count + "个包裹的发件人名长度超过了24字节,ParcelForce 不能处理,请缩短!!"); return; } if ((Hz2Py.Convert(send_phone)).Length > 15) { alert("第" + line_count + "个包裹的发件人手机号码长度超过了15个字符,ParcelForce 不能处理,请缩短!!"); return; } if ((Hz2Py.Convert(send_addressline)).Length > 67) { alert("第" + line_count + "个包裹的英文发件地址或者中文收件地址转化为拼音后长度超过了67字节,ParcelForce 不能处理,请缩短!!"); return; } if ((Hz2Py.Convert(send_city)).Length > 24) { alert("第" + line_count + "个包裹的发件 City 英文长度或中文转换为拼音后长度超过了24字符,ParcelForce 不能处理,请缩短!!"); return; } if ((Hz2Py.Convert(send_postcode)).Length > 16) { alert("第" + line_count + "个包裹的发件邮编长度超过了16字符,ParcelForce 不能处理,请缩短!!"); return; } if ((Hz2Py.Convert(description)).Length > 30) { alert("第" + line_count + "个包裹的 Description 字段 英文后中文转换为拼音后 长度超过了30字符,ParcelForce 不能处理,请缩短!!"); return; } if (weight.ToString().Length > 8) { alert("第" + line_count + "个包裹的重量 值 超过了 8 位,ParcelForce 不能处理,请缩短!!"); return; } if (height.ToString().Length > 8) { alert("第" + line_count + "个包裹的高度值超过了 8 位,ParcelForce 不能处理,请缩短!!"); return; } if (length.ToString().Length > 8) { alert("第" + line_count + "个包裹的长度值超过了 8 位,ParcelForce 不能处理,请缩短!!"); return; } if (package_value.ToString().Length > 8) { alert("第" + line_count + "个包裹的 包裹价值 长度超过了8位,ParcelForce 不能处理,请缩短!!"); return; } if (width.ToString().Length > 8) { alert("第" + line_count + "个包裹的 宽度 长度超过了 8 位,ParcelForce 不能处理,请缩短!!"); return; } if ((Hz2Py.Convert(comment)).Length > 16) { alert("第" + line_count + "个包裹的 Purpose Of Shipment 字段的英文长度或中文转换为英文后的长度超过了24字符,ParcelForce 不能处理,请缩短!!"); return; } string nowtime = DateTime.Now.ToString("yyyy-MM-dd"); Regex reg = new Regex(@"[0-9]{4}-[0-9]{2}-[0-9]{2}"); if (!reg.Match(delivery_time).Success) { alert("China-IPE 的发件时间格式必须为 YYYY-MM-DD,并且发件时间必须是明天以后"); return; } int k = (int)DateTime.Parse(delivery_time).DayOfWeek; if (delivery_time.CompareTo(nowtime) == -1) { alert("China-IPE 的发件时间格式必须为 YYYY-MM-DD,并且发件时间必须是第二天及以后"); return; } else if ((delivery_time.CompareTo(nowtime) == 0) && k != 6 && k != 0) { string nowminute = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); string temp = nowtime + " 11:30"; if (nowminute.CompareTo(temp) == 1) { if (k == 5) { delivery_time = Convert.ToDateTime(delivery_time).AddDays(3).ToString("yyyy-MM-dd"); } else { delivery_time = Convert.ToDateTime(delivery_time).AddDays(1).ToString("yyyy-MM-dd"); } } } if (delivery_time.CompareTo(DateTime.Now.AddDays(21).ToString("yyyy-MM-dd")) >= 0) { alert("取件时间不能离现在太远,最好不要超过 两个星期!!"); return; } if (k == 6) { delivery_time = Convert.ToDateTime(delivery_time).AddDays(2).ToString("yyyy-MM-dd"); } else if (k == 0) { delivery_time = Convert.ToDateTime(delivery_time).AddDays(1).ToString("yyyy-MM-dd"); } Application.Lock(); string orderNo = Application["packageNo"].ToString(); Application["packageNo"] = (int)Application["packageNo"] + 1; Application.UnLock(); package.Auto_no = auto_no; package.Order_no = "WA" + time.ToString("yyMMddHHmm") + orderNo.PadLeft(8, '0'); package.Name = Session["name"].ToString(); package.CollectionCompanyName = send_company; package.CollectionContactName = send_name; package.CollectionPhone = send_phone; package.CollectionAddressLine = send_addressline; package.CollectionTown = send_city; package.CollectionPostCode = send_postcode; package.CollectionCountry = "UK"; package.RecipientCompanyName = receive_company; package.RecipientContactName = receive_name; package.RecipientPhone = receive_phone; package.RecipientAddressLine = receive_address_line; package.RecipientTown = receive_city; package.RecipeintPostCode = receive_postcode; package.RecipientCountry = "China"; package.Shippingdate = delivery_time; package.Shippingtype = delivery_way; package.Shippingpurpose = comment; package.PackageDescription = description; package.PackageValue = Convert.ToSingle(package_value); package.Insurance = Convert.ToSingle(insurance); if (package.Shippingtype.ToLower().Contains("ollec")) { package.ServiceCode = "PF-IPE-Collection"; } else if (package.Shippingtype.ToLower().Contains("epot")) { package.ServiceCode = "PF-IPE-Depot"; } else if (package.Shippingtype.ToLower().Contains("railer")) { package.ServiceCode = "PF-IPE-Trailer"; } else if (package.Shippingtype.ToLower().Contains("pol")) { package.ServiceCode = "PF-IPE-Pol"; } package.Weight = Convert.ToSingle(weight); package.Length = Convert.ToSingle(length); package.Width = Convert.ToSingle(width); package.Height = Convert.ToSingle(height); package.Volumetric = (float)((package.Length * package.Width * package.Height) / 5000.0); if (package.Weight >= package.Volumetric) { package.Chargeable = package.Weight; } else { package.Chargeable = package.Volumetric; } package.Pay_status = "unpay"; //此处Pay_before_discount设置为100,以后要计算价格 package.Pay_before_discount = new BatchQuoteDAO().getQuote(username, package.ServiceCode, package.Weight, package.Chargeable);// new Quote().getQuote("UK", "China", package.Weight, package.Chargeable, "PostNL", Session["name"].ToString()); package.Pay_before_discount += package.Insurance; package.Discount = 0; package.Pay_after_discount = package.Pay_before_discount; package.Order_time = order.Order_time; package.Less_pay = 0; package.Is_delivery = 0; order.Pay_before_discount += package.Pay_before_discount; package_array.Add(package); } // 如果是 PF-GPR类型 else if (receive_country.ToLower().Equals("china-gpr")) { line_count++; if ((Hz2Py.Convert(receive_company)).Length > 24) { alert("第" + line_count + "个包裹的收件公司长度超过了24字节,请更改!!"); return; } if ((Hz2Py.Convert(receive_name)).Length > 24) { alert("第" + line_count + "个包裹的收件人名长度超过了24字节,请更改!!"); return; } if ((Hz2Py.Convert(receive_phone)).Length > 15) { alert("第" + line_count + "个包裹的收件人电话长度超过了15字节,请更改!!"); return; } if ((Hz2Py.Convert(receive_address_line)).Length > 67) { alert("第" + line_count + "个包裹的收件人地址长度超过了67字节,请更改!!"); return; } if ((Hz2Py.Convert(receive_city)).Length > 24) { alert("第" + line_count + "个包裹的收件人 City 长度超过了24字节,请更改!!"); return; } if ((Hz2Py.Convert(send_company)).Length > 24) { alert("第" + line_count + "个包裹的发件人公司长度超过了24字节,请更改!!"); return; } if ((Hz2Py.Convert(send_name)).Length > 24) { alert("第" + line_count + "个包裹的发件人名长度超过了24字节,请更改!!"); return; } if ((Hz2Py.Convert(send_phone)).Length > 15) { alert("第" + line_count + "个包裹的发件人手机号码长度超过了15字节,请更改!!"); return; } if ((Hz2Py.Convert(send_addressline)).Length > 67) { alert("第" + line_count + "个包裹的收件公司长度超过了67字节,请更改!!"); return; } if ((Hz2Py.Convert(send_city)).Length > 24) { alert("第" + line_count + "个包裹的收件公司长度超过了24字节,请更改!!"); return; } if ((Hz2Py.Convert(send_postcode)).Length > 16) { alert("第" + line_count + "个包裹的收件公司长度超过了16字节,请更改!!"); return; } if ((Hz2Py.Convert(description)).Length > 30) { alert("第" + line_count + "个包裹的 Description字段 长度超过了30字节,请更改!!"); return; } if (weight.ToString().Length > 8) { alert("第" + line_count + "个包裹的重量 值 超过了 8 位,请更改!!"); return; } if (height.ToString().Length > 8) { alert("第" + line_count + "个包裹的高度值超过了 8 位,请更改!!"); return; } if (length.ToString().Length > 8) { alert("第" + line_count + "个包裹的长度值超过了 8 位,请更改!!"); return; } if (package_value.ToString().Length > 8) { alert("第" + line_count + "个包裹的 包裹价值 长度超过了8位,请更改!!"); return; } if (width.ToString().Length > 8) { alert("第" + line_count + "个包裹的 宽度 长度超过了 8 位,请更改!!"); return; } if ((Hz2Py.Convert(comment)).Length > 16) { alert("第" + line_count + "个包裹的Purpose Of Shipment长度超过了24字节,请更改!!"); return; } string nowtime = DateTime.Now.ToString("yyyy-MM-dd"); Regex reg = new Regex(@"[0-9]{4}-[0-9]{2}-[0-9]{2}"); if (!reg.Match(delivery_time).Success) { alert("China-IPE,China-GPR 的发件时间格式必须为 YYYY-MM-DD,并且发件时间必须是明天以后,请从 PostNL首页下载模板!!"); return; } int k = (int)DateTime.Parse(delivery_time).DayOfWeek; if (delivery_time.CompareTo(nowtime) == -1) { alert("China-IPE,China-GPR 的发件时间格式必须为 YYYY-MM-DD,并且发件时间必须是明天以后"); return; } else if (delivery_time.CompareTo(nowtime) == 0) { string nowminute = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); string temp = nowtime + " 11:30"; if (nowminute.CompareTo(temp) == 1) { if (k == 5) { delivery_time = Convert.ToDateTime(delivery_time).AddDays(3).ToString("yyyy-MM-dd"); } } delivery_time = Convert.ToDateTime(delivery_time).AddDays(1).ToString("yyyy-MM-dd"); } if (delivery_time.CompareTo(DateTime.Now.AddDays(21).ToString("yyyy-MM-dd")) >= 0) { alert("取件时间不能离现在太远,最好不要超过 两个星期!!"); return; } if (k == 6) { delivery_time = Convert.ToDateTime(delivery_time).AddDays(2).ToString("yyyy-MM-dd"); } else if (k == 0) { delivery_time = Convert.ToDateTime(delivery_time).AddDays(1).ToString("yyyy-MM-dd"); } Application.Lock(); string orderNo = Application["packageNo"].ToString(); Application["packageNo"] = (int)Application["packageNo"] + 1; Application.UnLock(); package.Auto_no = auto_no; package.Order_no = "WA" + time.ToString("yyyyMMddHHmm") + orderNo.PadLeft(8, '0'); package.Name = Session["name"].ToString(); package.CollectionCompanyName = send_company; package.CollectionContactName = send_name; package.CollectionPhone = send_phone; package.CollectionAddressLine = send_addressline; package.CollectionTown = send_city; package.CollectionPostCode = send_postcode; package.CollectionCountry = "UK"; package.RecipientCompanyName = receive_company; package.RecipientContactName = receive_name; package.RecipientPhone = receive_phone; package.RecipientAddressLine = receive_address_line; package.RecipientTown = receive_city; package.RecipeintPostCode = receive_postcode; package.RecipientCountry = "China"; package.Shippingdate = delivery_time; package.Shippingtype = delivery_way; package.Shippingpurpose = comment; package.PackageDescription = description; package.PackageValue = Convert.ToSingle(package_value); package.Insurance = Convert.ToSingle(insurance); if (package.Shippingtype.ToLower().Contains("ollec")) { package.ServiceCode = "PF-GPR-Collection"; } else { package.ServiceCode = "PF-GPR-Delivery"; } package.Weight = Convert.ToSingle(weight); package.Length = Convert.ToSingle(length); package.Width = Convert.ToSingle(width); package.Height = Convert.ToSingle(height); package.Volumetric = (float)((package.Length * package.Width * package.Height) / 5000.0); if (package.Weight >= package.Volumetric) { package.Chargeable = package.Weight; } else { package.Chargeable = package.Volumetric; } package.Pay_status = "unpay"; //此处Pay_before_discount设置为100,以后要计算价格 package.Pay_before_discount = new BatchQuoteDAO().getQuote(username, package.ServiceCode, package.Weight, package.Chargeable);// new Quote().getQuote("UK", "China", package.Weight, package.Chargeable, "PostNL", Session["name"].ToString()); package.Pay_before_discount += package.Insurance; package.Discount = 0; package.Pay_after_discount = package.Pay_before_discount; package.Order_time = order.Order_time; package.Less_pay = 0; package.Is_delivery = 0; order.Pay_before_discount += package.Pay_before_discount; package_array.Add(package); } // 如果是 EMS else if (receive_country.ToLower().Equals("china-ems")) { line_count++; Application.Lock(); string orderNo = Application["packageNo"].ToString(); Application["packageNo"] = (int)Application["packageNo"] + 1; Application.UnLock(); package.Auto_no = auto_no; package.Order_no = "WA" + time.ToString("yyyyMMddHHmm") + orderNo.PadLeft(8, '0'); package.Name = Session["name"].ToString(); package.CollectionCompanyName = send_company; package.CollectionContactName = send_name; package.CollectionPhone = send_phone; package.CollectionAddressLine = send_addressline; package.CollectionTown = send_city; package.CollectionPostCode = send_postcode; package.CollectionCountry = "UK"; package.RecipientCompanyName = receive_company; package.RecipientContactName = receive_name; package.RecipientPhone = receive_phone; package.RecipientAddressLine = receive_address_line; package.RecipientTown = receive_city; package.RecipeintPostCode = receive_postcode; package.RecipientCountry = "China"; package.Shippingdate = delivery_time; package.Shippingtype = delivery_way; package.Shippingpurpose = comment; package.PackageDescription = description; package.PackageValue = Convert.ToSingle(package_value); package.Insurance = Convert.ToSingle(insurance); package.ServiceCode = "EMS"; package.Weight = Convert.ToSingle(weight); package.Length = Convert.ToSingle(length); package.Width = Convert.ToSingle(width); package.Height = Convert.ToSingle(height); package.Volumetric = (float)((package.Length * package.Width * package.Height) / 5000.0); if (package.Weight >= package.Volumetric) { package.Chargeable = package.Weight; } else { package.Chargeable = package.Volumetric; } package.Pay_status = "unpay"; //此处Pay_before_discount设置为100,以后要计算价格 package.Pay_before_discount = new BatchQuoteDAO().getQuote(username, package.ServiceCode, package.Weight, package.Chargeable);// new Quote().getQuote("UK", "China", package.Weight, package.Chargeable, "PostNL", Session["name"].ToString()); package.Pay_before_discount += package.Insurance; package.Discount = 0; package.Pay_after_discount = package.Pay_before_discount; package.Order_time = order.Order_time; package.Less_pay = 0; package.Is_delivery = 0; order.Pay_before_discount += package.Pay_before_discount; package_array.Add(package); } else { alert("收件国家必须是 China-NL、China-IPE、China-GPR 到 港澳台 也一样也是 China-NL、China-IPE、China-GPR "); return; } } } order.Discount = 0; order.Pay_after_discount = order.Pay_before_discount; order.Order_count = line_count; //确实有包裹 if (line_count != 0) { //添加订单的详细信息 for (int i = 0; i < package_array.Count; i++) { AutoOrderList temp_package = (AutoOrderList)package_array[i]; new AutoOrderListDAO().addAutoOrderList(temp_package); } //添加订单 new AutoOrderDAO().addAutoOrder(order); } } if (line_count == 0) { alert("Excel不能为空!!!"); } else { Response.Redirect("../my-shopping-cart.aspx?flag=excel"); } }
private DataTable createBarCodeTable(ArrayList order_numbers) { DataTable table = new DataTable(); un_download = 0; down_orders.Clear(); //订单号 DataColumn dc = new DataColumn("order_number", typeof(string)); table.Columns.Add(dc); dc = new DataColumn("local_order", typeof(string)); table.Columns.Add(dc); dc = new DataColumn("order_track", typeof(string)); table.Columns.Add(dc); //包裹个数 dc = new DataColumn("weight", typeof(float)); table.Columns.Add(dc); //发件人 dc = new DataColumn("sender", typeof(string)); table.Columns.Add(dc); //收件人 dc = new DataColumn("receiver", typeof(string)); table.Columns.Add(dc); //收件人 dc = new DataColumn("phone", typeof(string)); table.Columns.Add(dc); //服务方式 dc = new DataColumn("postway", typeof(string)); table.Columns.Add(dc); //付款金额 dc = new DataColumn("pay", typeof(string)); table.Columns.Add(dc); for (int i = 0; i < order_numbers.Count; i++) { string order_number = order_numbers[i].ToString(); AutoOrderList order = new AutoOrderList(); if (order_number.Contains("WA")) { order = new AutoOrderListDAO().getAutoOrderList(order_number); if (order.Ea_track_no == "") { un_download++; } else { DataRow dr = table.NewRow(); down_orders.Add(order.Ea_track_no); dr["order_number"] = order.Order_no; dr["order_track"] = order.Ea_track_no; dr["local_order"] = "无"; dr["weight"] = order.Weight; dr["sender"] = order.CollectionContactName; dr["receiver"] = order.RecipientContactName; dr["phone"] = order.RecipientPhone; dr["postway"] = order.ServiceCode; dr["pay"] = order.Pay_after_discount; table.Rows.Add(dr); } } else if (order_number.Contains("WM")) { Order temporder = new OrderDAO().getOrder(order_number); ArrayList packageArray = new PackageDAO().getPackage(temporder.Order_number); for (int j = 0; j < packageArray.Count; j++) { Package temp_package = (Package)packageArray[j]; DataRow dr = table.NewRow(); down_orders.Add(temp_package.Ea_track_no); dr["order_number"] = temp_package.Order_number; dr["order_track"] = temp_package.Ea_track_no; if (temp_package.Local_track_no == "") { dr["local_order"] = "无"; } else { dr["local_order"] = temp_package.Local_track_no; } dr["weight"] = temp_package.Weight; dr["sender"] = temporder.CollectionContactName; dr["receiver"] = temporder.RecipientContactName; dr["phone"] = temporder.RecipientPhone; if (temporder.Delivery_way == "CollectionPlus") { dr["postway"] = getPostWay(temporder.Post_way) + "—Collection +"; } else if (temporder.Delivery_way == "UKMail") { dr["postway"] = getPostWay(temporder.Post_way) + "—UKMail"; } else { dr["postway"] = getPostWay(temporder.Post_way); } dr["pay"] = temp_package.Pay; table.Rows.Add(dr); } } Session["all_orders"] = down_orders; } return(table); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { name = Request.QueryString["username"]; string code = Request.QueryString["code"]; string pay_way = Request.QueryString["paymethod"]; if (Session["name"].ToString() != null && code != null) { if (new UserDAO().isCodeRight(Session["name"].ToString(), code)) { //生成支付成功码 string success_code1 = (new Random().Next(100000000, 1000000000)).ToString(); string success_code2 = (new Random().Next(1000000, 10000000)).ToString(); string success_code3 = (new Random().Next(10000000, 100000000)).ToString(); string success_code = success_code1 + success_code2 + success_code3; //将成功码插入到用户表中,支付成功是进行验证 new UserDAO().updateSuccessCode(Session["name"].ToString(), success_code); //确实付款成功 //更新数据库信息 order_number_array.Clear(); ArrayList excel_payorders = new AutoOrderListDAO().getAutoOrderListArray(Session["name"].ToString(), "unpay"); ArrayList interface_payorders = new OrderDAO().getOrders(Session["name"].ToString(), "unpay"); for (int i = 0; i < excel_payorders.Count; i++) { AutoOrderList aulist = (AutoOrderList)excel_payorders[i]; new AutoOrderListDAO().updatePayStatus(aulist.Order_no); order_number_array.Add(aulist.Order_no); } new AutoOrderDAO().updateAutoOrderPayStatus(Session["name"].ToString(), pay_way); for (int i = 0; i < interface_payorders.Count; i++) { Order interface_order = (Order)interface_payorders[i]; //跟新付款状态 new OrderDAO().updatePayStatue(interface_order.Order_number, pay_way); order_number_array.Add(interface_order.Order_number); } Session["AllOrderMsg"] = order_number_array; for (int i = 0; i < order_number_array.Count; i++) { Order order = new OrderDAO().getOrder(order_number_array[i].ToString()); if (order.Delivery_way.ToLower() == "collectionplus") { ArrayList package_array = new PackageDAO().getPackage(order_number_array[i].ToString()); for (int j = 0; j < package_array.Count; j++) { Package package = (Package)package_array[j]; LocalTrackNumber++; CollectionPlusLabel collectionplus = new CollectionPlusLabel(order.CollectionContactName, LocalTrackNumber.ToString(), "", DateTime.Parse(order.Delivery_date).ToString("dd/MM/yyyy")); trackNumber = "8M6W" + LocalTrackNumber + "A025"; collectionplus.makeCollectionPlusLabel(Server.MapPath("~\\views\\pdf\\local\\" + trackNumber + ".pdf")); package.Local_track_no = trackNumber; new PackageDAO().updateLocalTrackNo(package); } } } total_count = order_number_array.Count; } else { Response.Redirect("error-page.aspx"); } } else { Response.Redirect("error-page.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { string order_number = Request.QueryString["order_number"]; string info = Request.QueryString["type"]; if (order_number != null) { AutoOrder autoorder = new AutoOrderDAO().getAutoOrder(order_number); ArrayList auto_orderlist_array = new AutoOrderListDAO().getAutoOrderListArray(autoorder.Auto_no); int ordercount = autoorder.Order_count; string[] pdflist = new string[ordercount]; for (int ii = 0; ii < ordercount; ii++) { AutoOrderList autoorderlist = (AutoOrderList)auto_orderlist_array[ii]; string tracknumber = autoorderlist.Order_no; pdflist[ii] = Server.MapPath("\\views\\pdf\\" + tracknumber + "2.pdf"); } mergePDFFiles(pdflist, Server.MapPath("\\views\\pdf\\" + order_number + "2.pdf")); string filename = Server.MapPath("\\views\\pdf\\" + order_number + "2.pdf"); HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + order_number + ".pdf"); HttpContext.Current.Response.WriteFile(filename); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.Close(); } if (info != null) { if (order_number != null) { Order order = new OrderDAO().getOrder(order_number); string parentPath = Server.MapPath(""); string filename = order.Order_number + ".pdf"; string path = parentPath + "/pdf/" + filename; generatePDF(order, path); HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.ClearHeaders(); //如果是在网页中显示 if (info == "detail") { //在网页中显示 HttpContext.Current.Response.ContentType = "application/PDF"; HttpContext.Current.Response.AddHeader("content-disposition", "filename=" + filename); } else { //以下载的形式展现 HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + filename); } HttpContext.Current.Response.WriteFile(path); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.Close(); } } else { if (Session["orders"] != null) { ArrayList orders = (ArrayList)Session["orders"]; string parentPath = Server.MapPath(""); string filename = "all_orders.pdf"; string path = parentPath + "/pdf/" + filename; generatePDF(orders, path); HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.ClearHeaders(); //如果是在网页中显示 //以下载的形式展现 HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + filename); HttpContext.Current.Response.WriteFile(path); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.Close(); } } }
/// <summary> /// 去购物车结算的实现 将要本地区间的订单信息添加到本地取件订单表中 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_goto_cart_Click(object sender, EventArgs e) { string c_companyname = txt_send_addr_company.Text; string c_contactname = txt_send_addr_contact.Text; string c_town = txt_send_addr_city.Text; string c_addressline = txt_send_addr_line1.Text + " " + txt_send_addr_line2.Text + " " + txt_send_addr_line3.Text; string c_phone = txt_send_addr_phone.Text; string c_postcode = txt_send_addr_postcode.Text; string c_shipdate = txt_shipdate.Text; ArrayList order_array = (ArrayList)Session["local_order"]; for (int i = 0; i < order_array.Count; i++) { AutoOrderList orderlist = new AutoOrderListDAO().getAutoOrderList(order_array[i].ToString()); autoorder_array.Add(orderlist); } LocalOrder local_order = new LocalOrder(); Application.Lock(); string orderNo = Application["orderNo"].ToString(); Application["orderNo"] = (int)Application["orderNo"] + 1; Application.UnLock(); local_order.Order_no = "WL" + DateTime.Now.ToString("yyMMddHHmm") + orderNo.PadLeft(8, '0'); local_order.Collectioncompanyname = c_companyname; local_order.Collectioncontactname = c_contactname; local_order.Collectionaddressline = c_addressline; local_order.Collectionpostcode = c_postcode; local_order.Collectiontown = c_town; local_order.Collectionphone = c_phone; local_order.Collectioncountry = "UK"; local_order.Recipientcompanyname = "华盟快递"; local_order.Recipientcontactname = "华盟"; local_order.Recipientaddressline = "华盟"; local_order.Recipientpostcode = "br sdf"; local_order.Recipienttown = "Birmihan"; local_order.Recipientcountry = "UK"; local_order.Recipientphone = "2384sdf"; local_order.Name = Session["name"].ToString(); local_order.Delivery_date = c_shipdate; local_order.Servicecode = Session["way"].ToString(); local_order.Order_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); local_order.Quantity = autoorder_array.Count; local_order.Is_pay = "unpay"; for (int i = 0; i < autoorder_array.Count; i++) { AutoOrderList orderlist = (AutoOrderList)autoorder_array[i]; LocalPackage local_package = new LocalPackage(); local_package.Name = Session["name"].ToString(); local_package.Order_number = local_order.Order_no; local_package.Wm_track_no = orderlist.Order_no; local_package.Cd_track_no = orderlist.Cd_track_no; local_package.Ea_track_no = orderlist.Ea_track_no; local_package.S_track_no = orderlist.S_track_no; local_package.Shipmentpurpose = orderlist.Shippingpurpose; local_package.Packagedescription = orderlist.PackageDescription; local_package.Packagevalue = orderlist.PackageValue; local_package.Weight = orderlist.Weight; local_package.Servicecode = local_order.Servicecode; local_package.Is_pay = "unpay"; local_package.Insurance = orderlist.Insurance; local_package.Pay_before_discount = 100; local_package.Discount = 0; local_package.Pay_after_discount = local_package.Pay_before_discount; local_package.Less_pay = 0; local_package.True_weight = 0; local_order.Pay_before_discount += local_package.Pay_before_discount; if (local_order.Wm_track_no != "") { local_order.Wm_track_no = local_order.Wm_track_no + "," + local_package.Wm_track_no; } else { local_order.Wm_track_no += local_package.Wm_track_no; } new LocalPackageDAO().addLocalPackage(local_package); } local_order.Pay_after_discount = local_order.Pay_before_discount; local_order.Discount = 0; new LocalOrderDAO().addLocalOrder(local_order); Response.Redirect("my-local-pick-up-cart.aspx"); }