public DataTable GetItemsStat(ref Ent_ttwhcol016 Parametros, ref string strError) { method = MethodBase.GetCurrentMethod(); paramList = new Dictionary <string, object>(); paramList.Add("stat", Parametros.stat.Trim().ToUpper()); //JC 210122 Buscar el item en tabla ticol135 paramList.Add("item", Parametros.item.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); }
//JC 020821 Retornar consecutivo y serie public DataTable VerificaCons_Serie_Label(ref Ent_ttwhcol016 parametros, ref string strError) { method = MethodBase.GetCurrentMethod(); paramList = new Dictionary <string, object>(); paramList.Add("p1", parametros.zone.Trim().ToUpperInvariant()); Dictionary <string, object> parametersOut = new Dictionary <string, object>(); 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 = "-1"; return(consulta); } } catch (Exception ex) { strError = "Error when querying data [ttwhcol016]. Try again or contact your administrator"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(consulta); }
public DataTable TakeMaterialInv_verificaBodegaZone_Param(ref Ent_ttwhcol016 parametros, ref string strError) { method = MethodBase.GetCurrentMethod(); paramList = new Dictionary <string, object>(); paramList.Add("p1", parametros.zone.Trim().ToUpperInvariant()); //strSentencia = "SELECT T$CWAR " + // "FROM " + owner + ".twhwmd310" + env + " TWAR " + // "WHERE TRIM(T$ZONE) = '" + Parametros.zone.Trim() + "'"; 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 = "Zone don´t have warehouse"; } ttwhcol016 dal016 = new ttwhcol016(); parametros.cwar = consulta.Rows[0]["T$CWAR"].ToString(); consulta = dal016.TakeMaterialInv_verificaBodega_Param(ref parametros, ref strError); } catch (Exception ex) { strError = "Error when querying data [ttwhcol017]. Try again or contact your administrator"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(consulta); }
public int DesactivarSerie_Consecutivo(ref Ent_ttwhcol016 parametros, ref string strError) { method = MethodBase.GetCurrentMethod(); bool retorno = false; string MsgstrError = string.Empty; paramList = new Dictionary <string, object>(); paramList.Add("p1", parametros.zone.Trim().ToUpperInvariant()); paramList.Add("p2", parametros.serietemp); paramList.Add("p3", '1'); paramList.Add("p4", '2'); paramList.Add("p5", parametros.serietemp + 1); try { strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList); retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, parametrosIn, false); strSentencia = recursos.readStatement(method.ReflectedType.Name, "ActivarNuevaSerie_Consecutivo", ref owner, ref env, tabla, paramList); retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, parametrosIn, false); } catch (Exception ex) { strError = MsgstrError + "Try again or contact your administrator"; log.escribirError(strError + Console.Out.NewLine + ex.Message, method.Module.Name, method.Name, method.ReflectedType.Name); } return(Convert.ToInt32(retorno)); }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_ttwhcol016 parametros, bool blnUsarPRetorno = false) { string strError = string.Empty; string param = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ZONE", DbType.String, parametros.zone); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LABL", DbType.String, parametros.labl); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ITEM", DbType.String, parametros.item); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.cwar); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.clot); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTYR", DbType.Decimal, Convert.ToDecimal(parametros.qtyr).ToString("#.##0,0000")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { log.escribirError(strError + Console.Out.NewLine + ex.Message, method.Module.Name, method.Name, method.ReflectedType.Name); throw (ex); } return(parameterCollection); }
public static string GetItems() { Ent_ttwhcol016 obj016 = new Ent_ttwhcol016(); obj016.stat = "RET"; //JC 210122 Buscar los posibles regrind en la tabla ticol135 obj016.item = HttpContext.Current.Session["ITM"].ToString(); int i = 0; DataTable DTItemt = dal016.GetItemsStat(ref obj016, ref strError); List <Ent_twhcol130131> lstItems = new List <Ent_twhcol130131>(); if (DTItemt.Rows.Count > 0) { foreach (DataRow item in DTItemt.Rows) { if (i <= 50) { Ent_twhcol130131 MyObj = new Ent_twhcol130131(); MyObj.KTLC = item["LOTE"].ToString(); MyObj.ITEM = item["T$ITEM"].ToString(); MyObj.DSCA = item["DESCRIPCION"].ToString(); MyObj.UNIT = item["UNIDAD"].ToString(); MyObj.Error = false; MyObj.errorMsg = string.Empty; MyObj.TipeMsgJs = string.Empty; lstItems.Add(MyObj); i++; } } } return(JsonConvert.SerializeObject(lstItems));; }
protected void btnSearchZone_Click(object sender, EventArgs e) { lblError.Text = string.Empty; strError = string.Empty; Ent_ttwhcol016 objZone = new Ent_ttwhcol016(); objZone.zone = txtZone.Text.ToUpperInvariant().Trim(); resultado = idal016.TakeMaterialInv_verificaZona_Param(ref objZone, ref strError); if (!string.IsNullOrEmpty(strError)) { lblZone.Text = strError; txtZone.Focus(); strError = string.Empty; divTabla.Visible = false; return; } //lblZone.Text = string.Empty; divTabla.Visible = true; lblZone.Text = resultado.Rows[0]["DESCRIPCION"].ToString(); resultado = idal.TakeMaterialInv_verificaBodegaZone_Param(ref objZone, ref strError); txtCwar.Text = resultado.Rows[0]["T$CWAR"].ToString(); lblCwar.Text = resultado.Rows[0]["DESCRIPCION"].ToString(); btnSearch.Enabled = true; Page.Form.DefaultButton = btnSearch.UniqueID; txtLabelId.Focus(); }
public static string VerificarTipoWarehouse(string WARE, string ROW) { string strError = string.Empty; Ent_ttwhcol016 Obj_twhcol016 = new Ent_ttwhcol016(); Obj_twhcol016.cwar = WARE.ToUpper(); Obj_twhcol016.Row = ROW; Ent_twhwmd200 Obj_twhwmd200 = new Ent_twhwmd200(); Obj_twhwmd200.cwar = WARE.ToUpper(); DataTable DtConsigment = ITtwhcol016.UserConsigment(HttpContext.Current.Session["user"].ToString(), WARE.ToUpper()); DataTable DtTtwhcol016 = ITtwhcol016.TakeMaterialInv_verificaBodega_Param(ref Obj_twhcol016, ref strError); DataTable DtTwhwmd200 = ITwhwmd200.listaRegistro_ObtieneAlmacenLocation(ref Obj_twhwmd200, ref strError); if (DtTtwhcol016.Rows.Count > 0) { Obj_twhcol016.Error = false; Obj_twhcol016.TypeMsgJs = "console"; Obj_twhcol016.SuccessMsg = "Warehouse Encontrado"; Obj_twhcol016.TYPW = DtTtwhcol016.Rows[0]["TYPW"].ToString(); if (Obj_twhcol016.TYPW.ToString() == "21" && DtConsigment.Rows[0]["T$CONS"].ToString().Trim() != "1") { Obj_twhcol016.Error = true; Obj_twhcol016.ErrorMsg = WarehouseConsigment; Obj_twhcol016.TypeMsgJs = "lbl"; } if (DtTwhwmd200.Rows.Count > 0) { Obj_twhcol016.sloc = DtTwhwmd200.Rows[0]["LOC"].ToString(); } else { Obj_twhcol016.sloc = string.Empty; } } else { Obj_twhcol016.Error = true; Obj_twhcol016.TypeMsgJs = "label"; Obj_twhcol016.ErrorMsg = WarehouseNotExist; } Obj_twhcol016.cwar.ToUpper(); return(JsonConvert.SerializeObject(Obj_twhcol016)); }
public static string validaInfo(string valor, string tipo, string orden = null) { string strSecondVal = string.Empty; string strError = string.Empty; string retorno = string.Empty; DataTable resultado = new DataTable(); InterfazDAL_ttwhcol016 idal016 = new InterfazDAL_ttwhcol016(); Ent_ttwhcol016 obj016 = new Ent_ttwhcol016(); InterfazDAL_tticol090 idal = new InterfazDAL_tticol090(); Ent_tticol090 obj = new Ent_tticol090(); if (tipo == "1") // Items { obj.item = valor; obj.fpdn = orden; resultado = idal.lineClearance_verificaRegistrosOrden_Param(ref obj, ref strError); } if (tipo == "2") // Lote { String[] valores = valor.Split('|'); obj016.clot = valores[0].Trim().ToUpperInvariant(); obj016.item = valores[1].Trim().ToUpperInvariant(); obj.fpdn = orden; resultado = idal016.TakeMaterialInv_verificaLote_Param(ref obj016, ref strError); strError = _idioma == "INGLES" ? "Lot code doesn´t exist. Cannot Continue" : "Codigo de lote no existe, no se puede continuar."; if (string.IsNullOrEmpty(strError)) { resultado = idal.lineClearance_verificaRegistrosOrden_Param(ref obj, ref obj016, ref strError); } strError = _idioma == "INGLES" ? "Lot code was not on Work Order. Cannot Continue" : "Codigo de lote no es de la orden de trabajo, no se puede continuar."; } // Validar si el numero de orden trae registros if (strError != string.Empty) { return("BAAN: " + strError); } if (resultado.Rows.Count > 0) { retorno = resultado.Rows[0]["DESCRIPCION"].ToString(); } return(retorno); }
//JC 020821 Retornar consecutivo y serie public DataTable VerificaCons_Serie_Label(ref Ent_ttwhcol016 Parametros, ref string strError) { DataTable retorno; try { retorno = dal.VerificaCons_Serie_Label(ref Parametros, ref strError); return(retorno); } catch (Exception ex) { throw new Exception(ex.InnerException.ToString()); } }
public int DesactivarSerie_Consecutivo(ref Ent_ttwhcol016 parametrosIn, ref string strError) { int retorno = -1; try { retorno = dal.DesactivarSerie_Consecutivo(ref parametrosIn, ref strError); return(retorno); } catch (Exception ex) { throw new Exception(strError += "\nPila: " + ex.Message); } }
public int actualizarContadores(ref Ent_ttwhcol016 Parametros, ref string strError) { int retorno = -1; try { retorno = dal.actualizarContadores(ref Parametros, ref strError); return(retorno); } catch (Exception ex) { throw new Exception(strError += ex.Message); } }
public static string validaInfo(string valor, string tipo, string orden = null) { string strSecondVal = string.Empty; string strError = string.Empty; string retorno = string.Empty; DataTable resultado = new DataTable(); InterfazDAL_ttwhcol016 idal016 = new InterfazDAL_ttwhcol016(); Ent_ttwhcol016 obj016 = new Ent_ttwhcol016(); InterfazDAL_tticol090 idal = new InterfazDAL_tticol090(); Ent_tticol090 obj = new Ent_tticol090(); if (tipo == "1") // Items { obj.item = valor; obj.fpdn = orden; resultado = idal.lineClearance_verificaRegistrosOrden_Param(ref obj, ref strError); } if (tipo == "2") // Lote { String[] valores = valor.Split('|'); obj016.clot = valores[0].Trim().ToUpperInvariant(); obj016.item = valores[1].Trim().ToUpperInvariant(); obj.fpdn = orden; resultado = idal016.TakeMaterialInv_verificaLote_Param(ref obj016, ref strError); if (string.IsNullOrEmpty(strError)) { resultado = idal.lineClearance_verificaRegistrosOrden_Param(ref obj, ref obj016, ref strError); } } // Validar si el numero de orden trae registros if (strError != string.Empty) { return("BAAN: " + strError); } if (resultado.Rows.Count > 0) { retorno = resultado.Rows[0]["DESCRIPCION"].ToString(); } return(retorno); }
public DataTable GetItemsStat(ref Ent_ttwhcol016 Parametros, ref string strError) { //int retorno = -1; DataTable retorno; try { retorno = dal.GetItemsStat(ref Parametros, ref strError); return(retorno); } catch (Exception ex) { throw new Exception(ex.InnerException.ToString()); } }
public DataTable TakeMaterialInv_verificaBodegaZone_Param(ref Ent_ttwhcol016 Parametros, ref string strError) { //int retorno = -1; DataTable retorno; try { retorno = dal.TakeMaterialInv_verificaBodegaZone_Param(ref Parametros, ref strError); return(retorno); } catch (Exception ex) { throw new Exception(ex.InnerException.ToString()); } }
public static string VerificarWarehouse(string CWAR) { Ent_twhcol130131 MyObj131Base = (Ent_twhcol130131)HttpContext.Current.Session["MyPalletTwhcol13"]; string strError = string.Empty; Ent_ttwhcol016 Obj_twhcol016 = new Ent_ttwhcol016(); Obj_twhcol016.cwar = CWAR; Ent_twhwmd200 Obj_twhwmd200 = new Ent_twhwmd200(); Obj_twhwmd200.cwar = CWAR; DataTable DtTtwhcol016 = ITtwhcol016.TakeMaterialInv_verificaBodega_Param(ref Obj_twhcol016, ref strError); DataTable DtTwhwmd200 = ITwhwmd200.listaRegistro_ObtieneAlmacenLocation(ref Obj_twhwmd200, ref strError); if (DtTtwhcol016.Rows.Count > 0) { Obj_twhcol016.Error = false; Obj_twhcol016.TypeMsgJs = "console"; Obj_twhcol016.SuccessMsg = "Warehouse Encontrado"; if (DtTwhwmd200.Rows.Count > 0) { Obj_twhcol016.sloc = DtTwhwmd200.Rows[0]["LOC"].ToString(); } else { Obj_twhcol016.sloc = string.Empty; if (MyObj131Base.CWAR == CWAR) { Obj_twhcol016.Error = true; Obj_twhcol016.TypeMsgJs = "label"; Obj_twhcol016.ErrorMsg = "Warehouse / Location can't be the same"; } } } else { Obj_twhcol016.Error = true; Obj_twhcol016.TypeMsgJs = "label"; Obj_twhcol016.ErrorMsg = Warehousecodedoesntexist; } return(JsonConvert.SerializeObject(Obj_twhcol016)); }
public static string validaInfo(string valor, string tipo, string orden = null) { string strSecondVal = string.Empty; string strError = string.Empty; string retorno = string.Empty; DataTable resultado = new DataTable(); InterfazDAL_ttwhcol016 idal016 = new InterfazDAL_ttwhcol016(); Ent_ttwhcol016 obj016 = new Ent_ttwhcol016(); InterfazDAL_ttscol100 idal = new InterfazDAL_ttscol100(); Ent_ttscol100 obj = new Ent_ttscol100(); if (tipo == "1") // Items { obj.item = valor; resultado = idal.spareDelivery_listaRegistroItem_Param(ref obj, ref strError); if (resultado.Rows.Count > 0) { retorno = resultado.Rows[0]["DESCRIPCION"].ToString().Trim() + "|" + resultado.Rows[0]["UNIDAD"].ToString().Trim() + "|" + resultado.Rows[0]["ARTICULO"].ToString().Trim(); } } if (tipo == "2") // Lote { obj.loca = valor; resultado = idal.spareDelivery_listaRegistroUbicacion_Param(ref obj, ref strError); if (resultado.Rows.Count > 0) { retorno = resultado.Rows[0]["LOCATION"].ToString().Trim() + "|" + resultado.Rows[0]["WAREHOUSE"].ToString().Trim(); } } // Validar si el numero de orden trae registros if (strError != string.Empty) { return("BAAN: " + strError); } // if (resultado.Rows.Count > 0) { retorno = resultado.Rows[0]["DESCRIPCION"].ToString(); } return(retorno); }
public static string VerificarWarehouse(string CWAR) { string strError = string.Empty; Ent_ttwhcol016 Obj_twhcol016 = new Ent_ttwhcol016(); Obj_twhcol016.cwar = CWAR; Ent_twhwmd200 Obj_twhwmd200 = new Ent_twhwmd200(); Obj_twhwmd200.cwar = CWAR.ToUpper(); DataTable DtTtwhcol016 = ITtwhcol016.TakeMaterialInv_verificaBodega_Param(ref Obj_twhcol016, ref strError); DataTable DtTwhwmd200 = ITwhwmd200.listaRegistro_ObtieneAlmacenLocation(ref Obj_twhwmd200, ref strError); if (DtTtwhcol016.Rows.Count > 0) { Obj_twhcol016.Error = false; Obj_twhcol016.TypeMsgJs = "console"; Obj_twhcol016.SuccessMsg = "Warehouse Encontrado"; Obj_twhcol016.dsca = DtTtwhcol016.Rows[0]["DESCRIPCION"].ToString(); if (DtTwhwmd200.Rows.Count > 0) { Obj_twhcol016.sloc = DtTwhwmd200.Rows[0]["LOC"].ToString(); } else { Obj_twhcol016.sloc = string.Empty; } HttpContext.Current.Session["CWAR"] = Obj_twhcol016.cwar; } else { Obj_twhcol016.Error = true; Obj_twhcol016.TypeMsgJs = "label"; Obj_twhcol016.ErrorMsg = Warehousecodedoesntexist; } return(JsonConvert.SerializeObject(Obj_twhcol016)); }
public static string verifyItem(string ITEM) { Ent_twhcol130131 MyObj = new Ent_twhcol130131(); Ent_ttwhcol016 obj016 = new Ent_ttwhcol016(); obj016.item = ITEM.ToUpper().Trim(); DataTable DTItemt = dal016.TakeMaterialInv_verificaItem_Param(ref obj016, ref strError); if (DTItemt.Rows.Count > 0) { Ent_twhcol130131 MyOriginalPallet = (Ent_twhcol130131)HttpContext.Current.Session["MyOriginalPallet"]; var MyObjDT = DTItemt.Rows[0]; if (MyObjDT["UNIDAD"].ToString().Trim() == MyOriginalPallet.UNIT.Trim()) { MyObj.KTLC = MyObjDT["LOTE"].ToString(); MyObj.ITEM = MyObjDT["T$ITEM"].ToString(); MyObj.DSCA = MyObjDT["DESCRIPCION"].ToString(); MyObj.UNIT = MyObjDT["UNIDAD"].ToString(); MyObj.Error = false; MyObj.errorMsg = string.Empty; MyObj.TipeMsgJs = string.Empty; } else { MyObj.Error = true; MyObj.errorMsg = "Item not allowed to adjust, due the unit is different"; MyObj.TipeMsgJs = "alert"; } } else { MyObj.Error = true; MyObj.errorMsg = Itemcodedoesntexist; MyObj.TipeMsgJs = "Label"; } return(JsonConvert.SerializeObject(MyObj));; }
public DataTable TakeMaterialInv_verificaLote_Param(ref Ent_ttwhcol016 ParametrosIn, ref string strError) { method = MethodBase.GetCurrentMethod(); paramList = new Dictionary <string, object>(); paramList.Add("p1", ParametrosIn.clot.Trim().ToUpperInvariant()); 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 = "Lot 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); }
public int actualizarContadores(ref Ent_ttwhcol016 Parametros, ref string strError) { method = MethodBase.GetCurrentMethod(); paramList = new Dictionary <string, object>(); paramList.Add("p1", Parametros.zone.Trim().ToUpperInvariant()); bool retorno = false; try { 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(Convert.ToInt32(retorno)); } catch (Exception ex) { strError = "Error when inserting data [ttcmcs050]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(Convert.ToInt32(retorno)); }
public DataTable lineClearance_verificaRegistrosOrden_Param(ref Ent_tticol090 Parametros, ref Ent_ttwhcol016 Parametros016, ref string strError) { method = MethodBase.GetCurrentMethod(); paramList = new Dictionary <string, object>(); paramList.Add("p1", Parametros016.item.Trim().ToUpperInvariant()); paramList.Add("p2", Parametros016.clot.Trim().ToUpperInvariant()); paramList.Add("p3", Parametros.fpdn.Trim().ToUpperInvariant()); strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList, 1); try { consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentencia, ref parametersOut, null, true); if (consulta.Rows.Count < 1) { strError = "Lot Code was not on Work Order. Cannot Continue"; } //return consulta; } catch (Exception ex) { log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(consulta); }
public static string Click_Save(string CWAR, string ITEM, string CLOT, string LOCA, string QTYS, string UNIT) { //int consecutivoPalletID = 0; //DataTable DTPalletContinue = twhcol130DAL.PaidMayorwhcol130("INITIAPOP-P"); //string SecuenciaPallet = "001"; //if (DTPalletContinue.Rows.Count > 0) //{ // foreach (DataRow item in DTPalletContinue.Rows) // { // string paid = item["T$PAID"].ToString().Trim(); // int indesSep = item["T$PAID"].ToString().Trim().IndexOf("-P"); // string secuence = paid.Substring(indesSep + 1); // consecutivoPalletID = Convert.ToInt32(secuence)+1; // if (consecutivoPalletID.ToString().Length == 1) // { // SecuenciaPallet = "P00" + consecutivoPalletID; // } // if (consecutivoPalletID.ToString().Length == 2) // { // SecuenciaPallet = "P0" + consecutivoPalletID; // } // if (consecutivoPalletID.ToString().Length == 3) // { // SecuenciaPallet = "P"+consecutivoPalletID.ToString(); // } // } //} Ent_ttwhcol016 data016 = new Ent_ttwhcol016();; string retorno = string.Empty; string strError = string.Empty; data016.zone = serieLabelRM; DataTable dat016 = ITtwhcol016.VerificaCons_Serie_Label(ref data016, ref strError); int actcontador = ITtwhcol016.actualizarContadores(ref data016, ref strError); //string SecuenciaPallet = "C"; string consecutivo = dat016.Rows[0]["CONSEC"].ToString().PadLeft(3, '0'); string serie = dat016.Rows[0]["SEQ"].ToString(); if (consecutivo == "990") { data016.serietemp = Convert.ToInt32(dat016.Rows[0]["SEQ"].ToString()) + 1; int retconser = ITtwhcol016.ActualizarSerie_Consecutivo(ref data016, ref strError); } if (consecutivo == "998") { data016.serietemp = Convert.ToInt32(dat016.Rows[0]["SEQ"].ToString()); int retconser = ITtwhcol016.DesactivarSerie_Consecutivo(ref data016, ref strError); } string id = CLOT.Trim() == "" ? cyclecountLabelRM : CLOT.Trim(); string sqnb = cyclecountLabelRM.Trim() + serie.Trim() + "-" + consecutivo; Ent_twhcol130131 MyObj = new Ent_twhcol130131 { OORG = "2",// Order type escaneada view //ORNO = "INITIAPOP", ORNO = cyclecountLabelRM.Trim() + serie.Trim(), ITEM = ITEM.ToUpper(), //PAID = "INITIAPOP" + "-" + SecuenciaPallet, PAID = sqnb, PONO = "1", SEQN = "1", CLOT = CLOT.ToUpper(), // lote VIEW CWAR = CWAR.ToUpper(), QTYS = QTYS, // cantidad escaneada view QTYA = QTYS, UNIT = UNIT, //unit escaneada view QTYC = QTYS, //cantidad escaneada view aplicando factor UNIC = UNIT, //unidad view stock DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //fecha de confirmacion CONF = "1", RCNO = " ", //llena baan DATR = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //llena baan LOCA = LOCA.ToUpper(), // enviamos vacio DATL = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //llenar con fecha de hoy PRNT = "1", // llenar en 1 DATP = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //llena baan NPRT = "1", //conteo de reimpresiones LOGN = HttpContext.Current.Session["user"].ToString(), // nombre de ususario de la session LOGT = " ", //llena baan STAT = "3", // LLENAR EN 3 DSCA = " ", COTP = " ", FIRE = "2", PSLIP = " ", ALLO = "0", //PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + "INITIAPOP" + "-" + SecuenciaPallet + "&code=Code128&dpi=96", PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + "INITIAPOP" + "-" + sqnb + "&code=Code128&dpi=96", ORNO_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + "DTOrdencompra.Rows[0][].ToString()" + "&code=Code128&dpi=96", ITEM_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + ITEM + "&code=Code128&dpi=96", CLOT_URL = CLOT.ToString().Trim() != "" ? UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + CLOT + "&code=Code128&dpi=96" : "", QTYC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + QTYS + "&code=Code128&dpi=96", UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + UNIT + "&code=Code128&dpi=96" }; string StrError = string.Empty; bool Insertsucces = twhcol130DAL.Insertartwhcol131(MyObj, ref StrError); if (Insertsucces) { HttpContext.Current.Session["MaterialDesc"] = "XXXXX XXX XXX XX"; HttpContext.Current.Session["MaterialCode"] = MyObj.ITEM; HttpContext.Current.Session["codePaid"] = MyObj.PAID; HttpContext.Current.Session["Lot"] = MyObj.CLOT; HttpContext.Current.Session["Quantity"] = MyObj.QTYS + " " + UNIT; HttpContext.Current.Session["Origin"] = MyObj.CLOT; HttpContext.Current.Session["Supplier"] = ""; HttpContext.Current.Session["RecibedBy"] = MyObj.LOGN; HttpContext.Current.Session["RecibedOn"] = DateTime.Now.ToString("MM/dd/yyyy"); HttpContext.Current.Session["Reprint"] = "no"; } else { MyObj.error = true; MyObj.TypeMsgJs = "label"; MyObj.errorMsg = "Error insert"; } return(JsonConvert.SerializeObject(MyObj)); }
public DataTable lineClearance_verificaRegistrosOrden_Param(ref Ent_tticol090 Parametros, ref Ent_ttwhcol016 Parametros016, ref string strError) { DataTable retorno; try { retorno = dal.lineClearance_verificaRegistrosOrden_Param(ref Parametros, ref Parametros016, ref strError); return(retorno); } catch (Exception ex) { throw new Exception(ex.InnerException.ToString()); } }
public static string validaInfo(string valor, string tipo) { InterfazDAL_ttwhcol016 idal = new InterfazDAL_ttwhcol016(); Ent_ttwhcol016 obj = new Ent_ttwhcol016(); string strError = string.Empty; string retorno = string.Empty; DataTable resultado = new DataTable(); string strSecondVal = string.Empty; if (tipo == "1") // Bodega { obj.cwar = valor.Trim().ToUpperInvariant(); resultado = idal.TakeMaterialInv_verificaBodega_Param(ref obj, ref strError); } if (tipo == "2") // Zona { obj.zone = valor.Trim().ToUpperInvariant(); resultado = idal.TakeMaterialInv_verificaZona_Param(ref obj, ref strError); if (resultado.Rows.Count > 0) { int consecutivo = 0; consecutivo = idal.TakeMaterialInv_verificaConsLabel_Param(ref obj, ref strError); strSecondVal = "|" + consecutivo.ToString().Trim(); if (consecutivo < 1) { strError = _idioma == "INGLES" ? "Sequence Zone " + valor + " doesn't exist. Cannot Continue" : "Secunecia de zona " + valor + " no existe, no se puede continuar."; } } } if (tipo == "3") // Item { obj.item = valor.Trim().ToUpperInvariant(); resultado = idal.TakeMaterialInv_verificaItem_Param(ref obj, ref strError); if (resultado.Rows.Count <= 0) { strError = _idioma == "INGLES" ? "Item code doesn´t exist. Cannot continue" : "Codigo de articulo no existe. No se puede continuar"; } } if (tipo == "4") // Lote { obj.clot = valor.Trim().ToUpperInvariant(); resultado = idal.TakeMaterialInv_verificaLote_Param(ref obj, ref strError); if (resultado.Rows.Count <= 0) { strError = _idioma == "INGLES" ? "Lot Code doesn´t exist. Cannot Continue" : "Codigo de lote no existe. No se puede continuar"; } } // Validar si el numero de orden trae registros if (strError != string.Empty) { return("BAAN: " + strError); } if (resultado.Rows.Count > 0) { retorno = resultado.Rows[0]["DESCRIPCION"].ToString(); if (tipo == "3") { retorno = resultado.Rows[0]["DESCRIPCION"].ToString().Trim() + "|" + resultado.Rows[0]["UNIDAD"].ToString().Trim() + "|" + resultado.Rows[0]["LOTE"].ToString().Trim(); } } return(retorno + strSecondVal); }
protected void Save_Click(object sender, EventArgs e) { string ITEM = HttpContext.Current.Session["ITEM"].ToString(); string CWAR = HttpContext.Current.Session["CWAR"].ToString(); string CLOT = HttpContext.Current.Session["CLOT"].ToString(); string LOCA = HttpContext.Current.Session["LOCA"].ToString(); string QTYS = HttpContext.Current.Session["QTYS"].ToString(); string UNIT = HttpContext.Current.Session["UNIT"].ToString(); string CUNI = HttpContext.Current.Session["CUNI"].ToString(); Ent_tticol022 data022; Ent_tticol042 data042; string strError = string.Empty; //JC 020801 Conseguir el último consecutivo de la serie NFP definida en baan Ent_ttwhcol016 data016 = new Ent_ttwhcol016();; string retorno = string.Empty; data016.zone = serieLabelFP; DataTable dat016 = _idaltwhcol016.VerificaCons_Serie_Label(ref data016, ref strError); int actcontador = _idaltwhcol016.actualizarContadores(ref data016, ref strError); //string SecuenciaPallet = "C"; string consecutivo = dat016.Rows[0]["CONSEC"].ToString().PadLeft(3, '0'); string serie = dat016.Rows[0]["SEQ"].ToString(); if (consecutivo == "990") { data016.serietemp = Convert.ToInt32(dat016.Rows[0]["SEQ"].ToString()) + 1; int retconser = _idaltwhcol016.ActualizarSerie_Consecutivo(ref data016, ref strError); } if (consecutivo == "998") { data016.serietemp = Convert.ToInt32(dat016.Rows[0]["SEQ"].ToString()); int retconser = _idaltwhcol016.DesactivarSerie_Consecutivo(ref data016, ref strError); } string id = CLOT.Trim() == "" ? cyclecountLabel : CLOT.Trim(); string sqnb = cyclecountLabel.Trim() + serie.Trim() + "-" + consecutivo; //if (HttpContext.Current.Session["myItemType"].ToString().Trim() != "RET") //{ //string id = cyclecountLabel; //JC 020821 Conseguir el último consecutivo de la serie NFP ya no se buscará el consecutivo por orden //DataTable Dtticol022 = _idaltticol022.SecuenciaMayor(id); //if (Dtticol022.Rows.Count > 0) //{ //int res; //string sqnb = Dtticol022.Rows[0]["T$SQNB"].ToString().Trim() == "" ? SecuenciaPallet : Dtticol022.Rows[0]["T$SQNB"].ToString().Trim(); //int iSep = sqnb.IndexOf("-"); //string CurrentSecuence = sqnb.Substring(iSep + 1).Replace("C",""); // //consecutivo = Convert.ToInt32(CurrentSecuence)+1; //consecutivo = CurrentSecuence + 1; //} //else //{ // //consecutivo = 1; // consecutivo = "1"; //} //} //else //{ // //string id = CLOT.Trim() == "" ? ITEM.Trim() : CLOT.Trim(); // //string id = cyclecountLabel; // DataTable Dtticol042 = _idaltticol042.SecuenciaMayor(id); // if (Dtticol042.Rows.Count > 0) // { // int res; // string sqnb = Dtticol042.Rows[0]["T$SQNB"].ToString().Trim(); // int iSep = sqnb.IndexOf("-"); // string CurrentSecuence = sqnb.Substring(iSep + 1).Replace("C", ""); // //consecutivo = Convert.ToInt32(CurrentSecuence)+1; // consecutivo = CurrentSecuence + 1; // } // else // { // //consecutivo = 1; // consecutivo = "1"; // } //} //JC 020821 Conseguir el último consecutivo de la serie NFP ya no se buscará el consecutivo por orden //if (consecutivo.ToString().Length == 1) //{ // SecuenciaPallet = "C00" + consecutivo.ToString(); //} //if (consecutivo.ToString().Length == 2) //{ // SecuenciaPallet = "C0" + consecutivo.ToString(); //} //if (consecutivo.ToString().Length == 3) //{ // SecuenciaPallet = "C0" + consecutivo.ToString(); //} if (HttpContext.Current.Session["myItemType"].ToString().Trim() != "RET") { data022 = new Ent_tticol022(); data022.pdno = CLOT == "" ? cyclecountLabel.Trim() + serie.Trim() : CLOT.Trim(); //data022.sqnb = (CLOT == "" ? cyclecountLabel : CLOT.Trim()) + "-" + SecuenciaPallet; data022.sqnb = sqnb; data022.proc = 2; data022.logn = HttpContext.Current.Session["user"].ToString(); data022.mitm = ITEM.Trim(); data022.qtdl = Convert.ToDecimal(QTYS); data022.cuni = CUNI; data022.log1 = "NONE"; data022.qtd1 = Convert.ToInt32(Convert.ToDecimal(QTYS)); data022.pro1 = 2; data022.log2 = "NONE"; data022.qtd2 = Convert.ToInt32(Convert.ToDecimal(QTYS)); data022.pro2 = 2; data022.loca = " "; data022.norp = 1; data022.dele = 7; data022.logd = "NONE"; data022.refcntd = 0; data022.refcntu = 0; data022.drpt = DateTime.Now; data022.urpt = HttpContext.Current.Session["user"].ToString(); data022.acqt = Convert.ToDecimal(QTYS); data022.cwaf = CWAR; data022.cwat = CWAR; data022.aclo = LOCA; data022.allo = 0; HttpContext.Current.Session["strOrden"] = data022.pdno; HttpContext.Current.Session["strSecuen"] = data022.sqnb; HttpContext.Current.Session["itemId"] = data022.mitm; HttpContext.Current.Session["cantidad"] = data022.acqt; HttpContext.Current.Session["bodega"] = data022.cwaf; HttpContext.Current.Session["usuario"] = data022.urpt; HttpContext.Current.Session["fecha"] = data022.drpt; HttpContext.Current.Session["descItem"] = data022.mitm; HttpContext.Current.Session["unidad"] = data022.cuni; HttpContext.Current.Session["strTagId"] = ""; var validateSave = _idaltticol022.insertarRegistroSimple(ref data022, ref strError); var validateSaveTicol222 = _idaltticol022.InsertarRegistroTicol222(ref data022, ref strError); //return JsonConvert.SerializeObject(data022); if (Convert.ToBoolean(validateSave) && Convert.ToBoolean(validateSaveTicol222)) { HttpContext.Current.Session["MaterialDesc"] = data022.mitm; HttpContext.Current.Session["codeMaterial"] = data022.mitm; HttpContext.Current.Session["codePaid"] = data022.sqnb; HttpContext.Current.Session["Lot"] = CLOT; HttpContext.Current.Session["Quantity"] = data022.acqt + " " + data022.cuni; HttpContext.Current.Session["Date"] = DateTime.Now.ToString("MM/dd/yyyy"); HttpContext.Current.Session["Pallet"] = data022.sqnb; HttpContext.Current.Session["Machine"] = _idaltticol022.getMachine(CLOT, ITEM.Trim().ToUpper(), ref strError); HttpContext.Current.Session["Operator"] = _operator; HttpContext.Current.Session["Reprint"] = "no"; StringBuilder script = new StringBuilder(); if (HttpContext.Current.Session["navigator"].ToString() == "EDG") { script.Append("myLabelFrame = document.getElementById('myLabelFrame'); myLabelFrame.src ='../Labels/RedesingLabels/4FinishedCupsME.aspx'; "); } else { script.Append("myLabelFrame = document.getElementById('myLabelFrame'); myLabelFrame.src ='../Labels/RedesingLabels/4FinishedCups.aspx'; "); } ScriptManager.RegisterStartupScript(this, this.GetType(), "printTag", script.ToString(), true); //StringBuilder script = new StringBuilder(); //script.Append("ventanaImp = window.open('../Labels/RedesingLabels/4FinishedCups.aspx', "); //script.Append("'ventanaImp', 'menubar=0,resizable=0,width=700,height=450');"); //script.Append("ventanaImp.moveTo(30, 0);"); ////script.Append("setTimeout (ventanaImp.close(), 20000);"); //ScriptManager.RegisterStartupScript(this, this.GetType(), "printTag", script.ToString(), true); //StringBuilder script = new StringBuilder(); //script.Append("ventanaImp = window.open('../Labels/whInvLabelFinishProduct.aspx', "); //script.Append("'ventanaImp', 'menubar=0,resizable=0,width=580,height=450');"); //script.Append("ventanaImp.moveTo(30, 0);"); ////script.Append("setTimeout (ventanaImp.close(), 20000);"); //ScriptManager.RegisterStartupScript(this, this.GetType(), "printTag", script.ToString(), true); } else { StringBuilder script = new StringBuilder(); string alert = "alert('" + strError.Replace("\n", "") + "')"; script.Append(alert); ScriptManager.RegisterStartupScript(this, this.GetType(), "printTag", script.ToString(), true); } } else { data042 = new Ent_tticol042() { pdno = CLOT == "" ? cyclecountLabel.Trim() + serie.Trim() : CLOT, //sqnb = (CLOT == "" ? cyclecountLabel : CLOT) + "-" + SecuenciaPallet, sqnb = sqnb, proc = 2, logn = HttpContext.Current.Session["user"].ToString(), mitm = ITEM.Trim(), qtdl = Convert.ToDouble(QTYS), cuni = CUNI, log1 = "NONE", qtd1 = Convert.ToDecimal(QTYS), pro1 = 2, log2 = "NONE", qtd2 = Convert.ToDecimal(QTYS), pro2 = 2, loca = " ", norp = 1, dele = 7, logd = "NONE", refcntd = 0, refcntu = 0, drpt = DateTime.Now, urpt = HttpContext.Current.Session["user"].ToString(), acqt = Convert.ToDouble(QTYS), cwaf = CWAR, cwat = CWAR, aclo = LOCA, allo = 0 }; HttpContext.Current.Session["strOrden"] = data042.pdno; HttpContext.Current.Session["strSecuen"] = data042.sqnb; HttpContext.Current.Session["itemId"] = data042.mitm; HttpContext.Current.Session["cantidad"] = data042.acqt; HttpContext.Current.Session["bodega"] = data042.cwaf; HttpContext.Current.Session["usuario"] = data042.urpt; HttpContext.Current.Session["fecha"] = data042.drpt; HttpContext.Current.Session["descItem"] = data042.mitm; HttpContext.Current.Session["unidad"] = data042.cuni; HttpContext.Current.Session["strTagId"] = ""; var validateSave = _idaltticol042.insertarRegistroSimpleD(ref data042, ref strError); var validateSaveTicol242 = _idaltticol042.InsertarRegistroTicol242(ref data042, ref strError); //return JsonConvert.SerializeObject(data042); if (Convert.ToBoolean(validateSave) && Convert.ToBoolean(validateSaveTicol242)) { HttpContext.Current.Session["MaterialDesc"] = data042.mitm; HttpContext.Current.Session["codeMaterial"] = data042.mitm; HttpContext.Current.Session["codePaid"] = data042.sqnb; HttpContext.Current.Session["Lot"] = CLOT; HttpContext.Current.Session["Quantity"] = data042.acqt + " " + data042.cuni; HttpContext.Current.Session["Date"] = DateTime.Now.ToString("MM/dd/yyyy"); HttpContext.Current.Session["Pallet"] = data042.sqnb; HttpContext.Current.Session["Machine"] = _idaltticol022.getMachine(CLOT, ITEM.Trim().ToUpper(), ref strError);; HttpContext.Current.Session["Operator"] = _operator; HttpContext.Current.Session["Reprint"] = "no"; StringBuilder script = new StringBuilder(); if (HttpContext.Current.Session["navigator"].ToString() == "EDG") { script.Append("myLabelFrame = document.getElementById('myLabelFrame'); myLabelFrame.src ='../Labels/RedesingLabels/4FinishedCupsME.aspx'; "); } else { script.Append("myLabelFrame = document.getElementById('myLabelFrame'); myLabelFrame.src ='../Labels/RedesingLabels/4FinishedCups.aspx'; "); } ScriptManager.RegisterStartupScript(this, this.GetType(), "printTag", script.ToString(), true); //StringBuilder script = new StringBuilder(); //script.Append("ventanaImp = window.open('../Labels/whInvLabelFinishProduct.aspx', "); //script.Append("'ventanaImp', 'menubar=0,resizable=0,width=580,height=450');"); //script.Append("ventanaImp.moveTo(30, 0);"); ////script.Append("setTimeout (ventanaImp.close(), 20000);"); //ScriptManager.RegisterStartupScript(this, this.GetType(), "printTag", script.ToString(), true); } } }
public static string Click_Save(string PAID, string ITEM, string CWAR, string LOCA, string UNIT, string QTYS, string CLOT, string ZONE, string USER) { string strError = string.Empty; //Valido si el articulo maneja lote Ent_ttcibd001 ObjTtcibd001 = new Ent_ttcibd001(); DataTable dtTtcibd001 = ITtcibd001.findItem(ITEM); if (dtTtcibd001.Rows.Count > 0) { ObjTtcibd001.item = dtTtcibd001.Rows[0]["ITEM"].ToString(); ObjTtcibd001.dsca = dtTtcibd001.Rows[0]["DSCA"].ToString(); ObjTtcibd001.cuni = dtTtcibd001.Rows[0]["CUNI"].ToString(); ObjTtcibd001.kltc = dtTtcibd001.Rows[0]["KLTC"].ToString(); ObjTtcibd001.kitm = dtTtcibd001.Rows[0]["KITM"].ToString(); if (ObjTtcibd001.kltc.Trim() == "1") { //Valido el Lote que exista en baan y este asociado al item Ent_tticol125 Obj_tticol125 = new Ent_tticol125(); Obj_tticol125.item = ITEM; Obj_tticol125.clot = CLOT; DataTable DtTticol125 = ITticol125.listaRegistrosLoteItem_Param(ref Obj_tticol125); if (DtTticol125.Rows.Count > 0) { Obj_tticol125.error = false; Obj_tticol125.typeMsgJs = "console"; Obj_tticol125.SuccessMsg = "Lote Encontrado"; } else { Obj_tticol125.error = true; Obj_tticol125.typeMsgJs = "label"; Obj_tticol125.SuccessMsg = Lotcodedoesntexist; return(JsonConvert.SerializeObject(Obj_tticol125)); } } } //Valido los datos de la bodega Ent_twhwmd200 Obj_twhwmd200 = new Ent_twhwmd200(); Ent_ttwhcol016 Obj_twhcol016 = new Ent_ttwhcol016(); Obj_twhcol016.cwar = CWAR; Obj_twhwmd200.cwar = CWAR; DataTable DtTtwhcol016 = ITtwhcol016.TakeMaterialInv_verificaBodega_Param(ref Obj_twhcol016, ref strError); DataTable DtTwhwmd200 = ITwhwmd200.listaRegistro_ObtieneAlmacenLocation(ref Obj_twhwmd200, ref strError); if (DtTtwhcol016.Rows.Count > 0) { Obj_twhcol016.error = false; Obj_twhcol016.typeMsgJs = "console"; Obj_twhcol016.SuccessMsg = "Warehouse Encontrado"; //if (CWAR != PCWAR) //{ // Obj_twhcol016.error = true; // Obj_twhcol016.typeMsgJs = "label"; // Obj_twhcol016.SuccessMsg = Warehousenotequalzone; // return JsonConvert.SerializeObject(Obj_twhcol016); //} if (DtTwhwmd200.Rows.Count > 0) { Obj_twhcol016.sloc = DtTwhwmd200.Rows[0]["LOC"].ToString(); } else { Obj_twhcol016.sloc = string.Empty; } } else { Obj_twhcol016.error = true; Obj_twhcol016.typeMsgJs = "label"; Obj_twhcol016.SuccessMsg = Warehousecodedoesntexist; return(JsonConvert.SerializeObject(Obj_twhcol016)); } if (Obj_twhcol016.sloc == "1") { //Valido que la ubicación sea válida. DataTable DtTransfer = Itransfer.ConsultarLocation(CWAR, LOCA); if (DtTransfer.Rows.Count > 0) { if (DtTransfer.Rows[0]["LOCT"].ToString() == "5") { if (DtTransfer.Rows[0]["BINB"].ToString() == "2") { Obj_twhwmd200.Error = false; Obj_twhwmd200.TypeMsgJs = "console"; Obj_twhwmd200.SuccessMsg = "Location Encontrado"; } else { Obj_twhwmd200.error = true; Obj_twhwmd200.typeMsgJs = "label"; Obj_twhwmd200.SuccessMsg = Locationcodedoesntexist; return(JsonConvert.SerializeObject(Obj_twhwmd200)); } } else { Obj_twhwmd200.error = true; Obj_twhwmd200.typeMsgJs = "label"; Obj_twhwmd200.SuccessMsg = Locationcodedoesntexist; return(JsonConvert.SerializeObject(Obj_twhwmd200)); } } else { Obj_twhwmd200.error = true; Obj_twhwmd200.typeMsgJs = "label"; Obj_twhwmd200.SuccessMsg = Locationcodedoesntexist; return(JsonConvert.SerializeObject(Obj_twhwmd200)); } } //Valido que exista un conteo activo para la bodega. Ent_twhcol002 ObjTwhcol002 = new Ent_twhcol002(); DataTable DTSecuenciaConteo = _idaltwhcol019.ConsecutivoConteo(CWAR, ref strError); string SecuenciaConteo = "0"; if (DTSecuenciaConteo.Rows.Count > 0) { SecuenciaConteo = DTSecuenciaConteo.Rows[0]["T$COUN"].ToString(); if (SecuenciaConteo == "0") { ObjTwhcol002.error = true; ObjTwhcol002.typeMsgJs = "label"; ObjTwhcol002.SuccessMsg = CountWarehouseNotDefined; return(JsonConvert.SerializeObject(ObjTwhcol002)); } } else { ObjTwhcol002.error = true; ObjTwhcol002.typeMsgJs = "label"; ObjTwhcol002.SuccessMsg = CountWarehouseNotDefined; return(JsonConvert.SerializeObject(ObjTwhcol002)); } DataTable DTPalletContinue = _idaltwhcol019.Consetwhcol019(PAID, ref strError); int SecuenciaPallet = 0; if (DTPalletContinue.Rows.Count > 0) { SecuenciaPallet = DTPalletContinue.Rows.Count + 1; } else { SecuenciaPallet = 1; } Ent_twhcol019 ObjTwhcol019 = new Ent_twhcol019(); QTYS = QTYS.Trim() == "" ? "0" : QTYS.Trim(); //QTYS = QTYS.Contains(".") == true ? QTYS.Replace(".", ",") : QTYS.Replace(",", "."); decimal QTYD = Convert.ToDecimal(QTYS); if (QTYD <= Convert.ToDecimal(0)) { ObjTwhcol019.error = false; ObjTwhcol019.typeMsgJs = "label"; ObjTwhcol019.SuccessMsg = Registeredquantitycannotbelessthanorequaltozero; return(JsonConvert.SerializeObject(ObjTwhcol019)); } //string CLOT = " "; ObjTwhcol019.PAID = PAID; ObjTwhcol019.SQNB = SecuenciaPallet;//Convert.ToInt32(PAID.Substring(10,3)); ObjTwhcol019.ZONE = ZONE; ObjTwhcol019.CWAR = CWAR; ObjTwhcol019.LOCA = Obj_twhcol016.sloc == "2" ? " ": LOCA.Trim() == "" ? " " : LOCA.Trim(); ObjTwhcol019.ITEM = ITEM; ObjTwhcol019.CLOT = CLOT.Trim() == "" ? " " : CLOT.Trim(); ObjTwhcol019.QTDL = QTYD; ObjTwhcol019.CUNI = UNIT; ObjTwhcol019.LOGN = USER.Trim() != "" ? USER.Trim() : HttpContext.Current.Session["user"].ToString().Trim(); ObjTwhcol019.DATE = new DateTime(); ObjTwhcol019.COUN = Convert.ToInt32(SecuenciaConteo); ObjTwhcol019.PROC = 0; ObjTwhcol019.REFCNTD = 0; ObjTwhcol019.REFCNTU = 0; bool res = _idaltwhcol019.insertRegistertwhcol019(ref ObjTwhcol019, ref strError); if (res) { ObjTwhcol019.error = false; ObjTwhcol019.typeMsgJs = "alert"; ObjTwhcol019.SuccessMsg = Therecordwassuccessfullyinserted; } else { ObjTwhcol019.error = true; ObjTwhcol019.typeMsgJs = "alert"; ObjTwhcol019.SuccessMsg = Therecordwasnotinserted + " " + strError; } return(JsonConvert.SerializeObject(ObjTwhcol019)); }