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; }