private DataTable createMyCartTable()
{
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("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);
ArrayList local_order_array = new LocalOrderDAO().getPayLocalOrder(Session["name"].ToString());
for (int i = 0; i < local_order_array.Count; i++)
{
LocalOrder local_order = (LocalOrder)local_order_array[i];
DataRow dr = table.NewRow();
dr["order_number"] = local_order.Order_no;
dr["sender"] = local_order.Collectioncontactname;
dr["receiver"] = local_order.Recipientcontactname;
dr["postway"] = local_order.Servicecode;
dr["quantity"] = local_order.Quantity;
dr["weight"] = local_order.Weight;
dr["pay"] = local_order.Pay_after_discount;
dr["time"] = local_order.Order_time;
table.Rows.Add(dr);
}
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;
ArrayList local_order_array = new LocalOrderDAO().getUnpayLocalOrderNumber(Session["name"].ToString());
//将成功码插入到用户表中，支付成功是进行验证
new UserDAO().updateSuccessCode(Session["name"].ToString(), success_code);
//确实付款成功
//更新数据库信息
new LocalOrderDAO().updateLocalOrderPayStatus(Session["name"].ToString());
Session["local_order"] = local_order_array;
for (int i = 0; i < local_order_array.Count; i++)
{
string orderno = local_order_array[i].ToString();
LocalOrder localOrder = new LocalOrderDAO().getLocalOrder(orderno);
ArrayList local_package_array = new LocalPackageDAO().getLocalPackageByOrderNo(localOrder.Order_no);
for (int j = 0; j < local_package_array.Count; j++)
{
LocalPackage localPackage = (LocalPackage)local_package_array[j];
LocalTrackNumber++;
CollectionPlusLabel collectionplus = new CollectionPlusLabel(localOrder.Collectioncontactname, LocalTrackNumber.ToString(), "", DateTime.Parse(localOrder.Delivery_date).ToString("dd/MM/yyyy"));
trackNumber = "8M6W" + LocalTrackNumber + "A025";
collectionplus.makeCollectionPlusLabel(Server.MapPath("~\\views\\pdf\\local\\" + trackNumber + ".pdf"));
localPackage.Local_track = trackNumber;
new LocalPackageDAO().updateLocalTrackNo(localPackage);
}
}
Response.Redirect("order-label.aspx");
}
else
{
Response.Redirect("error-page.aspx");
}
}
else
{
Response.Redirect("error-page.aspx");
}
}
}
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);
//确实付款成功
//更新数据库信息
new LocalOrderDAO().updateLocalOrderPayStatus(Session["name"].ToString());
ArrayList local_order_array = new LocalOrderDAO().getUnpayLocalOrderNumber(Session["name"].ToString());
Session["local_order"] = local_order_array;
for (int i = 0; i < local_order_array.Count; i++)
{
string orderno = local_order_array[i].ToString();
LocalOrder localOrder = new LocalOrderDAO().getLocalOrder(orderno);
// ArrayList local_array = new LocalPackageDAO();
// CollectionPlusLabel collectionplus = new CollectionPlusLabel(, "18888881", "", "06/01/2015");
//collectionplus.makeCollectionPlusLabel(Server.MapPath("~\\views\\pdf\\local\\"+local_order_array));
}
}
else
{
Response.Redirect("error-page.aspx");
}
}
else
{
Response.Redirect("error-page.aspx");
}
}
}
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("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("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 < order_numbers.Count; i++)
{
string order_number = order_numbers[i].ToString();
LocalOrder localorder = new LocalOrderDAO().getLocalOrder(order_number);
ArrayList packageArray = new LocalPackageDAO().getLocalPackageByOrderNo(order_number);
//if (localorder.Servicecode == "UKMail")
//{
for (int j = 0; j < packageArray.Count; j++)
{
LocalPackage package = (LocalPackage)packageArray[i];
DataRow dr = table.NewRow();
dr["order_number"] = package.Ea_track_no;
dr["local_order"] = package.Local_track;
dr["weight"] = package.Weight;
dr["sender"] = localorder.Collectioncontactname;
dr["receiver"] = localorder.Recipientcontactname;
dr["postway"] = package.Servicecode;
dr["pay"] = package.Pay_after_discount;
dr["time"] = localorder.Pay_time;
table.Rows.Add(dr);
}
//}
//else if (localorder.Servicecode == "CollectionPlus")
//{
//for (int j = 0; j < packageArray.Count; j++)
//{
// LocalPackage package = (LocalPackage)packageArray[i];
// DataRow dr = table.NewRow();
// dr["order_number"] = package.Ea_track_no;
// dr["local_track"] = "localtrack";
// dr["weight"] = package.Weight;
// dr["sender"] = localorder.Collectioncontactname;
// dr["receiver"] = localorder.Recipientcontactname;
// dr["postway"] = package.Servicecode;
// dr["pay"] = package.Pay_after_discount;
// dr["time"] = localorder.Pay_time;
// table.Rows.Add(dr);
//}
//}
}
return(table);
}
