protected void btnSearch_Click(object sender, EventArgs e)
{
lblError.Text = string.Empty;
strError = string.Empty;
obj = new Ent_ttwhcol017();
obj.labl = txtLabelId.Text.Trim();
resultado = idal.TakeMaterialInv_listaConsLabel_Param(ref obj, ref strError);
if (!string.IsNullOrEmpty(strError))
{
lblError.Text = strError;
txtLabelId.Focus();
strError = string.Empty;
return;
}
CultureInfo decimalPunto = new CultureInfo("en-US");
decimalPunto.NumberFormat.NumberDecimalSeparator = ".";
// txtCwar.Text = resultado.Rows[0]["T$CWAR"].ToString().Trim();
// lblCwar.Text = resultado.Rows[0]["BODEGA"].ToString();
txtItem.Text = resultado.Rows[0]["T$ITEM"].ToString().Trim();
lblItem.Text = resultado.Rows[0]["ARTICULO"].ToString();
txtLote.Text = resultado.Rows[0]["T$CLOT"].ToString();
txtQuantity.Text = (Decimal.Parse(resultado.Rows[0]["T$QTYR"].ToString())).ToString(decimalPunto); //Convert.ToDecimal(txtQuantity.Text);
lblUnity.Text = hi_unityItem.Value = resultado.Rows[0]["UNIDAD"].ToString();
hi_unityItem.Value = lblUnity.Text;
Page.Form.DefaultButton = btnSend.UniqueID;
txtQuantity.Focus();
btnSearch.Enabled = true;
}
public DataTable TakeMaterialInv_listaConsLabel_Param(ref Ent_ttwhcol017 Parametros, ref string strError)
{
//int retorno = -1;
DataTable retorno;
try
{
retorno = dal.TakeMaterialInv_listaConsLabel_Param(ref Parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
List <Ent_ttwhcol017> parameterCollection = new List <Ent_ttwhcol017>();
obj = new Ent_ttwhcol017();
obj.labl = txtLabelId.Text.Trim().ToUpperInvariant();;
obj.sqnb = 0;
obj.cwar = txtCwar.Text.ToUpperInvariant();
obj.item = txtItem.Text.ToUpperInvariant();
obj.clot = string.IsNullOrEmpty(txtLote.Text.Trim()) ? " " : txtLote.Text.Trim().ToUpperInvariant();
obj.qtdl = Decimal.Parse(txtQuantity.Text, System.Globalization.CultureInfo.InvariantCulture); //Convert.ToDecimal(txtQuantity.Text);
obj.cuni = hi_unityItem.Value;
obj.logn = Session["user"].ToString();
obj.coun = 0;
obj.proc = 2;
obj.refcntd = 0;
obj.refcntu = 0;
obj.zone = txtZone.Text.Trim().ToUpperInvariant();
parameterCollection.Add(obj);
int resultado = idal.insertarRegistro(ref parameterCollection, ref strError);
if (resultado < 1)
{
lblError.Text = "Error on save";
return;
}
//txtCwar.Text = string.Empty;
//lblCwar.Text = string.Empty;
txtLabelId.Text = string.Empty;
txtItem.Text = string.Empty;
lblItem.Text = string.Empty;
txtLote.Text = string.Empty;
txtQuantity.Text = string.Empty;
lblUnity.Text = string.Empty;
hi_unityItem.Value = string.Empty;
lblError.Text = "Count has been saved sucessfully";
Page.Form.DefaultButton = btnSearch.UniqueID;
txtLabelId.Focus();
// btnSearchZone.Enabled = false;
txtZone.Enabled = false;
}
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_ttwhcol017 parametros, bool blnUsarPRetorno = false)
{
string param = string.Empty;
List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>();
try
{
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$LABL", DbType.String, parametros.labl);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$SQNB", DbType.Int32, parametros.sqnb);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$CWAR", DbType.String, parametros.cwar);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$ITEM", DbType.String, parametros.item);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$CLOT", DbType.String, parametros.clot);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$QTDL", DbType.Decimal, Convert.ToDecimal(parametros.qtdl).ToString("#.##0,0000"));
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$CUNI", DbType.String, parametros.cuni);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$LOGN", DbType.String, parametros.logn);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$COUN", DbType.Int32, parametros.coun);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$PROC", DbType.Int32, parametros.proc);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$REFCNTD", DbType.Int32, parametros.refcntd);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$REFCNTU", DbType.Int32, parametros.refcntu);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$ZONE", DbType.String, parametros.zone);
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)
{
throw (ex);
}
return(parameterCollection);
}
public DataTable TakeMaterialInv_listaConsLabel_Param(ref Ent_ttwhcol017 Parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
string tableSeco = owner + ".tticol022" + env;
string tableSeco1 = owner + ".ttisfc001" + env;
string tableSeco2 = owner + ".ttcmcs003" + env; // item
string tableSeco3 = owner + ".ttcibd001" + env; // Bodega
Dictionary <string, object> paramList = new Dictionary <string, object>();
paramList.Add(":T$LABL", Parametros.labl.Trim());
strSentencia = recursos.readStatement(method.ReflectedType.Name, "TakeMaterialInv_listaConsLabel_Param", ref owner, ref env, tabla, paramList);
//strSentencia = "SELECT T016.T$ZONE, T016.T$LABL, T016.T$ITEM, T002.T$DSCA ARTICULO, T002.T$CUNI UNIDAD, T002.T$KLTC T$KITM, " +
// "T016.T$CWAR, T003.T$DSCA BODEGA, T016.T$CLOT, T016.T$QTYR, T016.T$LOGN, " +
// "TO_CHAR(((T016.T$DATE)-5/24), 'DD/MM/YYYY hh24:mi:ss') T$DATE, T016.T$REFCNTD, T016.T$REFCNTU " +
// "FROM " + tablaCons + " T016 LEFT JOIN " + tableSeco3 + " T002 ON TRIM(T016.T$ITEM) = TRIM(T002.T$ITEM)" +
// "LEFT JOIN " + tableSeco2 + " T003 ON T016.T$CWAR = T003.T$CWAR " +
// " WHERE TRIM(t$labl) = '" + Parametros.labl.Trim() + "'";
//SELECT T016.T$ZONE, T016.T$LABL, T016.T$ITEM, T002.T$DSCA ARTICULO, T002.T$CUNI UNIDAD, T002.T$KLTC T$KITM,
//T016.T$CWAR, T003.T$DSCA BODEGA, T016.T$CLOT, T016.T$QTYR, T016.T$LOGN,
//TO_CHAR(((T016.T$DATE)-5/24), 'DD/MM/YYYY hh24:mi:ss') T$DATE, T016.T$REFCNTD, T016.T$REFCNTU
//FROM baan.twhcol016140 T016 LEFT JOIN baan.ttcibd001140 T002 ON TRIM(T016.T$ITEM) = TRIM(T002.T$ITEM)
//LEFT JOIN baan.ttcmcs003140 T003 ON T016.T$CWAR = T003.T$CWAR
//WHERE TRIM(t$labl) = '[:T$LABL]'
Dictionary <string, object> parametersOut = new Dictionary <string, object>();
try
{
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentencia, ref parametersOut, null, true);
if (consulta.Rows.Count < 1)
{
string tablaPrinc = owner + ".tticol022" + env;
strSentencia = recursos.readStatement(method.ReflectedType.Name, "selecttticol022", ref owner, ref env, tabla, paramList);
//strSentencia = "SELECT T022.T$SQNB T$LABL, T022.T$MITM T$ITEM, T002.T$DSCA ARTICULO, T002.T$CUNI UNIDAD, " +
// " T003.T$CWAR, T022.T$QTDL T$QTYR, T003.T$DSCA BODEGA, NVL(T002.T$KLTC ,3) T$KITM, " +
// " CASE NVL(T002.T$KLTC,3) WHEN 1 THEN T022.T$PDNO ELSE '' END T$CLOT " +
// "FROM " + tableSeco + " T022 LEFT JOIN " + tableSeco1 + " T001 ON T022.T$PDNO = T001.T$PDNO " +
// "LEFT JOIN " + tableSeco2 + " T003 ON T001.T$CWAR = T003.T$CWAR " +
// "LEFT JOIN " + tableSeco3 + " T002 ON TRIM(T022.T$MITM)= TRIM(T002.T$ITEM) " +
// "WHERE TRIM(T$SQNB) = '" + Parametros.labl.Trim() + "'";
//SELECT T022.T$SQNB T$LABL, T022.T$MITM T$ITEM, T002.T$DSCA ARTICULO, T002.T$CUNI UNIDAD,
//T003.T$CWAR, T022.T$QTDL T$QTYR, T003.T$DSCA BODEGA, NVL(T002.T$KLTC ,3) T$KITM,
//CASE NVL(T002.T$KLTC,3) WHEN 1 THEN T022.T$PDNO ELSE '' END T$CLOT
//FROM BAAN baan.tticol022140 T022 LEFT JOIN BAAN.ttisfc001140 T001 ON T022.T$PDNO = T001.T$PDNO
//LEFT JOIN BAAN.ttcmcs003140 T003 ON T001.T$CWAR = T003.T$CWAR
//LEFT JOIN BAAN.ttcibd001140 T002 ON TRIM(T022.T$MITM)= TRIM(T002.T$ITEM)
//WHERE TRIM(T$SQNB) = '[:T$LABL]'
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentencia, ref parametersOut, null, true);
if (consulta.Rows.Count < 1)
{
tablaPrinc = owner + ".twhcol018" + env;
strSentencia = recursos.readStatement(method.ReflectedType.Name, "selecttwhcol018", ref owner, ref env, tabla, paramList);
//strSentencia = "SELECT T022.T$TGID T$LABL, T022.T$ITEM, T002.T$DSCA ARTICULO, T002.T$CUNI UNIDAD, " +
// " T003.T$CWAR, SUBSTR(T022.T$TGID, 0, INSTR(T022.T$TGID, '-')) T$PDNO, T022.T$CLOT, " +
// " T022.T$QTDL T$QTYR, T003.T$DSCA BODEGA, T002.T$KLTC T$KITM " +
// " FROM " + tablaPrinc + " T022 LEFT JOIN " + tableSeco1 + " T001 ON " +
// " SUBSTR(T022.T$TGID, 0, INSTR(T022.T$TGID, '-')) = T001.T$PDNO " +
// " LEFT JOIN " + tableSeco2 + " T003 ON T001.T$CWAR = T003.T$CWAR " +
// " LEFT JOIN " + tableSeco3 + " T002 ON LTRIM(RTRIM(T022.T$ITEM))= LTRIM(RTRIM(T002.T$ITEM)) " +
// " WHERE LTRIM(RTRIM(T$TGID)) = '" + Parametros.labl.Trim() + "'";
//SELECT T022.T$TGID T$LABL, T022.T$ITEM, T002.T$DSCA ARTICULO, T002.T$CUNI UNIDAD,
//T003.T$CWAR, SUBSTR(T022.T$TGID, 0, INSTR(T022.T$TGID, '-')) T$PDNO, T022.T$CLOT,
//T022.T$QTDL T$QTYR, T003.T$DSCA BODEGA, T002.T$KLTC T$KITM
//FROM baan,twhcol018140 T022 LEFT JOIN baan.ttisfc001140 T001 ON
//SUBSTR(T022.T$TGID, 0, INSTR(T022.T$TGID, '-')) = T001.T$PDNO
//LEFT JOIN baan.ttcmcs003140 T003 ON T001.T$CWAR = T003.T$CWAR
//LEFT JOIN baan.ttcibd001140 T002 ON LTRIM(RTRIM(T022.T$ITEM))= LTRIM(RTRIM(T002.T$ITEM))
//WHERE LTRIM(RTRIM(T$TGID)) = '[:T$LABL]'
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentencia, ref parametersOut, null, true);
if (consulta.Rows.Count < 1)
{
strError = "Label ID " + Parametros.labl + " doesn't exist. Cannot Continue";
}
}
}
return(consulta);
}
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);
}
protected void btnSend_Click(object sender, EventArgs e)
{
obj = new Ent_ttwhcol017();
obj.labl = txtLabelId.Text.Trim();
DataTable valida = idal.TakeMaterialInv_listaConsLabel_Param(ref obj, ref strError);
btnSend.Enabled = false;
if (!string.IsNullOrEmpty(strError))
{
lblError.Text = String.Format(mensajes("labelnotexists"), obj.labl);
txtLabelId.Focus();
strError = string.Empty;
return;
}
lblError.Text = string.Empty;
strError = string.Empty;
List <Ent_ttwhcol017> parameterCollection = new List <Ent_ttwhcol017>();
obj.labl = txtLabelId.Text.Trim().ToUpperInvariant();;
obj.sqnb = 0;
obj.cwar = txtCwar.Text.ToUpperInvariant();
obj.item = txtItem.Text.ToUpperInvariant();
obj.clot = string.IsNullOrEmpty(txtLote.Text.Trim()) ? " " : txtLote.Text.Trim().ToUpperInvariant();
obj.qtdl = Decimal.Parse(txtQuantity.Text, System.Globalization.CultureInfo.InvariantCulture); //Convert.ToDecimal(txtQuantity.Text);
obj.cuni = hi_unityItem.Value;
obj.logn = Session["user"].ToString();
obj.coun = 0;
obj.proc = 2;
obj.refcntd = 0;
obj.refcntu = 0;
obj.zone = txtZone.Text.Trim().ToUpperInvariant();
parameterCollection.Add(obj);
int resultado = idal.insertarRegistro(ref parameterCollection, ref strError);
if (resultado < 1)
{
lblError.Text = mensajes("errorsave");
return;
}
//txtCwar.Text = string.Empty;
//lblCwar.Text = string.Empty;
txtLabelId.Text = string.Empty;
txtItem.Text = string.Empty;
lblItem.Text = string.Empty;
txtLote.Text = string.Empty;
txtQuantity.Text = string.Empty;
lblUnity.Text = string.Empty;
hi_unityItem.Value = string.Empty;
lblError.Text = mensajes("msjsave");
Page.Form.DefaultButton = btnSearch.UniqueID;
txtLabelId.Focus();
// btnSearchZone.Enabled = false;
txtZone.Enabled = false;
btnSend.Enabled = false;
}
