public static bool saveOriginTable(Ent_twhcol028 twhcol028) { Ent_twhcol130131 MyOriginalPallet = (Ent_twhcol130131)HttpContext.Current.Session["MyOriginalPallet"]; bool ActalizacionExitosa = false; Ent_tticol082 MyObj82 = new Ent_tticol082(); MyObj82.PAID = twhcol028.PAID; MyObj82.STAT = "14"; MyObj82.QTYC = "0"; switch (MyOriginalPallet.TBL) { case "ticol022": twhcolDAL.ActCausalTICOL022(MyObj82.PAID,14); ActalizacionExitosa = Itticol082.Actualizartticol222Cant(MyObj82); break; case "ticol042": twhcolDAL.ActCausalTICOL042(MyObj82.PAID,14); ActalizacionExitosa = Itticol082.Actualizartticol242Cant(MyObj82); break; case "whcol131": twhcolDAL.ActCausalcol131140(MyObj82.PAID,5); ActalizacionExitosa = Itticol082.Actualizartwhcol131Cant(MyObj82); break; case "whcol130": twhcolDAL.ActCausalcol131140(MyObj82.PAID,5); ActalizacionExitosa = Itticol082.Actualizartwhcol131Cant(MyObj82); break; } return(ActalizacionExitosa); }
public bool Actualizartticol242Cant(Ent_tticol082 myObj) { method = MethodBase.GetCurrentMethod(); bool retorno = false; string strError = string.Empty; try { paramList = new Dictionary <string, object>(); paramList.Add(":PAID", myObj.PAID); paramList.Add(":QTYA", myObj.QTYC); strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList); retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("Text", strSentencia, ref parametersOut, null, false); } catch (Exception ex) { strError = ex.InnerException != null ? ex.Message + " (" + ex.InnerException + ")" : ex.Message; } return(retorno); }
public bool InsertarregistroItticol093(Ent_tticol082 Objtticol082) { method = MethodBase.GetCurrentMethod(); bool retorno = false; string strError = string.Empty; try { paramList = new Dictionary <string, object>(); paramList.Add(":T$OORG", Objtticol082.OORG); paramList.Add(":T$ORNO", Objtticol082.ORNO); paramList.Add(":T$OSET", Objtticol082.OSET); paramList.Add(":T$PONO", Objtticol082.PONO); paramList.Add(":T$SEQN", Objtticol082.SQNB); paramList.Add(":T$ADVS", Objtticol082.ADVS); paramList.Add(":T$LOGN", Objtticol082.LOGN); paramList.Add(":T$PRIO", Objtticol082.PRIO); paramList.Add(":T$PRIT", Objtticol082.PRIT); strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList); return(DAL.BaseDAL.BaseDal.EjecutarCrud("Text", strSentencia, ref parametersOut, null, false)); } catch (Exception ex) { strError = ex.InnerException != null ? ex.Message + " (" + ex.InnerException + ")" : ex.Message; } return(retorno); }
public static DataTable getNextPrio(string PRIO) { Ent_tticol082 MyObj082 = new Ent_tticol082(); MyObj082.PRIO = PRIO; DataTable dtMachine = _idalticol082.getNextPrio(MyObj082); return(dtMachine); }
public static bool UpdatePrio(string PRIO, string PICK) { Ent_tticol082 MyObj082 = new Ent_tticol082(); MyObj082.PRIO = PRIO; MyObj082.PICK = PICK; List <Ent_tticol082> lstPicks = new List <Ent_tticol082>(); return(_idalticol082.UpdatePrio(MyObj082)); }
public static string SearchPickID(string PickID) { List <Ent_tticol082> lsttticol082 = new List <Ent_tticol082>(); DataTable TableItticol082 = Itticol082.ConsultarPalletID_x_Picking(PickID); string ObjRetorno = string.Empty; if (ExistenciaData(TableItticol082)) { DataRow myObjDt = TableItticol082.Rows[0]; if (MyObj.STAT == "4") { MyObj.Error = true; ObjRetorno = JsonConvert.SerializeObject(MyObj); } if (myObjDt["STAP"].ToString() == "6") { MyObj.Error = true; MyObj.TipeMsgJs = "lbl"; MyObj.ErrorMsg = ThePickIDAlreadyDrop; ObjRetorno = JsonConvert.SerializeObject(MyObj); } else { foreach (DataRow row in TableItticol082.Rows) { Ent_tticol082 MyObj2 = new Ent_tticol082(); MyObj2.TBL = row["TBL"].ToString(); MyObj2.PAID = row["PAID"].ToString(); MyObj2.QTYT = row["QTYT"].ToString(); MyObj2.UNIT = row["UNIT"].ToString(); MyObj2.ITEM = row["ITEM"].ToString(); MyObj2.DSCA = row["DSCA"].ToString(); MyObj2.MCNO = row["MCNO"].ToString(); MyObj2.DSCAM = row["DSCAM"].ToString(); MyObj2.ORNO = row["ORNO"].ToString(); MyObj2.STAT = row["STAT"].ToString(); MyObj2.CWAR = row["CWAR"].ToString(); MyObj2.Error = false; lsttticol082.Add(MyObj2); ObjRetorno = JsonConvert.SerializeObject(lsttticol082); } } } else { MyObj.Error = true; MyObj.TipeMsgJs = "lbl"; MyObj.ErrorMsg = ThePickIDDoesntexist; ObjRetorno = JsonConvert.SerializeObject(MyObj); } return(ObjRetorno); }
public bool UpdateTtico082StatEndPicking(Ent_tticol082 Obj082, String Random) { string strError = string.Empty; try { return(dal.UpdateTtico082StatEndPicking(Obj082, Random)); } catch (Exception ex) { throw new Exception(strError += "\nError: " + ex.Message); } }
//JC 260921 Ajustar informacion pallet cuando se cambia el pallet public bool UpdateTtico082Stat_CambioPallet(Ent_tticol082 Obj082) { string strError = string.Empty; try { return(dal.UpdateTtico082Stat_CambioPallet(Obj082)); } catch (Exception ex) { throw new Exception(strError += "\nError: " + ex.Message); } }
public static bool ExistPrio(string PRIO) { bool ret = false; Ent_tticol082 MyObj082 = new Ent_tticol082(); MyObj082.PRIO = PRIO; DataTable dtMachine = _idalticol082.ExistPrio(MyObj082); if (dtMachine.Rows.Count > 0) { ret = true; } return(ret); }
public int UpdateTtico082(Ent_tticol082 myObj82) { string strError = string.Empty; try { int updateTticol082 = dal.UpdateTtico082(myObj82); return(updateTticol082); } catch (Exception ex) { throw new Exception(strError += "\nError: " + ex.Message); } }
public static string ClickSave(string LstJson) { List <Ent_tticol082> lstGuardar = JsonConvert.DeserializeObject <List <Ent_tticol082> >(LstJson); foreach (Ent_tticol082 item in lstGuardar) { item.LOGN = HttpContext.Current.Session["user"].ToString(); ListaRegistroCustomer = Itticol082.ConsultarTticol082PorPlantPono(plantGlobal, Convert.ToInt32(item.PRIT), item.ADVS); if (ListaRegistroCustomer.Rows.Count > 0) { foreach (DataRow itemDt in ListaRegistroCustomer.Rows) { Ent_tticol082 obj82 = new Ent_tticol082(); obj82.OORG = itemDt["OORG"].ToString(); obj82.ORNO = itemDt["ORNO"].ToString(); //obj82.OSET = itemDt["OSET"].ToString(); obj82.PONO = itemDt["PONO"].ToString(); //obj82.SQNB = itemDt["SQNB"].ToString(); obj82.ADVS = itemDt["ADVS"].ToString(); obj82.ITEM = itemDt["ITEM"].ToString(); obj82.STAT = itemDt["STAT"].ToString(); obj82.QTYT = itemDt["QTYT"].ToString(); obj82.CWAR = itemDt["CWAR"].ToString(); obj82.UNIT = itemDt["UNIT"].ToString(); obj82.PRIT = (Convert.ToInt32(itemDt["PRIO"]) + 1).ToString(); obj82.TIME = itemDt["TIME"].ToString(); Itticol082.ActualizarPrioridadTticol082(obj82); Itticol082.InsertarregistroItticol093(obj82); } } bool Upt082 = Itticol082.ActualizarPrioridadTticol082(item); Itticol082.InsertarregistroItticol093(item); } return("{www:'1221'}"); }
public static void actualizarTablas(Ent_tticol082 MyObj) { bool ActalizacionExitosa = false; switch (MyObj.TBL) { case "ticol022": ActalizacionExitosa = Itticol082.Actualizartticol022STAT(MyObj); break; case "whcol130": ActalizacionExitosa = Itticol082.Actualizartwhcol130STAT(MyObj); break; case "whcol131": ActalizacionExitosa = Itticol082.Actualizartwhcol131STAT(MyObj); break; case "ticol042": ActalizacionExitosa = Itticol082.Actualizartticol042STAT(MyObj); break; } }
public static string GetPicks(string MCNO) { Ent_tticol082 MyObj082 = new Ent_tticol082(); MyObj082.MCNO = MCNO; List <Ent_tticol082> lstPicks = new List <Ent_tticol082>(); DataTable dtMachine = _idalticol082.GetPicks(MyObj082); if (dtMachine.Rows.Count > 0) { foreach (DataRow dtRow in dtMachine.Rows) { Ent_tticol082 tticol082 = new Ent_tticol082(); tticol082.PICK = dtRow["PICK"].ToString(); tticol082.MCNO = dtRow["MCNO"].ToString(); tticol082.ORNO = dtRow["ORNO"].ToString(); //tticol082.TIME = dtRow["TIME"].ToString(); tticol082.PRIO = dtRow["PRIO"].ToString(); lstPicks.Add(tticol082); } } return(JsonConvert.SerializeObject(lstPicks)); }
public bool ActualizarPrioridadTticol082(Ent_tticol082 Objtticol082) { method = MethodBase.GetCurrentMethod(); bool retorno = false; string strError = string.Empty; try { paramList = new Dictionary <string, object>(); paramList.Add(":T$OORG", Objtticol082.OORG); paramList.Add(":T$ORNO", Objtticol082.ORNO); paramList.Add(":T$OSET", Objtticol082.OSET); paramList.Add(":T$PONO", Objtticol082.PONO); paramList.Add(":T$SQNB", Objtticol082.SQNB); paramList.Add(":T$ADVS", Objtticol082.ADVS); paramList.Add(":T$ITEM", Objtticol082.ITEM); paramList.Add(":T$STAT", Objtticol082.STAT); paramList.Add(":T$QTYT", Objtticol082.QTYT); paramList.Add(":T$CWAR", Objtticol082.CWAR); paramList.Add(":T$UNIT", Objtticol082.UNIT); paramList.Add(":T$PRIO", Objtticol082.PRIT); paramList.Add(":T$TIME", Objtticol082.TIME); strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList); return(DAL.BaseDAL.BaseDal.EjecutarCrud("Text", strSentencia, ref parametersOut, null, false)); } catch (Exception ex) { strError = ex.InnerException != null ? ex.Message + " (" + ex.InnerException + ")" : ex.Message; } return(retorno); }
public static void actualizarTablasCant(Ent_tticol082 MyObj) { bool ActalizacionExitosa = false; switch (HttpContext.Current.Session["TBL"].ToString().Trim()) { case "ticol022": Itticol082.Actualizartticol222Cant(MyObj); break; case "whcol130": Itticol082.Actualizartwhcol130Cant(MyObj); break; case "whcol131": Itticol082.Actualizartwhcol131Cant(MyObj); break; case "ticol042": Itticol082.Actualizartticol242Cant(MyObj); break; } }
public bool Actualizartwhcol131(Ent_tticol082 myObj) { return(dal.Actualizartwhcol131(myObj)); }
public bool Actualizartticol242(Ent_tticol082 myObj) { return(dal.Actualizartticol242(myObj)); }
public bool InsertarregistroItticol082(Ent_tticol082 myObj) { return(dal.InsertarregistroItticol082(myObj)); }
public bool ActualizarPrioridadTticol082(Ent_tticol082 myObj) { return(dal.ActualizarPrioridadTticol082(myObj)); }
public bool Actualizartticol042STAT(Ent_tticol082 myObj) { return(dal.Actualizartticol042STAT(myObj)); }
public bool Actualizartticol242MFG(Ent_tticol082 MyObj) { return(dal.Actualizartticol222MFG(MyObj)); }
public bool Actualizartwhcol130(Ent_tticol082 MyObj) { return(dal.Actualizartwhcol130(MyObj)); }
public static string ClickDropTagPick(string PalletID) { DataTable TableItticol082 = Itticol082.ConsultarPalletIDTticol082(PalletID); string ObjRetorno = string.Empty; if (ExistenciaData(TableItticol082)) { DataRow myObjDt = TableItticol082.Rows[0]; Ent_tticol082 MyObj = new Ent_tticol082 { TBL = myObjDt["TBL"].ToString(), PAID = myObjDt["PAID"].ToString(), QTYT = myObjDt["QTYT"].ToString(), UNIT = myObjDt["UNIT"].ToString(), ITEM = myObjDt["ITEM"].ToString(), DSCA = myObjDt["DSCA"].ToString(), PRIO = myObjDt["PRIO"].ToString(), ADVS = myObjDt["ADVS"].ToString(), PONO = myObjDt["PONO"].ToString(), ORNO = myObjDt["ORNO"].ToString(), QTYC = myObjDt["QTYA"].ToString() }; bool ActalizacionExitosa = false; switch (MyObj.TBL) { case "ticol022": Itwhcol130.Eliminartccol307(MyObj.PAID, ""); Itticol082.Actualizartticol082(MyObj); if (MyObj.QTYC.Trim() == "0") { ActalizacionExitosa = Itticol082.Actualizartticol022(MyObj); } else { ActalizacionExitosa = false; } break; //case "ticol222": // Itwhcol130.Eliminartccol307(MyObj.PAID, ""); // Itticol082.Actualizartticol082(MyObj); // Itticol082.Actualizartticol022(MyObj); // ActalizacionExitosa = Itticol082.Actualizartticol222(MyObj); // break; //case "ticol242": // Itwhcol130.Eliminartccol307(MyObj.PAID, ""); // Itticol082.Actualizartticol082(MyObj); // Itticol082.Actualizartticol042(MyObj); // ActalizacionExitosa = Itticol082.Actualizartticol242(MyObj); // break; case "whcol131": Itwhcol130.Eliminartccol307(MyObj.PAID, ""); Itticol082.Actualizartticol082(MyObj); if (MyObj.QTYC.Trim() == "0") { ActalizacionExitosa = Itticol082.Actualizartwhcol131(MyObj); } else { ActalizacionExitosa = false; } break; case "whcol130": Itwhcol130.Eliminartccol307(MyObj.PAID, ""); Itticol082.Actualizartticol082(MyObj); if (MyObj.QTYC.Trim() == "0") { ActalizacionExitosa = Itticol082.Actualizartwhcol130(MyObj); } else { ActalizacionExitosa = false; } break; case "ticol042": Itwhcol130.Eliminartccol307(MyObj.PAID, ""); Itticol082.Actualizartticol082(MyObj); if (MyObj.QTYC.Trim() == "0") { ActalizacionExitosa = Itticol082.Actualizartticol042(MyObj); } else { ActalizacionExitosa = false; } break; } if (ActalizacionExitosa) { MyObj.Error = false; MyObj.TipeMsgJs = "alert"; MyObj.SuccessMsg = Thedropprocessissuccess; ObjRetorno = JsonConvert.SerializeObject(MyObj); } else if (MyObj.QTYC.Trim() != "0") { MyObj.Error = false; MyObj.TipeMsgJs = "alert"; MyObj.SuccessMsg = Thedropprocessissuccess; ObjRetorno = JsonConvert.SerializeObject(MyObj); } else { MyObj.Error = true; MyObj.TipeMsgJs = "alert"; MyObj.ErrorMsg = Thedropprocessisnotsuccess; ObjRetorno = JsonConvert.SerializeObject(MyObj); } } else { Ent_tticol082 MyObj = new Ent_tticol082 { Error = true, TipeMsgJs = "alert", ErrorMsg = ThePalletIDDoesntexist }; ObjRetorno = JsonConvert.SerializeObject(MyObj); } return(ObjRetorno); }
public static void SavePrio(string PRIO, string PICK) { string prioUsing307 = string.Empty; bool ExistNewPrio = ExistPrio(PRIO); if (ExistNewPrio) { List <Ent_tticol082> lstUpdatePicks = new List <Ent_tticol082>(); Ent_tticol082 MyObj082Last = new Ent_tticol082(); DataTable nextsPrios = getNextPrio(PRIO); foreach (DataRow item in nextsPrios.Rows) { Ent_tticol082 MyObj082 = new Ent_tticol082(); MyObj082.PICK = item["PICK"].ToString(); MyObj082.PRIO = item["PRIO"].ToString(); MyObj082.PAID = item["PAID"].ToString(); MyObj082.OLDP = item["PRIO"].ToString(); if (lstUpdatePicks.Count == 0) { lstUpdatePicks.Add(MyObj082); MyObj082Last = MyObj082; } else { if (Convert.ToInt32(MyObj082Last.PRIO) + 1 == Convert.ToInt32(MyObj082.PRIO)) { lstUpdatePicks.Add(MyObj082); MyObj082Last = MyObj082; } else { break; } } } if (lstUpdatePicks.Count > 0) { for (int i = (lstUpdatePicks.Count - 1); i >= 0; i--) { if (lstUpdatePicks[i].PAID == string.Empty) { if (prioUsing307 == string.Empty) { UpdatePrio((Convert.ToInt32(lstUpdatePicks[i].PRIO) + 1).ToString(), lstUpdatePicks[i].PICK); } else { UpdatePrio((Convert.ToInt32(prioUsing307) + 1).ToString(), lstUpdatePicks[i].PICK); prioUsing307 = string.Empty; } } else { if (prioUsing307 == string.Empty) { prioUsing307 = lstUpdatePicks[i].PRIO; } } } if (prioUsing307 == string.Empty) { UpdatePrio(PRIO, PICK); } } } else { UpdatePrio(PRIO, PICK); } }
public static string Click_Save(string PDNO, string ITEM, string CLOT, string QTYS, string UNIT) { Ent_tticol080 MyObj = new Ent_tticol080(); string strError = string.Empty; string myPdno = PDNO.ToUpper().Trim(); string myItem = ITEM.ToUpper().Trim(); //if (Convert.ToDecimal(HttpContext.Current.Session["QTYC"].ToString().Trim()) < Convert.ToDecimal(QTYS.Trim())) //{ // MyObj.Error = true; // MyObj.TypeMsgJs = "label"; // MyObj.ErrorMsg = QuantitymustbelowerthanPalletIDquantity; // return JsonConvert.SerializeObject(MyObj); //} DataTable dtTticst001 = ITticst001.findByItemAndPdno(ref myPdno, ref myItem, ref strError); if (dtTticst001.Rows.Count > 0) { HttpContext.Current.Session["PONO"] = dtTticst001.Rows[0]["PONO"].ToString(); HttpContext.Current.Session["CWAR"] = dtTticst001.Rows[0]["CWAR"].ToString(); } else { MyObj.Error = true; MyObj.TypeMsgJs = "alert"; MyObj.ErrorMsg = doesnotexistaregisterwithItemassociatedtopalletIDandWorkOrder; return(JsonConvert.SerializeObject(MyObj)); } string strTagId = string.Empty; List <Ent_tticol080> lstTticol080 = new List <Ent_tticol080>(); MyObj.orno = PDNO.ToUpper().Trim(); MyObj.pono = Convert.ToInt32(HttpContext.Current.Session["PONO"].ToString().Trim()); // VARIABLE GLOBAL MyObj.item = ITEM.ToUpper().Trim(); MyObj.cwar = HttpContext.Current.Session["CWAR"].ToString().ToUpper(); //VARIABLE GLOBAL //MyObj.qune = Convert.ToDecimal(QTYS); MyObj.qune = Convert.ToDecimal(QTYS); MyObj.logn = HttpContext.Current.Session["user"].ToString(); MyObj.date = ""; MyObj.proc = 2; MyObj.refcntu = 0; MyObj.refcntd = 0; MyObj.clot = CLOT.ToUpper().Trim() == string.Empty ? " " : CLOT.ToUpper().Trim(); MyObj.oorg = "4"; MyObj.pick = 0; lstTticol080.Add(MyObj); string ORNO = MyObj.orno.ToString(); string PONO = MyObj.pono.ToString(); string ITEMN = MyObj.item.ToString(); DataTable dtTticol080 = Tticol080.findRecordByOrnoPonoItem(ref ORNO, ref PONO, ref ITEMN, ref strError); if (dtTticol080.Rows.Count > 0) { int res = Tticol080.actualizarRegistro_Param(ref lstTticol080, ref strError, ref strTagId); if (res == 1) { MyObj.Error = false; MyObj.TypeMsgJs = "alert"; MyObj.SuccessMsg = Updatesuccess; //if ((Convert.ToDecimal(HttpContext.Current.Session["QTYC"].ToString()) - Convert.ToDecimal(QTYS.Trim())) == 0) //{ actualizarTablas(MyObj); Ent_tticol082 ObjTticol082 = new Ent_tticol082(); ObjTticol082.PAID = HttpContext.Current.Session["PAID"].ToString().Trim().ToUpper(); ObjTticol082.QTYC = (Convert.ToDecimal(HttpContext.Current.Session["QTYC"].ToString()) - Convert.ToDecimal(QTYS.Trim())).ToString(); actualizarTablasCant(ObjTticol082); //} //else //{ // Ent_tticol082 ObjTticol082 = new Ent_tticol082(); // ObjTticol082.PAID = HttpContext.Current.Session["PAID"].ToString().Trim().ToUpper(); // ObjTticol082.QTYC = (Convert.ToDecimal(HttpContext.Current.Session["QTYC"].ToString()) - Convert.ToDecimal(QTYS.Trim())).ToString(); // actualizarTablasCant(ObjTticol082); //} } else { MyObj.Error = true; MyObj.TypeMsgJs = "alert"; MyObj.ErrorMsg = Updatefail; } } else { int res = Tticol080.insertarRegistro(ref lstTticol080, ref strError, ref strTagId); if (res == 1) { MyObj.Error = false; MyObj.TypeMsgJs = "label"; MyObj.SuccessMsg = Insertsuccess; //if ((Convert.ToDecimal(HttpContext.Current.Session["QTYC"].ToString()) - Convert.ToDecimal(QTYS.Trim())) == 0) //{ actualizarTablas(MyObj); Ent_tticol082 ObjTticol082 = new Ent_tticol082(); ObjTticol082.PAID = HttpContext.Current.Session["PAID"].ToString().Trim().ToUpper(); ObjTticol082.QTYC = (Convert.ToDecimal(HttpContext.Current.Session["QTYC"].ToString()) - Convert.ToDecimal(QTYS.Trim())).ToString(); actualizarTablasCant(ObjTticol082); //} //else //{ // Ent_tticol082 ObjTticol082 = new Ent_tticol082(); // ObjTticol082.PAID = HttpContext.Current.Session["PAID"].ToString().Trim().ToUpper(); // ObjTticol082.QTYC = (Convert.ToDecimal(HttpContext.Current.Session["QTYC"].ToString()) - Convert.ToDecimal(QTYS.Trim())).ToString(); // actualizarTablasCant(ObjTticol082); //} } else { MyObj.Error = true; MyObj.TypeMsgJs = "alert"; MyObj.ErrorMsg = Insertfail; } } return(JsonConvert.SerializeObject(MyObj)); }
protected void btnSave_Click(object sender, EventArgs e) { txtAdjustmentQuantity.Text = txtAdjustmentQuantity.Text.Trim() == string.Empty ? "0" : txtAdjustmentQuantity.Text.Trim(); string inputQtyStr = txtAdjustmentQuantity.Text; decimal inputQty; if (inputQtyStr.Contains(".")) { inputQty = Convert.ToDecimal(inputQtyStr); if (!inputQty.ToString().Contains(".")) { inputQty = Convert.ToDecimal(ReplaceDecimal(inputQtyStr)); } } else if (inputQtyStr.Contains(",")) { inputQty = Convert.ToDecimal(inputQtyStr); if (!inputQty.ToString().Contains(",")) { inputQty = Convert.ToDecimal(ReplaceDecimal(inputQtyStr)); } } else { inputQty = Convert.ToDecimal(inputQtyStr); } if (inputQty < 0) { lblError.Text = ""; lblError.Text = Adjustmentquantitycannotbezero; txtPalletId.Enabled = true; txtPalletId.Text = String.Empty; btnSend.Visible = true; tblPalletInfo.Visible = true; btnSave.Visible = true; txtAdjustmentQuantity.Text = ""; txtAdjustmentQuantity.Focus(); return; } else { if (lblQuantityValue.Text.Trim() != "0") { if (inputQty > (Convert.ToDecimal(lblQuantityValue.Text) * 2)) { lblError.Text = "New quantity not allowed, máximum double”"; txtPalletId.Enabled = true; btnSave.Visible = true; tblPalletInfo.Visible = true; btnSave.Visible = true; txtAdjustmentQuantity.Text = ""; txtAdjustmentQuantity.Focus(); return; } } } //if (Convert.ToInt32(txtAdjustmentQuantity.Text.Trim()) > Convert.ToInt32(lblQuantityValue.Text.Trim())) //{ // lblError.Text = AdjustmentquantityshouldbelessthanexistingQty; // txtPalletId.Enabled = true; // txtPalletId.Text = String.Empty; // btnSend.Visible = true; // return; //} InterfazDAL_twhcol025 idal = new InterfazDAL_twhcol025(); string strError = string.Empty; List<Ent_twhcol025> parameterCollection025 = new List<Ent_twhcol025>(); //T$PAID, T$ITEM, T$LOCA, T$CLOT, T$QTYA, T$UNIT, T$DATE, T$LOGN, T$EMNO, T$PROC, T$REFCNTD,T$REFCNTU string PAID = txtPalletId.Text.ToUpperInvariant().Trim(); int consecutivoPalletID = 0; string strMaxSequence = getSequence(PAID, "A"); string separator = "-"; string newPallet = recursos.GenerateNewPallet(strMaxSequence, separator); string SQNB = PAID.Substring(0, PAID.IndexOf(separator)); Ent_tticol082 MyObj82 = new Ent_tticol082(); MyObj82.PAID = PAID; MyObj82.QTYC = "0"; obj.PAID = PAID; obj.ITEM = lblItemValue.Text.Trim().ToUpper(); //obj.LOCA = lblLocationValue.Text.Trim().ToUpper(); obj.CWAR = lblWarehouseValue.Text; obj.LOCA = lblLocationValue.Text; obj.CLOT = lblLotValue.Text; obj.QTYA = Convert.ToDouble(inputQty) - Pquantity; obj.UNIT = lblUnitValue.Text.Trim(); obj.LOGN = Session["user"].ToString(); ; //obj.CDIS = dropDownReasonCodes.SelectedItem.Value; //obj.EMNO = dropDownCostCenters.SelectedItem.Value; //JC 280921 Evitar que tome los valores por defecto de la variable de session //obj.CDIS = Session["cdis"].ToString(); //obj.EMNO = Session["emno"].ToString(); obj.CDIS = dropDownReasonCodes.SelectedValue; obj.EMNO = dropDownCostCenters.SelectedValue; obj.PROC = 2; obj.ORNO = " "; obj.PONO = Convert.ToInt32(HttpContext.Current.Session["pono"].ToString()); obj.MESS = " "; obj.REFCNTD = 0; obj.REFCNTU = 0; parameterCollection025.Add(obj); var validSave = idal.insertRegistrItemAdjustment(ref parameterCollection025, ref strError); if (validSave > 0) { if (Convert.ToInt32(HttpContext.Current.Session["flag022"].ToString().Trim()) == 1) { twhcolDAL.ActCausalTICOL022(PAID, 14); Ent_tticol022 MyObj = new Ent_tticol022(); MyObj.pdno = obj.CLOT; MyObj.sqnb = newPallet; MyObj.proc = 2; MyObj.logn = HttpContext.Current.Session["user"].ToString().Trim(); MyObj.mitm = obj.ITEM.Trim(); MyObj.qtdl = Convert.ToDecimal(inputQty); MyObj.cuni = obj.UNIT;//CUNI; MyObj.log1 = "NONE"; MyObj.qtd1 = Convert.ToInt32(inputQty); MyObj.pro1 = 2; MyObj.log2 = "NONE"; MyObj.qtd2 = Convert.ToInt32(inputQty); MyObj.pro2 = 2; MyObj.loca = obj.LOCA; MyObj.norp = 1; MyObj.dele = 7; MyObj.logd = "NONE"; MyObj.refcntd = 0; MyObj.refcntu = 0; MyObj.drpt = DateTime.Now; MyObj.urpt = HttpContext.Current.Session["user"].ToString().Trim(); MyObj.acqt = Convert.ToDecimal(inputQty); MyObj.cwaf = obj.CWAR;//CWAR; MyObj.cwat = obj.CWAR;//CWAR; MyObj.aclo = obj.LOCA; MyObj.allo = 0;// Convert.ToDecimal(txtAdjustmentQuantity.Text.Trim()); ; var validateSave = _idaltticol022.insertarRegistroSimple(ref MyObj, ref strError); var validateSaveTicol222 = _idaltticol022.InsertarRegistroTicol222(ref MyObj, ref strError); var ActalizacionExitosa = Itticol082.Actualizartticol222Cant(MyObj82); } else if (Convert.ToInt32(HttpContext.Current.Session["flag042"].ToString().Trim()) == 1) { twhcolDAL.ActCausalTICOL042(PAID, 14); Ent_tticol042 MyObj = new Ent_tticol042(); MyObj.pdno = obj.CLOT; MyObj.sqnb = newPallet; MyObj.proc = 2; MyObj.logn = HttpContext.Current.Session["user"].ToString().Trim(); MyObj.mitm = obj.ITEM.Trim(); MyObj.qtdl = Convert.ToDouble(inputQty); MyObj.cuni = obj.UNIT;//CUNI; MyObj.log1 = "NONE"; MyObj.qtd1 = Convert.ToDecimal(inputQty); MyObj.pro1 = 2; MyObj.log2 = "NONE"; MyObj.qtd2 = Convert.ToDecimal(inputQty); MyObj.pro2 = 2; MyObj.loca = obj.LOCA; MyObj.norp = 1; MyObj.dele = 7; MyObj.logd = "NONE"; MyObj.refcntd = 0; MyObj.refcntu = 0; MyObj.drpt = DateTime.Now; MyObj.urpt = HttpContext.Current.Session["user"].ToString().Trim(); MyObj.acqt = Convert.ToDouble(inputQty); MyObj.cwaf = obj.CWAR;//CWAR; MyObj.cwat = obj.CWAR;//CWAR; MyObj.aclo = obj.LOCA; MyObj.allo = 0;// Convert.ToDecimal(txtAdjustmentQuantity.Text.Trim());//Convert.ToDecimal(qtyt_act.ToString()); var validateSave = _idaltticol042.insertarRegistroSimple(ref MyObj, ref strError); var validateSaveTicol242 = _idaltticol042.InsertarRegistroTicol242(ref MyObj, ref strError); var ActalizacionExitosa = Itticol082.Actualizartticol242Cant(MyObj82); } else if (Convert.ToInt32(HttpContext.Current.Session["flag131"].ToString().Trim()) == 1) { twhcolDAL.ActCausalcol131140(PAID, 5); Ent_twhcol130131 MyObj = new Ent_twhcol130131(); MyObj.OORG = "2";// Order type escaneada view MyObj.ORNO = newPallet.Substring(0, newPallet.IndexOf("-")); MyObj.ITEM = obj.ITEM.Trim(); MyObj.PAID = newPallet; MyObj.PONO = HttpContext.Current.Session["pono"].ToString(); MyObj.SEQN = "1"; MyObj.CLOT = obj.CLOT;//CLOT.ToUpper();// lote VIEW MyObj.CWAR = obj.CWAR;//CWAR.ToUpper(); MyObj.QTYS = inputQty.ToString();//QTYS;// cantidad escaneada view MyObj.UNIT = obj.UNIT;//UNIT;//unit escaneada view MyObj.QTYC = inputQty.ToString();//QTYS;//cantidad escaneada view aplicando factor MyObj.QTYA = inputQty.ToString();//QTYS;//cantidad escaneada view aplicando factor MyObj.UNIC = obj.UNIT;//UNIT;//unidad view stock MyObj.DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString();//fecha de confirmacion MyObj.CONF = "1"; MyObj.RCNO = " ";//llena baan MyObj.DATR = DateTime.Now.ToString("dd/MM/yyyy").ToString();//llena baan MyObj.LOCA = obj.LOCA;//LOCA.ToUpper();// enviamos vacio MyObj.DATL = DateTime.Now.ToString("dd/MM/yyyy").ToString();//llenar con fecha de hoy MyObj.PRNT = "1";// llenar en 1 MyObj.DATP = DateTime.Now.ToString("dd/MM/yyyy").ToString();//llena baan MyObj.NPRT = "1";//conteo de reimpresiones MyObj.LOGN = HttpContext.Current.Session["user"].ToString().Trim();// nombre de ususario de la session MyObj.LOGT = " ";//llena baan MyObj.STAT = "3";// LLENAR EN 3 MyObj.DSCA = " "; MyObj.COTP = " "; MyObj.FIRE = "2"; MyObj.PSLIP = " "; MyObj.ALLO = "0"; //txtAdjustmentQuantity.Text.Trim(); string StrError = string.Empty; bool Insertsucces = twhcol130DAL.Insertartwhcol131(MyObj, ref StrError); var ActalizacionExitosa = Itticol082.Actualizartwhcol131Cant(MyObj82); } lblError.Text = ""; lblConfirm.Text = mensajes("msjsave"); //divTable.Visible = false; lblitemDesc.Text = Transfers.DescripcionItem(obj.ITEM); ; lblWorkOrder.Text = obj.PAID.Substring(0, obj.PAID.IndexOf("-")); lblPalletNum.Text = newPallet.Substring(obj.PAID.IndexOf("-") + 1); lblInspector.Text = obj.LOGN; lblDate.Text = DateTime.Now.ToString("MM/dd/yyyy"); //lblShift.Text =Session["shif"].ToString(); lblQuantityL.Text = txtAdjustmentQuantity.Text.Trim() + " " + lblUnitValue.Text.Trim(); codeItem.ImageUrl = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + obj.ITEM.Trim() + "&code=Code128&dpi=96"; codePaid.ImageUrl = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + newPallet.Trim() + "&code=Code128&dpi=96"; divPrint.Visible = true; txtPalletId.Enabled = true; txtPalletId.Text = String.Empty; txtAdjustmentQuantity.Text = String.Empty; dropDownCostCenters.Items.Clear(); dropDownReasonCodes.Items.Clear(); lblCost.Text = string.Empty; lblReason.Text = string.Empty; btnSend.Visible = true; } else { lblConfirm.Text = ""; lblError.Text = mensajes("errorsave"); return; } }
public static string SearchPickID(string PickID, bool consigment = false) { bool consigmentPallets = false; bool noConsigmentPallets = false; HttpContext.Current.Session["consigment"] = consigment.ToString(); Ent_tticol082 MyObj = new Ent_tticol082(); //DataTable TableItticol082 = Itticol082.ConsultarPalletIDTticol082(PickID); DataTable TableItticol082 = Itticol082.ConsultarPalletIDTticol082PIckAbreb(PickID.Substring(0, PickID.IndexOf('-'))); string ObjRetorno = string.Empty; bool PalletAsignado = false; if (ExistenciaData(TableItticol082) && PalletAsignado == false) { //foreach (DataRow dr1 in TableItticol082.Rows) //{ foreach (DataRow myObjDt in TableItticol082.Rows) { MyObj.TBL = myObjDt["TBL"].ToString(); MyObj.QTYT = myObjDt["QTYT"].ToString(); MyObj.UNIT = myObjDt["UNIT"].ToString(); MyObj.ITEM = myObjDt["ITEM"].ToString(); MyObj.DSCA = myObjDt["DSCA"].ToString(); MyObj.MCNO = myObjDt["MCNO"].ToString(); MyObj.DSCAM = myObjDt["DSCAM"].ToString(); MyObj.ORNO = myObjDt["ORNO"].ToString(); MyObj.STAT = myObjDt["STAT"].ToString(); MyObj.STAP = myObjDt["STAP"].ToString(); MyObj.TYPW = myObjDt["TYPW"].ToString(); //JC 270721 Duplicar la sesion para que permita hacer drop de cualquier pick (consignacion y no consignacion //if (MyObj.TYPW == "21" && consigment == true) //{ // MyObj.PAID += myObjDt["PAID"].ToString().Trim() + ","; //} //else if (MyObj.TYPW == "1" && consigment == false) //{ // MyObj.PAID += myObjDt["PAID"].ToString().Trim() + ","; //} MyObj.PAID += myObjDt["PAID"].ToString().Trim() + ","; HttpContext.Current.Session["PAID"] = MyObj.PAID; HttpContext.Current.Session["MCNO"] = MyObj.MCNO; //if (MyObj.STAT == "2") //{ // MyObj.Error = true; // MyObj.TipeMsgJs = "alert"; // MyObj.ErrorMsg = StatusNotAllowed; // ObjRetorno = JsonConvert.SerializeObject(MyObj); //} //if (MyObj.TYPW == "1") //{ // MyObj.Error = true; // MyObj.TipeMsgJs = "alert"; // MyObj.ErrorMsg = WarehouseNotAllowed; // ObjRetorno = JsonConvert.SerializeObject(MyObj); //} //JC 270721 Duplicar la sesion para que permita hacer drop de cualquier pick (consignacion y no consignacion //if (MyObj.TYPW != "21") //{ // noConsigmentPallets = true; //} //else if (MyObj.TYPW != "1") //{ // consigmentPallets = true; //} } //if (consigment == true && consigmentPallets == false) //{ // MyObj.Error = true; // MyObj.TipeMsgJs = "alert"; // MyObj.ErrorMsg = Thepickdoesnothavewarehousesonconsignment; // ObjRetorno = JsonConvert.SerializeObject(MyObj); //} //else if (consigment == false && noConsigmentPallets == false) //{ // MyObj.Error = true; // MyObj.TipeMsgJs = "alert"; // MyObj.ErrorMsg = Thepickdoesnothavewarehouses; // ObjRetorno = JsonConvert.SerializeObject(MyObj); //} ObjRetorno = JsonConvert.SerializeObject(MyObj); } else if (PalletAsignado == false) { MyObj.Error = true; MyObj.TipeMsgJs = "alert"; MyObj.ErrorMsg = ThePalletIDDoesntexist; ObjRetorno = JsonConvert.SerializeObject(MyObj); } return(ObjRetorno); }
public static string ClickDropTagPick(string PickID) { Ent_tticol082 MyObj = new Ent_tticol082(); //DataTable TableItticol082 = Itticol082.ConsultarPalletIDTticol082(PickID); DataTable TableItticol082 = Itticol082.ConsultarPalletIDTticol082PIckAbreb(PickID.Substring(0, PickID.IndexOf('-'))); string ObjRetorno = string.Empty; bool ActalizacionExitosa = false; //JC 230721 Adicionar la generación del número aleatorio para asignarsela al pick int randomNum = new Random().Next(999); string ramdomNumStr = string.Empty; if (randomNum > 0 && randomNum < 10) { ramdomNumStr = "00" + randomNum.ToString(); } else if (randomNum > 9 && randomNum < 100) { ramdomNumStr = "0" + randomNum.ToString(); } else { ramdomNumStr = randomNum.ToString(); } if (ExistenciaData(TableItticol082)) { List <string> paids = new List <string>(); foreach (DataRow myObjDt in TableItticol082.Rows) { MyObj.TBL = myObjDt["TBL"].ToString(); MyObj.PAID = myObjDt["PAID"].ToString(); paids.Add(myObjDt["PAID"].ToString()); MyObj.QTYT = myObjDt["QTYT"].ToString(); MyObj.UNIT = myObjDt["UNIT"].ToString(); MyObj.ITEM = myObjDt["ITEM"].ToString(); MyObj.DSCA = myObjDt["DSCA"].ToString(); MyObj.PRIO = myObjDt["PRIO"].ToString(); MyObj.ADVS = myObjDt["ADVS"].ToString(); MyObj.PONO = myObjDt["PONO"].ToString(); MyObj.ORNO = myObjDt["ORNO"].ToString(); MyObj.QTYC = myObjDt["QTYA"].ToString(); MyObj.PICK = myObjDt["PICK"].ToString().Trim(); MyObj.TYPW = myObjDt["TYPW"].ToString(); MyObj.CWAR = myObjDt["CWAR"].ToString(); MyObj.STAT = myObjDt["STAT"].ToString(); MyObj.MCNO = HttpContext.Current.Session["MCNO"].ToString(); MyObj.PAIDS = paids; STATPICK = MyObj.STAT; //JC 230721 Cambio para que se envíe el dato con el numero aleatorio //MyObj.PICK_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + myObjDt["PICK"] + "&code=Code128&dpi=96"; //JC 270721 Quitar restricion de consignacion //if (HttpContext.Current.Session["consigment"].ToString().ToLower() == "true" && MyObj.TYPW == "21") if (MyObj.TYPW == "21") { //MyObj.STAT = MyObj.STAT.Trim() == "2" ? "7" : "4"; MyObj.STAT = "8"; //JC 230721 Cambio para que se envíe el dato con el numero aleatorio //JC 260721 Cambio para que cuando ya tenga el número aleatorio no le genere uno adicional if (STATPICK == "7") { MyObj.RAND = ""; Itticol082.Actualizartticol082SinRandom(MyObj); //JC 230721 Cambio para que se envíe el dato con el numero aleatorio MyObj.PICK_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.PICK + "&code=Code128&dpi=96"; } else { MyObj.RAND = ramdomNumStr; MyObj.STAT = "4"; MyObj.STATW = "8"; Itticol082.Actualizartticol082Pick(MyObj); //JC 230721 Cambio para que se envíe el dato con el numero aleatorio MyObj.PICK = MyObj.PICK + "-" + ramdomNumStr; MyObj.PICK_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.PICK + "&code=Code128&dpi=96"; } } //JC 270721 Quitar restricion de consignacion //else if (HttpContext.Current.Session["consigment"].ToString().ToLower() == "false" && MyObj.TYPW == "1") else if (MyObj.TYPW == "1") { MyObj.STAT = "4"; //JC 230721 Cambio para que se envíe el dato con el numero aleatorio MyObj.STATW = "8"; MyObj.RAND = ramdomNumStr; Itticol082.Actualizartticol082Pick(MyObj); //JC 230721 Cambio para que se envíe el dato con el numero aleatorio MyObj.PICK = MyObj.PICK + "-" + ramdomNumStr; MyObj.PICK_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.PICK + "&code=Code128&dpi=96"; } } if (MyObj.Error != true) { ActalizacionExitosa = true; } if (ActalizacionExitosa) { MyObj.Error = false; MyObj.TipeMsgJs = "alert"; MyObj.SuccessMsg = Thedropprocessissuccess; ObjRetorno = JsonConvert.SerializeObject(MyObj); } else { MyObj.Error = true; MyObj.TipeMsgJs = "alert"; MyObj.ErrorMsg = Thedropprocessisnotsuccess; ObjRetorno = JsonConvert.SerializeObject(MyObj); } } else { MyObj.Error = true; MyObj.TipeMsgJs = "alert"; MyObj.ErrorMsg = ThePalletIDDoesntexist; ObjRetorno = JsonConvert.SerializeObject(MyObj); } return(ObjRetorno); }
public DataTable Delete182(Ent_tticol082 Obj082) { return(dal.Delete182(Obj082)); }
public DataTable ConsultarPallet_X_Picking_Advs(Ent_tticol082 Obj082PPaid) { return(dal.ConsultarPallet_X_Picking_Advs(Obj082PPaid)); }