示例#1
0
        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");
            }
        }
示例#2
0
        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();
                        }
                    }
                }
            }
        }
示例#3
0
        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);
        }
示例#8
0
        //上传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");
            }
        }
示例#9
0
        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);
        }
示例#10
0
        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");
                }
            }
        }
示例#11
0
        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();
                }
            }
        }
示例#12
0
        /// <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");
        }