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));
}
