//查询单头单身 protected void search(object sender, EventArgs e) { try { string Invoice_no = DropDownList_invoice_no.SelectedValue.ToString(); string first_time = "2016-07-01 00:00:00"; DateTime start_time = Convert.ToDateTime(first_time); DateTime end_time = DateTime.Now; if (Invoice_no == "--选择领料单号--") { Invoice_no = ""; } IssueHeaderReater.DataSource = invoiceDC.getIssueHeaderBySome(Invoice_no, "", ""); IssueLineReater.DataSource = invoiceDC.getIssueLineBySome(Invoice_no, "", "", start_time, end_time); if (IssueHeaderReater.DataSource == null) { PageUtil.showToast(this, "无相关领料单头信息"); } IssueHeaderReater.DataBind(); if (IssueLineReater.DataSource == null) { PageUtil.showToast(this, "无相关领料单身信息"); } IssueLineReater.DataBind(); } catch (Exception e1) { PageUtil.showToast(this, "查询失败"); } }
//显示打印页面中的所有数据 protected void DataView() { InvoiceDC invoiceDC = new InvoiceDC(); try { //绑定其他数据 DataSet dataset_header = new DataSet(); dataset_header = invoiceDC.getIssueHeaderBySome(select_text.Value, "", ""); flex_value.Value = dataset_header.Tables[0].Rows[0]["flex_value"].ToString(); description.Value = dataset_header.Tables[0].Rows[0]["description"].ToString(); remark.Value = dataset_header.Tables[0].Rows[0]["remark"].ToString(); issue_type.Value = dataset_header.Tables[0].Rows[0]["issue_type"].ToString(); status.Value = dataset_header.Tables[0].Rows[0]["status"].ToString(); //绑定Repeater中数据 DataSet dataset_line = new DataSet(); dataset_line = invoiceDC.getIssueLineBySome(select_text.Value, "", "", Convert.ToDateTime("2016-07-01 00:00:00"), DateTime.Now); printMaterialRequisitionRepeater.DataSource = dataset_line; printMaterialRequisitionRepeater.DataBind(); } catch (Exception e) { PageUtil.showToast(this, "数据库中没有对应数据,请重新输入领料单号"); } }
protected void Select(object sender, EventArgs e) { try { //string Invoice_no = DropDownList_issue_no.SelectedValue.ToString(); //string Item_name = DropDownList_item_name.SelectedValue.ToString(); string Invoice_no = invoice_no.Value; string Item_name = item_name.Value; string Issue_type = Request.Form["issue_type"]; //if (Invoice_no == "--选择领料单号--") // Invoice_no = ""; //if (Item_name == "--选择料号--") // Item_name = ""; string FIRST_TIME = inpend.Value; if (FIRST_TIME == "") { FIRST_TIME = "2016-07-01 00:00:00"; } start_time = Convert.ToDateTime(FIRST_TIME); string LAST_TIME = inpstart.Value; end_time = Convert.ToDateTime(LAST_TIME); GridView_header.DataSource = invoiceDC.getIssueHeaderBySome(Invoice_no, Issue_type, Item_name); GridView_header.DataBind(); GridView_line.DataSource = invoiceDC.getIssueLineBySome(Invoice_no, Item_name, Issue_type, start_time, end_time); GridView_line.DataBind(); if (GridView_header.DataSource == null) { PageUtil.showToast(this, "无相关领料单头信息"); } if (GridView_line.DataSource == null) { PageUtil.showToast(this, "无相关领料单身信息"); } } catch (Exception e1) { PageUtil.showToast(this, "查询失败"); } }
//导入缺料明细 protected void import_short_detail(object sender, EventArgs e) { //导入缺料明细前,先把框框里的数据清空 GridView1.DataSource = null; GridView1.DataBind(); DataSet ds; if (string.IsNullOrWhiteSpace(invoice_no.Value)) { PageUtil.showToast(this, "请填写单据号"); return; } string Invoice_no = invoice_no.Value; if (invoiceDC.getIssueHeaderBySome(Invoice_no, "", "") == null) { PageUtil.showToast(this, "请确定单据号存在"); return; } ds = invoiceDC.getIssueHeaderBySome(Invoice_no, "", ""); //工单领料时才需要导入缺料明细 if (ds.Tables[0].Rows[0]["issue_type"].ToString() == "工单领料") { string Issue_wo_no = DropDownList_issue_wo_no.SelectedValue.ToString(); if (DropDownList_issue_wo_no.SelectedValue.ToString() == "--选择工单--") { PageUtil.showToast(this, "请选择工单后再做操作"); return; } //避免重复点击导入缺料明细按钮(每一个领料单只能导入一次缺料明细) DataSet ds2; ds2 = invoiceDC.getIssueLineBySome(Invoice_no, ""); if (ds2 != null) { PageUtil.showToast(this, "该领料单已导入过缺料明细,请勿重复导入缺料明细!"); return; } //从数据库中获取该单据对应的line_num值 int Line_num = invoiceDC.getIssueLine_numByInvoice_no(Invoice_no); //Line_num生成失败 if (Line_num == -1) { PageUtil.showToast(this, "添加单身失败"); return; } DataTable table = new DataTable(); table = GetGridViewData(table); //当框框中已经有一条数据及以上时,需要对line_num做处理 if (table.Rows.Count >= 1) { Line_num = Line_num + table.Rows.Count; } //获取缺料明细 DataSet ds3 = invoiceDC.getShort_detail(Issue_wo_no); //遍历查询出来的每行 foreach (DataRow Dr in ds3.Tables[0].Rows) { DataRow sourseRow = table.NewRow(); sourseRow["wo_no"] = Issue_wo_no; sourseRow["line_num"] = Line_num; sourseRow["item_name"] = Dr["item_name"]; sourseRow["peration_seq_num"] = "请修改制程"; sourseRow["issued_qty"] = Dr["issued_qty"]; sourseRow["simulated_qty"] = Dr["simulated_qty"]; sourseRow["required_qty"] = Dr["required_qty"]; //sourseRow["frame_key"] = Frame_key; sourseRow["issued_sub"] = "请修改库别"; sourseRow["create_man"] = user; sourseRow["create_time"] = DateTime.Now; table.Rows.Add(sourseRow); Line_num++; //line_num递增 } Session["TaskTable"] = table; GridView1.DataSource = table; GridView1.DataBind(); //提交单个单身数据成功时,清除用户已填写的单身数据,方便用户填写下一个单身 DropDownList_issue_wo_no.SelectedValue = "--选择工单--"; DropDownList_item_name.SelectedValue = "--选择小料号--"; DropDownList_operation_seq_num.SelectedValue = "--选择制程--"; DropDownList_issue_sub_key.SelectedValue = "--选择库别--"; //DropDownList_frame_key.SelectedValue = "--选择料架--"; issued_qty.Value = ""; simulated_qty.Value = ""; required_qty.Value = ""; PageUtil.showToast(this, "导入缺料明细成功,请修改库别与制程后点击更新按钮!"); return; } }