protected void btnSend_Click(object sender, EventArgs e) { // btnEnviar.Visible = false; if (string.IsNullOrEmpty(txtReturnOrder.Text.Trim())) { //RequiredField.Enabled = true; //RequiredField.IsValid = false; txtReturnOrder.Focus(); // grdRecords.DataSource = ""; // grdRecords.DataBind(); return; } tblReturnInfo.Visible = false; grdRecords.Visible = false; InterfazDAL_twhcol130 idal = new InterfazDAL_twhcol130(); string strError = string.Empty; string retorno = string.Empty; string returnorder = string.Empty; returnorder = txtReturnOrder.Text.Trim().ToString().ToUpperInvariant(); DataTable resultado = idal.vallidatePurchaseOrder(ref returnorder, ref strError); string tableName = string.Empty; string retorder, position, secuence, item, description, supplier, quantity, lot, dsca, STUN, waredesc; // decimal order_qty, pending_qty; ListItem itemS = null; itemS = new ListItem(); int rowIndex = 0; itemS.Text = _idioma == "INGLES" ? "-- Select an Position -- " : " -- Seleccione --"; itemS.Value = ""; dropDownPosition.Items.Clear(); dropDownPosition.Items.Insert(rowIndex, itemS); lblError.Text = ""; if (resultado.Rows.Count < 1) { //Purchase Order Return doesn´t exist lblError.Text = mensajes("PONotExists"); return; } else { tblReturnInfo.Visible = true; /* * select pur401.t$orno "ret_order", pur401.t$pono "position", pur401.t$sqnb "secuence", * pur401.t$oqua "order_qty", pur401.t$bqua "pending_qty", pur401.t$item "item", * ibd001.T$dsca "description", pur401.t$ddtb "date_pl_receive", inh210.t$oset "set", * ipu001.t$rtdp "datetol_max", ipu001.t$rtdm "datetol_min", ipu001.t$rtqp "qtytol_max", * ipu001.t$rtqm "qtytol_min", pur401.t$oltp "type", pur401.t$cwar "warehouse", * inh210.t$seqn "secuence", inh210.t$clot "lot", ibd001.t$cuni "unit", * pur400.t$cotp "currency", pur401.t$otbp "supplier", com100.t$nama "name" */ DataRow dr = resultado.Rows[0]; retorder = dr.ItemArray[0].ToString(); position = dr.ItemArray[1].ToString(); secuence = dr.ItemArray[2].ToString(); // order_qty = dr.ItemArray[3].ToString(); // pending_qty = dr.ItemArray[4].ToString(); item = dr.ItemArray[5].ToString(); description = dr.ItemArray[6].ToString(); supplier = dr.ItemArray[19].ToString(); lot = dr.ItemArray[16].ToString(); STUN = dr.ItemArray[17].ToString(); //lblItemValue.Text = item; //lblItemDescValue.Text = description; lblSupplierValue.Text = supplier; lblreturnorderValue.Text = retorder; lblstun.Value = STUN; //lblUnitValue.Text = unit; lbllotValue.Text = lot; grdRecords.DataSource = resultado; grdRecords.DataBind(); grdRecords.Visible = true; itemS = new ListItem(); // rowIndex = (int)resultado.Rows.IndexOf(dr); //itemS.DataSource = resultado; //itemS.Value = position; //itemS.Text = position; //dropDownPosition.Items.Insert(rowIndex + 1, itemS); DropDownList listregrind = (DropDownList)dropDownPosition; listregrind.DataSource = resultado; listregrind.DataTextField = "position"; listregrind.DataValueField = "position"; listregrind.DataBind(); listregrind.Items.Insert(0, new ListItem(_idioma == "INGLES" ? "Select Item here..." : "Seleccione un articulo...", string.Empty)); //btnSave.Visible = true; } }
public static string vallidatePalletID(string palletID, string position, string returnOrder) { InterfazDAL_tticol125 idal = new InterfazDAL_tticol125(); Ent_tticol125 obj = new Ent_tticol125(); string strError = string.Empty; string retorno = string.Empty; //TextBox quantity = (TextBox)e.Row.Cells[10].FindControl("palletId"); obj.paid = palletID.Trim().ToUpperInvariant(); DataTable resultado = idal.vallidatePalletData(ref obj, ref strError); //decimal palletQuantity = 0; //decimal status; //string tableName = string.Empty; //decimal givenQuantity = Convert.ToDecimal(quantity); /* select col131.t$paid "palletid", col131.t$loaa "current_location", * col131.t$qtya "current_qty", col131.t$item "item", ibd001.t$dsca "description"*/ string item, description, palletid, current_location, unit, war, stat; decimal current_qty; if (resultado.Rows.Count < 1) { return(null); } else { foreach (DataRow dr in resultado.Rows) { palletid = dr.ItemArray[0].ToString(); current_location = dr.ItemArray[1].ToString(); current_qty = Convert.ToDecimal(dr.ItemArray[2].ToString()); item = dr.ItemArray[3].ToString(); description = dr.ItemArray[4].ToString(); unit = dr.ItemArray[5].ToString(); war = dr.ItemArray[6].ToString(); stat = dr.ItemArray[7].ToString(); // lblItemValue.Text = item; //lblItemDescValue.Text = description; //lblUnitValue.Text = unit; //lbllotValue.Text = lot; string warehouse, itemcode; decimal qty; InterfazDAL_twhcol130 idal2 = new InterfazDAL_twhcol130(); DataTable resultado1 = idal2.vallidatePurchaseOrderWithPosition(ref returnOrder, ref position, ref strError); if (resultado1.Rows.Count < 1) { return(null); } else { foreach (DataRow dr1 in resultado1.Rows) { itemcode = dr1.ItemArray[0].ToString(); warehouse = dr1.ItemArray[1].ToString(); qty = Convert.ToDecimal(dr1.ItemArray[2].ToString()); if (warehouse.Trim() != war.Trim()) { return(PalletWarehousedoesnotmatch); } if (itemcode.Trim() != item.Trim()) { return(PalletItemcodedoesnotmatch); } if (current_qty < qty) { return(ActualquantitypalletIDequalorlessthanorderedquantity ); } } } } return(JsonConvert.SerializeObject(resultado)); } }