public static string VerificarQuantity(string CWAR, string ITEM, string LOCA = " ", string CLOT = " ")
{
string strError = string.Empty;
DataTable DtTtwhinr140 = ITtwhinr140.consultaPorAlmacenItemUbicacionLote(ref CWAR, ref ITEM, ref LOCA, ref PCLOT, ref strError);
Ent_twhinr140 ObjTtwhinr140 = new Ent_twhinr140();
if (DtTtwhinr140.Rows.Count > 0)
{
if (Convert.ToInt32(DtTtwhinr140.Rows[0]["STKS"].ToString()) < 1)
{
ObjTtwhinr140.Error = true;
ObjTtwhinr140.TypeMsgJs = "label";
ObjTtwhinr140.ErrorMsg = RegisteredquantitynotavilableonBaaninventory;
}
else
{
ObjTtwhinr140.stks = Convert.ToInt32(DtTtwhinr140.Rows[0]["STKS"].ToString());
ObjTtwhinr140.Error = false;
ObjTtwhinr140.TypeMsgJs = "label";
ObjTtwhinr140.SuccessMsg = RegisteredquantitynotavilableonBaaninventory;
}
}
else
{
ObjTtwhinr140.Error = true;
ObjTtwhinr140.TypeMsgJs = "label";
ObjTtwhinr140.ErrorMsg = RegisteredquantitynotavilableonBaaninventory;
}
return(JsonConvert.SerializeObject(ObjTtwhinr140));
}
public static string VerificarQuantity(string QTY)
{
//LOCA = LOCA.Trim() == "" ? " " : LOCA.Trim();
//CLOT = CLOT.Trim() == "" ? " " : CLOT.Trim();
//string strError = string.Empty;
//DataTable DtTtwhinr140 = ITtwhinr140.consultaPorAlmacenItemUbicacionLote(ref CWAR, ref ITEM, ref LOCA, ref PCLOT, ref strError);
Ent_twhinr140 ObjTtwhinr140 = new Ent_twhinr140();
QTY = QTY.Trim() == "" ? "0" : QTY.Trim();
QTY = QTY.Contains(".") == true?QTY.Replace(".", ",") : QTY.Replace(",", ".");
if (Convert.ToDecimal(QTY) <= 0)
{
ObjTtwhinr140.error = true;
ObjTtwhinr140.typeMsgJs = "label";
ObjTtwhinr140.errorMsg = Registeredquantitycannotbelessthanorequaltozero;
}
else
{
ObjTtwhinr140.error = false;
ObjTtwhinr140.typeMsgJs = "label";
ObjTtwhinr140.errorMsg = Registeredquantitycannotbelessthanorequaltozero;
}
return(JsonConvert.SerializeObject(ObjTtwhinr140));
}
public DataTable listaRegistros_ObtieneItem(ref Ent_twhinr140 ParametrosIn, ref string strError)
{
method = MethodBase.GetCurrentMethod();
paramList = new Dictionary <string, object>();
paramList.Add(":T$LOCA", ParametrosIn.loca.Trim().ToUpperInvariant());
paramList.Add(":T$CLOT", 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 = "That Lot doesn't have Item Asociated.";
}
}
catch (Exception ex)
{
strError = "Error when querying data [twhinr140]. Try again or contact your administrator \n " + strSentencia;
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(consulta);
}
public static string VerificarQuantity(string CWAR, string ITEM, string CLOT, string LOCA, string QTYS)
{
decimal factor = 0;
string strError = string.Empty;
DataTable DtTtwhinr140 = new DataTable();
Ent_twhinr140 ObjTtwhinr140 = new Ent_twhinr140();
if (HttpContext.Current.Session["CUNI"].ToString().Trim() == "CJ" || Convert.ToInt32(QTYS) == 0)
{
if (Convert.ToInt32(QTYS) != 0)
{
DataTable dtFactor = twhcol130DAL.ConsultafactoresporItem(ITEM.Trim());
if (dtFactor.Rows.Count > 0)
{
foreach (DataRow row in dtFactor.Rows)
{
if (row["UNIT"].ToString().Trim() == "PLT" && row["BASU"].ToString().Trim() == HttpContext.Current.Session["CUNI"].ToString().Trim())
{
factor = Convert.ToDecimal(row["FACTOR"].ToString().Trim());
}
}
if (factor > 0)
{
if (Convert.ToDecimal(QTYS) > factor)
{
ObjTtwhinr140.TypeMsgJs = "label";
ObjTtwhinr140.Error = true;
ObjTtwhinr140.ErrorMsg = qtygreaterfactor;
}
}
else
{
ObjTtwhinr140.TypeMsgJs = "label";
ObjTtwhinr140.Error = true;
ObjTtwhinr140.ErrorMsg = FactordontexistforthisItem;
}
if (Convert.ToInt32(QTYS) == 0)
{
ObjTtwhinr140.Error = false;
}
}
}
else
{
ObjTtwhinr140.Error = false;
}
}
HttpContext.Current.Session["QTYS"] = QTYS;
return(JsonConvert.SerializeObject(ObjTtwhinr140));
}
public DataTable listaRegistros_ObtieneItem(ref Ent_twhinr140 Parametros, ref string strError)
{
//int retorno = -1;
DataTable retorno;
try
{
retorno = dal.listaRegistros_ObtieneItem(ref Parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
public static string VerificarQuantity(string CWAR, string ITEM, string CLOT, string LOCA)
{
string strError = string.Empty;
DataTable DtTtwhinr140 = new DataTable();
//CWAR = CWAR.ToUpper();
//ITEM = ITEM.ToUpper();
//CLOT = CLOT.ToUpper();
//LOCA = LOCA.ToUpper();
//DtTtwhinr140 = ITtwhinr140.consultaStks(ref CWAR, ref ITEM, ref CLOT, ref LOCA, ref strError);
Ent_twhinr140 ObjTtwhinr140 = new Ent_twhinr140();
//if (DtTtwhinr140.Rows.Count > 0)
//{
// decimal stks = Convert.ToDecimal(DtTtwhinr140.Rows[0]["STKS"].ToString());
// if (stks > 0)
// {
// ObjTtwhinr140.stks = stks;
// ObjTtwhinr140.Error = false;
// ObjTtwhinr140.TypeMsgJs = "label";
// ObjTtwhinr140.SuccessMsg = RegisteredquantitynotavilableonBaaninventory;
// }
// else
// {
// ObjTtwhinr140.Error = true;
// ObjTtwhinr140.TypeMsgJs = "label";
// ObjTtwhinr140.ErrorMsg = RegisteredquantitynotavilableonBaaninventory;
// }
//}
//else
//{
// ObjTtwhinr140.Error = true;
// ObjTtwhinr140.TypeMsgJs = "label";
// ObjTtwhinr140.ErrorMsg = RegisteredquantitynotavilableonBaaninventory;
//}
return(JsonConvert.SerializeObject(ObjTtwhinr140));
}
