/// <summary> /// 开始模拟 /// 按工單将仓库中的原料HOLD住 /// 遵循先进先出的原则,还有有退过料的先出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void start_analog_Click(object sender, EventArgs e) { DataTable table = GetGridViewData(); string[] wo_no_array = new string[table.Rows.Count]; Simulate_operation dc = new Simulate_operation(); int z = 0; for (int i = 0; i < table.Rows.Count; i++) { int j = dc.getSimulateByWo(table.Rows[i][0].ToString()); if (j == 1) { PageUtil.showToast(this.Page, "请不要重复模拟部分工单,请刷新!"); return; } else { wo_no_array[i] = table.Rows[i][0].ToString(); } } AnalogAcquisitionDC analogAcquisitionDC = new AnalogAcquisitionDC(); int fail = analogAcquisitionDC.start_simulate(wo_no_array); if (fail == 1) { PageUtil.showToast(this.Page, "模拟成功"); } else { PageUtil.showToast(this.Page, "模拟失败"); } }
//根据输入框的工单号进行单向模拟查询 protected void select_one_simulate(object sender, EventArgs e) { AnalogAcquisitionDC DC = new AnalogAcquisitionDC(); string wo_no = wo_no_1.Text; if (string.IsNullOrEmpty(wo_no)) { PageUtil.showToast(this, "请输入工单编号!"); return; } DataSet ds = DC.get_simulite_by_wo_no(wo_no); panl1.Style["display"] = "none"; panl2.Style["display"] = "block"; panl3.Style["display"] = "none"; GridView2.DataSource = ds; GridView2.DataBind(); }
//获取最新需求 protected void one_latest_demand(object sender, EventArgs e) { string message = "更新完成"; AnalogAcquisitionDC analogAcquisitionDC = new AnalogAcquisitionDC(); DataTable table = GetGridViewData(); string[] wo_no_array = new string[table.Rows.Count]; for (int i = 0; i < table.Rows.Count; i++) { wo_no_array[i] = table.Rows[i][0].ToString().Trim(); } if (wo_no_array.Length == 0) { PageUtil.showToast(this.Page, "请输入工单号"); return; } DataSet ds1 = analogAcquisitionDC.get_new_demand(wo_no_array); int panduan = analogAcquisitionDC.update_simulate(wo_no_array); //DataSet ds2 = analogAcquisitionDC.get_new_simulate(wo_no_array); if (panduan == 1) { panl1.Style["display"] = "block"; panl2.Style["display"] = "none"; panl3.Style["display"] = "none"; GridView1.DataSource = ds1; //GridView2.DataSource = ds2; GridView1.DataBind(); //GridView2.DataBind(); status.InnerText = message; } else { PageUtil.showToast(this.Page, "最新需求获取失败,可能是有人删除了工单。"); } }
//添加工单号,并追加各个gridview protected void add_wo_no_Click(object sender, EventArgs e) { DataTable table = GetGridViewData(); string wo_no = wo_no_1.Text; if (string.IsNullOrEmpty(wo_no)) { PageUtil.showToast(this, "请输入工单编号!"); return; } AnalogAcquisitionDC analogAcquisitionDC = new AnalogAcquisitionDC(); DataSet ds = analogAcquisitionDC.getSomeByWo_No(wo_no); DataSet ds3 = null; for (int i = 0; i < table.Rows.Count; i++) { if (string.Compare(wo_no, table.Rows[i][0].ToString()) == 0) { PageUtil.showToast(this, "工单号重复,请检查后输入"); return; } } if (ds == null || ds.Tables[0].Rows.Count == 0) { PageUtil.showToast(this, "该工单编号不存在!"); return; } else { //ds3 = analogAcquisitionDC.get_simulite_by_wo_no(wo_no); //if (ds3 == null || ds3.Tables[0].Rows.Count == 0) //{ // DateTime d = DateTime.Now; // int simulate_id=int.Parse(d.ToString("yyyyMMdd")); // int a = analogAcquisitionDC.add_wo_simulate(wo_no); // if (a == 0) // { // PageUtil.showToast(this.Page, "添加模拟单失败"); // return; // } // else // { // a = analogAcquisitionDC.update_wo_simulate(simulate_id, wo_no); // if (a == 0) // { // PageUtil.showToast(this.Page, "系统崩溃"); // return; // } // else // { // ds3 = analogAcquisitionDC.get_simulite_by_wo_no(wo_no); // } // } //} } Add_Wo_No(table, wo_no); GridView_Add.DataSource = table; GridView1.DataSource = addGridView1(ds); //GridView2.DataSource = addGridView2(ds3); GridView_Add.DataBind(); GridView1.DataBind(); //GridView2.DataBind(); wo_no_1.Text = ""; panl1.Style["display"] = "block"; panl2.Style["display"] = "none"; panl3.Style["display"] = "none"; string message = "更新完成"; status.InnerText = message; }