protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.ToString() == "btnover")
{
int index = Convert.ToInt32(e.CommandArgument);
DataKey key = GridView3.DataKeys[index];
string ofid = key.Value.ToString();
State_Order_Form sof = new State_Order_Form();
Order_Form of = db.Order_Form.Single(p => p.orderform_id == ofid);
//判断哪个按钮
switch (e.CommandName.ToString())
{
case "btnover":
of.current_state_id = 0;
sof.orderform_id = ofid;
sof.state_id = 0;
sof.modify_date = DateTime.Now;
db.State_Order_Form.InsertOnSubmit(sof);
db.SubmitChanges();
Response.Redirect("SellList.aspx");
break;
}
}
}
//protected void ddlProType1_SelectedIndexChanged(object sender, EventArgs e)
//{
// SqlDataSource2.SelectCommand = "SELECT [product_type_2_name], [product_type_2_id] FROM [Product_Type_2] WHERE [product_type_id]=" + ddlProType1.SelectedValue;
// ddlProType2.DataBind();
//}
//protected void ddlProType2_SelectedIndexChanged(object sender, EventArgs e)
//{
// SqlDataSource3.SelectCommand = "SELECT [product_type_3_name], [product_type_3_id] FROM [Product_Type_3] WHERE [product_type_id]=" + ddlProType2.SelectedValue;
// ddlProType3.DataBind();
//}
//protected void ddlProType3_SelectedIndexChanged(object sender, EventArgs e)
//{
// SqlDataSource4.SelectCommand = "SELECT [product_id], [product_standars] FROM [Product] WHERE [product_type_id]=" + ddlProType3.SelectedValue;
// ddlProduct.DataBind();
//}
protected void Button1_Click(object sender, EventArgs e)
{
Order_Form_Product ofp = db.Order_Form_Product.Single(p => p.orderformproduct_id == Convert.ToInt32(Session["orderformproduct_id"]));
Order_Form of = db.Order_Form.Single(p => p.orderform_id == ofp.orderform_id);
if (Convert.ToInt32(txtamount.Text) <= ofp.rest_num)
{
Product_Export pe = new Product_Export();
pe.export_property = DropDownListproperty.SelectedValue;
pe.export_partnum = txtpartnum.Text;
pe.export_series = txtseries.Text;
pe.export_num = Convert.ToInt32(txtamount.Text);
pe.export_date = Convert.ToDateTime(txtTime.Text);
pe.export_note = txtnote.Text;
pe.orderformproduct_id = Convert.ToInt32(Session["orderformproduct_id"]);
pe.export_level = DropDownListlevel.SelectedValue;
ofp.rest_num -= pe.export_num;
db.Product_Export.InsertOnSubmit(pe);
IQueryable <Order_Form_Product> OFPs = db.Order_Form_Product.Where(p => p.orderform_id == ofp.orderform_id);
bool flag = true;
foreach (Order_Form_Product m in OFPs)
{
if (m.rest_num != 0)
{
flag = false;
}
}
if (flag)
{
of.current_state_id = 7;
State_Order_Form sof = new State_Order_Form();
sof.modify_date = DateTime.Now;
sof.modify_person = Session["UserName"].ToString();
sof.orderform_id = of.orderform_id;
sof.state_id = 7;
db.State_Order_Form.InsertOnSubmit(sof);
Client cl = db.Client.Single(p => p.client_id == of.client_id);
Message me = db.Message.Single(p => p.staff_id == cl.staff_id);
me.mes_export_num += 1;
}
db.SubmitChanges();
}
else
{
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('出错啦~出库过量！');</script>");
}
Response.Redirect("ProductStoreList.aspx");
//pi.import_package_num = Convert.ToInt32(txtPackNum.Text);
//pi.import_date = Convert.ToDateTime(txtTime.Text);
//pi.import_note = txtDetail.Text;
//pi.import_series = txtseries.Text;
}
protected void ddlPriority_SelectedIndexChanged1(object sender, EventArgs e)
{
DropDownList ddl = (DropDownList)sender;
GridViewRow drv = (GridViewRow)ddl.NamingContainer;
int rowIndex = drv.RowIndex;
Order_Form of = db.Order_Form.Single(p => p.orderform_id == GridView3.DataKeys[rowIndex].Values[0]);
of.priority = Convert.ToInt32(ddl.SelectedValue);
db.SubmitChanges();
Response.Redirect("OrderManager.aspx");
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string orderdate = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Tborderdate")).Text;
string clientname = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("Tbclientname")).Text;
string orderid = ((Label)GridView1.Rows[e.RowIndex].FindControl("Label1")).Text;
Order_Form OF = db.Order_Form.First(p => p.orderform_id.ToString() == orderid);
OF.order_date = Convert.ToDateTime(orderdate);
OF.client_id = db.Client.First(p => p.client_name == clientname).client_id;
db.SubmitChanges();
SqlDataSource1.UpdateCommand = " ";
SqlDataSource1.Update();
ClientScript.RegisterStartupScript(GetType(), "Message", "<SCRIPT LANGUAGE='javascript'>alert('订单修改成功！');</script>");
}
protected void btnover_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
GridViewRow drv = (GridViewRow)btn.NamingContainer;
int rowIndex = drv.RowIndex;
DataClassesDataContext db = new DataClassesDataContext();
State_Order_Form sof = new State_Order_Form();
Order_Form of = db.Order_Form.Single(p => p.orderform_id == GridView3.Rows[rowIndex].Cells[1].Text);
of.current_state_id = 0;
sof.orderform_id = GridView3.Rows[rowIndex].Cells[0].Text;
sof.state_id = 0;
sof.modify_date = DateTime.Now;
db.State_Order_Form.InsertOnSubmit(sof);
db.SubmitChanges();
Response.Redirect("SellList.aspx");
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
//取INdex
if (e.CommandName.ToString() == "btnSure" || e.CommandName.ToString() == "btnBack")
{
int index = Convert.ToInt32(e.CommandArgument);
DataKey key = GridView1.DataKeys[index];
string ofid = key.Value.ToString();
State_Order_Form sof = new State_Order_Form();
Order_Form of = db.Order_Form.Single(p => p.orderform_id == ofid);
Client cl = db.Client.Single(p => p.client_id == of.client_id);
Message me = db.Message.Single(p => p.staff_id == cl.staff_id);
//判断哪个按钮
switch (e.CommandName.ToString())
{
case "btnSure":
of.current_state_id = 3;
sof.orderform_id = ofid;
sof.state_id = 3;
IQueryable <Staff> Stores = db.Staff.Where(p => p.staff_type == "storemen");
foreach (Staff m in Stores)
{
Message sme = db.Message.Single(p => p.staff_id == m.staff_id);
sme.mes_sure_num += 1;
}
me.mes_sure_num += 1;
sof.modify_date = DateTime.Now;
db.State_Order_Form.InsertOnSubmit(sof);
db.SubmitChanges();
Response.Redirect("OrderManager.aspx");
break;
case "btnBack":
me.mes_back_num += 1;
of.current_state_id = 2;
sof.orderform_id = ofid;
sof.state_id = 2;
sof.modify_date = DateTime.Now;
db.State_Order_Form.InsertOnSubmit(sof);
db.SubmitChanges();
Response.Redirect("OrderManager.aspx");
break;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Order_Form_Product ofp = db.Order_Form_Product.Single(p => p.orderformproduct_id == Convert.ToInt32(Session["orderformproduct_id"]));
Order_Form of = db.Order_Form.Single(p => p.orderform_id == ofp.orderform_id);
Product pro = db.Product.Single(p => p.product_id == ofp.product_id);
Product_Type_3 pt3 = db.Product_Type_3.Single(p => p.product_type_3_id == pro.product_type_id);
Product_Type_2 pt2 = db.Product_Type_2.Single(p => p.product_type_2_id == pt3.product_type_id);
Product_Type_1 pt1 = db.Product_Type_1.Single(p => p.product_type_1_id == pt2.product_type_id);
Client clnt = db.Client.Single(p => p.client_id == of.client_id);
txtProType1.Text = pt1.product_type_1_name;
txtProType2.Text = pt2.product_type_2_name;
txtProType3.Text = pt3.product_type_3_name;
txtSta.Text = pro.product_standars;
txtClient.Text = clnt.client_name;
txtOrderFormid.Text = of.orderform_id;
}
protected void deletedoder_Click(object sender, EventArgs e)
{
IQueryable <State_Order_Form> SOF = db.State_Order_Form.Where(p => p.orderform_id.ToString() == Session["orderid"].ToString());
if (Session["orderid"].ToString() != " " && SOF.Count() > 0)
{
//IQueryable<State_Order_Form> SOF = db.State_Order_Form.Where(p => p.orderform_id.ToString() == Session["orderid"].ToString());
db.State_Order_Form.DeleteAllOnSubmit(SOF);
IQueryable <Order_Form_Product> OFPs = db.Order_Form_Product.Where(p => p.orderform_id.ToString() == Session["orderid"].ToString());
if (OFPs.Count() > 0)
{
db.Order_Form_Product.DeleteAllOnSubmit(OFPs);
}
Order_Form OF = db.Order_Form.First(p => p.orderform_id.ToString() == Session["orderid"].ToString());
db.Order_Form.DeleteOnSubmit(OF);
db.SubmitChanges();
}
Response.Redirect("SellList.aspx");
Session["orderid"] = " ";
}
protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e)
{
//取INdex
int index = Convert.ToInt32(e.CommandArgument);
DataKey key = GridView1.DataKeys[index];
string ofid = key.Value.ToString();
State_Order_Form sof = new State_Order_Form();
Order_Form of = db.Order_Form.Single(p => p.orderform_id == ofid);
DropDownList ddlPriority = (DropDownList)GridView1.Rows[index].Cells[7].FindControl("ddlPriority");
//判断哪个按钮
switch (e.CommandName.ToString())
{
case "ddlPriority":
of.priority = Convert.ToInt32(ddlPriority.SelectedValue);
db.SubmitChanges();
Response.Redirect("OrderManager.aspx");
break;
}
}
protected void saveorder_Click(object sender, EventArgs e)
{
Session["orderid"] = OrderNum.Text;
Order_Form of = new Order_Form();
of.client_id = Convert.ToInt32(ClientName.SelectedValue);
of.order_date = Convert.ToDateTime(OrderDate.Text);
of.orderform_id = OrderNum.Text;
of.current_state_id = 1;
db.Order_Form.InsertOnSubmit(of);
db.SubmitChanges();
State_Order_Form sof = new State_Order_Form();
sof.state_id = 1;
sof.modify_date = DateTime.Now;
sof.modify_person = Session["UserName"].ToString();
sof.orderform_id = OrderNum.Text;
db.State_Order_Form.InsertOnSubmit(sof);
db.SubmitChanges();
saveorder.Visible = false;
}
public Client_form(Order_Form instance)
{
// Use the passed instance to access your clientName
instance.clientName = "your string back";
}
