//绑定订单
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
}
}
