protected void txtItem_OnTextChanged(object sender, EventArgs e)
{
lblError.Text = String.Empty;
var item = txtItem.Text.Trim().ToUpper();
if (item != String.Empty)
{
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());
if (kltc != 1)
{
txtLot.Text = String.Empty;
txtLot.Enabled = false;
}
}
protected void btnConsultar_Click(object sender, EventArgs e)
{
divTable.InnerHtml = String.Empty;
if (txtArticulo.Text.Trim().ToUpper() != String.Empty)
{
Ent_tticol127 dataticol127 = new Ent_tticol127()
{
user = HttpContext.Current.Session["user"].ToString()
};
//_consultaLoteUsuario = _idaltticol127.listaRegistro_ObtieneAlmacen(ref dataticol127, ref strError);
//if (_consultaLoteUsuario.Rows.Count > 0)
//{
Ent_ttcibd001 data001 = new Ent_ttcibd001()
{
item = txtArticulo.Text.Trim().ToUpper()
};
_consultaItem = _idalttcibd001.listaRegistro_ObtieneDescripcionUnidad(ref data001, ref strError);
if (_consultaItem.Rows.Count > 0)
{
var cwar = string.Empty;
//var cwar = _consultaLoteUsuario.Rows[0]["BODEGA"].ToString();
//var cwardesc = _consultaLoteUsuario.Rows[0]["DSCA"].ToString();
var item = txtArticulo.Text.Trim().ToUpper();
var itemdesc = _consultaItem.Rows[0]["DESCRIPCION"].ToString();
var unidad = _consultaItem.Rows[0]["UNID"].ToString();
_consultaInformacion = _idaltwhinr140.consultaPorAlmacenItem(ref item, ref strError);
if (_consultaInformacion.Rows.Count > 0)
{
divTable.InnerHtml = makeTableReceipt();
}
else
{
lblError.Text = String.Format(mensajes("nodata"), cwar, item);
return;
}
}
else
{
lblError.Text = mensajes("itemnotexists");
return;
}
//}
//else
//{
// lblError.Text = mensajes("usernotwarehouse");
// return;
//}
}
else
{
lblError.Text = mensajes("formempty");
return;
}
}
public DataTable listaRegistro_ObtieneDescUnidNOLote(ref Ent_ttcibd001 Parametros, ref string strError)
{
DataTable retorno;
try
{
retorno = dal.listaRegistro_ObtieneDescUnidNOLote(ref Parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
public static string VerificarItem(string ITEM)
{
HttpContext.Current.Session["myItemType"] = string.Empty;
Ent_ttcibd001 ObjTtcibd001 = new Ent_ttcibd001();
DataTable dtTtcibd001 = ITtcibd001.findItem(ITEM);
if (dtTtcibd001.Rows.Count > 0)
{
kltc = Convert.ToInt32(dtTtcibd001.Rows[0]["KLTC"].ToString());
ObjTtcibd001.item = dtTtcibd001.Rows[0]["ITEM"].ToString();
ObjTtcibd001.dsca = dtTtcibd001.Rows[0]["DSCA"].ToString();
ObjTtcibd001.cuni = dtTtcibd001.Rows[0]["CUNI"].ToString();
ObjTtcibd001.kltc = kltc.ToString();
ObjTtcibd001.kitm = dtTtcibd001.Rows[0]["KITM"].ToString();
ObjTtcibd001.cpcl = dtTtcibd001.Rows[0]["CPCL"].ToString();
if (ObjTtcibd001.kitm.Trim() == "2")
{
ObjTtcibd001.Error = false;
ObjTtcibd001.TypeMsgJs = "console";
ObjTtcibd001.SuccessMsg = "Item Encontrado";
HttpContext.Current.Session["myItemType"] = ObjTtcibd001.cpcl;
HttpContext.Current.Session["ITEM"] = ObjTtcibd001.item;
HttpContext.Current.Session["CUNI"] = ObjTtcibd001.cuni;
}
else
{
ObjTtcibd001.Error = true;
ObjTtcibd001.TypeMsgJs = "label";
ObjTtcibd001.ErrorMsg = ItemcodeisnotManufacturingType;
}
}
else
{
ObjTtcibd001.Error = true;
ObjTtcibd001.TypeMsgJs = "label";
ObjTtcibd001.ErrorMsg = Itemcodedoesntexist;
}
return(JsonConvert.SerializeObject(ObjTtcibd001));
}
public static string VerificarItem(string ITEM, string CLOT)
{
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")
{
PCLOT = CLOT;
}
if (ObjTtcibd001.kitm.Trim() == "1")
{
ObjTtcibd001.Error = true;
ObjTtcibd001.TypeMsgJs = "label";
ObjTtcibd001.ErrorMsg = ItemcodeisnotPurchaseType;
}
else
{
ObjTtcibd001.Error = false;
ObjTtcibd001.TypeMsgJs = "console";
ObjTtcibd001.SuccessMsg = "Item Encontrado";
}
}
else
{
ObjTtcibd001.Error = true;
ObjTtcibd001.TypeMsgJs = "label";
ObjTtcibd001.ErrorMsg = ItemcodeisnotPurchaseType;
}
return(JsonConvert.SerializeObject(ObjTtcibd001));
}
public static string VerificarItem(string PDNO, string ITEM)
{
string strError = string.Empty;
Ent_ttcibd001 ObjTtcibd001 = new Ent_ttcibd001();
string myPdno = PDNO.ToUpper().Trim();
string myItem = ITEM.ToUpper().Trim();
DataTable dtTticst001 = ITticst001.findByItemAndPdno(ref myPdno, ref myItem, ref strError);
if (dtTticst001.Rows.Count > 0)
{
HttpContext.Current.Session["PONO"] = dtTticst001.Rows[0]["PONO"].ToString();
HttpContext.Current.Session["CWAR"] = dtTticst001.Rows[0]["CWAR"].ToString();
DataTable dtTtcibd001 = ITtcibd001.findItem(ITEM);
if (dtTtcibd001.Rows.Count > 0)
{
kltc = Convert.ToInt32(dtTtcibd001.Rows[0]["KLTC"].ToString());
ObjTtcibd001.item = dtTtcibd001.Rows[0]["ITEM"].ToString();
ObjTtcibd001.dsca = dtTtcibd001.Rows[0]["DSCA"].ToString();
ObjTtcibd001.cuni = dtTtcibd001.Rows[0]["CUNI"].ToString();
ObjTtcibd001.kltc = kltc.ToString();
ObjTtcibd001.kitm = dtTtcibd001.Rows[0]["KITM"].ToString();
}
else
{
ObjTtcibd001.Error = true;
ObjTtcibd001.TypeMsgJs = "label";
ObjTtcibd001.ErrorMsg = Itemcodedoesntexist;
}
}
else
{
ObjTtcibd001.Error = true;
ObjTtcibd001.TypeMsgJs = "label";
ObjTtcibd001.ErrorMsg = Itemcodedoesntexist;
}
return(JsonConvert.SerializeObject(ObjTtcibd001));
}
public static string VerificarSalesOrder(string ORDER)
{
HttpContext.Current.Session["ORNO"] = "";
Ent_ttcibd001 ObjTtcibd001 = new Ent_ttcibd001();
DataTable dtTtcibd001 = ITtcibd001.findSalesOrder(ORDER);
if (dtTtcibd001.Rows.Count > 0)
{
ObjTtcibd001.Error = false;
ObjTtcibd001.TypeMsgJs = "console";
ObjTtcibd001.SuccessMsg = "Orden Encontrada";
HttpContext.Current.Session["ORNO"] = ORDER;
}
else
{
ObjTtcibd001.Error = true;
ObjTtcibd001.TypeMsgJs = "label";
ObjTtcibd001.ErrorMsg = SalesOrdercodedoesntexist;
}
return(JsonConvert.SerializeObject(ObjTtcibd001));
}
public DataTable listaRegistro_ObtieneDescUnidNOLote(ref Ent_ttcibd001 Parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
paramList = new Dictionary <string, object>();
paramList.Add(":T$ITEM", Parametros.item.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 = "Wrong item, please check. " + Parametros.item.Trim();
}
}
catch (Exception ex)
{
strError = "Error to the search sequence [ttcibd001]. 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));
}
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 btnGuardar_Click(object sender, EventArgs e)
{
lblError.Text = String.Empty;
lblConfirm.Text = String.Empty;
if (txtLocation.Text.Trim() == String.Empty || lblValueLocation2.Text.Trim() == String.Empty)
{
lblError.Text = mensajes("locationblank");
return;
}
if (float.Parse(lblValueQuantity.Text) < 1)
{
lblError.Text = mensajes("quantityzero");
return;
}
//Valida la ubicacion del producto (INS o REC)
var item = lblValueArticulo.Text.Split('-')[0].Trim().ToUpper() + "-" + lblValueArticulo.Text.Split('-')[1].Trim().ToUpper();
var origen = slOrigen.SelectedValue;
var dsca = lblValueArticulo.Text.Split('-')[2].Trim().ToUpper();
var validaUbicacion = _idaltqmptc011.findRecordByItemConOrigen(ref item, ref origen, ref strError);
var location = validaUbicacion.Rows.Count > 0 ? "INS" : "REC";
//Valida si el articulo maneja lote
Ent_ttcibd001 data001 = new Ent_ttcibd001()
{
item = item
};
var validaArticulo = _idalttcibd001.listaRegistro_ObtieneDescripcionUnidad(ref data001, ref strError);
var consultaOrden = new DataTable();
var numeroOrden = lblValueOrden.Text.Trim();
var numeroOrdenPallet = txtNumeroOrden.Text.Trim().ToUpper();
var clot = validaArticulo.Rows[0]["KLTC"].ToString();
var cwar = _validaAlmacen.Rows[0]["ALM"].ToString();
if (clot != "1")
{
consultaOrden = _idaltwhcol124.findBySqnbPdnoNoClot(ref location, ref cwar, ref numeroOrdenPallet, ref strError);
}
else
{
consultaOrden = _idaltwhcol124.findBySqnbPdnoYesClot(ref location, ref cwar, ref numeroOrdenPallet, ref strError);
}
if (consultaOrden.Rows.Count > 0)
{
var QTYPEND = float.Parse(consultaOrden.Rows[0]["QTYPEND"].ToString()).ToString("0.00");
var QTDL = float.Parse(lblValueQuantity.Text == "" ? "0" : lblValueQuantity.Text).ToString("0.00");
var STRQDPU = float.Parse((float.Parse(QTYPEND) - float.Parse(lblValuePorAprobar.Text.Trim())).ToString()).ToString("0.00");
var CWAR = consultaOrden.Rows[0]["CWAR"].ToString();
var LOTE = consultaOrden.Rows[0]["CLOT"].ToString();
//Validar que el almacen sea el mismo de la orden
if (CWAR != cwar)
{
lblError.Text = String.Format(mensajes("diferentcwar"), txtLocation.Text.ToUpper(), CWAR);
return;
}
//Validar que exista ubicacion, que sea tipo 5-carga y que no este bloqueado
Ent_twhwmd300 data300 = new Ent_twhwmd300()
{
loca = txtLocation.Text.Trim(),
cwar = cwar
};
var validarUbicacionTipo = _idaltwhwmd300.listaRegistro_AlmacenUbicaion(ref data300, ref strError);
if (validarUbicacionTipo.Rows.Count > 0)
{
if (float.Parse(QTDL) > float.Parse(QTYPEND))
{
lblError.Text = String.Format(mensajes("suggestedquantityannounced"), QTDL, QTYPEND);
return;
}
//
//Validar que la cantidad ingresada no sea mayor a la cantidad disponible por ubicar
if (float.Parse(QTDL) > float.Parse(STRQDPU))
{
lblError.Text = String.Format(mensajes("suggestedquantityavailable"), numeroOrden, QTDL, STRQDPU);
return;
}
//Verificar si ya existe un registro para esta orden
//var consecutivo = _idaltticol032.consultarConsecutivoRegistro(ref numeroOrden, ref strError);
//consecutivo = consecutivo + 1;
Ent_twhinh210 datawhinh210 = new Ent_twhinh210()
{
orno = lblValueOrden.Text,
oorg = origen,
item = item,
clot = LOTE
};
var consultaDatosOrden = _idaltwhinh210.findByOrderNumberAndOrigin(ref datawhinh210, ref strError);
if (consultaDatosOrden.Rows.Count < 1)
{
lblError.Text = mensajes("210empty");
return;
}
//T$OORG AS OORG, T$ORNO AS ORNO, T$OSET AS OSET, T$PONO AS PONO, T$SEQN AS SEQN
var oorg = consultaDatosOrden.Rows[0]["OORG"].ToString();
var orno = consultaDatosOrden.Rows[0]["ORNO"].ToString();
var oset = consultaDatosOrden.Rows[0]["OSET"].ToString();
var pono = consultaDatosOrden.Rows[0]["PONO"].ToString();
var seqn = consultaDatosOrden.Rows[0]["SEQN"].ToString();
Ent_tticol032 dataticol032 = new Ent_tticol032()
{
oorg = Convert.ToInt32(oorg),
orno = orno,
sqnb = numeroOrdenPallet,
oset = Convert.ToInt32(oset),
pono = Convert.ToInt32(pono),
seqn = Convert.ToInt32(seqn),
mitm = item.Trim(),
dsca = dsca,
cwar = cwar,
loca = lblValueLocation2.Text,
qtdl = Convert.ToDecimal(QTDL),
cuni = lblValueUnit.Text,
mess = " ",
user = HttpContext.Current.Session["user"].ToString(),
refcntd = 0,
refcntu = 0
};
var validSave = _idaltticol032.insertarRegistro(ref dataticol032, ref strError);
if (validSave > 0)
{
lblConfirm.Text = mensajes("msjsave");
divTable.Visible = false;
txtNumeroOrden.Enabled = true;
txtNumeroOrden.Text = String.Empty;
return;
}
else
{
lblError.Text = mensajes("errorsave");
return;
}
}
else
{
lblError.Text = String.Format(mensajes("locationnotexist"), data300.loca);
return;
}
}
else
{
lblError.Text = mensajes("orderemptytwo");
}
}
protected void btnTransfer_Click(object sender, EventArgs e)
{
if (txtItem.Text.Trim() == String.Empty || txtTargetLocation.Text.Trim() == String.Empty || txtTargetQty.Text.Trim() == String.Empty)
{
lblError.Text = mensajes("formempty");
return;
}
if (_tipoFormulario == "TO" && slPlant.SelectedValue.Trim() == String.Empty)
{
lblError.Text = mensajes("formempty");
return;
}
var item = txtItem.Text.Trim().ToUpper();
var loca = txtTargetLocation.Text.Trim().ToUpper();
var qtdl = double.Parse(txtTargetQty.Text.Trim(), CultureInfo.InvariantCulture.NumberFormat);
//Buscar datos del articulo
Ent_ttcibd001 data001 = new Ent_ttcibd001()
{
item = item
};
var datosArticulo = _idalttcibd001.listaRegistro_ObtieneDescripcionUnidad(ref data001, ref strError);
if (datosArticulo.Rows.Count <= 0)
{
lblError.Text = mensajes("itemnotexists");
return;
}
var dscaitem = datosArticulo.Rows[0]["DESCRIPCION"].ToString();
var cuni = datosArticulo.Rows[0]["UNID"].ToString();
//Buscar almacen de la ubicación+
var loct = "5";
var btrr = "2";
var datosUbicacion = _idaltwhwmd300.findLocationByLoctAndBtrr(ref loct, ref btrr, ref loca, ref strError);
if (datosUbicacion.Rows.Count <= 0)
{
lblError.Text = String.Format(mensajes("targetlocation"), loca);
return;
}
var cwar = datosUbicacion.Rows[0]["CWAR"].ToString();
//Valida si ya existe registro
var consecutivo = _tipoFormulario == "TO" ? _idaltwhcol010.consultarConsecutivoMaximo(ref strError)
: _idaltwhcol010.consultarConsecutivoMaximo(ref strError); //_idaltwhcol010.consultarConsecutivoRegistroPorItem(ref item, ref loca, ref strError);
consecutivo = consecutivo + 1;
Ent_twhcol010 data010 = new Ent_twhcol010()
{
clot = " ",
sqnb = consecutivo,
mitm = item,
dsca = dscaitem,
cwor = _tipoFormulario == "TO" ? slPlant.SelectedValue.Trim().ToUpper() : cwar,
loor = " ",
cwde = cwar,
lode = loca,
qtdl = qtdl,
cuni = cuni,
user = HttpContext.Current.Session["user"].ToString(),
refcntd = 0,
refcntu = 0
};
var validInsert = _idaltwhcol010.insertarRegistro(ref data010, ref strError);
if (validInsert > 0)
{
lblError.Text = String.Empty;
lblConfirm.Text = mensajes("msjsave");
txtItem.Text = String.Empty;
txtTargetLocation.Text = String.Empty;
txtTargetQty.Text = String.Empty;
return;
}
else
{
lblError.Text = mensajes("errorsave");
return;
}
}
protected void btnGuardar_Click(object sender, EventArgs e)
{
if (txtLocation.Text.Trim() == String.Empty || lblValueLocation2.Text.Trim() == String.Empty)
{
lblError.Text = mensajes("locationblank");
return;
}
if (float.Parse(lblValueQuantity.Text) < 1)
{
lblError.Text = mensajes("quantityzero");
return;
}
//Valida la ubicacion del producto (INS o REC)
var item = lblValueArticulo.Text.Split('-')[0].Trim().ToUpper() + "-" + lblValueArticulo.Text.Split('-')[1].Trim().ToUpper();
var dsca = lblValueArticulo.Text.Split('-')[2].Trim().ToUpper();
var validaUbicacion = _idaltqmptc011.findRecordByItem(ref item, ref strError);
var location = validaUbicacion.Rows.Count > 0 ? "INS" : "REC";
//Valida si el articulo maneja lote
Ent_ttcibd001 data001 = new Ent_ttcibd001()
{
item = item
};
var validaArticulo = _idalttcibd001.listaRegistro_ObtieneDescripcionUnidad(ref data001, ref strError);
var consultaOrden = new DataTable();
var numeroOrden = lblValueOrden.Text.Trim();
var numeroOrdenPallet = txtNumeroOrden.Text.Trim().ToUpper();
var clot = validaArticulo.Rows[0]["KLTC"].ToString();
var cwar = _validaAlmacen.Rows[0]["ALM"].ToString();
if (clot != "1")
{
consultaOrden = _idalttisfc001.findBySqnbPdnoNoClot(ref location, ref cwar, ref numeroOrden, ref numeroOrdenPallet, ref strError);
}
else
{
consultaOrden = _idalttisfc001.findBySqnbPdnoYesClot(ref location, ref cwar, ref numeroOrden, ref numeroOrdenPallet, ref strError);
}
if (consultaOrden.Rows.Count > 0)
{
var QTYPEND = float.Parse(consultaOrden.Rows[0]["QTYPEND"].ToString()).ToString("0.00");
var QTDL = float.Parse(lblValueQuantity.Text == "" ? "0" : lblValueQuantity.Text).ToString("0.00");
//var STRQDPU = float.Parse((float.Parse(QTYPEND) - float.Parse(QTDL)).ToString()).ToString("0.00");
var STRQDPU = float.Parse(QTYPEND).ToString("0.00");
var CWAR = consultaOrden.Rows[0]["CWAR"].ToString();
//Validar que el almacen sea el mismo de la orden
if (CWAR != cwar)
{
lblError.Text = String.Format(mensajes("diferentcwar"), txtLocation.Text.ToUpper(), CWAR);
return;
}
//Validar que exista ubicacion, que sea tipo 5-carga y que no este bloqueado
Ent_twhwmd300 data300 = new Ent_twhwmd300()
{
loca = txtLocation.Text.Trim(),
cwar = cwar
};
var validarUbicacionTipo = _idaltwhwmd300.listaRegistro_AlmacenUbicaion(ref data300, ref strError);
if (validarUbicacionTipo.Rows.Count > 0)
{
//Validar que la cantidad no sea mayor a la cantidad pendiente
if (float.Parse(QTDL) > float.Parse(QTYPEND))
{
lblError.Text = String.Format(mensajes("suggestedquantityannounced"), QTDL, QTYPEND);
return;
}
//Validar que la cantidad ingresada no sea mayor a la cantidad disponible por ubicar
if (float.Parse(QTDL) > float.Parse(STRQDPU))
{
lblError.Text = String.Format(mensajes("suggestedquantityavailable"), numeroOrden, QTDL, STRQDPU);
return;
}
//Verificar si ya existe un registro para esta orden
var consecutivo = _idaltticol030.consultarConsecutivoRegistro(ref numeroOrden, ref strError);
consecutivo = consecutivo + 1;
Ent_tticol030 data030 = new Ent_tticol030()
{
pdno = numeroOrden,
sqnb = consecutivo,
mitm = item,
dsca = dsca,
cwar = cwar,
loca = lblValueLocation2.Text,
qtdl = Convert.ToDecimal(QTDL),
cuni = lblValueUnit.Text,
mess = " ",
user = HttpContext.Current.Session["user"].ToString(),
refcntd = 0,
refcntu = 0
};
List <Ent_tticol030> lista = new List <Ent_tticol030>();
lista.Add(data030);
var validSave = _idaltticol030.insertarRegistro(ref lista, ref strError);
if (validSave > 0)
{
Ent_tticol022 data022 = new Ent_tticol022()
{
log2 = HttpContext.Current.Session["user"].ToString(),
qtd2 = Convert.ToInt32(data030.qtdl),
loca = data030.loca,
pdno = data030.pdno,
sqnb = numeroOrdenPallet,
dele = 7
};
var validUpdate = _idaltticol022.actualizaRegistroSugUbicaciones(ref data022, ref strError);
if (validUpdate)
{
//_idaltticol022.ActualizarRegistroTicol222
var actubicticol222 = _idaltticol022.ActualizarUbicacionTicol222(data022.pdno, data022.sqnb, data022.loca, data030.cwar);
lblConfirm.Text = mensajes("msjsave");
divTable.Visible = false;
txtNumeroOrden.Text = String.Empty;
return;
}
else
{
lblError.Text = mensajes("errorupdt");
return;
}
}
else
{
lblError.Text = mensajes("errorsave");
return;
}
}
else
{
lblError.Text = String.Format(mensajes("locationnotexist"), data300.loca);
return;
}
}
else
{
lblError.Text = mensajes("orderemptytwo");
}
}
