protected void OrderBtu_Click(object sender, EventArgs e) { EnOrder en = Session["OrderInfo"] as EnOrder; CnOrders cn = new CnOrders(); DataTable dt = cn.getDataTable("select * from Orders where OrderNumber='" + en.orderNumber.Trim() + "'"); dt.Rows[0]["Coment"] = Coments.Text.Trim(); DataSet ds = DataBase.RunDataSet("select * from Doc where 0=1"); DataTable DocTable = ds.Tables[0]; try { dt.Rows[0]["OrderTypeID"] = int.Parse(SendMothedList.SelectedItem.Value.Trim()); dt.Rows[0]["AddressRecID"] = int.Parse(AddressList.SelectedItem.Value.Trim()); dt.Rows[0]["ToalPrice"] = this.Money.Text; int k = DataBase.update("Orders", "OrderNumber", dt); List <EnDoc> docslist = en.docs; foreach (var item in docslist) { DataRow dr = DocTable.NewRow(); dr["DocID"] = 0; dr["OrderNumber"] = en.orderNumber.Trim(); dr["Comment"] = Coments.Text.Trim(); dr["DocName"] = item.docName; dr["DocPath"] = item.docPath; dr["DocTypeID"] = item.docTypeID; dr["UploadTime"] = en.placeOrderTime; dr["TotalPages"] = item.totalPages; dr["PrintTypeID"] = item.printTypeID; DocTable.Rows.Add(dr); } int j = DataBase.update("Doc", "DocID", DocTable); this.Page.RegisterStartupScript("", "<script>alert('下单成功!');window.location.href= 'UserCenter.aspx'</script>"); } catch (Exception) { int k = DataBase.ExecuteNonQuery("delete Orders where OrderNumber='" + en.orderNumber + "'"); int l = DataBase.ExecuteNonQuery("delete Doc where OrderNumber='" + en.orderNumber + "'"); this.Page.RegisterStartupScript("", "<script>alert('下单失败!');window.location.href= 'UserCenter.aspx'</script>"); } }
protected void UpLoadBut_OnClick(object sender, EventArgs e) { EnOrder order = new EnOrder(); UploadDetail upDetail = Session["UploadDetail"] as UploadDetail; order.orderNumber = upDetail.OrderUmber.ToString(); order.orderStatusID = 1; order.placeOrderTime = DateTime.Now; int CTCount = NewfilesInfo.Controls.Count; Label toPrice = (Label)NewfilesInfo.Controls[CTCount - 1].FindControl("totalPrice"); order.toalPrice = decimal.Parse(toPrice.Text); order.docs = new List <EnDoc>(); for (int i = 0; i < NewfilesInfo.Items.Count; i++) { Label fn = (Label)NewfilesInfo.Items[i].FindControl("fileName"); Label ph = (Label)NewfilesInfo.Items[i].FindControl("filepath"); DropDownList pt = (DropDownList)NewfilesInfo.Items[i].FindControl("PrintTypes"); Label pc = (Label)NewfilesInfo.Items[i].FindControl("PageCount"); TextBox num = (TextBox)NewfilesInfo.Items[i].FindControl("CopiesTextBox"); order.docs.Add(new EnDoc { orderNumber = order.orderNumber, docName = fn.Text, docPath = ph.Text, printTypeID = long.Parse(pt.SelectedItem.Value.Trim()), totalPages = int.Parse(pc.Text.Trim()) * int.Parse(num.Text.Trim()) }); } CnOrders cn = new CnOrders(); DataTable dt = cn.getOrderTabel(order); int k = DataBase.update("Orders", "OrderNumber", dt); Session["OrderInfo"] = new EnOrder(); Session["OrderInfo"] = order; Session.Remove("UploadDetail"); Session.Remove("OrdreTypeList"); Response.Redirect("Order.aspx"); }