public DataTable findByOrderNumberAndOrigin(ref Ent_twhinh210 data, ref string strError) { method = MethodBase.GetCurrentMethod(); paramList = new Dictionary <string, object>(); paramList.Add(":T$ORNO", data.orno.Trim().ToUpper()); paramList.Add(":T$OORG", data.oorg.Trim().ToUpper()); paramList.Add(":T$ITEM", data.item.Trim().ToUpper()); paramList.Add(":T$CLOT", data.clot.Trim().ToUpper()); strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList); try { consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentencia, ref parametersOut, null, true); if (consulta.Rows.Count < 1) { strError = "Incorrect location, please verify."; } } catch (Exception ex) { strError = "Error to the search sequence [twhinh210]. 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 DataTable findByOrderNumberAndOrigin(ref Ent_twhinh210 data, ref string strError) { DataTable retorno = new DataTable(); try { retorno = dal.findByOrderNumberAndOrigin(ref data, ref strError); return(retorno); } catch (Exception ex) { throw new Exception(strError += "\nPila: " + ex.Message); } }
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"); } }