private void SetWOinfo(string WO) { DataTable dt = CreateLot.QueryWorkorderIno(WO); if (dt.Rows.Count > 0) { txtThinkness.Text = dt.Rows[0]["MouldThinkness"].ToString(); txtType.Text = dt.Rows[0]["MouldType"].ToString(); txtPETType.Text = dt.Rows[0]["MouldPETType"].ToString(); txtPinMin.Text = dt.Rows[0]["mouldpinmin"].ToString(); } else { JScript.Alert("未查询到工单信息", this); } }
//private void test() //{ // grd.DataSource= EqpManage.Exist("All"); // grd.DataBind(); //} protected void txtBtnEnter_Click(object sender, EventArgs e) { //长度和宽度是否已经输入 if (txtLotLength.Text == "") { JScript.Alert("请输入批次长度", this); return; } if (txtLotWidth.Text == "") { JScript.Alert("请输入批次宽度", this); return; } int beginValue; beginValue = CreateLot.QueryMaxNum(txtWorkOrder.Text); if (beginValue >= 999) { JScript.Alert("工单数量已经用完大于999个序列号", this); return; } beginValue = beginValue + 1; dt = (DataTable)ViewState["dt"]; dt.Rows.Clear(); DataRow dtRow; for (int i = beginValue; i <= Convert.ToInt32(txtLotCount.Text) + beginValue - 1; i++) { //CreateMouldLot.InsertLot() //AddRow((i).ToString("000")); dtRow = dt.NewRow(); dtRow["mouldid"] = txtWorkOrder.Text + i.ToString("000"); dtRow["Length"] = txtLotLength.Text; dtRow["Width"] = txtLotWidth.Text; dt.Rows.Add(dtRow); } ViewState["dt"] = dt; databind(); }
//protected void btnSaveClose_Click(object sender, EventArgs e) //{ // test(); //} private void setBominfo(string wo) { DataTable dt = CreateLot.QueryWorkorderIno(wo); if (dt.Rows.Count > 0) { txtBOMID.Text = dt.Rows[0]["bomid"].ToString(); txtMouldLength.Text = dt.Rows[0]["mouldLength"].ToString(); txtMouldPETType.Text = dt.Rows[0]["mouldpettype"].ToString(); txtMouldPinMin.Text = dt.Rows[0]["mouldpinmin"].ToString(); txtMouldThinkness.Text = dt.Rows[0]["mouldthinkness"].ToString(); txtMouldType.Text = dt.Rows[0]["mouldtype"].ToString(); txtMouldWidth.Text = dt.Rows[0]["mouldwidth"].ToString(); txtWorkflow.Text = dt.Rows[0]["flowidalias"].ToString(); txtWorkorderType.Text = dt.Rows[0]["workordertype"].ToString(); txtWorkshopID.Text = dt.Rows[0]["WorkshopID"].ToString(); txtWorkflowID.Text = dt.Rows[0]["flowid"].ToString(); Showflowid(dt.Rows[0]["flowid"].ToString()); } else { JScript.Alert("未查询到工单信息", this); } }
protected void btnEnter_Click(object sender, EventArgs e) { //查询是否可以过站 string result = CRUD.QueryStationOfLot(lblWorksiteID.Text, txtLot.Text); if (result != "success") { JScript.Alert(result, this); txtLot.Text = ""; return; } DataTable lotDt = CRUD.GetLotBasisInfo(txtLot.Text); ViewState["lotDt"] = lotDt; string workshop = lotDt.Rows[0]["workshopID"].ToString(); setddl(workshop); string WO = lotDt.Rows[0]["workorder"].ToString(); ViewState["WO"] = WO; #region 批次流程 //查询批次流程 CRUD.setLabelProcess(lblLotprocess, lblCurrnentWorksite, lblEndProcess, txtLot.Text, lblWorksiteID.Text); #endregion DataTable dt = CRUD.GetWorkflow(txtLot.Text); string firstWorksiteID = dt.Rows[0]["worksiteid"].ToString(); //第一个站点从工单获取; if (lblWorksiteID.Text == firstWorksiteID) { //查询工单中的长、宽 dt.Clear(); dt = CreateLot.QueryWorkorderIno(WO); txtPreLength.Text = dt.Rows[0]["mouldlength"].ToString(); txtPreWidth.Text = dt.Rows[0]["mouldwidth"].ToString(); } else { //批次已过站点 string WorksiteIDOfLot = CRUD.GetWorksite2(txtLot.Text); //查询前站的长宽 dt.Clear(); dt = CRUD.getStationInfo(txtLot.Text, WorksiteIDOfLot); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["paratype"].ToString() == "MouldLength") { txtPreLength.Text = dt.Rows[i]["paraid"].ToString(); } if (dt.Rows[i]["paratype"].ToString() == "MouldWidth") { txtPreWidth.Text = dt.Rows[i]["paraid"].ToString(); } } } //查询母批的长度宽度及其剩余量 //FilmCRUD.GetPreLengthAndWidth(txtPreLength, txtPreWidth, txtLot.Text, lblWorksiteID.Text, WO, ""); //txtRestLength.Text = lotDt.Rows[0]["restlength"].ToString(); //txtPreLength.Text = lotDt.Rows[0]["mouldlength"].ToString(); //txtPreWidth.Text = lotDt.Rows[0]["mouldwidth"].ToString(); //=======前站宽幅长度和剩余长度取有效值 modify by lei.xue on 2017-6-1================ txtRestLength.Text = lotDt.Rows[0]["restlength"].ToString(); txtPreLength.Text = lotDt.Rows[0]["validlength"].ToString(); txtPreWidth.Text = lotDt.Rows[0]["validwidth"].ToString(); //==========标签增加产品类型 add by lei.xue on 2017-5-20================ txtProductType.Text = lotDt.Rows[0]["producttype"].ToString(); //生成条码 LabelInfo(ddlEqp.SelectedValue.ToString().Substring(0, 3)); }
protected void btnSaveClose_Click(object sender, EventArgs e) { if (txtWorkflowID.Text == "" || txtWorkshopID.Text == "" || txtWorkOrder.Text == "") { JScript.Alert("请输入工单按回车", this); return; } if (txtLotLength.Text == "" || txtLotWidth.Text == "") { JScript.Alert("请输入批次长度和批次宽度", this); return; } DataTable viewdt = (DataTable)ViewState["dt"]; if (viewdt.Rows.Count <= 0) { JScript.Alert("请先生成PET编号,在文本框输入数量按回车!", this); return; } //循环datatable插入lotbasis for (int i = 0; i <= grd.Rows.Count - 1; i++) { //CheckBox cbx = (CheckBox)grd.Rows[i].FindControl("cbx"); //if (cbx.Checked == true) //{ // //result = EqpManage.Delete(grd.Rows[i].Cells[1].Text); // //if (result != "success") // //{ // // JScript.Alert("删除设备!", this); // //} //} LotBasisDatalist dl = new LotBasisDatalist(); dl.flowid = txtWorkflowID.Text; dl.workshopid = txtWorkshopID.Text; dl.lottype = "Film"; dl.status = "Active"; dl.createuser = System.Web.HttpContext.Current.Request.Cookies["userID"].Value.ToString(); dl.currentflowidno = "0"; dl.factoryid = ""; dl.workorder = txtWorkOrder.Text;//ddlWorkorder.SelectedValue; dl.reworkorder = ""; dl.lotid = grd.Rows[i].Cells[0].Text; dl.lotcount = "1"; dl.Filmlevel = "A"; //创建批次增加宽度和长度记录 //批次长宽改为手动输入 modify by lei.xue on 2017-4-12================================================ //dl.length = txtMouldLength.Text; //dl.restlength = txtMouldLength.Text; //dl.width = txtMouldWidth.Text; //dl.restwidth = txtMouldWidth.Text; dl.length = txtLotLength.Text; dl.restlength = txtLotLength.Text; dl.width = txtLotWidth.Text; dl.restwidth = txtLotWidth.Text; //增加有效长度 dl.validlength = txtLotLength.Text; dl.validwidth = txtLotWidth.Text; string result = CreateMouldLot.InsertLot(dl); if (result != "success") { JScript.Alert(result, this); return; } string WOStatusResult = CreateLot.ChangWOStatus(txtWorkOrder.Text, "open"); if (WOStatusResult != "success") { JScript.Alert("开启工单失败!", this); return; } JScript.Alert("创建PET膜序列号成功!", this); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>PrintLabel();</script>"); //CreateTable(); //databind(); //txtLotCount.Text = ""; } }