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