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 DataTable GetItemNetw(ref Ent_twhcol028 Parametros, ref string strError)
{
DataTable retorno;
try
{
retorno = dal.GetItemNetw(ref Parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
public bool insertRegistertwhcol028(ref Ent_twhcol028 Obj028, ref string strError)
{
bool retorno = false;
try
{
retorno = dal.insertRegistertwhcol028(ref Obj028, ref strError);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
return(retorno);
}
public bool insertRegistertwhcol028(ref Ent_twhcol028 Obj028, ref string strError)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
try
{
paramList = new Dictionary <string, object>();
paramList.Add(":T$PAID", Obj028.PAID.Trim().ToUpper());
paramList.Add(":T$CDIS", Obj028.CDIS.Trim().ToUpper());
paramList.Add(":T$EMNO", Obj028.EMNO.Trim().ToUpper());
paramList.Add(":T$SITM", Obj028.SITM.Trim().ToUpper());
paramList.Add(":T$SWAR", Obj028.SWAR.Trim().ToUpper());
paramList.Add(":T$SLOC", Obj028.SLOC.Trim().ToUpper().Trim() == string.Empty ? " ":Obj028.SLOC.Trim().ToUpper().Trim());
paramList.Add(":T$SLOT", Obj028.SLOT.Trim().ToUpper().Trim() == string.Empty ? " ":Obj028.SLOT.Trim().ToUpper().Trim());
paramList.Add(":T$SQTY",Obj028.SQTY.Trim().ToUpper());
paramList.Add(":T$TITM",Obj028.TITM.Trim().ToUpper());
paramList.Add(":T$TWAR",Obj028.TWAR.Trim().ToUpper());
paramList.Add(":T$TLOC",Obj028.TLOC.Trim().ToUpper().Trim() == string.Empty ? " ":Obj028.TLOC.Trim().ToUpper().Trim());
paramList.Add(":T$TLOT",Obj028.TLOT.Trim().ToUpper().Trim() == string.Empty ? " ":Obj028.TLOT.Trim().ToUpper().Trim());
paramList.Add(":T$TQTY",Obj028.TQTY.Trim().ToUpper());
paramList.Add(":T$LOGN",Obj028.LOGN.Trim().ToUpper() == string.Empty ? "0" : Obj028.LOGN.Trim().ToUpper());
paramList.Add(":T$DATR",Obj028.DATR.Trim().ToUpper() == string.Empty ? "0" : Obj028.DATR.Trim().ToUpper());
paramList.Add(":T$PROC",Obj028.PROC.Trim().ToUpper() == string.Empty ? "0" : Obj028.PROC.Trim().ToUpper());
paramList.Add(":T$SORN",Obj028.SORN.Trim().ToUpper() == string.Empty ? "0" : Obj028.SORN.Trim().ToUpper());
paramList.Add(":T$SPON",Obj028.SPON.Trim().ToUpper() == string.Empty ? "0" : Obj028.SPON.Trim().ToUpper());
paramList.Add(":T$TORN",Obj028.TORN.Trim().ToUpper() == string.Empty ? "0" : Obj028.TORN.Trim().ToUpper());
paramList.Add(":T$TPON",Obj028.TPON.Trim().ToUpper() == string.Empty ? "0" : Obj028.TPON.Trim().ToUpper());
paramList.Add(":T$MESS",Obj028.MESS.Trim().ToUpper() == string.Empty ? "0" : Obj028.MESS.Trim().ToUpper());
paramList.Add(":T$REFCNTD",Obj028.REFCNTD.Trim().ToUpper() == string.Empty ? "0" : Obj028.REFCNTD.Trim().ToUpper());
paramList.Add(":T$REFCNTU",Obj028.REFCNTD.Trim().ToUpper() == string.Empty ? "0" : Obj028.REFCNTD.Trim().ToUpper());
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);
return(retorno);
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
return(retorno);
}
private static bool UpdatePalletOriginTable(ref Ent_twhcol028 twhcol028)
{
bool res = false;
string separator = "-";
string SQNB = twhcol028.PAID.Substring(0,twhcol028.PAID.IndexOf(separator));
switch (HttpContext.Current.Session["TBL"].ToString())
{
case "ticol022":
Ent_tticol022 obj022 = new Ent_tticol022();
obj022.sqnb = twhcol028.PAID;
obj022.dele = 7;
obj022.cwaf = twhcol028.TWAR;
obj022.cwat = twhcol028.TWAR;
obj022.aclo = twhcol028.TLOC == string.Empty ? " " : twhcol028.TLOC;
res = dalticol100.updatetticol222(ref obj022,ref strError);
break;
case "ticol042":
Ent_tticol042 obj042 = new Ent_tticol042();
obj042.sqnb = twhcol028.PAID;
obj042.dele = 7;
obj042.cwaf = twhcol028.TWAR;
obj042.cwat = twhcol028.TWAR;
obj042.aclo = twhcol028.TLOC == string.Empty ? " " : twhcol028.TLOC;;
res = dalticol100.updatetticol242(ref obj042,ref strError);
break;
case "whcol131":
Ent_twhcol130131 MyObj131 = new Ent_twhcol130131();
MyObj131.PAID = twhcol028.PAID;
MyObj131.STAT = "3";
MyObj131.CWAR = twhcol028.TWAR;
MyObj131.LOCA = twhcol028.TLOC == string.Empty ? " " : twhcol028.TLOC;;
res = dalticol100.updatetwhcol131(ref MyObj131,ref strError);
break;
}
return(res);
}
//JC 210122 Buscar tipo Item
public DataTable GetItemType(ref Ent_twhcol028 Parametros,ref string strError)
{
method = MethodBase.GetCurrentMethod();
paramList = new Dictionary <string,object>();
paramList.Add("item",Parametros.TITM.Trim().ToUpper());
strSentencia = recursos.readStatement(method.ReflectedType.Name,method.Name,ref owner,ref env,tabla,paramList);
try
{
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text",strSentencia,ref parametersOut,null,true);
if (consulta.Rows.Count < 1)
{
strError = "Item code doesn´t exist. Cannot continue";
}
return(consulta);
}
catch (Exception ex)
{
log.escribirError(strError + Console.Out.NewLine + ex.Message,method.Module.Name,method.Name,method.ReflectedType.Name);
}
return(consulta);
}
private static bool saveNewPalletOriginTable(ref Ent_twhcol028 twhcol028,string MaxSequence)
{
bool res = false;
string separator = "-";
twhcol028.PAID = recursos.GenerateNewPallet(MaxSequence,separator);
string SQNB = twhcol028.PAID.Substring(0,twhcol028.PAID.IndexOf(separator));
twhcol028.LOGN = HttpContext.Current.Session["user"].ToString();
twhcol028.DATR = DateTime.Now.ToString("MM/dd/yyyy");
switch (HttpContext.Current.Session["TBL"].ToString())
{
case "ticol022":
Ent_tticol022 obj022 = new Ent_tticol022();
List <Ent_tticol022> list022 = new List <Ent_tticol022>();
twhcol028.WHLOT = twhcol028.TLOT.Trim() == string.Empty ? " " : twhcol028.TLOT.Trim();
obj022.pdno = SQNB;
obj022.sqnb = twhcol028.PAID;
obj022.proc = 1;
obj022.logn = twhcol028.LOGN;
obj022.mitm = twhcol028.TITM;
//JC 210122 Grabar la cantidad Correcta si es un regrind
//obj022.cuni = twhcol028.UNIT;
//obj022.qtdl = Convert.ToDecimal(twhcol028.TQTY);
if (twhcol028.TYPE == "RET")
{
obj022.cuni = twhcol028.UNRG;
obj022.qtdl = Math.Round(((Convert.ToDecimal(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462)),4);
obj022.qtd1 = Convert.ToInt32((Convert.ToInt32(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462));
obj022.qtd2 = Convert.ToInt32((Convert.ToInt32(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462));
obj022.acqt = Math.Round(((Convert.ToDecimal(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462)),4);
}
else
{
obj022.cuni = twhcol028.UNIT;
obj022.qtdl = Convert.ToDecimal(twhcol028.TQTY);
obj022.qtd1 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj022.qtd2 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj022.acqt = Convert.ToDecimal(twhcol028.TQTY);
}
obj022.log1 = "NONE";
//obj022.qtd1 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj022.pro1 = 1;
obj022.log2 = "NONE";
//obj022.qtd2 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj022.pro2 = 2;
obj022.loca = " ";
obj022.norp = 1;
obj022.dele = 7;
obj022.logd = "NONE";
obj022.refcntd = 0;
obj022.refcntu = 0;
obj022.drpt = DateTime.Now;
obj022.urpt = twhcol028.LOGN;
//obj022.acqt = Convert.ToDecimal(twhcol028.TQTY);
obj022.cwaf = twhcol028.TWAR;
obj022.cwat = twhcol028.TWAR;
obj022.aclo = twhcol028.SLOC;
obj022.allo = 0;
list022.Add(obj022);
bool insert022 = Convert.ToBoolean(_idaltticol022.insertarRegistroSimple(ref obj022,ref strError));
bool insert222 = Convert.ToBoolean(_idaltticol022.InsertarRegistroTicol222(ref obj022,ref strError));
res = (insert222 == true && insert022 == true) ? true : false;
break;
case "ticol042":
Ent_tticol042 obj042 = new Ent_tticol042();
List <Ent_tticol042> list042 = new List <Ent_tticol042>();
twhcol028.WHLOT = twhcol028.TLOT;
obj042.pdno = SQNB;
obj042.sqnb = twhcol028.PAID;
obj042.proc = 1;
obj042.logn = twhcol028.LOGN;
obj042.mitm = twhcol028.TITM;
obj042.qtdl = Convert.ToDouble(twhcol028.TQTY);
obj042.cuni = twhcol028.UNIT;
obj042.log1 = "NONE";
obj042.qtd1 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj042.pro1 = 1;
obj042.log2 = "NONE";
obj042.qtd2 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj042.pro2 = 2;
obj042.loca = " ";
obj042.norp = 1;
obj042.dele = 7;
obj042.logd = "NONE";
obj042.refcntd = 0;
obj042.refcntu = 0;
obj042.drpt = DateTime.Now;
obj042.urpt = twhcol028.LOGN;
obj042.acqt = Convert.ToDouble(twhcol028.TQTY);
obj042.cwaf = twhcol028.TWAR;
obj042.cwat = twhcol028.TWAR;
obj042.aclo = twhcol028.SLOC;
obj042.allo = 0;
list042.Add(obj042);
bool insert042 = Convert.ToBoolean(_idaltticol042.insertarRegistroSimple(ref obj042,ref strError));
bool insert242 = Convert.ToBoolean(_idaltticol042.InsertarRegistroTicol242(ref obj042,ref strError));
res = (insert242 == true && insert042 == true) ? true : false;
break;
case "whcol131":
Ent_twhcol130131 obj131 = new Ent_twhcol130131();
Ent_twhcol130131 MyObj131 = new Ent_twhcol130131();
twhcol028.WHLOT = twhcol028.PAID.Substring(0,(twhcol028.PAID.IndexOf("-")));
MyObj131.OORG = "4";
MyObj131.ORNO = SQNB.Trim().ToUpper();
MyObj131.ITEM = twhcol028.TITM;
MyObj131.PAID = twhcol028.PAID;
MyObj131.PONO = "0";
MyObj131.SEQN = "0";
MyObj131.CLOT = string.IsNullOrEmpty(twhcol028.TLOT) ? " " : twhcol028.TLOT.ToUpper();
MyObj131.CWAR = twhcol028.TWAR;
MyObj131.QTYS = twhcol028.TQTY; // cantidad escaneada view
MyObj131.QTYA = twhcol028.TQTY;
MyObj131.UNIT = twhcol028.UNIT;
MyObj131.QTYC = twhcol028.TQTY; //cantidad escaneada view aplicando factor
MyObj131.UNIC = twhcol028.UNIT;
MyObj131.DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString(); //fecha de confirmacion
MyObj131.CONF = "1";
MyObj131.RCNO = " "; //llena baan
MyObj131.DATR = "01/01/70"; //llena baan
MyObj131.LOCA = twhcol028.SLOC; // enviamos vacio
MyObj131.DATL = DateTime.Now.ToString("dd/MM/yyyy").ToString(); //llenar con fecha de hoy
MyObj131.PRNT = "1"; // llenar en 1
MyObj131.DATP = DateTime.Now.ToString("dd/MM/yyyy").ToString(); //llena baan
MyObj131.NPRT = "1"; //conteo de reimpresiones
MyObj131.LOGN = twhcol028.LOGN; // nombre de ususario de la session
MyObj131.LOGT = " "; //llena baan
MyObj131.STAT = "3"; // LLENAR EN 1
MyObj131.DSCA = "0";
MyObj131.COTP = "0";
MyObj131.FIRE = "1";
MyObj131.PSLIP = " ";
MyObj131.ALLO = "0";
string StrError = string.Empty;
res = _idaltwhcol130.Insertartwhcol131(MyObj131,ref StrError);
break;
}
return(res);
}
public static string Save(Ent_twhcol028 twhcol028)
{
//twhcol028.EMNO =
Ent_twhcol130131 MyOriginalPallet = (Ent_twhcol130131)HttpContext.Current.Session["MyOriginalPallet"];
twhcol028.LOGN = HttpContext.Current.Session["user"].ToString();
bool Res = _idaltwhcol028.insertRegistertwhcol028(ref twhcol028, ref strError);
//JC 210122 Si es un retal hacer un calculo diferente para la cantidad.
DataTable TipoItem = _idaltwhcol028.GetItemType(ref twhcol028, ref strError);
DataTable NetwItem = _idaltwhcol028.GetItemNetw(ref twhcol028, ref strError);
twhcol028.TYPE = TipoItem.Rows[0]["TYPE"].ToString().ToUpper().Trim();
twhcol028.NETW = NetwItem.Rows[0]["NETW"].ToString().Trim();
twhcol028.UNRG = TipoItem.Rows[0]["UNIT"].ToString();
twhcol028.QTRG = Convert.ToString(Math.Round(((Convert.ToDecimal(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462)), 4));
if (Res)
{
if ((twhcol028.TITM == twhcol028.SITM) && (twhcol028.TWAR != twhcol028.SWAR || twhcol028.TLOC != twhcol028.SLOC))
{
bool updateSuccessPallet = UpdatePalletOriginTable(ref twhcol028);
if (updateSuccessPallet)
{
twhcol028.Error = false;
}
else
{
twhcol028.Error = true;
}
}
else
{
saveOriginTable(twhcol028);
string strMaxSequence = string.Empty;
switch (MyOriginalPallet.TBL)
{
case "ticol022":
case "ticol042":
if (twhcol028.KTLC == "1")
{
if (twhcol028.TLOT.Trim().ToUpper() == twhcol028.SLOT.Trim().ToUpper())
{
strMaxSequence = getSequence(twhcol028.SLOT.Trim().ToUpper() + "-A");
}
else
{
//strMaxSequence = getSequence(twhcol028.TLOT.Trim().ToUpper() + "-A");
//JC 210122 Corregir la busqueda si el lote destino no existe o si el item no maneja lote
strMaxSequence = getSequence(twhcol028.PAID.Substring(0,9).ToUpper() + "-A");
}
}
else if (twhcol028.KTLC != "1")
{
if (twhcol028.TLOT.Trim().ToUpper() == twhcol028.SLOT.Trim().ToUpper())
{
strMaxSequence = getSequence(MyOriginalPallet.ORNO + "-A");
}
else
{
strMaxSequence = getSequence(twhcol028.SLOT.Trim() + "-A");
}
}
break;
case "whcol131":
strMaxSequence = getSequence(MyOriginalPallet.ORNO + "-A");
break;
}
bool createSuccessNewPaller = saveNewPalletOriginTable(ref twhcol028,strMaxSequence);
if (createSuccessNewPaller)
{
twhcol028.Error = false;
twhcol028.ErrorMsg = "Se inserto correctamente";
twhcol028.SuccessMsg = "Se inserto ok";
twhcol028.TypeMsgJs = "Label";
}
else
{
twhcol028.Error = true;
twhcol028.ErrorMsg = "No se inserto correctamente el nuevo pallet";
twhcol028.TypeMsgJs = "Label";
}
}
}
else
{
twhcol028.Error = true;
twhcol028.ErrorMsg = "No se inserto correctamente";
twhcol028.TypeMsgJs = "Label";
}
return(JsonConvert.SerializeObject(twhcol028));
}
public static string Save(Ent_twhcol028 twhcol028)
{
//twhcol028.EMNO =
twhcol028.LOGN = HttpContext.Current.Session["user"].ToString();
bool Res = _idaltwhcol028.insertRegistertwhcol028(ref twhcol028, ref strError);
if (Res)
{
saveOriginTable(twhcol028);
Ent_twhcol130131 MyOriginalPallet = (Ent_twhcol130131)HttpContext.Current.Session["MyOriginalPallet"];
string strMaxSequence = string.Empty;
switch (MyOriginalPallet.TBL)
{
case "ticol022":
case "ticol042":
if (twhcol028.KTLC == "1")
{
if (twhcol028.TLOT.Trim().ToUpper() == twhcol028.SLOT.Trim().ToUpper())
{
strMaxSequence = getSequence(twhcol028.SLOT.Trim().ToUpper() + "-A");
}
else
{
strMaxSequence = getSequence(twhcol028.TLOT.Trim().ToUpper() + "-A");
}
}
else if (twhcol028.KTLC != "1")
{
if (twhcol028.TLOT.Trim().ToUpper() == twhcol028.SLOT.Trim().ToUpper())
{
strMaxSequence = getSequence(MyOriginalPallet.ORNO + "-A");
}
else
{
strMaxSequence = getSequence(twhcol028.SLOT.Trim() + "-A");
}
}
break;
case "whcol131":
strMaxSequence = getSequence(MyOriginalPallet.ORNO + "-A");
break;
}
bool createSuccessNewPaller = saveNewPalletOriginTable(ref twhcol028,strMaxSequence);
if (createSuccessNewPaller)
{
twhcol028.Error = false;
twhcol028.ErrorMsg = "Se inserto correctamente";
twhcol028.SuccessMsg = "Se inserto ok";
twhcol028.TypeMsgJs = "Label";
}
else
{
twhcol028.Error = true;
twhcol028.ErrorMsg = "No se inserto correctamente el nuevo pallet";
twhcol028.TypeMsgJs = "Label";
}
}
else
{
twhcol028.Error = true;
twhcol028.ErrorMsg = "No se inserto correctamente";
twhcol028.TypeMsgJs = "Label";
}
return(JsonConvert.SerializeObject(twhcol028));
}
