//绑定订单 protected void BindOrder() { string temp = " and PMPO_PurchaseOrderID like'%" + Label6.Text.ToString().Trim() + "%'"; Gridview3.DataSource = pp.Select_Order_Main(temp); Gridview3.DataBind(); UpdatePanel_PMPurchaseOrder.Update(); }
protected void Page_Load(object sender, EventArgs e) { Title = "采购订单"; if (!(Session["UserRole"].ToString().Contains("采购订单制定"))) { Response.Redirect("~/Default.aspx"); } if (!IsPostBack) { BindGridview3(""); UpdatePanel_PMPurchaseOrder.Update(); } }
//重置 protected void Button_Reset1(object sender, EventArgs e) { BindGridview3(""); UpdatePanel_PMPurchaseOrder.Update(); DropDownList4.SelectedValue = "请选择"; DropDownList3.SelectedValue = "请选择"; PurchaseOrderID.Text = ""; DropDownList1.SelectedValue = "请选择"; DropDownList2.SelectedValue = "请选择"; TextBox3.Text = ""; TextBox_SPTime2.Text = ""; TextBox_SPTime3.Text = ""; UpdatePanel1.Update(); }
protected void Button_Sh2(object sender, EventArgs e) { string condition = GetCondition(); BindGridview3(condition); UpdatePanel_PMPurchaseOrder.Update(); Panel3.Visible = false; UpdatePanel3.Update(); Panel4.Visible = false; UpdatePanel4.Update(); Panel2.Visible = false; UpdatePanel2.Update(); Panel_Material.Visible = false; UpdatePanel_Material.Update(); Panel_PMPurchaseOrderDetail.Visible = false; UpdatePanel_PMPurchaseOrderDetail.Update(); }
//提交所有采购订单详细表 protected void ButtonMark(object sender, EventArgs e) { Gridview1_BL(); PMPurchaseOrderinfo.PMPO_TotalMoney = Convert.ToDecimal(label_ActuallNum.Text.ToString()); PMPurchaseOrderinfo.PMPO_ResidueMoney = Convert.ToDecimal(label_ActuallNum.Text.ToString()); //PMPurchaseOrderinfo.PMPO_Num = Convert.ToDecimal(this.label_ZS.Text.ToString()); PMPurchaseOrderinfo.PMPO_PurchaseOrderID = new Guid(labelPurchaseOrderID.Text); PMPurchaseOrderinfo.PMPO_State = "已提交"; pl.UpdatePMPurchaseOrder_State(PMPurchaseOrderinfo); BindGridview3(""); UpdatePanel_PMPurchaseOrder.Update(); Panel_PMPurchaseOrderDetail.Visible = false; UpdatePanel_PMPurchaseOrderDetail.Update(); Panel2.Visible = false; UpdatePanel2.Update(); ScriptManager.RegisterClientScriptBlock(UpdatePanel_PMPurchaseOrderDetail, GetType(), "aa", "alert('提交成功!')", true); return; }
//制定详细表 protected void Button_Create(object sender, EventArgs e) { if (TextBox1.Text != "") { PMPurchaseOrderinfo.PMSI_ID = new Guid(LabelSupplyID.Text); } else { ScriptManager.RegisterClientScriptBlock(UpdatePanel3, GetType(), "alert", "alert('标记*的为必填项,请填写完整!')", true); return; } if (DropDownList6.SelectedValue != "请选择") { PMPurchaseOrderinfo.PMPO_PayWay = DropDownList6.SelectedValue.ToString(); if (DropDownList6.SelectedValue == "预付款" || DropDownList6.SelectedValue == "现金预付款") { PMPurchaseOrderinfo.PMPO_AdvancePayNum = Convert.ToDecimal(TextBox14.Text); } else { PMPurchaseOrderinfo.PMPO_AdvancePayNum = Convert.ToDecimal("0"); } } else { ScriptManager.RegisterClientScriptBlock(UpdatePanel3, GetType(), "alert", "alert('标记*的为必填项,请填写完整!')", true); return; } if (TextBox2.Text != "") { PMPurchaseOrderinfo.PMPO_PaymentTime = Convert.ToInt32(TextBox2.Text.ToString()); } else { ScriptManager.RegisterClientScriptBlock(UpdatePanel3, GetType(), "alert", "alert('标记*的为必填项,请填写完整!')", true); return; } if (TextBox5.Text != "") { PMPurchaseOrderinfo.PMPO_PlanArrTime = Convert.ToDateTime(TextBox5.Text.ToString()); } else { ScriptManager.RegisterClientScriptBlock(UpdatePanel3, GetType(), "alert", "alert('标记*的为必填项,请填写完整!')", true); return; } PMPurchaseOrderinfo.PMPO_MakeMan = Session["UserName"].ToString(); //PMPurchaseOrderinfo.PMPO_MakeTime=DateTime.Now; //this.Label_MakeTime.Text PMPurchaseOrderinfo.PMPO_State = "未制定"; pl.InsertPMPurchaseOrderMain(PMPurchaseOrderinfo); BindGridview3(""); UpdatePanel_PMPurchaseOrder.Update(); TextBox1.Text = ""; DropDownList6.SelectedValue = "请选择"; TextBox2.Text = ""; TextBox5.Text = ""; Panel3.Visible = false; UpdatePanel3.Update(); }
//提交订单 protected void Button_Create(object sender, EventArgs e) { Guid id = new Guid(Label6.Text.ToString()); Guid sid = new Guid(pdid.Text.ToString()); string payway = DropDownList6.SelectedValue.ToString(); if (payway == "请选择") { ScriptManager.RegisterClientScriptBlock(Page, GetType(), "alert", "alert('请选择付款方式!')", true); return; } int paymenttime = 0; if (TextBox4.Text == "") { paymenttime = 0; } else { paymenttime = Convert.ToInt32(TextBox4.Text.ToString()); } DateTime arrtime = Convert.ToDateTime(TextBox6.Text.ToString()); DateTime remindtime = Convert.ToDateTime(TextBox7.Text.ToString()); string man = Session["UserName"].ToString().Trim(); pp.Insert_PurchaseOrder(id, sid, payway, paymenttime, arrtime, remindtime, man); if (Label_Way.Text == "Month") { foreach (GridViewRow item in Gridview_DetailPlan.Rows) { CheckBox cb = item.FindControl("CheckBox2") as CheckBox; if (cb.Checked) { Guid pid = new Guid(Gridview_DetailPlan.DataKeys[item.RowIndex]["PMPPD_ID"].ToString()); Guid Mid = new Guid(Gridview_DetailPlan.DataKeys[item.RowIndex]["IMMBD_MaterialID"].ToString()); decimal num = 0; if (Gridview_DetailPlan.Rows[item.RowIndex].Cells[7].Text.ToString().Replace(" ", "") == "") { num = 0; } else { num = Convert.ToDecimal(Gridview_DetailPlan.Rows[item.RowIndex].Cells[7].Text.ToString().Replace(" ", "")); } pp.Insert_Material_MonthPlan(id, pid, Mid, num); } } } else if (Label_Way.Text == "Week") { foreach (GridViewRow item in Gridview_Week.Rows) { CheckBox cb = item.FindControl("CheckBox2") as CheckBox; if (cb.Checked) { Guid pid = new Guid(Gridview_Week.DataKeys[item.RowIndex]["MWPD_ID"].ToString()); Guid Mid = new Guid(Gridview_Week.DataKeys[item.RowIndex]["IMMBD_MaterialID"].ToString()); decimal num = Convert.ToDecimal(Gridview_Week.Rows[item.RowIndex].Cells[5].Text.ToString()); pp.Insert_Material_WeekPlan(id, pid, Mid, num); } } } ScriptManager.RegisterClientScriptBlock(Page, GetType(), "alert", "alert('新建成功!')", true); Panel_PMPurchaseOrder.Visible = true; UpdatePanel_PMPurchaseOrder.Update(); BindOrder(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindDropDownList1(); BindDropDownList11(); BindDropDownList111(); BindPlanMain(); BindOrder(); BindMatPlan_Add(); BindMatPlan_Original(); BindMatPlan_Week(); #region 权限 if (Request.QueryString["status"] == "PurchasingPlanLook")//采购计划查看 { Title = "采购计划查看"; Button6.Visible = false; UpdatePanel_Search.Update(); Gridview_MonthPlan.Columns[9].Visible = false; Gridview_MonthPlan.Columns[10].Visible = false; Gridview_MonthPlan.Columns[11].Visible = false; UpdatePanel_MonthPlan.Update(); Gridview_DetailPlan.Columns[11].Visible = false; Gridview_DetailPlan.Columns[12].Visible = false; Gridview_DetailPlan.Columns[13].Visible = false; Button31.Visible = false; Button2.Visible = false; Button33.Visible = false; UpdatePanel_Detail.Update(); } if (Request.QueryString["status"] == "PurchasingPlanEdit")//采购计划维护 { Title = "采购计划维护"; Button6.Visible = true; ButtonPro.Visible = true; Cbx2_SelectAll.Visible = true; Button8.Visible = true; CheckBox1.Visible = true; UpdatePanel_Search.Update(); Gridview_MonthPlan.Columns[9].Visible = true; Gridview_MonthPlan.Columns[10].Visible = false; Gridview_MonthPlan.Columns[11].Visible = true; UpdatePanel_MonthPlan.Update(); Gridview_DetailPlan.Columns[11].Visible = true; Gridview_DetailPlan.Columns[12].Visible = true; Gridview_DetailPlan.Columns[13].Visible = true; Button31.Visible = true; Button2.Visible = false; Button33.Visible = true; UpdatePanel_Detail.Update(); } if (Request.QueryString["status"] == "PurchasingPlanCheck")//采购计划审核 { Title = "采购计划审核"; Button6.Visible = false; UpdatePanel_Search.Update(); Gridview_MonthPlan.Columns[9].Visible = false; Gridview_MonthPlan.Columns[10].Visible = true; Gridview_MonthPlan.Columns[11].Visible = false; UpdatePanel_MonthPlan.Update(); Gridview_DetailPlan.Columns[11].Visible = false; Gridview_DetailPlan.Columns[12].Visible = false; Gridview_DetailPlan.Columns[13].Visible = false; Button31.Visible = false; Button2.Visible = false; Button33.Visible = false; UpdatePanel_Detail.Update(); } if (Request.QueryString["status"] == "PurchasingPlanBuy")//采购计划执行 { Title = "采购计划执行"; ButtonPro.Visible = true; Button8.Visible = true; Button17.Visible = true; Cbx2_SelectAll.Visible = true; CheckBox1.Visible = true; CheckBox3.Visible = true; Button6.Visible = false; UpdatePanel_Search.Update(); Gridview_MonthPlan.Columns[9].Visible = false; Gridview_MonthPlan.Columns[10].Visible = false; Gridview_MonthPlan.Columns[11].Visible = false; UpdatePanel_MonthPlan.Update(); Gridview_DetailPlan.Columns[0].Visible = true; Gridview_DetailPlan.Columns[11].Visible = false; Gridview_DetailPlan.Columns[12].Visible = false; Gridview_DetailPlan.Columns[13].Visible = false; Button31.Visible = false; Button2.Visible = true; Button33.Visible = false; UpdatePanel_Detail.Update(); } if (Request.QueryString["status"] == "PurchasingPlanMatBuy")//材料周计划执行 { Title = "材料周计划执行"; Panel_PMPurchaseOrder.Visible = false; UpdatePanel_PMPurchaseOrder.Update(); Button17.Visible = true; CheckBox3.Visible = true; Panel_Search.Visible = false; UpdatePanel_Search.Update(); Panel_MonthPlan.Visible = false; UpdatePanel_MonthPlan.Update(); Panel_Choose.Visible = true; Button10.Visible = false; Button11.Visible = false; UpdatePanel_Choose.Update(); //this.Label6.Text = "6CFEB693-4DE7-49F9-A0C3-2A89A5B990FB"; BindOrder(); Panel_PMPurchaseOrder.Visible = false; UpdatePanel_PMPurchaseOrder.Update(); } #endregion } }