protected void btnConsultar_Click(object sender, EventArgs e) { //JC 300721 Evitar Error de Collection was Modified DataTable _consultaMateriales = new DataTable(); List <MyLioEntidad> LstTable = new List <MyLioEntidad>(); Session["orno"] = txtOrder.Text.Trim().ToUpper(); lblError.Text = String.Empty; lblConfirm.Text = String.Empty; var order = txtOrder.Text.Trim().ToUpper(); if (order != String.Empty) { Ent_tticol090 data090 = new Ent_tticol090() { fpdn = order }; var consultaOrden = _idaltticol090.lineClearance_verificaOrdenes_Param(ref data090, ref strError); if (consultaOrden.Rows.Count > 0) { if (valstatwo) { if (consultaOrden.Rows[0]["STAT"].ToString() != "2") { lblError.Text = _textoLabels.readStatement(formName, _idioma, "WorkorderhasnotbeeninitiatedPOP"); return; } } _consultarTurno = _idaltticol111.findRecordByPdno(ref order, ref strError); if (_consultarTurno.Rows.Count > 0) { string shift = _consultarTurno.Rows[0]["shif"].ToString().Trim(); _consultaMateriales = _idaltticst001.findByPdnoCosts(ref order, ref shift, ref strError); if (_consultaMateriales.Rows.Count > 0) { LstTable.Clear(); foreach (DataRow item in _consultaMateriales.Rows) { MyLioEntidad MyLioEntidadObj = new MyLioEntidad(); MyLioEntidadObj.PDNO = item["PDNO"].ToString(); MyLioEntidadObj.PONO = item["PONO"].ToString(); MyLioEntidadObj.CWAR = item["CWAR"].ToString(); MyLioEntidadObj.CLOT = item["CLOT"].ToString(); MyLioEntidadObj.SITM = item["SITM"].ToString(); MyLioEntidadObj.DSCA = item["DSCA"].ToString(); MyLioEntidadObj.CUNI = item["CUNI"].ToString(); MyLioEntidadObj.CANT_EST = item["CANT_EST"].ToString(); MyLioEntidadObj.ACT_CANT = item["ACT_CANT"].ToString(); MyLioEntidadObj.ISWH = item["ISWH"].ToString().Trim() == "" ? "0" : item["ISWH"].ToString().Trim(); MyLioEntidadObj.OQMF = item["OQMF"].ToString(); MyLioEntidadObj.CANTD = item["CANTD"].ToString(); MyLioEntidadObj.MCNO = item["MCNO"].ToString(); MyLioEntidadObj.CANT_PICK = item["CANT_PICK"].ToString(); DataTable dt215 = _idaltticol090.ConsultarCantidad215(MyLioEntidadObj, ref strError); //JC 190821 No sumar doble vez los pallets asignados //DataTable dt022044131 = _idaltticol090.ConsultarCantidadPoritem022042131(MyLioEntidadObj, ref strError); var Stock = Convert.ToDecimal(dt215.Rows[0]["T$STOC"].ToString()); var Cant_Pic = Convert.ToDecimal(string.IsNullOrEmpty(MyLioEntidadObj.CANT_PICK.Trim()) ? Convert.ToDecimal(0) : Convert.ToDecimal(MyLioEntidadObj.CANT_PICK.Trim())); //MyLioEntidadObj.cant_reg = quantity_reg_order_machine140(shift, MyLioEntidadObj.MCNO, MyLioEntidadObj.SITM, MyLioEntidadObj.PDNO, "cant_reg") == string.Empty ? Convert.ToString(0) : quantity_reg_order_machine140(shift, MyLioEntidadObj.MCNO, MyLioEntidadObj.SITM, MyLioEntidadObj.PDNO, "cant_reg"); //MyLioEntidadObj.cant_max = maxquantity_per_shift140(shift, MyLioEntidadObj.MCNO, MyLioEntidadObj.SITM, MyLioEntidadObj.PDNO, "cant_max") == string.Empty ? Convert.ToString(Int32.MaxValue) : maxquantity_per_shift140(shift, MyLioEntidadObj.MCNO, MyLioEntidadObj.SITM, MyLioEntidadObj.PDNO, "cant_max"); //MyLioEntidadObj.cant_proc = maxquantity_per_shift140(shift, MyLioEntidadObj.MCNO, MyLioEntidadObj.SITM, MyLioEntidadObj.PDNO, "cant_proc") == string.Empty ? Convert.ToString(0) : maxquantity_per_shift140(shift, MyLioEntidadObj.MCNO, MyLioEntidadObj.SITM, MyLioEntidadObj.PDNO, "cant_proc"); //JC 190821 No sumar doble vez los pallets asignados //if (dt022044131.Rows.Count > 0) //{ //MyLioEntidadObj.STOCK = (Convert.ToDecimal(string.IsNullOrEmpty(MyLioEntidadObj.ISWH.Trim()) ? Convert.ToDecimal(0) : Convert.ToDecimal(MyLioEntidadObj.ISWH.Trim())) + Convert.ToDecimal(dt022044131.Rows[0]["QTYC"].ToString())).ToString(); //MyLioEntidadObj.ISWH = (Convert.ToDecimal(string.IsNullOrEmpty(MyLioEntidadObj.ISWH.Trim()) ? Convert.ToDecimal(0) : Convert.ToDecimal(MyLioEntidadObj.ISWH.Trim())) + Convert.ToDecimal(dt022044131.Rows[0]["QTYC"].ToString())).ToString(); MyLioEntidadObj.ISWH = (Convert.ToDecimal(string.IsNullOrEmpty(MyLioEntidadObj.ISWH.Trim()) ? Convert.ToDecimal(0) : Convert.ToDecimal(MyLioEntidadObj.ISWH.Trim())).ToString()); //} if (dt215.Rows.Count > 0) { //MyLioEntidadObj.STOCK = (Convert.ToDecimal(dt215.Rows[0]["T$STOC"].ToString()) - Cant_Pic - Convert.ToDecimal(string.IsNullOrEmpty(MyLioEntidadObj.ACT_CANT.Trim()) ? Convert.ToDecimal(0) : Convert.ToDecimal(MyLioEntidadObj.ISWH.Trim()))).ToString(); MyLioEntidadObj.STOCK = (Convert.ToDecimal(dt215.Rows[0]["T$STOC"].ToString()) - Cant_Pic - Convert.ToDecimal(string.IsNullOrEmpty(MyLioEntidadObj.ACT_CANT.Trim())) - Convert.ToDecimal(MyLioEntidadObj.ISWH.Trim())).ToString(); } MyLioEntidadObj.cant_reg = item["CANT_REG"].ToString().Trim() == "" ? "0" : item["CANT_REG"].ToString().Trim(); MyLioEntidadObj.cant_max = item["CANT_MAX"].ToString().Trim() == "" ? MyLioEntidadObj.STOCK : item["CANT_MAX"].ToString().Trim(); MyLioEntidadObj.cant_proc = item["CANT_PROC"].ToString().Trim() == "" ? "0" : item["CANT_PROC"].ToString().Trim(); LstTable.Add(MyLioEntidadObj); } //foreach (MyLioEntidad item in LstTable) //{ // item.cant_reg = quantity_reg_order_machine140(shift, item.MCNO, item.SITM, item.PDNO, "cant_reg") == string.Empty ? Convert.ToString(0) : quantity_reg_order_machine140(shift, item.MCNO, item.SITM, item.PDNO, "cant_reg"); // item.cant_max = maxquantity_per_shift140(shift, item.MCNO, item.SITM, item.PDNO, "cant_max") == string.Empty ? Convert.ToString(Int32.MaxValue) : maxquantity_per_shift140(shift, item.MCNO, item.SITM, item.PDNO, "cant_max"); // item.cant_proc = maxquantity_per_shift140(shift, item.MCNO, item.SITM, item.PDNO, "cant_proc") == string.Empty ? Convert.ToString(0) : maxquantity_per_shift140(shift, item.MCNO, item.SITM, item.PDNO, "cant_proc"); //} Session["LstTable"] = LstTable; Session["numReg"] = LstTable.Count(); makeTable(); divBtnGuardar.Visible = true; lblError.Text = String.Empty; } else { lblError.Text = mensajes("nomaterials"); return; } } else { lblError.Text = mensajes("machinenotexists"); return; } } else { lblError.Text = mensajes("ordernotexists"); return; } } else { lblError.Text = mensajes("formempty"); return; } }
protected void btnSend_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtWorkOrderFrom.Text.Trim())) { RequiredField.Enabled = true; RequiredField.IsValid = false; RequiredField.Validate(); txtWorkOrderFrom.Focus(); return; } if (string.IsNullOrEmpty(txtWorkOrderTo.Text.Trim())) { RequiredFieldValidator1.Enabled = true; RequiredFieldValidator1.IsValid = false; RequiredFieldValidator1.Validate(); txtWorkOrderTo.Focus(); return; } lblResult.Text = string.Empty; txtWorkOrderFrom.Text = txtWorkOrderFrom.Text.ToUpperInvariant(); txtWorkOrderTo.Text = txtWorkOrderTo.Text.ToUpperInvariant(); if (string.IsNullOrEmpty(txtWorkOrderFrom.Text.Trim())) { return; } if (string.IsNullOrEmpty(txtWorkOrderTo.Text.Trim())) { return; } if (txtWorkOrderFrom.Text.Trim().ToUpperInvariant() == txtWorkOrderTo.Text.Trim().ToUpperInvariant()) { lblResult.Text = mensajes("ordersequals"); lblResult.ForeColor = System.Drawing.Color.Red; return; } string ErrorOrden = "FROM "; obj.fpdn = txtWorkOrderFrom.Text.ToUpperInvariant(); resultado = idal.lineClearance_verificaOrdenes_Param(ref obj, ref strError); if (resultado.Rows.Count < 1) { lblResult.Text = string.Format(mensajes("ordernotexists"), ErrorOrden, obj.fpdn.Trim()); lblResult.ForeColor = System.Drawing.Color.Red; return; } ErrorOrden = "TO "; obj.fpdn = txtWorkOrderTo.Text.ToUpperInvariant(); resultado = idal.lineClearance_verificaOrdenes_Param(ref obj, ref strError); if (resultado.Rows.Count < 1) { lblResult.Text = string.Format(mensajes("ordernotexists"), ErrorOrden, obj.fpdn.Trim()); lblResult.ForeColor = System.Drawing.Color.Red; return; } obj.fpdn = txtWorkOrderFrom.Text.ToUpperInvariant(); resultado = idal.lineClearance_listaRegistrosOrden_Param(ref obj, ref strError); if (resultado.Rows.Count < 1) { lblResult.Text = string.Format(mensajes("ordernotexists"), ErrorOrden, obj.fpdn.Trim()); lblResult.ForeColor = System.Drawing.Color.Red; return; } hidden.Value = txtWorkOrderTo.Text.Trim(); grdRecords.DataSource = resultado; grdRecords.DataBind(); HeaderGrid.Visible = true; btnSave.Visible = true; }
protected void btnSend_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtWorkOrderFrom.Text.Trim())) { RequiredField.Enabled = true; RequiredField.IsValid = false; RequiredField.Validate(); txtWorkOrderFrom.Focus(); return; } if (string.IsNullOrEmpty(txtWorkOrderTo.Text.Trim())) { RequiredFieldValidator1.Enabled = true; RequiredFieldValidator1.IsValid = false; RequiredFieldValidator1.Validate(); txtWorkOrderTo.Focus(); return; } lblResult.Text = string.Empty; txtWorkOrderFrom.Text = txtWorkOrderFrom.Text.ToUpperInvariant(); txtWorkOrderTo.Text = txtWorkOrderTo.Text.ToUpperInvariant(); if (string.IsNullOrEmpty(txtWorkOrderFrom.Text.Trim())) { return; } if (string.IsNullOrEmpty(txtWorkOrderTo.Text.Trim())) { return; } if (txtWorkOrderFrom.Text.Trim().ToUpperInvariant() == txtWorkOrderTo.Text.Trim().ToUpperInvariant()) { lblResult.Text = "Work Order's are equals. Cannot continue"; return; } string ErrorOrden = "FROM "; obj.fpdn = txtWorkOrderFrom.Text.ToUpperInvariant(); resultado = idal.lineClearance_verificaOrdenes_Param(ref obj, ref strError); ErrorOrden = "TO "; obj.fpdn = txtWorkOrderTo.Text.ToUpperInvariant(); resultado = idal.lineClearance_verificaOrdenes_Param(ref obj, ref strError); obj.fpdn = txtWorkOrderFrom.Text.ToUpperInvariant(); resultado = idal.lineClearance_listaRegistrosOrden_Param(ref obj, ref strError); if (resultado.Rows.Count < 1) { lblResult.Text = string.Format("Order Work {0}: {1} doesn't exist or the status is not active, release or completed.", ErrorOrden, obj.fpdn.Trim()); return; } hidden.Value = txtWorkOrderTo.Text.Trim(); grdRecords.DataSource = resultado; grdRecords.DataBind(); HeaderGrid.Visible = true; btnSave.Visible = true; }