public DataTable listaRegistro_ObtieneConteo(ref Ent_twhcol002 Parametros, ref string strError) { DataTable retorno; try { retorno = dal.listaRegistro_ObtieneConteo(ref Parametros, ref strError); return(retorno); } catch (Exception ex) { throw new Exception(ex.InnerException.ToString()); } }
public DataTable listaRegistro_ObtieneConteo(ref Ent_twhcol002 Parametros, ref string strError) { method = MethodBase.GetCurrentMethod(); paramList = new Dictionary <string, object>(); paramList.Add(":T$CWAR", Parametros.cwar.Trim()); strSQL = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList); try { consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSQL, ref parametersOut, null, true); if (consulta.Rows.Count < 1) { strError = "There is no active count for the warehouse." + Parametros.cwar.Trim(); } } catch (Exception ex) { strError = "Error to the search sequence [twhcol002]. 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(consulta); }
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)); }