protected void SendMothedList_SelectedIndexChanged(object sender, EventArgs e)
{
EnOrder en = Session["OrderInfo"] as EnOrder;
string mySql = "select * from OrderType";
DataSet st = DataBase.RunDataSet(mySql);
DataTable s = st.Tables[0];
float All = 0;
if (this.SendMothedList.SelectedIndex == 0)
{
double addmoney = Convert.ToSingle(s.Rows[0]["SendPrice"].ToString()) * 1.0;
this.AddMoney.Text = addmoney.ToString();
All = Convert.ToSingle(en.toalPrice.ToString()) + Convert.ToSingle(s.Rows[0]["SendPrice"].ToString());
}
else
{
if (this.SendMothedList.SelectedIndex == 1)
{
double addmoney = Convert.ToSingle(s.Rows[1]["SendPrice"].ToString()) * 1.0;
this.AddMoney.Text = addmoney.ToString();
All = Convert.ToSingle(en.toalPrice.ToString()) + Convert.ToSingle(s.Rows[1]["SendPrice"].ToString());
}
else
{
double addmoney = Convert.ToSingle(s.Rows[2]["SendPrice"].ToString()) * 1.0;
this.AddMoney.Text = addmoney.ToString();
All = Convert.ToSingle(en.toalPrice.ToString()) + Convert.ToSingle(s.Rows[2]["SendPrice"].ToString());
}
}
Money.Text = All.ToString();
}
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 Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = Session["UserTable"] as DataTable;
EnOrder en = Session["OrderInfo"] as EnOrder;
if (dt == null || en == null)
{
return;
}
this.UserName.Text = dt.Rows[0]["UserName"].ToString();
OrderNumber.Text = en.orderNumber.ToString();
OrderTime.Text = en.placeOrderTime.ToString();
Coments.Text = "";
List <EnDoc> docslist = en.docs;
Repeater1.DataSource = docslist;
Repeater1.DataBind();
string Sql = "select * from Address where UserRecID='" + dt.Rows[0]["UserRecID"].ToString() + "'";
DataSet ST = DataBase.RunDataSet(Sql);
DataTable S = ST.Tables[0];
AddressList.DataSource = S;
AddressList.DataValueField = "AddressRecID";
AddressList.DataTextField = "AddressName";
AddressList.DataBind();
string mySql = "select * from OrderType";
DataSet st = DataBase.RunDataSet(mySql);
DataTable s = st.Tables[0];
SendMothedList.DataSource = s;
SendMothedList.DataValueField = "OrderTypeID";
SendMothedList.DataTextField = "OrderTypeName";
SendMothedList.DataBind();
this.SendMothedList.SelectedIndex = 0;
double addmoney = Convert.ToSingle(s.Rows[0]["SendPrice"].ToString()) * 1.0;
this.AddMoney.Text = addmoney.ToString();
float All = Convert.ToSingle(en.toalPrice.ToString()) + Convert.ToSingle(s.Rows[0]["SendPrice"].ToString());
Money.Text = All.ToString();
}
}