public static string VerificarLocation(string CWAR, string LOCA)
{
string strError = string.Empty;
Ent_twhwmd200 Obj_twhwmd200 = new Ent_twhwmd200();
Obj_twhwmd200.cwar = CWAR;
DataTable DtTransfer = Itransfer.ConsultarLocation(Obj_twhwmd200.cwar, LOCA);
if (DtTransfer.Rows.Count > 0)
{
if (DtTransfer.Rows[0]["LOCT"].ToString() == "5")
{
Obj_twhwmd200.Error = false;
Obj_twhwmd200.TypeMsgJs = "console";
Obj_twhwmd200.SuccessMsg = "Location Encontrado";
}
else
{
Obj_twhwmd200.Error = true;
Obj_twhwmd200.TypeMsgJs = "label";
Obj_twhwmd200.ErrorMsg = LocationCodeDoesntExist;
}
}
else
{
Obj_twhwmd200.Error = true;
Obj_twhwmd200.TypeMsgJs = "label";
Obj_twhwmd200.ErrorMsg = codeDoesntExist;
}
return(JsonConvert.SerializeObject(Obj_twhwmd200));
}
public static string VerificarLocation(string CWAR, string LOCA)
{
Ent_twhcol130131 MyObj131Base = (Ent_twhcol130131)HttpContext.Current.Session["MyPalletTwhcol13"];
string strError = string.Empty;
Ent_twhwmd200 Obj_twhwmd200 = new Ent_twhwmd200();
Obj_twhwmd200.cwar = CWAR;
DataTable DtTransfer = Itransfer.ConsultarLocation(Obj_twhwmd200.cwar, LOCA);
if (DtTransfer.Rows.Count > 0)
{
if (DtTransfer.Rows[0]["LOCT"].ToString() == "5")
{
if (DtTransfer.Rows[0]["BINB"].ToString() == "2")
{
if (MyObj131Base.LOCA.ToUpper().Trim() != LOCA.ToUpper().Trim())
{
Obj_twhwmd200.Error = false;
Obj_twhwmd200.TypeMsgJs = "console";
Obj_twhwmd200.SuccessMsg = "Location Encontrado";
}
else
{
Obj_twhwmd200.Error = true;
Obj_twhwmd200.TypeMsgJs = "label";
Obj_twhwmd200.ErrorMsg = "Warehouse / Location can't be the same";
}
}
else
{
Obj_twhwmd200.Error = true;
Obj_twhwmd200.TypeMsgJs = "label";
Obj_twhwmd200.ErrorMsg = Locationblockedinbound;
}
}
else
{
Obj_twhwmd200.Error = true;
Obj_twhwmd200.TypeMsgJs = "label";
Obj_twhwmd200.ErrorMsg = Locationcodedoesntexist;
}
}
else
{
Obj_twhwmd200.Error = true;
Obj_twhwmd200.TypeMsgJs = "label";
Obj_twhwmd200.ErrorMsg = Locationcodedoesntexist;
}
return(JsonConvert.SerializeObject(Obj_twhwmd200));
}
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 DataTable listaRegistro_ObtieneAlmacenLocation(ref Ent_twhwmd200 Parametros, ref string strError)
{
DataTable retorno;
try
{
retorno = dal.listaRegistro_ObtieneAlmacenLocation(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 VerificarLocation(string CWAR, string LOCA, string ROW)
{
string strError = string.Empty;
Ent_twhwmd200 Obj_twhwmd200 = new Ent_twhwmd200();
Obj_twhwmd200.cwar = CWAR.ToUpper();
Obj_twhwmd200.row = ROW;
DataTable DtTransfer = Itransfer.ConsultarLocation(Obj_twhwmd200.cwar, LOCA.ToUpper());
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.ErrorMsg = "Location blocked inbound";
}
}
else
{
Obj_twhwmd200.Error = true;
Obj_twhwmd200.TypeMsgJs = "label";
Obj_twhwmd200.ErrorMsg = "Location code doesnt exist";
}
}
else
{
Obj_twhwmd200.Error = true;
Obj_twhwmd200.TypeMsgJs = "label";
Obj_twhwmd200.ErrorMsg = "Location code doesnt exist";
}
return(JsonConvert.SerializeObject(Obj_twhwmd200));
}
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 DataTable listaRegistro_ObtieneAlmacenLocation(ref Ent_twhwmd200 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 = "Warehouse incorrect, please check.";
}
}
catch (Exception ex)
{
strError = "Error to the search sequence [twhwmd200]. 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 InsertarReseiptRawMaterial(string OORG, string ORNO, string ITEM, string PONO, string LOT, decimal QUANTITY, string STUN, string CUNI, string CWAR, string FIRE, string PSLIP)
{
//string PSLIP = string.Empty;
PSLIP = PSLIP.Trim() == string.Empty ? " " : PSLIP.Trim();
decimal QUANTITYAUX = QUANTITY;
string Retrono = "El Registro no se ha insertado";
Factor MyConvertionFactor = new Factor {
};
if (CUNI != STUN)
{
MyConvertionFactor = FactorConversion(ITEM, STUN, CUNI);
QUANTITY = (MyConvertionFactor.Tipo == "Div") ? Convert.ToDecimal((QUANTITY * MyConvertionFactor.FactorB) / MyConvertionFactor.FactorD) : Convert.ToDecimal((QUANTITY * MyConvertionFactor.FactorD) / MyConvertionFactor.FactorB);
}
if (MyConvertionFactor.FactorD != null || CUNI == STUN)
{
if (OORG == "2")
{
DataTable DTOrdencompra = ConsultaOrdencompra(ORNO, PONO, QUANTITYAUX, ITEM, "");
if (DTOrdencompra.Rows.Count > 0)
{
bool OrdenImportacion = false;
OrdenImportacion = twhcol130DAL.ConsultaOrdenImportacion(DTOrdencompra.Rows[0]["T$COTP"].ToString()).Rows.Count > 0 ? true : false;
int consecutivoPalletID = 0;
DataTable DTPalletContinue = twhcol130DAL.PaidMayorwhcol130(ORNO);
string SecuenciaPallet = "001";
if (DTPalletContinue.Rows.Count > 0)
{
foreach (DataRow item in DTPalletContinue.Rows)
{
consecutivoPalletID = Convert.ToInt32(item["T$PAID"].ToString().Trim().Substring(10, 3)) + 1;
if (consecutivoPalletID.ToString().Length == 1)
{
SecuenciaPallet = "00" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 2)
{
SecuenciaPallet = "0" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 3)
{
SecuenciaPallet = consecutivoPalletID.ToString();
}
}
}
string LOCAL = string.Empty;
string PRIORIDAD = string.Empty;
Ent_twhcol130131 MyObjError = new Ent_twhcol130131();
try
{
string strError = string.Empty;
Ent_twhwmd200 OBJ200 = new Ent_twhwmd200 {
cwar = DTOrdencompra.Rows[0]["T$CWAR"].ToString().Trim()
};
DataTable Dttwhwmd200 = twhwmd200.listaRegistro_ObtieneAlmacenLocation(ref OBJ200, ref strError);
if (Dttwhwmd200.Rows.Count > 0)
{
if (Dttwhwmd200.Rows[0]["LOC"].ToString().Trim() == "1")
{
PRIORIDAD = twhcol130DAL.ConsultarPrioridadNativa(DTOrdencompra.Rows[0]["T$CWAR"].ToString().Trim()).Rows[0]["T$PRIO"].ToString().Trim();
LOCAL = twhcol130DAL.ConsultarLocationNativa(DTOrdencompra.Rows[0]["T$CWAR"].ToString().Trim(), PRIORIDAD).Rows[0]["T$LOCA"].ToString().Trim();
}
}
}
catch (Exception ex)
{
//LOCAL = " ";
MyObjError.error = true;
MyObjError.errorMsg = "Prior inbound not found";
return(JsonConvert.SerializeObject(MyObjError));
}
Ent_twhcol130131 MyObj = new Ent_twhcol130131
{
OORG = OORG,// Order type escaneada view
ORNO = DTOrdencompra.Rows[0]["T$ORNO"].ToString(),
ITEM = DTOrdencompra.Rows[0]["T$ITEM"].ToString(),
PAID = DTOrdencompra.Rows[0]["T$ORNO"].ToString() + "-" + SecuenciaPallet,
PONO = DTOrdencompra.Rows[0]["T$PONO"].ToString(),
SEQN = DTOrdencompra.Rows[0]["T$SQNBR"].ToString(),
CLOT = LOT, // lote VIEW
CWAR = DTOrdencompra.Rows[0]["T$CWAR"].ToString(),
QTYS = QUANTITYAUX.ToString("0.0000"), // cantidad escaneada view
UNIT = STUN, //unit escaneada view
QTYC = QUANTITY.ToString("0.0000"), //cantidad escaneada view aplicando factor
UNIC = CUNI, //unidad view stock
DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //fecha de confirmacion
CONF = "1",
RCNO = " ", //llena baan
DATR = "01/01/70", //llena baan
LOCA = LOCAL, // 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 = "0", // LLENAR EN 1
ALLO = "0",
DSCA = DTOrdencompra.Rows[0]["DSCA"].ToString(),
COTP = DTOrdencompra.Rows[0]["T$COTP"].ToString(),
FIRE = FIRE,
PSLIP = PSLIP.ToUpper(),
PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + DTOrdencompra.Rows[0]["T$ORNO"].ToString() + "-" + SecuenciaPallet + "&code=Code128&dpi=96",
ORNO_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + DTOrdencompra.Rows[0]["T$ORNO"].ToString() + "&code=Code128&dpi=96",
ITEM_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + DTOrdencompra.Rows[0]["T$ITEM"].ToString().Trim().ToUpper() + "&code=Code128&dpi=96",
CLOT_URL = LOT.ToString().Trim() != "" ? UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + LOT.ToString().Trim().ToUpper() + "&code=Code128&dpi=96" : "",
QTYC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + QUANTITY.ToString("0.0000").Trim().ToUpper() + "&code=Code128&dpi=96",
UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + STUN.ToString().Trim().ToUpper() + "&code=Code128&dpi=96"
};
if (OrdenImportacion)
{
DataTable ConsultaPresupuestoImportacion = twhcol130DAL.ConsultaPresupuestoImportacion(ORNO);
if (ConsultaPresupuestoImportacion.Rows.Count > 0 && ConsultaPresupuestoImportacion.Rows[0]["pres"].ToString().Trim() == "3")
{
bool Insertsucces = twhcol130DAL.InsertarReseiptRawMaterial(MyObj);
if (Insertsucces)
{
Retrono = JsonConvert.SerializeObject(MyObj);
}
else
{
MyObj.error = true;
MyObj.errorMsg = "la insercion fue: " + Insertsucces.ToString();
Retrono = JsonConvert.SerializeObject(MyObj);
}
}
else
{
MyObj.error = true;
MyObj.errorMsg = "Import PO, Budget is not closed. PO cannot be recived";
Retrono = JsonConvert.SerializeObject(MyObj);
}
}
else
{
bool Insertsucces = twhcol130DAL.InsertarReseiptRawMaterial(MyObj);
if (Insertsucces)
{
Retrono = JsonConvert.SerializeObject(MyObj);
}
else
{
MyObj.error = true;
MyObj.errorMsg = "la insercion fue: " + Insertsucces.ToString();
Retrono = JsonConvert.SerializeObject(MyObj);
}
}
}
}
else
{
DataTable DTNOOrdencompra = ConsultaNOOrdencompra(ORNO, PONO, OORG, QUANTITY, ITEM, LOT);
bool ExistenciaLot = ValidarLote(ITEM, LOT);
if (DTNOOrdencompra.Rows.Count > 0 && (ExistenciaLot == true || DTNOOrdencompra.Rows[0]["KLTC"].ToString().Trim() != "1"))
{
int consecutivoPalletID = 0;
DataTable DTPalletContinue = twhcol130DAL.PaidMayorwhcol130(ORNO);
string SecuenciaPallet = "001";
if (DTPalletContinue.Rows.Count > 0)
{
foreach (DataRow item in DTPalletContinue.Rows)
{
consecutivoPalletID = Convert.ToInt32(item["T$PAID"].ToString().Trim().Substring(10, 3)) + 1;
if (consecutivoPalletID.ToString().Length == 1)
{
SecuenciaPallet = "00" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 2)
{
SecuenciaPallet = "0" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 3)
{
SecuenciaPallet = consecutivoPalletID.ToString();
}
}
}
string LOCAL = string.Empty;
string PRIORIDAD = string.Empty;
Ent_twhcol130131 MyObjError = new Ent_twhcol130131();
try
{
PRIORIDAD = twhcol130DAL.ConsultarPrioridadNativa(DTNOOrdencompra.Rows[0]["T$CWAR"].ToString().Trim()).Rows[0]["T$PRIO"].ToString().Trim();
LOCAL = twhcol130DAL.ConsultarLocationNativa(DTNOOrdencompra.Rows[0]["T$CWAR"].ToString().Trim()).Rows[0]["T$LOCA"].ToString().Trim();
}
catch (Exception ex)
{
//LOCAL = " ";
MyObjError.error = true;
MyObjError.errorMsg = "Prior inbound not found";
return(JsonConvert.SerializeObject(MyObjError));
}
Ent_twhcol130131 MyObj = new Ent_twhcol130131
{
OORG = OORG,// Order type escaneada view
ORNO = DTNOOrdencompra.Rows[0]["T$ORNO"].ToString(),
ITEM = DTNOOrdencompra.Rows[0]["T$ITEM"].ToString(),
PAID = DTNOOrdencompra.Rows[0]["T$ORNO"].ToString() + "-" + SecuenciaPallet,
PONO = DTNOOrdencompra.Rows[0]["T$PONO"].ToString(),
SEQN = DTNOOrdencompra.Rows[0]["T$SEQN"].ToString(),
CLOT = LOT, // lote VIEW
CWAR = DTNOOrdencompra.Rows[0]["T$CWAR"].ToString(),
QTYS = QUANTITYAUX.ToString("0.0000"), // cantidad escaneada view
UNIT = STUN, //unidad view stock
QTYC = QUANTITY.ToString("0.0000"), //cantidad escaneada view aplicando factor
UNIC = CUNI, //unit escaneada view
DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //fecha de confirmacion
CONF = "1",
RCNO = " ", //llena baan
DATR = "01/01/70", //llena baan
LOCA = LOCAL, // 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 = "0", // LLENAR EN 1
ALLO = "0",
DSCA = DTNOOrdencompra.Rows[0]["T$DSCA"].ToString(),
FIRE = FIRE,
PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + DTNOOrdencompra.Rows[0]["T$ORNO"].ToString() + "-" + SecuenciaPallet + "&code=Code128&dpi=96",
ORNO_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + DTNOOrdencompra.Rows[0]["T$ORNO"].ToString() + "&code=Code128&dpi=96",
ITEM_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + DTNOOrdencompra.Rows[0]["T$ITEM"].ToString().Trim().ToUpper() + "&code=Code128&dpi=96",
CLOT_URL = LOT.ToString().Trim() != "" ? UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + LOT.ToString().Trim().ToUpper() + "&code=Code128&dpi=96" : "",
QTYC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + QUANTITY.ToString("0.0000").Trim().ToUpper() + "&code=Code128&dpi=96",
UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + STUN.ToString().Trim().ToUpper() + "&code=Code128&dpi=96"
};
bool Insertsucces = twhcol130DAL.InsertarReseiptRawMaterial(MyObj);
if (Insertsucces)
{
Retrono = JsonConvert.SerializeObject(MyObj);
}
else
{
MyObj.error = true;
MyObj.errorMsg = "la insercion fue:" + Insertsucces.ToString();
Retrono = JsonConvert.SerializeObject(MyObj);
}
}
else
{
Ent_twhcol130131 MyObj = new Ent_twhcol130131
{
error = true,
errorMsg = "The lot does not correspond to the order"
};
Retrono = JsonConvert.SerializeObject(MyObj);
}
}
}
return(Retrono);
}
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));
}
protected void btnConsultar_Click(object sender, EventArgs e)
{
lblError.Text = String.Empty;
var item = txtItem.Text.Trim().ToUpper();
var warehouse = txtWarehouse.Text.Trim().ToUpper();
var location = txtLocation.Text.Trim().ToUpper();
var lot = txtLot.Text.Trim().ToUpper();
if (string.IsNullOrEmpty(txtLot.Text.Trim().ToUpper()) == true)
{
Session["Lot"] = string.Empty;
}
else
{
Session["Lot"] = txtLot.Text.Trim().ToUpper();
}
Ent_ttcibd001 data001 = new Ent_ttcibd001()
{
item = item
};
_validaItem = _idalttcibd001.listaRegistro_ObtieneDescripcionUnidad(ref data001, ref strError);
if (_validaItem.Rows.Count < 1)
{
lblError.Text = mensajes("itemnotexists");
return;
}
var kltc = Convert.ToInt32(_validaItem.Rows[0]["KLTC"].ToString());
manejalote = kltc;
_validaWarehouse = _idalttcmcs003.findRecordByCwar(ref warehouse, ref strError);
if (_validaWarehouse.Rows.Count < 1)
{
lblError.Text = mensajes("warehousenotexists");
return;
}
Ent_twhwmd200 data200 = new Ent_twhwmd200()
{
cwar = warehouse
};
var manejoUbicacionAlmacen = Convert.ToInt32(_idaltwhwmd200.listaRegistro_ObtieneAlmacenLocation(ref data200, ref strError).Rows[0]["LOC"]);
manejaubicacion = manejoUbicacionAlmacen;
if (manejoUbicacionAlmacen == 1)
{
_validaUbicacion = _idaltwhwmd300.validateExistsLocation(ref location, ref warehouse, ref strError);
if (_validaUbicacion.Rows.Count < 1)
{
lblError.Text = mensajes("Location doesn't exist.");
return;
}
}
if (kltc == 1)
{
Ent_twhltc100 data100 = new Ent_twhltc100()
{
item = item, clot = lot
};
_validaItemLote = _idaltwhltc100.listaRegistro_Clot(ref data100, ref strError);
if (_validaItemLote.Rows.Count < 1)
{
lblError.Text = mensajes("lotnotexists");
return;
}
}
var consultaCantidad = new DataTable();
if (manejoUbicacionAlmacen == 1)
{
if (kltc == 1)
{
consultaCantidad = _idaltwhinr140.consultaPorAlmacenItemUbicacionLote(ref warehouse, ref item, ref location, ref lot, ref strError);
}
else
{
consultaCantidad = _idaltwhinr140.consultaPorAlmacenItemUbicacion(ref warehouse, ref item, ref location, ref strError);
}
}
else
{
if (kltc == 1)
{
consultaCantidad = _idaltwhinr140.consultaPorAlmacenItemLote(ref warehouse, ref item, ref lot, ref strError);
}
else
{
consultaCantidad = _idaltwhinr140.consultaCantidadItemLote(ref warehouse, ref item, ref strError);
}
}
//_stock = (Decimal)0;
if (consultaCantidad.Rows.Count > 0)
{
//_stock = Convert.ToDecimal(consultaCantidad.Rows[0]["STKS"].ToString());
_stock = consultaCantidad.Rows[0]["STKS"].ToString();
}
//if (_stock == 0)
if (_stock == "0")
{
lblError.Text = mensajes("notstock");
return;
}
divBotones.Visible = false;
divLabel.Visible = false;
divBtnGuardar.Visible = true;
makeTable();
}
protected void btnConsultarSource_Click(object sender, EventArgs e)
{
lblConfirm.Text = String.Empty;
lblError.Text = String.Empty;
if (txtUbicacion.Text.Trim() != String.Empty)
{
var CWAR = txtSourceLocation.Text.Trim().ToUpper();
Ent_twhwmd200 datamd200 = new Ent_twhwmd200()
{
cwar = CWAR
};
var consultaAlmacen = _idaltwhwmd200.listaRegistro_ObtieneAlmacenLocation(ref datamd200, ref strError);
if (consultaAlmacen.Rows.Count > 0)
{
var clot = txtNumeroLote.Text.Trim().ToUpper();
var item = txtItem.Text.Trim().ToUpper();
var cwar = txtSourceLocation.Text.Trim().ToUpper();
var loca = txtUbicacion.Text.Trim().ToUpper();
var consultaInfoUbicacion = _idaltwhwmd300.consultaPorAlmacenUbicacion(ref clot, ref item, ref cwar, ref loca, ref strError).Rows;
if (consultaInfoUbicacion.Count > 0)
{
var loct = Convert.ToInt32(consultaInfoUbicacion[0]["LOCT"]);
var btri = Convert.ToInt32(consultaInfoUbicacion[0]["BTRI"]);
var qtydisp = consultaInfoUbicacion[0]["QTYDISP"].ToString();
var factor = hdfFactor.Value;
var unidad = hdfUnidad.Value;
if (loct != 5)
{
lblError.Text = String.Format(mensajes("locationnotload"), loca);
return;
}
if (btri != 2)
{
lblError.Text = String.Format(mensajes("locationblock"), loca);
return;
}
if ((float.Parse(qtydisp, CultureInfo.InvariantCulture.NumberFormat) == 0))
{
lblError.Text = mensajes("itemunavailable");
return;
}
var cantplt = 0.0;
if (factor.Trim() != String.Empty)
{
cantplt = Math.Round((float.Parse(qtydisp, CultureInfo.InvariantCulture.NumberFormat) / float.Parse(factor, CultureInfo.InvariantCulture.NumberFormat)), 2);
}
else
{
cantplt = Math.Round((float.Parse(qtydisp, CultureInfo.InvariantCulture.NumberFormat) / 1), 2);
}
txtCantidadUnidad.Text = qtydisp + " - " + unidad;
txtCantidad.Text = cantplt.ToString();
txtUbicacion.Enabled = false;
trCantidadUnidad.Visible = true;
trCantidad.Visible = true;
trDestination.Visible = true;
trCantidadTransferir.Visible = true;
btnConsultarSource.Visible = false;
btnActualizar.Visible = true;
}
else
{
txtCantidadUnidad.Text = String.Empty;
txtCantidad.Text = String.Empty;
txtUbicacion.Enabled = true;
trCantidadUnidad.Visible = false;
trCantidad.Visible = false;
trDestination.Visible = false;
trCantidadTransferir.Visible = false;
btnConsultarSource.Visible = true;
btnActualizar.Visible = false;
lblError.Text = mensajes("locationnotexists");
return;
}
}
else
{
lblError.Text = mensajes("warehousenotexists");
return;
}
}
else
{
lblError.Text = mensajes("formempty");
return;
}
}
public static string InsertarReseiptRawMaterial(string OORG, string ORNO, string ITEM, string PONO, string LOT, decimal QUANTITY, string STUN, string PALLET, string UNIT)
{
//if (string.IsNullOrEmpty(ORNO.Trim()))
//{
// //RequiredField.Enabled = true;
// //RequiredField.IsValid = false;
// txtPalletIDValue.Focus();
// lblError.Text = mensajes("Palletnotpresent");
// // grdRecords.DataSource = "";
// // grdRecords.DataBind();
// return;
//}
//var ORNO = lblreturnorderValue.Text.Trim().ToUpper();
//var PONO = dropDownPosition.Text;
//var QUANTITYAUX = Convert.ToInt32(lblqtyValue1.Value.ToString());
//var ITEM = lblItemValue1.Value.Trim().ToString().ToUpper();
Ent_twhcol130131 MyObj = new Ent_twhcol130131();
decimal QUANTITYAUX = QUANTITY;
LOT = LOT.Trim() == string.Empty ? " " : LOT.Trim();
string Retrono = "El Registro no se ha insertado";
DataTable DTOrdencompra = ConsultaOrdencompra(ORNO, PONO, QUANTITYAUX, ITEM, "");
//DataTable DTOrdencompra = ConsultaPOReturn(ORNO, PONO, QUANTITYAUX, ITEM, "");
if (DTOrdencompra.Rows.Count > 0) //Changes
{
bool OrdenImportacion = false;
OrdenImportacion = twhcol130DAL.ConsultaOrdenImportacion(DTOrdencompra.Rows[0]["T$COTP"].ToString()).Rows.Count > 0 ? true : false;
string LOCAL = string.Empty;
string PRIORIDAD = string.Empty;
Ent_twhcol130131 MyObjError = new Ent_twhcol130131();
try
{
string strError = string.Empty;
Ent_twhwmd200 OBJ200 = new Ent_twhwmd200 {
cwar = DTOrdencompra.Rows[0]["T$CWAR"].ToString().Trim()
};
DataTable Dttwhwmd200 = twhwmd200.listaRegistro_ObtieneAlmacenLocation(ref OBJ200, ref strError);
if (Dttwhwmd200.Rows.Count > 0)
{
if (Dttwhwmd200.Rows[0]["LOC"].ToString().Trim() == "1")
{
PRIORIDAD = twhcol130DAL.ConsultarPrioridadNativa(DTOrdencompra.Rows[0]["T$CWAR"].ToString().Trim()).Rows[0]["T$PRIO"].ToString().Trim();
LOCAL = twhcol130DAL.ConsultarLocationNativa(DTOrdencompra.Rows[0]["T$CWAR"].ToString().Trim(), PRIORIDAD).Rows[0]["T$LOCA"].ToString().Trim();
}
}
}
catch (Exception ex)
{
//LOCAL = " ";
MyObjError.error = true;
MyObjError.errorMsg = Priorinboundnotfound;
//return MyObjError;
}
// var OORG = 2;
var FIRE = 2;
MyObj.OORG = OORG.ToString();// Order type escaneada view
MyObj.ORNO = DTOrdencompra.Rows[0]["T$ORNO"].ToString();
MyObj.ITEM = DTOrdencompra.Rows[0]["T$ITEM"].ToString().Trim();
MyObj.PAID = PALLET;
MyObj.PONO = DTOrdencompra.Rows[0]["T$PONO"].ToString();
MyObj.SEQN = DTOrdencompra.Rows[0]["T$SQNBR"].ToString();
MyObj.CLOT = LOT; // lote VIEW
MyObj.CWAR = DTOrdencompra.Rows[0]["T$CWAR"].ToString();
MyObj.QTYS = QUANTITYAUX.ToString("0.00"); // cantidad escaneada view
MyObj.UNIT = STUN; //unit escaneada view
MyObj.QTYC = QUANTITYAUX.ToString("0.00"); //cantidad escaneada view aplicando factor
MyObj.UNIC = UNIT; //unidad view stock
MyObj.DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString(); //fecha de confirmacion
MyObj.CONF = "1";
MyObj.RCNO = " "; //llena baan
MyObj.DATR = "01/01/70"; //llena baan
MyObj.LOCA = LOCAL; // enviamos vacio
MyObj.DATL = DateTime.Now.ToString("dd/MM/yyyy").ToString(); //llenar con fecha de hoy
MyObj.PRNT = "1"; // llenar en 1
MyObj.DATP = DateTime.Now.ToString("dd/MM/yyyy").ToString(); //llena baan
MyObj.NPRT = "1"; //conteo de reimpresiones
MyObj.LOGN = HttpContext.Current.Session["user"].ToString(); // nombre de ususario de la session
MyObj.LOGT = " "; //llena baan
MyObj.STAT = "0"; // LLENAR EN 1
MyObj.DSCA = DTOrdencompra.Rows[0]["DSCA"].ToString();
MyObj.COTP = DTOrdencompra.Rows[0]["T$COTP"].ToString();
MyObj.FIRE = FIRE.ToString();
MyObj.PSLIP = "";
MyObj.ALLO = "0";
MyObj.PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + PALLET.ToString() + "&code=Code128&dpi=96";
MyObj.ORNO_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + DTOrdencompra.Rows[0]["T$ORNO"].ToString() + "&code=Code128&dpi=96";
MyObj.ITEM_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + DTOrdencompra.Rows[0]["T$ITEM"].ToString().Trim().ToUpper() + "&code=Code128&dpi=96";
MyObj.CLOT_URL = LOT.ToString().Trim() != "" ? UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + LOT.ToString().Trim().ToUpper() + "&code=Code128&dpi=96" : "";
MyObj.QTYC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + QUANTITYAUX.ToString("0.00").Trim().ToUpper() + "&code=Code128&dpi=96";
MyObj.UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + UNIT.ToString().Trim().ToUpper() + "&code=Code128&dpi=96";
//if (OrdenImportacion)
//{
var i = 1;
int PRIO = 1;
Ent_tticol082 Objtticol082 = new Ent_tticol082
{
OORG = OORG.ToString(),
ORNO = MyObj.ORNO,
OSET = DTOrdencompra.Rows[0]["T$OSET"].ToString(),
PONO = MyObj.PONO,
SQNB = MyObj.SEQN,
ADVS = i.ToString(),
ITEM = MyObj.ITEM,
STAT = "2",
QTYT = QUANTITYAUX.ToString("0.00"),
CWAR = DTOrdencompra.Rows[0]["T$CWAR"].ToString(),
UNIT = MyObj.UNIT,
PRIO = PRIO.ToString(),
PAID = PALLET,
LOGN = HttpContext.Current.Session["user"].ToString(),
};
bool InsertSuccess = Itticol082.InsertarregistroItticol082(Objtticol082);
if (InsertSuccess)
{
//Update pallet ID status to “Picked” (whcol131.stat).
bool updatesuccess = twhcol130DAL.UpdateStatusPicked(MyObj);
HttpContext.Current.Session["MaterialDesc"] = MyObj.ITEM;
HttpContext.Current.Session["MaterialCode"] = MyObj.ITEM;
HttpContext.Current.Session["codePaid"] = MyObj.PAID.ToString();
HttpContext.Current.Session["Lot"] = MyObj.ORNO;
HttpContext.Current.Session["Quantity"] = MyObj.QTYS + " " + MyObj.UNIT;
HttpContext.Current.Session["Origin"] = MyObj.ORNO;
HttpContext.Current.Session["Supplier"] = "";
HttpContext.Current.Session["RecibedBy"] = HttpContext.Current.Session["user"].ToString();
HttpContext.Current.Session["RecibedOn"] = DateTime.Now.ToString();
HttpContext.Current.Session["Reprint"] = "no";
Retrono = JsonConvert.SerializeObject(MyObj);
}
else
{
MyObj.error = true;
MyObj.errorMsg = "la insercion fue: " + InsertSuccess.ToString();
Retrono = JsonConvert.SerializeObject(MyObj);
}
}
else
{
MyObj.error = true;
MyObj.errorMsg = Retrono;
Retrono = JsonConvert.SerializeObject(MyObj);
}
return(Retrono);
}
public static string InsertarReseiptRawMaterial(string OORG, string ORNO, string ITEM, string PONO, string LOT, decimal QUANTITY, string STUN, string CUNI, string CWAR, string FIRE, string PSLIP)
{
//string PSLIP = string.Empty;
PSLIP = PSLIP.Trim() == string.Empty ? " " : PSLIP.Trim();
decimal QUANTITYAUX = QUANTITY;
string Retrono = "El Registro no se ha insertado";
Factor MyConvertionFactor = new Factor {
};
QUANTITYAUX_COMPLETADA = 0;
if (CUNI != STUN)
{
MyConvertionFactor = FactorConversion(ITEM, STUN, CUNI);
QUANTITY = (MyConvertionFactor.Tipo == "Div") ? Convert.ToDecimal((QUANTITY * MyConvertionFactor.FactorB) / MyConvertionFactor.FactorD) : Convert.ToDecimal((QUANTITY * MyConvertionFactor.FactorD) / MyConvertionFactor.FactorB);
}
if (MyConvertionFactor.FactorD != null || CUNI == STUN)
{
if (OORG == "2")
{
DataTable DTOrdencompra = ConsultaOrdencompra(ORNO, PONO, QUANTITYAUX, ITEM, "");
if (DTOrdencompra.Rows.Count > 0)
{
bool OrdenImportacion = false;
OrdenImportacion = twhcol130DAL.ConsultaOrdenImportacion(DTOrdencompra.Rows[0]["T$COTP"].ToString()).Rows.Count > 0 ? true : false;
int consecutivoPalletID = 0;
DataTable DTPalletContinue = twhcol130DAL.PaidMayorwhcol130(ORNO);
string SecuenciaPallet = "001";
if (DTPalletContinue.Rows.Count > 0)
{
foreach (DataRow item in DTPalletContinue.Rows)
{
consecutivoPalletID = Convert.ToInt32(item["T$PAID"].ToString().Trim().Substring(10, 3)) + 1;
if (consecutivoPalletID.ToString().Length == 1)
{
SecuenciaPallet = "00" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 2)
{
SecuenciaPallet = "0" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 3)
{
SecuenciaPallet = consecutivoPalletID.ToString();
}
}
}
string LOCAL = string.Empty;
string PRIORIDAD = string.Empty;
Ent_twhcol130131 MyObjError = new Ent_twhcol130131();
try
{
string strError = string.Empty;
Ent_twhwmd200 OBJ200 = new Ent_twhwmd200 {
cwar = DTOrdencompra.Rows[0]["T$CWAR"].ToString().Trim()
};
DataTable Dttwhwmd200 = twhwmd200.listaRegistro_ObtieneAlmacenLocation(ref OBJ200, ref strError);
if (Dttwhwmd200.Rows.Count > 0)
{
if (Dttwhwmd200.Rows[0]["LOC"].ToString().Trim() == "1")
{
PRIORIDAD = twhcol130DAL.ConsultarPrioridadNativa(DTOrdencompra.Rows[0]["T$CWAR"].ToString().Trim()).Rows[0]["T$PRIO"].ToString().Trim();
LOCAL = twhcol130DAL.ConsultarLocationNativa(DTOrdencompra.Rows[0]["T$CWAR"].ToString().Trim(), PRIORIDAD).Rows[0]["T$LOCA"].ToString().Trim();
}
}
}
catch (Exception ex)
{
//LOCAL = " ";
MyObjError.error = true;
MyObjError.errorMsg = "Prior inbound not found";
return(JsonConvert.SerializeObject(MyObjError));
}
Ent_twhcol130131 MyObj = new Ent_twhcol130131
{
OORG = OORG,// Order type escaneada view
ORNO = DTOrdencompra.Rows[0]["T$ORNO"].ToString(),
ITEM = DTOrdencompra.Rows[0]["T$ITEM"].ToString(),
PAID = DTOrdencompra.Rows[0]["T$ORNO"].ToString() + "-" + SecuenciaPallet,
PONO = DTOrdencompra.Rows[0]["T$PONO"].ToString(),
SEQN = DTOrdencompra.Rows[0]["T$SQNBR"].ToString(),
CLOT = LOT, // lote VIEW
CWAR = DTOrdencompra.Rows[0]["T$CWAR"].ToString(),
QTYS = QUANTITYAUX.ToString("0.0000"), // cantidad escaneada view
UNIT = STUN, //unit escaneada view
QTYC = QUANTITY.ToString("0.0000"), //cantidad escaneada view aplicando factor
UNIC = CUNI, //unidad view stock
DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //fecha de confirmacion
CONF = "1",
RCNO = " ", //llena baan
DATR = "01/01/70", //llena baan
LOCA = LOCAL, // 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 = "0", // LLENAR EN 1
ALLO = "0",
DSCA = DTOrdencompra.Rows[0]["DSCA"].ToString(),
COTP = DTOrdencompra.Rows[0]["T$COTP"].ToString(),
NAMA = DTOrdencompra.Rows[0]["T$NAMA"].ToString(),
FIRE = FIRE,
PSLIP = PSLIP.ToUpper(),
PROC = "2",
//RFID = " ",
EVNT = " ",
REFCNTD = "0",
REFCNTU = "0",
ITEM_URL = DTOrdencompra.Rows[0]["T$ITEM"].ToString().Trim().ToUpper() + " - " + DTOrdencompra.Rows[0]["DSCA"].ToString().Trim().ToUpper(),
PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + DTOrdencompra.Rows[0]["T$ORNO"].ToString() + "-" + SecuenciaPallet + "&code=Code128&dpi=96",
ORNO_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + DTOrdencompra.Rows[0]["T$ORNO"].ToString() + "&code=Code128&dpi=96",
CLOT_URL = LOT.ToString().Trim() != "" ? UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + LOT.ToString().Trim().ToUpper() + "&code=Code128&dpi=96" : "",
QTYC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + QUANTITY.ToString("0.0000").Trim().ToUpper() + "&code=Code128&dpi=96",
UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + STUN.ToString().Trim().ToUpper() + "&code=Code128&dpi=96"
};
if (MyObj.FIRE == "1")
{
DataTable x131 = twhcol130DAL.ConsultaSumatoriaCantidadesTticol130131(MyObj);
DataTable x210 = twhcol130DAL.ConsultaSumatoriaCantidadesTwhinh210(MyObj);
QUANTITYAUX_COMPLETADA = QUANTITYAUX_COMPLETADA + Convert.ToDecimal(MyObj.QTYC);
decimal LIMITE = 0.05m;
decimal TotalRecibido = Convert.ToDecimal(DTOrdencompra.Rows[0]["RECIBIDO"].ToString());
decimal QTYCActual = Convert.ToDecimal(MyObj.QTYC);
decimal CantidadMaxima = Convert.ToDecimal(DTOrdencompra.Rows[0]["T$QSTK"].ToString());
decimal Restante = (CantidadMaxima - (TotalRecibido + QTYCActual));
if (Math.Abs(Restante) <= LIMITE)
{
MyObj.QTYC = Convert.ToString(CantidadMaxima - TotalRecibido);
}
}
HttpContext.Current.Session["MaterialDesc"] = DTOrdencompra.Rows[0]["DSCA"].ToString();
HttpContext.Current.Session["MaterialCode"] = DTOrdencompra.Rows[0]["T$ITEM"].ToString();
HttpContext.Current.Session["codePaid"] = DTOrdencompra.Rows[0]["T$ORNO"].ToString() + "-" + SecuenciaPallet;
HttpContext.Current.Session["Lot"] = LOT;
HttpContext.Current.Session["Quantity"] = MyObj.QTYC + " " + CUNI;
HttpContext.Current.Session["Origin"] = LOT;
HttpContext.Current.Session["Supplier"] = DTOrdencompra.Rows[0]["T$NAMA"].ToString();
HttpContext.Current.Session["RecibedBy"] = _operator;
HttpContext.Current.Session["RecibedOn"] = DateTime.Now.ToString();
HttpContext.Current.Session["Reprint"] = "no";
HttpContext.Current.Session["AutoPrint"] = "yes";
if (OrdenImportacion)
{
DataTable ConsultaPresupuestoImportacion = twhcol130DAL.ConsultaPresupuestoImportacion(ORNO);
if (ConsultaPresupuestoImportacion.Rows.Count > 0 && ConsultaPresupuestoImportacion.Rows[0]["pres"].ToString().Trim() == "3")
{
bool Insertsucces = twhcol130DAL.InsertarReseiptRawMaterial(MyObj);
if (Insertsucces)
{
Retrono = JsonConvert.SerializeObject(MyObj);
}
else
{
MyObj.error = true;
MyObj.errorMsg = "la insercion fue: " + Insertsucces.ToString();
Retrono = JsonConvert.SerializeObject(MyObj);
}
}
else
{
MyObj.error = true;
MyObj.errorMsg = "Import PO, Budget is not closed. PO cannot be recived";
Retrono = JsonConvert.SerializeObject(MyObj);
}
}
else
{
bool Insertsucces = twhcol130DAL.InsertarReseiptRawMaterial(MyObj);
if (Insertsucces)
{
//if (rfid == true)
//{
//DataTable DtRfID = twhcol130DAL.selectTccol020(MyObj);
// if (DtRfID.Rows.Count > 0)
// {
// if (DtRfID.Rows[0]["T$RFID"].ToString().Trim() == "1")
// {
// //if (rfid == true)
// //{
// SrvRfidPop.Service1Client wcfser = new SrvRfidPop.Service1Client();
// string res = wcfser.ProWhcol133(MyObj.PAID, "0", "VA Dock", MyObj.ORNO, MyObj.DATE, MyObj.LOGN, "0", "0", "0");
// Console.WriteLine(res);
// //}
// }
// }
//}
Retrono = JsonConvert.SerializeObject(MyObj);
}
else
{
MyObj.error = true;
MyObj.errorMsg = "la insercion fue: " + Insertsucces.ToString();
Retrono = JsonConvert.SerializeObject(MyObj);
}
}
}
}
else
{
DataTable DTNOOrdencompra = ConsultaNOOrdencompra(ORNO, PONO, OORG, QUANTITY, ITEM, LOT);
bool ExistenciaLot = ValidarLote(ITEM, LOT);
if (DTNOOrdencompra.Rows.Count > 0 && (ExistenciaLot == true || DTNOOrdencompra.Rows[0]["KLTC"].ToString().Trim() != "1"))
{
int consecutivoPalletID = 0;
DataTable DTPalletContinue = twhcol130DAL.PaidMayorwhcol130(ORNO);
string SecuenciaPallet = "001";
if (DTPalletContinue.Rows.Count > 0)
{
foreach (DataRow item in DTPalletContinue.Rows)
{
consecutivoPalletID = Convert.ToInt32(item["T$PAID"].ToString().Trim().Substring(10, 3)) + 1;
if (consecutivoPalletID.ToString().Length == 1)
{
SecuenciaPallet = "00" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 2)
{
SecuenciaPallet = "0" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 3)
{
SecuenciaPallet = consecutivoPalletID.ToString();
}
}
}
string LOCAL = string.Empty;
string PRIORIDAD = string.Empty;
Ent_twhcol130131 MyObjError = new Ent_twhcol130131();
try
{
PRIORIDAD = twhcol130DAL.ConsultarPrioridadNativa(DTNOOrdencompra.Rows[0]["T$CWAR"].ToString().Trim()).Rows[0]["T$PRIO"].ToString().Trim();
LOCAL = twhcol130DAL.ConsultarLocationNativa(DTNOOrdencompra.Rows[0]["T$CWAR"].ToString().Trim()).Rows[0]["T$LOCA"].ToString().Trim();
}
catch (Exception ex)
{
//LOCAL = " ";
MyObjError.error = true;
MyObjError.errorMsg = "Prior inbound not found";
return(JsonConvert.SerializeObject(MyObjError));
}
Ent_twhcol130131 MyObj = new Ent_twhcol130131
{
OORG = OORG,// Order type escaneada view
ORNO = DTNOOrdencompra.Rows[0]["T$ORNO"].ToString(),
ITEM = DTNOOrdencompra.Rows[0]["T$ITEM"].ToString(),
PAID = DTNOOrdencompra.Rows[0]["T$ORNO"].ToString() + "-" + SecuenciaPallet,
PONO = DTNOOrdencompra.Rows[0]["T$PONO"].ToString(),
SEQN = DTNOOrdencompra.Rows[0]["T$SEQN"].ToString(),
CLOT = LOT, // lote VIEW
CWAR = DTNOOrdencompra.Rows[0]["T$CWAR"].ToString(),
QTYS = QUANTITYAUX.ToString("0.0000"), // cantidad escaneada view
UNIT = STUN, //unidad view stock
QTYC = QUANTITY.ToString("0.0000"), //cantidad escaneada view aplicando factor
UNIC = CUNI, //unit escaneada view
DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //fecha de confirmacion
CONF = "1",
RCNO = " ", //llena baan
DATR = "01/01/70", //llena baan
LOCA = LOCAL, // 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 = "0", // LLENAR EN 1
ALLO = "0",
DSCA = DTNOOrdencompra.Rows[0]["T$DSCA"].ToString(),
NAMA = DTNOOrdencompra.Rows[0]["T$NAMA"].ToString(),
FIRE = FIRE,
ITEM_URL = DTNOOrdencompra.Rows[0]["T$ITEM"].ToString().Trim().ToUpper() + " - " + DTNOOrdencompra.Rows[0]["DSCA"].ToString().Trim().ToUpper(),
PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + DTNOOrdencompra.Rows[0]["T$ORNO"].ToString() + "-" + SecuenciaPallet + "&code=Code128&dpi=96",
ORNO_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + DTNOOrdencompra.Rows[0]["T$ORNO"].ToString() + "&code=Code128&dpi=96",
CLOT_URL = LOT.ToString().Trim() != "" ? UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + LOT.ToString().Trim().ToUpper() + "&code=Code128&dpi=96" : "",
QTYC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + QUANTITY.ToString("0.0000").Trim().ToUpper() + "&code=Code128&dpi=96",
UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + STUN.ToString().Trim().ToUpper() + "&code=Code128&dpi=96"
};
HttpContext.Current.Session["MaterialDesc"] = DTNOOrdencompra.Rows[0]["T$DSCA"].ToString();
HttpContext.Current.Session["MaterialCode"] = DTNOOrdencompra.Rows[0]["T$ITEM"].ToString();
HttpContext.Current.Session["codePaid"] = DTNOOrdencompra.Rows[0]["T$ORNO"].ToString() + "-" + SecuenciaPallet;
HttpContext.Current.Session["Lot"] = LOT;
HttpContext.Current.Session["Quantity"] = QUANTITY.ToString("0.0000") + " " + CUNI;
HttpContext.Current.Session["Origin"] = LOT;
HttpContext.Current.Session["Supplier"] = _operator;
HttpContext.Current.Session["RecibedBy"] = _operator;
HttpContext.Current.Session["RecibedOn"] = DateTime.Now.ToString();
HttpContext.Current.Session["Reprint"] = "no";
HttpContext.Current.Session["AutoPrint"] = "yes";
if (MyObj.FIRE == "1")
{
DataTable CantidadesTticol130131 = twhcol130DAL.ConsultaSumatoriaCantidadesTticol130131(MyObj);
DataTable CantidadesTwhinh210 = twhcol130DAL.ConsultaSumatoriaCantidadesTwhinh210(MyObj);
if (CantidadesTticol130131.Rows.Count > 0 && CantidadesTwhinh210.Rows.Count > 0)
{
double qtyc = Convert.ToDouble(CantidadesTticol130131.Rows[0]["QTYC"].ToString());
double qstk = Convert.ToDouble(CantidadesTwhinh210.Rows[0]["T$QSTK"].ToString());
}
}
bool Insertsucces = twhcol130DAL.InsertarReseiptRawMaterial(MyObj);
if (Insertsucces)
{
Retrono = JsonConvert.SerializeObject(MyObj);
}
else
{
MyObj.error = true;
MyObj.errorMsg = "la insercion fue:" + Insertsucces.ToString();
Retrono = JsonConvert.SerializeObject(MyObj);
}
}
else
{
Ent_twhcol130131 MyObj = new Ent_twhcol130131
{
error = true,
errorMsg = "The lot does not correspond to the order"
};
Retrono = JsonConvert.SerializeObject(MyObj);
}
}
}
return(Retrono);
}
