public DataTable ListaRegistro_ReprintRegrind(ref Ent_tticol042 Parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
string strSecuencia = Parametros.sqnb.Trim().ToUpperInvariant();
paramList = new Dictionary <string, object>();
paramList.Add(":T$SQNB", strSecuencia);
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 = "Not item's found for Sequence ";
}
}
catch (Exception ex)
{
strError = "Error to the search sequence [tticol042]. Try again or contact your administrator \n " + strSentencia;
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(consulta);
}
public static string Click_Query(string PAID)
{
if (active022 == true)
{
DataTable consultaOrden = tticol022DAL.ConsultaPorPalletID(ref PAID, ref strError);
Ent_tticol022 ObjTticol022 = new Ent_tticol022();
if (consultaOrden.Rows.Count > 0)
{
DataRow MyRow = consultaOrden.Rows[0];
ObjTticol022.proc = Convert.ToInt32(MyRow["PROC"].ToString());
ObjTticol022.mitm = MyRow["ITEM"].ToString();
ObjTticol022.dsca = MyRow["DSCA"].ToString();
ObjTticol022.qtdl = Convert.ToDecimal(MyRow["ACQT"].ToString() == String.Empty ? "0" : MyRow["ACQT"].ToString());
ObjTticol022.cuni = MyRow["CUNI"].ToString();
ObjTticol022.dele = Convert.ToInt32(MyRow["STAT"].ToString());
ObjTticol022.date = MyRow["DATEA"].ToString();
ObjTticol022.Error = false;
}
else
{
ObjTticol022.Error = true;
ObjTticol022.ErrorMsg = PalletidDoesnexist;
ObjTticol022.TypeMsgJs = "alert";
}
return(JsonConvert.SerializeObject(ObjTticol022));
}
else
{
DataTable consultaOrden = tticol042DAL.ConsultaPorPalletID(ref PAID, ref strError);
Ent_tticol042 ObjTticol042 = new Ent_tticol042();
if (consultaOrden.Rows.Count > 0)
{
DataRow MyRow = consultaOrden.Rows[0];
ObjTticol042.proc = Convert.ToInt32(MyRow["PROC"].ToString());
ObjTticol042.date = MyRow["DATEA"].ToString();
ObjTticol042.mitm = MyRow["ITEM"].ToString();
ObjTticol042.dsca = MyRow["DSCA"].ToString();
ObjTticol042.qtdl = Convert.ToDouble(MyRow["ACQT"].ToString() == String.Empty ? "0" : MyRow["ACQT"].ToString());
ObjTticol042.cuni = MyRow["CUNI"].ToString();
ObjTticol042.dele = Convert.ToInt32(MyRow["STAT"].ToString());
ObjTticol042.Error = false;
if (ObjTticol042.dele != 2)
{
ObjTticol042.Error = true;
ObjTticol042.ErrorMsg = RegrindPalletIDStatusdoesntallowdeleteit;
ObjTticol042.TypeMsgJs = "alert";
}
}
else
{
ObjTticol042.Error = true;
ObjTticol042.ErrorMsg = PalletidDoesnexist;
ObjTticol042.TypeMsgJs = "alert";
}
return(JsonConvert.SerializeObject(ObjTticol042));
}
}
public static string VerificarPalletID(string PAID)
{
string strError = string.Empty;
Ent_tticol042 ObjTticol042 = new Ent_tticol042();
ObjTticol042.sqnb = PAID.Trim();
DataTable DTticol042 = _idaltticol042.listaRegistroXSQNB_LocatedRegrind(ref ObjTticol042, ref strError);
if (DTticol042.Rows.Count > 0)
{
ObjTticol042.pdno = DTticol042.Rows[0]["T$PDNO"].ToString();
ObjTticol042.sqnb = DTticol042.Rows[0]["T$SQNB"].ToString();
ObjTticol042.mitm = DTticol042.Rows[0]["T$MITM"].ToString();
ObjTticol042.dsca = DTticol042.Rows[0]["T$DSCA"].ToString();
ObjTticol042.cuni = DTticol042.Rows[0]["T$CUNI"].ToString();
ObjTticol042.kltc = DTticol042.Rows[0]["T$KLTC"].ToString();
ObjTticol042.Error = false;
if (DTticol042.Rows[0]["T$DELE"].ToString() != "7")
{
ObjTticol042.Error = true;
ObjTticol042.TypeMsgJs = "label";
ObjTticol042.ErrorMsg = PalletIdNotLocated;
}
}
else
{
ObjTticol042.Error = true;
ObjTticol042.TypeMsgJs = "label";
ObjTticol042.ErrorMsg = PalletIdDoesntExist;
}
return(JsonConvert.SerializeObject(ObjTticol042));
}
public DataTable listaCantidadRegrind(ref Ent_tticol042 ParametrosIn, ref string strError)
{
method = MethodBase.GetCurrentMethod();
paramList = new Dictionary <string, object>();
paramList.Add(":T$PDNO", ParametrosIn.pdno);
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 = "-1";
}
return(consulta);
}
catch (Exception ex)
{
strError = "Error when querying data [tticol042]. Try again or contact your administrator";
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
throw ex;
}
}
public bool UpdateMasive(Ent_tticol042 MyObj042)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
string strError = string.Empty;
try
{
paramList = new Dictionary <string, object>();
paramList.Add(":T$PDNO", MyObj042.pdno);
paramList.Add(":T$MITM", MyObj042.mitm);
paramList.Add(":T$DELE", MyObj042.dele);
paramList.Add(":T$SQNB", MyObj042.sqnb.ToUpper());
strSentencia = recursos.readStatement("tticol042", method.Name, ref owner, ref env, tabla2, paramList);
//retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, parametrosIn, false);
retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, null, false);
//return retorno;
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
return(retorno);
}
public static string Click_Save(string PAID, string ORNO, string ITEM, string CWAR, string LOCA, string UNIT, string QTYS)
{
string strError = string.Empty;
_idalttwhcol122.ActCausalTICOL042(PAID, 7);
Ent_tticol042 ObjTticol042 = new Ent_tticol042();
ObjTticol042.pdno = ORNO;
ObjTticol042.sqnb = PAID;
ObjTticol042.urpt = HttpContext.Current.Session["user"].ToString();
ObjTticol042.acqt = Convert.ToDouble(QTYS);
ObjTticol042.cwaf = CWAR;
ObjTticol042.cwat = CWAR;
ObjTticol042.aclo = LOCA;
ObjTticol042.allo = 0;
ObjTticol042.Error = false;
List <Ent_tticol042> Listtticol042 = new List <Ent_tticol042>();
Listtticol042.Add(ObjTticol042);
bool res = _idaltticol042.insertarRegistroTticon242(ref Listtticol042, ref strError);
if (res == false)
{
_idaltticol042.ActualizarCantidadAlmacenRegistroTicol242(HttpContext.Current.Session["user"].ToString(), ObjTticol042.acqt, ObjTticol042.aclo, ObjTticol042.cwaf, ObjTticol042.sqnb);
}
return(JsonConvert.SerializeObject(ObjTticol042));
}
public bool UpdateMasive242WrhQty(Ent_tticol042 MyObj042)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
string strError = string.Empty;
try
{
paramList = new Dictionary <string, object>();
paramList.Add(":T$CWAT", MyObj042.cwat);
paramList.Add(":T$ACQT", MyObj042.acqt);
strSentencia = recursos.readStatement("tticol042", method.Name, ref owner, ref env, tabla2, paramList);
retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, null, false);
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
return(retorno);
}
//JC 240821 Solo actualiza cantidad en la ticol222 al pallet viejo
//public bool updatetticol222acqt(ref Ent_tticol022 parametro, ref string strError)
//{
// method = MethodBase.GetCurrentMethod();
// bool retorno = false;
// try
// {
// paramList = new Dictionary<string, object>();
// paramList.Add(":T$ACQT", parametro.acqt);
// paramList.Add(":T$CWAT", parametro.cwat);
// paramList.Add(":T$SQNB", parametro.sqnb);
// strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
// retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, parametrosIn, false);
// return retorno;
// }
// catch (Exception ex)
// {
// strError = ex.InnerException != null ?
// ex.Message + " (" + ex.InnerException + ")" :
// ex.Message;
// }
// return retorno;
//}
public bool updatetticol242(ref Ent_tticol042 parametro, ref string strError)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
try
{
paramList = new Dictionary <string, object>();
paramList.Add(":T$SWAR", parametro.cwaf.Trim().ToUpper());
paramList.Add(":T$SQNB", parametro.sqnb.Trim().ToUpper());
paramList.Add(":ALOC", parametro.aclo.ToUpper());
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, parametrosIn, false);
return(retorno);
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
return(retorno);
}
//JC 240821 Solo actualiza cantidad en la ticol222 al pallet viejo
//public bool updatetticol222acqt(ref Ent_tticol022 parametro, ref string strError)
//{
// bool retorno = false;
// try
// {
// retorno = dal.updatetticol222acqt(ref parametro, ref strError);
// return retorno;
// }
// catch (Exception ex)
// {
// throw new Exception(strError += "\nPila: " + ex.Message);
// }
//}
public bool updatetticol242(ref Ent_tticol042 parametro, ref string strError)
{
bool retorno = false;
try
{
retorno = dal.updatetticol242(ref parametro, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
public static string Click_Update(string WARE)
{
string strError = string.Empty;
Ent_twhcol130 MyObj131 = new Ent_twhcol130();
Ent_tticol022 MyObj022 = new Ent_tticol022();
Ent_tticol042 MyObj042 = new Ent_tticol042();
MyObj042.Error = true;
MyObj042.cwat = WARE;
MyObj042.acqt = Convert.ToInt32(0);
MyObj042.dele = Convert.ToInt32(11);
if (ITticol042.UpdateMasiveStatus(MyObj042))
{
ITticol042.UpdateMasive242WrhQty(MyObj042);
MyObj042.Error = false;
}
MyObj022.cwat = WARE;
MyObj022.acqt = Convert.ToInt32(0);
MyObj022.dele = Convert.ToInt32(11);
if (ITticol022.UpdateMasiveStatus(MyObj022))
{
ITticol022.UpdateMasive222WrhQty(MyObj022);
MyObj042.Error = false;
}
MyObj131.CWAA = WARE;
MyObj131.QTYA = Convert.ToInt32(0);
MyObj131.STAT = Convert.ToInt32(9);
if (ITwhcol130.UpdateMasiveStaQty(MyObj131))
{
MyObj042.Error = false;
}
if (MyObj042.Error == false)
{
MyObj042.Error = false;
MyObj042.TypeMsgJs = "label";
MyObj042.ErrorMsg = "Data Updated";
}
else
{
MyObj042.Error = true;
MyObj042.TypeMsgJs = "label";
MyObj042.ErrorMsg = "No Data Updated";
}
return(JsonConvert.SerializeObject(MyObj042));
}
public bool UpdateMasive242WrhQty(Ent_tticol042 MyObj042)
{
string strError = string.Empty;
try
{
bool retorno = dal.UpdateMasive242WrhQty(MyObj042);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
public int insertarRegistroSimpleD(ref Ent_tticol042 parametros, ref string strError)
{
int retorno = -1;
try
{
retorno = dal.insertarRegistroSimpleD(ref parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
public int InsertarRegistroTicol242(ref Ent_tticol042 data042, ref string strError)
{
int retorno = -1;
try
{
retorno = dal.InsertarRegistroTicol242(ref data042, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
//JC 15122021 Buscar el maximo consecutivo en todas las tablas
public DataTable listaCantidadRegrind_Disposicion(ref Ent_tticol042 ParametrosIn, ref string strError)
{
DataTable retorno;
try
{
retorno = dal.listaCantidadRegrind_Disposicion(ref ParametrosIn, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
public DataTable ListaRegistro_ReprintRegrind(ref Ent_tticol042 Parametros, ref string strError)
{
DataTable retorno;
try
{
retorno = dal.ListaRegistro_ReprintRegrind(ref Parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
public DataTable invLabel_registroImprimir_Param(ref Ent_tticol042 Parametros, ref string strError)
{
//int retorno = -1;
DataTable retorno;
try
{
retorno = dal.invLabel_registroImprimir_Param(ref Parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
protected void btnQuery_Click(object sender, EventArgs e)
{
Clear();
obj042 = new Ent_tticol042();
strError = string.Empty;
strConteo = string.Empty;
obj042.sqnb = txtSQNB.Text.Trim().ToUpperInvariant();
obj042.dele = 1;
resultado = idal042.listaRegistroXSQNB_ConfirmedRegrind(ref obj042, ref strError);
resultado1 = idal042.selectTticol000(ref strError);
string RGVL = resultado1.Rows[0]["T$RGVL"].ToString();
if (resultado.Rows.Count < 1)
{
lblError.Visible = true;
lblError.Text = mensajes("regrindnotexists");
return;
}
if (resultado.Rows[0]["T$DELE"].ToString() != "4" && RGVL != "2")
{
lblError.Visible = true;
lblError.Text = mensajes("regrindwrapped");
return;
}
if (resultado.Rows[0]["T$PRO1"].ToString() == "1")
{
lblError.Visible = true;
lblError.Text = mensajes("regrindconfirmed");
return;
}
lblWorkOrder.Text = resultado.Rows[0]["T$PDNO"].ToString();
lblRegrindSequence.Text = resultado.Rows[0]["T$SQNB"].ToString();
lblRegrindCode.Text = resultado.Rows[0]["T$MITM"].ToString();
lblRegrindDesc.Text = resultado.Rows[0]["T$DSCA"].ToString();
lblQuantity.Text = resultado.Rows[0]["T$QTDL"].ToString();
lblUnit.Text = resultado.Rows[0]["T$CUNI"].ToString();
lblWareh.Text = resultado.Rows[0]["T$CWAR"].ToString();
Session["PONO"] = resultado.Rows[0]["T$PONO"].ToString();
Session["CWAR"] = resultado.Rows[0]["T$CWAR"].ToString();
printerDiv.Visible = true;
btnSave.Visible = true;
}
public int insertarRegistroSimpleD(ref Ent_tticol042 parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
paramList = new Dictionary <string, object>();
paramList.Add(":T$PDNO", parametros.pdno.Trim().ToUpper());
paramList.Add(":T$SQNB", parametros.sqnb.Trim().ToUpper());
paramList.Add(":T$PROC", parametros.proc);
paramList.Add(":T$LOGN", parametros.logn.Trim().ToUpper());
paramList.Add(":T$MITM", parametros.mitm.Trim().ToUpper());
paramList.Add(":T$PONO", parametros.pono);
paramList.Add(":T$QTDL", parametros.qtdl);
paramList.Add(":T$CUNI", parametros.cuni.Trim().ToUpper());
paramList.Add(":T$LOG1", parametros.log1.Trim().ToUpper());
paramList.Add(":T$QTD1", parametros.qtd1);
paramList.Add(":T$PRO1", parametros.pro1);
paramList.Add(":T$LOG2", parametros.log2.Trim().ToUpper());
paramList.Add(":T$QTD2", parametros.qtd2);
paramList.Add(":T$PRO2", parametros.pro2);
paramList.Add(":T$LOCA", parametros.loca.Trim().ToUpper() == string.Empty ? " " : parametros.loca.Trim().ToUpper());
paramList.Add(":T$NORP", parametros.norp);
paramList.Add(":T$DELE", parametros.dele);
paramList.Add(":T$LOGD", parametros.logd.Trim().ToUpper());
try
{
strSentencia = recursos.readStatement("tticol042", method.Name, ref owner, ref env, tabla2, paramList);
log.escribirError("Sentencia SQL: " + strSentencia, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
parametrosIn = AdicionaParametrosComunes(parametros);
retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, null, false);
return(Convert.ToInt32(retorno));
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
log.escribirError(strError + Console.Out.NewLine + ex.Message + "Sentencia SQL: " + strSentencia, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(Convert.ToInt32(retorno));
}
protected void btnQuery_Click(object sender, EventArgs e)
{
Clear();
obj042 = new Ent_tticol042();
strError = string.Empty;
strConteo = string.Empty;
obj042.sqnb = txtSQNB.Text.Trim().ToUpperInvariant();
resultado = idal042.listaRegistroXSQNB_ConfirmedRegrind(ref obj042, ref strError);
if (resultado.Rows.Count < 1)
{
lblError.Visible = true;
lblError.Text = strError;
return;
}
if (resultado.Rows[0]["T$DELE"].ToString() != "4")
{
lblError.Visible = true;
lblError.Text = "Regrind has not been wrapped";
return;
}
if (resultado.Rows[0]["T$PRO1"].ToString() == "1")
{
lblError.Visible = true;
lblError.Text = "Regrind sequence already confirmed, process cannot continue";
return;
}
lblWorkOrder.Text = resultado.Rows[0]["T$PDNO"].ToString();
lblRegrindSequence.Text = resultado.Rows[0]["T$SQNB"].ToString();
lblRegrindCode.Text = resultado.Rows[0]["T$MITM"].ToString();
lblRegrindDesc.Text = resultado.Rows[0]["T$DSCA"].ToString();
lblQuantity.Text = resultado.Rows[0]["T$QTDL"].ToString();
lblUnit.Text = resultado.Rows[0]["T$CUNI"].ToString();
Session["PONO"] = resultado.Rows[0]["T$PONO"].ToString();
Session["CWAR"] = resultado.Rows[0]["T$CWAR"].ToString();
printerDiv.Visible = true;
btnSave.Visible = true;
}
protected void btnSend_Click(object sender, EventArgs e)
{
InsertarIngresoPagina();
lblError.Visible = false;
lblError.Text = string.Empty;
lblResult.Visible = false;
lblResult.Text = string.Empty;
obj042 = new Ent_tticol042();
strError = string.Empty;
obj042.sqnb = txtSQNB.Text.Trim().ToUpperInvariant();
resultado = idal042.listaRegistroXSQNB(ref obj042, ref strError);
if (resultado.Rows.Count < 1)
{
lblError.Visible = true;
lblError.Text = String.Format(mensajes("notfounditems"), obj042.sqnb.Trim());
return;
}
List <Ent_tticol042> parameterCollection042 = new List <Ent_tticol042>();
obj042.dele = 4;
parameterCollection042.Add(obj042);
int retorno = idal042.wrapRegrind_ActualizaRegistro(ref parameterCollection042, ref strError);
if (!string.IsNullOrEmpty(strError))
{
lblError.Visible = true;
lblError.Text = mensajes("errorupdt");
return;
}
if (retorno > 0)
{
lblResult.Visible = true;
}
lblResult.Text = Therecordhasbeenupdatedsuccessfully;
txtSQNB.Text = string.Empty;
}
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol042 parametros, bool blnUsarPRetorno = false)
{
string param = string.Empty;
List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>();
try
{
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PDNO", DbType.String, parametros.pdno);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SQNB", DbType.String, parametros.sqnb);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.String, parametros.proc);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MITM", DbType.String, parametros.mitm);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PONO", DbType.String, parametros.pono);
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$LOG1", DbType.String, parametros.log1);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTD1", DbType.Decimal, Convert.ToDecimal(parametros.qtd1).ToString("#.##0,0000"));
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PRO1", DbType.String, parametros.pro1);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOG2", DbType.String, parametros.log2);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTD2", DbType.Decimal, Convert.ToDecimal(parametros.qtd2).ToString("#.##0,0000"));
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PRO2", DbType.String, parametros.pro2);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCA", DbType.String, parametros.loca);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$NORP", DbType.String, parametros.norp);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DELE", DbType.String, parametros.dele);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGD", DbType.String, parametros.logd);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.String, parametros.refcntd);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.String, parametros.refcntu);
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);
}
protected void btnSend_Click(object sender, EventArgs e)
{
InsertarIngresoPagina();
lblError.Visible = false;
lblError.Text = string.Empty;
lblResult.Visible = false;
lblResult.Text = string.Empty;
obj042 = new Ent_tticol042();
strError = string.Empty;
obj042.sqnb = txtSQNB.Text.Trim().ToUpperInvariant();
resultado = idal042.listaRegistroXSQNB(ref obj042, ref strError);
if (resultado.Rows.Count < 1)
{
lblError.Visible = true;
lblError.Text = strError + obj042.sqnb.Trim();
return;
}
List <Ent_tticol042> parameterCollection042 = new List <Ent_tticol042>();
obj042.dele = 4;
parameterCollection042.Add(obj042);
int retorno = idal042.wrapRegrind_ActualizaRegistro(ref parameterCollection042, ref strError);
if (!string.IsNullOrEmpty(strError))
{
lblError.Visible = true;
lblError.Text = strError;
return;
}
if (retorno > 0)
{
lblResult.Visible = true;
}
lblResult.Text = "Pallet was saved succesfully.";
txtSQNB.Text = string.Empty;
}
private static bool UpdatePalletOriginTable(ref Ent_twhcol028 twhcol028)
{
bool res = false;
string separator = "-";
string SQNB = twhcol028.PAID.Substring(0,twhcol028.PAID.IndexOf(separator));
switch (HttpContext.Current.Session["TBL"].ToString())
{
case "ticol022":
Ent_tticol022 obj022 = new Ent_tticol022();
obj022.sqnb = twhcol028.PAID;
obj022.dele = 7;
obj022.cwaf = twhcol028.TWAR;
obj022.cwat = twhcol028.TWAR;
obj022.aclo = twhcol028.TLOC == string.Empty ? " " : twhcol028.TLOC;
res = dalticol100.updatetticol222(ref obj022,ref strError);
break;
case "ticol042":
Ent_tticol042 obj042 = new Ent_tticol042();
obj042.sqnb = twhcol028.PAID;
obj042.dele = 7;
obj042.cwaf = twhcol028.TWAR;
obj042.cwat = twhcol028.TWAR;
obj042.aclo = twhcol028.TLOC == string.Empty ? " " : twhcol028.TLOC;;
res = dalticol100.updatetticol242(ref obj042,ref strError);
break;
case "whcol131":
Ent_twhcol130131 MyObj131 = new Ent_twhcol130131();
MyObj131.PAID = twhcol028.PAID;
MyObj131.STAT = "3";
MyObj131.CWAR = twhcol028.TWAR;
MyObj131.LOCA = twhcol028.TLOC == string.Empty ? " " : twhcol028.TLOC;;
res = dalticol100.updatetwhcol131(ref MyObj131,ref strError);
break;
}
return(res);
}
protected void btnQuery_Click(object sender, EventArgs e)
{
Clear();
obj042 = new Ent_tticol042();
strError = string.Empty;
strConteo = string.Empty;
obj042.sqnb = txtSQNB.Text.Trim().ToUpperInvariant();
resultado = idal042.listaRegistroXSQNB_LocatedRegrind(ref obj042, ref strError);
if (resultado.Rows.Count < 1)
{
lblError.Visible = true;
lblError.Text = mensajes("regrindnotexists");
return;
}
if (resultado.Rows[0]["T$PRO2"].ToString() == "1")
{
lblError.Visible = true;
lblError.Text = mensajes("alreadylocated");
return;
}
lblWorkOrder.Text = resultado.Rows[0]["T$PDNO"].ToString();
lblRegrindSequence.Text = resultado.Rows[0]["T$SQNB"].ToString();
lblRegrindCode.Text = resultado.Rows[0]["T$MITM"].ToString();
lblRegrindDesc.Text = resultado.Rows[0]["T$DSCA"].ToString();
lblQuantity.Text = resultado.Rows[0]["T$ACQT"].ToString();
lblUnit.Text = resultado.Rows[0]["T$CUNI"].ToString();
Session["PONO"] = resultado.Rows[0]["T$PONO"].ToString();
Session["CWAR"] = resultado.Rows[0]["T$CWAR"].ToString();
printerDiv.Visible = true;
btnSave.Visible = true;
}
public DataTable invLabel_registroImprimir_Param(ref Ent_tticol042 Parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
string strSentenciaS = string.Empty;
string strOrden = Parametros.pdno.Trim().ToUpperInvariant();
string strSecuencia = Parametros.sqnb.Trim().ToUpperInvariant();;
paramList = new Dictionary <string, object>();
paramList.Add("p1", strOrden);
paramList.Add("p2", strSecuencia);
strSentenciaS = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
try
{
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentenciaS, ref parametersOut, null, true);
}
catch (Exception ex)
{
strError = "Error to search information to print [tticol022]. Try again or contact your administrator \n " + strSentencia;
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(consulta);
}
public int InsertarRegistroTicol242(ref Ent_tticol042 parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
paramList = new Dictionary <string, object>();
paramList.Add(":T$PDNO", parametros.pdno.Trim().ToUpper());
paramList.Add(":T$SQNB", parametros.sqnb.Trim().ToUpper());
paramList.Add(":T$URPT", parametros.urpt.ToUpper());
paramList.Add(":T$ACQT", parametros.acqt.ToString().Contains(",") == true ? parametros.acqt.ToString().Replace(",", ".") : parametros.acqt.ToString().Replace(".", ","));
paramList.Add(":T$CWAF", parametros.cwaf.ToUpper().Trim());
paramList.Add(":T$CWAT", parametros.cwat.ToUpper().Trim() == string.Empty ? " " : parametros.cwat.ToUpper().Trim());
paramList.Add(":T$ACLO", parametros.aclo.ToUpper() == string.Empty ? " " : parametros.aclo.ToUpper().Trim());
paramList.Add(":T$ALLO", parametros.allo.ToString().Contains(".") == true ? parametros.allo.ToString().Replace(".", ",") : parametros.allo.ToString().Replace(",", "."));
try
{
strSentencia = recursos.readStatement("tticol042", method.Name, ref owner, ref env, tabla2, paramList);
log.escribirError("Sentencia SQL: " + strSentencia, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
parametrosIn = AdicionaParametrosComunes(parametros);
retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, null, false);
return(Convert.ToInt32(retorno));
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
log.escribirError(strError + Console.Out.NewLine + ex.Message + "Sentencia SQL: " + strSentencia, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(Convert.ToInt32(retorno));
}
public int insertarRegistroSimple(ref Ent_tticol042 parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
try
{
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla);
parametrosIn = AdicionaParametrosComunes(parametros);
retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, parametrosIn, false);
return(Convert.ToInt32(retorno));
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
return(Convert.ToInt32(retorno));
}
private static bool saveNewPalletOriginTable(ref Ent_twhcol028 twhcol028,string MaxSequence)
{
bool res = false;
string separator = "-";
twhcol028.PAID = recursos.GenerateNewPallet(MaxSequence,separator);
string SQNB = twhcol028.PAID.Substring(0,twhcol028.PAID.IndexOf(separator));
twhcol028.LOGN = HttpContext.Current.Session["user"].ToString();
twhcol028.DATR = DateTime.Now.ToString("MM/dd/yyyy");
switch (HttpContext.Current.Session["TBL"].ToString())
{
case "ticol022":
Ent_tticol022 obj022 = new Ent_tticol022();
List <Ent_tticol022> list022 = new List <Ent_tticol022>();
twhcol028.WHLOT = twhcol028.TLOT.Trim() == string.Empty ? " " : twhcol028.TLOT.Trim();
obj022.pdno = SQNB;
obj022.sqnb = twhcol028.PAID;
obj022.proc = 1;
obj022.logn = twhcol028.LOGN;
obj022.mitm = twhcol028.TITM;
//JC 210122 Grabar la cantidad Correcta si es un regrind
//obj022.cuni = twhcol028.UNIT;
//obj022.qtdl = Convert.ToDecimal(twhcol028.TQTY);
if (twhcol028.TYPE == "RET")
{
obj022.cuni = twhcol028.UNRG;
obj022.qtdl = Math.Round(((Convert.ToDecimal(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462)),4);
obj022.qtd1 = Convert.ToInt32((Convert.ToInt32(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462));
obj022.qtd2 = Convert.ToInt32((Convert.ToInt32(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462));
obj022.acqt = Math.Round(((Convert.ToDecimal(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462)),4);
}
else
{
obj022.cuni = twhcol028.UNIT;
obj022.qtdl = Convert.ToDecimal(twhcol028.TQTY);
obj022.qtd1 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj022.qtd2 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj022.acqt = Convert.ToDecimal(twhcol028.TQTY);
}
obj022.log1 = "NONE";
//obj022.qtd1 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj022.pro1 = 1;
obj022.log2 = "NONE";
//obj022.qtd2 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj022.pro2 = 2;
obj022.loca = " ";
obj022.norp = 1;
obj022.dele = 7;
obj022.logd = "NONE";
obj022.refcntd = 0;
obj022.refcntu = 0;
obj022.drpt = DateTime.Now;
obj022.urpt = twhcol028.LOGN;
//obj022.acqt = Convert.ToDecimal(twhcol028.TQTY);
obj022.cwaf = twhcol028.TWAR;
obj022.cwat = twhcol028.TWAR;
obj022.aclo = twhcol028.SLOC;
obj022.allo = 0;
list022.Add(obj022);
bool insert022 = Convert.ToBoolean(_idaltticol022.insertarRegistroSimple(ref obj022,ref strError));
bool insert222 = Convert.ToBoolean(_idaltticol022.InsertarRegistroTicol222(ref obj022,ref strError));
res = (insert222 == true && insert022 == true) ? true : false;
break;
case "ticol042":
Ent_tticol042 obj042 = new Ent_tticol042();
List <Ent_tticol042> list042 = new List <Ent_tticol042>();
twhcol028.WHLOT = twhcol028.TLOT;
obj042.pdno = SQNB;
obj042.sqnb = twhcol028.PAID;
obj042.proc = 1;
obj042.logn = twhcol028.LOGN;
obj042.mitm = twhcol028.TITM;
obj042.qtdl = Convert.ToDouble(twhcol028.TQTY);
obj042.cuni = twhcol028.UNIT;
obj042.log1 = "NONE";
obj042.qtd1 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj042.pro1 = 1;
obj042.log2 = "NONE";
obj042.qtd2 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj042.pro2 = 2;
obj042.loca = " ";
obj042.norp = 1;
obj042.dele = 7;
obj042.logd = "NONE";
obj042.refcntd = 0;
obj042.refcntu = 0;
obj042.drpt = DateTime.Now;
obj042.urpt = twhcol028.LOGN;
obj042.acqt = Convert.ToDouble(twhcol028.TQTY);
obj042.cwaf = twhcol028.TWAR;
obj042.cwat = twhcol028.TWAR;
obj042.aclo = twhcol028.SLOC;
obj042.allo = 0;
list042.Add(obj042);
bool insert042 = Convert.ToBoolean(_idaltticol042.insertarRegistroSimple(ref obj042,ref strError));
bool insert242 = Convert.ToBoolean(_idaltticol042.InsertarRegistroTicol242(ref obj042,ref strError));
res = (insert242 == true && insert042 == true) ? true : false;
break;
case "whcol131":
Ent_twhcol130131 obj131 = new Ent_twhcol130131();
Ent_twhcol130131 MyObj131 = new Ent_twhcol130131();
twhcol028.WHLOT = twhcol028.PAID.Substring(0,(twhcol028.PAID.IndexOf("-")));
MyObj131.OORG = "4";
MyObj131.ORNO = SQNB.Trim().ToUpper();
MyObj131.ITEM = twhcol028.TITM;
MyObj131.PAID = twhcol028.PAID;
MyObj131.PONO = "0";
MyObj131.SEQN = "0";
MyObj131.CLOT = string.IsNullOrEmpty(twhcol028.TLOT) ? " " : twhcol028.TLOT.ToUpper();
MyObj131.CWAR = twhcol028.TWAR;
MyObj131.QTYS = twhcol028.TQTY; // cantidad escaneada view
MyObj131.QTYA = twhcol028.TQTY;
MyObj131.UNIT = twhcol028.UNIT;
MyObj131.QTYC = twhcol028.TQTY; //cantidad escaneada view aplicando factor
MyObj131.UNIC = twhcol028.UNIT;
MyObj131.DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString(); //fecha de confirmacion
MyObj131.CONF = "1";
MyObj131.RCNO = " "; //llena baan
MyObj131.DATR = "01/01/70"; //llena baan
MyObj131.LOCA = twhcol028.SLOC; // enviamos vacio
MyObj131.DATL = DateTime.Now.ToString("dd/MM/yyyy").ToString(); //llenar con fecha de hoy
MyObj131.PRNT = "1"; // llenar en 1
MyObj131.DATP = DateTime.Now.ToString("dd/MM/yyyy").ToString(); //llena baan
MyObj131.NPRT = "1"; //conteo de reimpresiones
MyObj131.LOGN = twhcol028.LOGN; // nombre de ususario de la session
MyObj131.LOGT = " "; //llena baan
MyObj131.STAT = "3"; // LLENAR EN 1
MyObj131.DSCA = "0";
MyObj131.COTP = "0";
MyObj131.FIRE = "1";
MyObj131.PSLIP = " ";
MyObj131.ALLO = "0";
string StrError = string.Empty;
res = _idaltwhcol130.Insertartwhcol131(MyObj131,ref StrError);
break;
}
return(res);
}
protected void btnSave_Click(object sender, EventArgs e)
{
txtAdjustmentQuantity.Text = txtAdjustmentQuantity.Text.Trim() == string.Empty ? "0" : txtAdjustmentQuantity.Text.Trim();
string inputQtyStr = txtAdjustmentQuantity.Text;
decimal inputQty;
if (inputQtyStr.Contains("."))
{
inputQty = Convert.ToDecimal(inputQtyStr);
if (!inputQty.ToString().Contains("."))
{
inputQty = Convert.ToDecimal(ReplaceDecimal(inputQtyStr));
}
}
else if (inputQtyStr.Contains(","))
{
inputQty = Convert.ToDecimal(inputQtyStr);
if (!inputQty.ToString().Contains(","))
{
inputQty = Convert.ToDecimal(ReplaceDecimal(inputQtyStr));
}
}
else
{
inputQty = Convert.ToDecimal(inputQtyStr);
}
if (inputQty < 0)
{
lblError.Text = "";
lblError.Text = Adjustmentquantitycannotbezero;
txtPalletId.Enabled = true;
txtPalletId.Text = String.Empty;
btnSend.Visible = true;
tblPalletInfo.Visible = true;
btnSave.Visible = true;
txtAdjustmentQuantity.Text = "";
txtAdjustmentQuantity.Focus();
return;
}
else
{
if (lblQuantityValue.Text.Trim() != "0")
{
if (inputQty > (Convert.ToDecimal(lblQuantityValue.Text) * 2))
{
lblError.Text = "New quantity not allowed, máximum double”";
txtPalletId.Enabled = true;
btnSave.Visible = true;
tblPalletInfo.Visible = true;
btnSave.Visible = true;
txtAdjustmentQuantity.Text = "";
txtAdjustmentQuantity.Focus();
return;
}
}
}
//if (Convert.ToInt32(txtAdjustmentQuantity.Text.Trim()) > Convert.ToInt32(lblQuantityValue.Text.Trim()))
//{
// lblError.Text = AdjustmentquantityshouldbelessthanexistingQty;
// txtPalletId.Enabled = true;
// txtPalletId.Text = String.Empty;
// btnSend.Visible = true;
// return;
//}
InterfazDAL_twhcol025 idal = new InterfazDAL_twhcol025();
string strError = string.Empty;
List<Ent_twhcol025> parameterCollection025 = new List<Ent_twhcol025>();
//T$PAID, T$ITEM, T$LOCA, T$CLOT, T$QTYA, T$UNIT, T$DATE, T$LOGN, T$EMNO, T$PROC, T$REFCNTD,T$REFCNTU
string PAID = txtPalletId.Text.ToUpperInvariant().Trim();
int consecutivoPalletID = 0;
string strMaxSequence = getSequence(PAID, "A");
string separator = "-";
string newPallet = recursos.GenerateNewPallet(strMaxSequence, separator);
string SQNB = PAID.Substring(0, PAID.IndexOf(separator));
Ent_tticol082 MyObj82 = new Ent_tticol082();
MyObj82.PAID = PAID;
MyObj82.QTYC = "0";
obj.PAID = PAID;
obj.ITEM = lblItemValue.Text.Trim().ToUpper();
//obj.LOCA = lblLocationValue.Text.Trim().ToUpper();
obj.CWAR = lblWarehouseValue.Text;
obj.LOCA = lblLocationValue.Text;
obj.CLOT = lblLotValue.Text;
obj.QTYA = Convert.ToDouble(inputQty) - Pquantity;
obj.UNIT = lblUnitValue.Text.Trim();
obj.LOGN = Session["user"].ToString(); ;
//obj.CDIS = dropDownReasonCodes.SelectedItem.Value;
//obj.EMNO = dropDownCostCenters.SelectedItem.Value;
//JC 280921 Evitar que tome los valores por defecto de la variable de session
//obj.CDIS = Session["cdis"].ToString();
//obj.EMNO = Session["emno"].ToString();
obj.CDIS = dropDownReasonCodes.SelectedValue;
obj.EMNO = dropDownCostCenters.SelectedValue;
obj.PROC = 2;
obj.ORNO = " ";
obj.PONO = Convert.ToInt32(HttpContext.Current.Session["pono"].ToString());
obj.MESS = " ";
obj.REFCNTD = 0;
obj.REFCNTU = 0;
parameterCollection025.Add(obj);
var validSave = idal.insertRegistrItemAdjustment(ref parameterCollection025, ref strError);
if (validSave > 0)
{
if (Convert.ToInt32(HttpContext.Current.Session["flag022"].ToString().Trim()) == 1)
{
twhcolDAL.ActCausalTICOL022(PAID, 14);
Ent_tticol022 MyObj = new Ent_tticol022();
MyObj.pdno = obj.CLOT;
MyObj.sqnb = newPallet;
MyObj.proc = 2;
MyObj.logn = HttpContext.Current.Session["user"].ToString().Trim();
MyObj.mitm = obj.ITEM.Trim();
MyObj.qtdl = Convert.ToDecimal(inputQty);
MyObj.cuni = obj.UNIT;//CUNI;
MyObj.log1 = "NONE";
MyObj.qtd1 = Convert.ToInt32(inputQty);
MyObj.pro1 = 2;
MyObj.log2 = "NONE";
MyObj.qtd2 = Convert.ToInt32(inputQty);
MyObj.pro2 = 2;
MyObj.loca = obj.LOCA;
MyObj.norp = 1;
MyObj.dele = 7;
MyObj.logd = "NONE";
MyObj.refcntd = 0;
MyObj.refcntu = 0;
MyObj.drpt = DateTime.Now;
MyObj.urpt = HttpContext.Current.Session["user"].ToString().Trim();
MyObj.acqt = Convert.ToDecimal(inputQty);
MyObj.cwaf = obj.CWAR;//CWAR;
MyObj.cwat = obj.CWAR;//CWAR;
MyObj.aclo = obj.LOCA;
MyObj.allo = 0;// Convert.ToDecimal(txtAdjustmentQuantity.Text.Trim()); ;
var validateSave = _idaltticol022.insertarRegistroSimple(ref MyObj, ref strError);
var validateSaveTicol222 = _idaltticol022.InsertarRegistroTicol222(ref MyObj, ref strError);
var ActalizacionExitosa = Itticol082.Actualizartticol222Cant(MyObj82);
}
else if (Convert.ToInt32(HttpContext.Current.Session["flag042"].ToString().Trim()) == 1)
{
twhcolDAL.ActCausalTICOL042(PAID, 14);
Ent_tticol042 MyObj = new Ent_tticol042();
MyObj.pdno = obj.CLOT;
MyObj.sqnb = newPallet;
MyObj.proc = 2;
MyObj.logn = HttpContext.Current.Session["user"].ToString().Trim();
MyObj.mitm = obj.ITEM.Trim();
MyObj.qtdl = Convert.ToDouble(inputQty);
MyObj.cuni = obj.UNIT;//CUNI;
MyObj.log1 = "NONE";
MyObj.qtd1 = Convert.ToDecimal(inputQty);
MyObj.pro1 = 2;
MyObj.log2 = "NONE";
MyObj.qtd2 = Convert.ToDecimal(inputQty);
MyObj.pro2 = 2;
MyObj.loca = obj.LOCA;
MyObj.norp = 1;
MyObj.dele = 7;
MyObj.logd = "NONE";
MyObj.refcntd = 0;
MyObj.refcntu = 0;
MyObj.drpt = DateTime.Now;
MyObj.urpt = HttpContext.Current.Session["user"].ToString().Trim();
MyObj.acqt = Convert.ToDouble(inputQty);
MyObj.cwaf = obj.CWAR;//CWAR;
MyObj.cwat = obj.CWAR;//CWAR;
MyObj.aclo = obj.LOCA;
MyObj.allo = 0;// Convert.ToDecimal(txtAdjustmentQuantity.Text.Trim());//Convert.ToDecimal(qtyt_act.ToString());
var validateSave = _idaltticol042.insertarRegistroSimple(ref MyObj, ref strError);
var validateSaveTicol242 = _idaltticol042.InsertarRegistroTicol242(ref MyObj, ref strError);
var ActalizacionExitosa = Itticol082.Actualizartticol242Cant(MyObj82);
}
else if (Convert.ToInt32(HttpContext.Current.Session["flag131"].ToString().Trim()) == 1)
{
twhcolDAL.ActCausalcol131140(PAID, 5);
Ent_twhcol130131 MyObj = new Ent_twhcol130131();
MyObj.OORG = "2";// Order type escaneada view
MyObj.ORNO = newPallet.Substring(0, newPallet.IndexOf("-"));
MyObj.ITEM = obj.ITEM.Trim();
MyObj.PAID = newPallet;
MyObj.PONO = HttpContext.Current.Session["pono"].ToString();
MyObj.SEQN = "1";
MyObj.CLOT = obj.CLOT;//CLOT.ToUpper();// lote VIEW
MyObj.CWAR = obj.CWAR;//CWAR.ToUpper();
MyObj.QTYS = inputQty.ToString();//QTYS;// cantidad escaneada view
MyObj.UNIT = obj.UNIT;//UNIT;//unit escaneada view
MyObj.QTYC = inputQty.ToString();//QTYS;//cantidad escaneada view aplicando factor
MyObj.QTYA = inputQty.ToString();//QTYS;//cantidad escaneada view aplicando factor
MyObj.UNIC = obj.UNIT;//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 = DateTime.Now.ToString("dd/MM/yyyy").ToString();//llena baan
MyObj.LOCA = obj.LOCA;//LOCA.ToUpper();// 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().Trim();// nombre de ususario de la session
MyObj.LOGT = " ";//llena baan
MyObj.STAT = "3";// LLENAR EN 3
MyObj.DSCA = " ";
MyObj.COTP = " ";
MyObj.FIRE = "2";
MyObj.PSLIP = " ";
MyObj.ALLO = "0"; //txtAdjustmentQuantity.Text.Trim();
string StrError = string.Empty;
bool Insertsucces = twhcol130DAL.Insertartwhcol131(MyObj, ref StrError);
var ActalizacionExitosa = Itticol082.Actualizartwhcol131Cant(MyObj82);
}
lblError.Text = "";
lblConfirm.Text = mensajes("msjsave");
//divTable.Visible = false;
lblitemDesc.Text = Transfers.DescripcionItem(obj.ITEM); ;
lblWorkOrder.Text = obj.PAID.Substring(0, obj.PAID.IndexOf("-"));
lblPalletNum.Text = newPallet.Substring(obj.PAID.IndexOf("-") + 1);
lblInspector.Text = obj.LOGN;
lblDate.Text = DateTime.Now.ToString("MM/dd/yyyy");
//lblShift.Text =Session["shif"].ToString();
lblQuantityL.Text = txtAdjustmentQuantity.Text.Trim() + " " + lblUnitValue.Text.Trim();
codeItem.ImageUrl = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + obj.ITEM.Trim() + "&code=Code128&dpi=96";
codePaid.ImageUrl = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + newPallet.Trim() + "&code=Code128&dpi=96";
divPrint.Visible = true;
txtPalletId.Enabled = true;
txtPalletId.Text = String.Empty;
txtAdjustmentQuantity.Text = String.Empty;
dropDownCostCenters.Items.Clear();
dropDownReasonCodes.Items.Clear();
lblCost.Text = string.Empty;
lblReason.Text = string.Empty;
btnSend.Visible = true;
}
else
{
lblConfirm.Text = "";
lblError.Text = mensajes("errorsave");
return;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Session["save"] == null)
{
Session["save"] = true;
List <Ent_tticol125> parameterCollection = new List <Ent_tticol125>();
Ent_tticol125 obj = new Ent_tticol125();
//Recorrer filas con valores en los textos
Session["WorkOrder"] = txtWorkOrder.Text.Trim();
//string vpaid = validaPalletID("OPI009584-001", 1);
String a = string.Empty;
foreach (GridViewRow row in grdRecords.Rows)
{
string paid = string.Empty;
string sec = string.Empty;
int sec022 = 0;
string toreturn = ((TextBox)row.Cells[4].FindControl("toReturn")).Text;
string toLot = ((DropDownList)row.Cells[6].FindControl("toLot")).SelectedValue;
//string palletId = ((TextBox)row.Cells[9].FindControl("palletId")).Text;
string condLote = ((HiddenField)row.Cells[4].FindControl("LOTE")).Value.Trim();
ktlc = Convert.ToString(row.Cells[9].Text);
Item = row.Cells[0].Text.ToUpperInvariant();
//JC 180821 Tomar la bodega del maestro de artículos
HttpContext.Current.Session["ITEM"] = Item;
var Warehouse = Itwhcol130.GetWarehouseMaterialReturn(HttpContext.Current.Session["ITEM"].ToString());
Uni = row.Cells[3].Text.ToLower().Trim();
//JC 061221 Como ya no se tiene posición se define fija la posicíón 10
//Pos = row.Cells[0].Text;
Pos = "10";
Tipo = row.Cells[10].Text;
Clase = row.Cells[11].Text.ToUpperInvariant().Trim();
bool reqLote = condLote == "1" ? true : false;
//if (myObj.CUNI.Trim().ToUpper() != "PLT")
//{
// MyConvertionFactor = FactorConversion(myObj.ITEM, myObj.CUNI, "PLT");
// QUANTITYPLT = (MyConvertionFactor.Tipo == "Div") ? Convert.ToDecimal((QUANTITYCUNI * MyConvertionFactor.FactorB) / MyConvertionFactor.FactorD) : Convert.ToDecimal((QUANTITYCUNI * MyConvertionFactor.FactorD) / MyConvertionFactor.FactorB);
// ciclosADVS = Convert.ToInt32(Math.Ceiling(QUANTITYPLT));
//}
//if (palletId.Trim() == string.Empty)
//{
// lblResult.Text = RecordswithoutIDpallet;
// lblResult.ForeColor = System.Drawing.Color.Red;
// return;
//}
if ((reqLote && String.IsNullOrEmpty(toLot.Trim())) && !string.IsNullOrEmpty(toreturn))
{
lblResult.Text = mensajes("lotcode");
lblResult.ForeColor = System.Drawing.Color.Red;
Session["save"] = null;
return;
}
//string toreturn = ((TextBox)row.Cells[6].FindControl("toReturn")).Text;
//string toLot = ((TextBox)row.Cells[8].FindControl("toLot")).Text;
int tabla022 = 0;
int tabla042 = 0;
int tabla131 = 0;
if (!toreturn.Equals(string.Empty))
{
if (Tipo == "2")
{
if (Clase != "RET")
{
tabla022 = 1;
tabla042 = 0;
tabla131 = 0;
}
else
{
tabla042 = 1;
tabla022 = 0;
tabla131 = 0;
}
}
else
{
tabla131 = 1;
tabla022 = 0;
tabla042 = 0;
}
DataTable dt022 = Itticol022.SecuenciaMayorRT(txtWorkOrder.Text.Trim().ToUpperInvariant());
if (dt022.Rows.Count > 0)
{
paid = dt022.Rows[0]["T$SQNB"].ToString().Trim().ToUpper();;
sec = paid.Substring(12, 2);
sec022 = Convert.ToInt32(sec);
sec = addZero(sec022 + 1);
}
else
{
sec = "01";
}
if (tabla131 == 1)
{
Ent_twhcol130131 obj131 = new Ent_twhcol130131();
Ent_twhcol130131 MyObj = new Ent_twhcol130131();
MyObj.OORG = "4";
MyObj.ORNO = txtWorkOrder.Text.Trim().ToUpper();
MyObj.ITEM = row.Cells[0].Text.ToUpper();
MyObj.PAID = txtWorkOrder.Text.Trim().ToUpper() + "-RT" + sec;
//JC 061221 Como ya no se tiene posición se define fija la posicíón 10
//MyObj.PONO = Convert.ToInt32(row.Cells[0].Text).ToString();
MyObj.PONO = "10";
MyObj.SEQN = "0";
MyObj.CLOT = string.IsNullOrEmpty(toLot) ? " " : toLot.ToUpper();
//JC 180821 Grabar la bodega por defecto del item
//MyObj.CWAR = row.Cells[3].Text.ToUpperInvariant();
MyObj.CWAR = Warehouse.Rows[0]["WARITEM"].ToString().Trim().ToUpper();
MyObj.QTYS = toreturn;// cantidad escaneada view
MyObj.QTYA = toreturn;
MyObj.UNIT = row.Cells[3].Text.Trim();
MyObj.QTYC = toreturn; //cantidad escaneada view aplicando factor
MyObj.UNIC = row.Cells[3].Text.Trim();
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 = " "; // 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 = "1"; // LLENAR EN 1
MyObj.DSCA = row.Cells[1].Text.ToUpperInvariant();
MyObj.COTP = "0";
MyObj.FIRE = "1";
MyObj.PSLIP = " ";
MyObj.ALLO = "0";
string StrError = string.Empty;
Itwhcol130.Insertartwhcol131(MyObj, ref StrError);
}
if (tabla022 == 1)
{
Ent_tticol022 obj022 = new Ent_tticol022();
List <Ent_tticol022> list022 = new List <Ent_tticol022>();
//obj022.pdno = txtWorkOrder.Text.Trim().ToUpper();
obj022.pdno = string.IsNullOrEmpty(toLot) ? txtWorkOrder.Text.Trim().ToUpper() : toLot.ToUpper().Trim();
obj022.sqnb = txtWorkOrder.Text.Trim().ToUpper() + "-RT" + sec;
obj022.proc = 1;
obj022.logn = HttpContext.Current.Session["user"].ToString();
obj022.mitm = row.Cells[0].Text.ToUpper().Trim();
obj022.qtdl = Convert.ToDecimal(toreturn);
obj022.cuni = row.Cells[3].Text.Trim();
obj022.log1 = "NONE";
obj022.qtd1 = Convert.ToInt32(toreturn);
obj022.pro1 = 1;
obj022.log2 = "NONE";
obj022.qtd2 = Convert.ToInt32(toreturn);
obj022.pro2 = 2;
obj022.loca = " ";
obj022.norp = 1;
obj022.dele = 2;
obj022.logd = "NONE";
obj022.refcntd = 0;
obj022.refcntu = 0;
obj022.drpt = DateTime.Now;
obj022.urpt = HttpContext.Current.Session["user"].ToString();
obj022.acqt = Convert.ToDecimal(toreturn);
//JC 180821 Grabar la bodega por defecto del item
//obj022.cwaf = row.Cells[3].Text.ToUpper();
//obj022.cwat = row.Cells[3].Text.ToUpper();
obj022.cwaf = Warehouse.Rows[0]["WARITEM"].ToString().Trim().ToUpper();
obj022.cwat = Warehouse.Rows[0]["WARITEM"].ToString().Trim().ToUpper();
obj022.aclo = "";
obj022.allo = 0;
list022.Add(obj022);
Itticol022.insertarRegistroSimple(ref obj022, ref strError);
Itticol022.InsertarRegistroTicol222(ref obj022, ref strError);
}
if (tabla042 == 1)
{
Ent_tticol042 obj042 = new Ent_tticol042();
List <Ent_tticol042> list042 = new List <Ent_tticol042>();
//JC 061221 Ajustar para que salve el campo orden en la tabla ticol042 siempre con un valor
//obj042.pdno = string.IsNullOrEmpty(toLot) ? " " : toLot.ToUpper().Trim();
obj042.pdno = string.IsNullOrEmpty(toLot) ? txtWorkOrder.Text.Trim().ToUpper() : toLot.ToUpper().Trim();
obj042.sqnb = txtWorkOrder.Text.Trim().ToUpper() + "-RT" + sec;
obj042.proc = 1;
obj042.logn = HttpContext.Current.Session["user"].ToString();
obj042.mitm = row.Cells[0].Text.ToUpper().Trim();
obj042.pono = Convert.ToInt32(Pos);
obj042.qtdl = Convert.ToDouble(toreturn);
obj042.cuni = row.Cells[3].Text.Trim();
obj042.log1 = "NONE";
obj042.qtd1 = Convert.ToDecimal(toreturn);
obj042.pro1 = 1;
obj042.log2 = "NONE";
obj042.qtd2 = Convert.ToDecimal(toreturn);
obj042.pro2 = 2;
obj042.loca = " ";
obj042.norp = 1;
obj042.dele = 2;
obj042.logd = "NONE";
obj042.refcntd = 0;
obj042.refcntu = 0;
obj042.drpt = DateTime.Now;
obj042.urpt = HttpContext.Current.Session["user"].ToString();
obj042.acqt = Convert.ToDouble(toreturn);
//JC 180821 Grabar la bodega por defecto del item
//obj042.cwaf = row.Cells[3].Text.ToUpper();
//obj042.cwat = row.Cells[3].Text.ToUpper();
obj042.cwaf = Warehouse.Rows[0]["WARITEM"].ToString().Trim().ToUpper();
obj042.cwat = Warehouse.Rows[0]["WARITEM"].ToString().Trim().ToUpper();
//JC 061221 Se quita esta inserción debido a que se cambio la estructura del gridview
//obj042.cwaf = row.Cells[3].Text.ToUpper();
//obj042.cwat = row.Cells[3].Text.ToUpper();
obj042.aclo = "";
obj042.allo = 0;
list042.Add(obj042);
Itticol042.insertarRegistroSimple(ref obj042, ref strError);
Itticol042.InsertarRegistroTicol242(ref obj042, ref strError);
}
obj = new Ent_tticol125();
obj.pdno = txtWorkOrder.Text.Trim().ToUpper();
//JC 061221 Como ya no se tiene posición se define fija la posicíón 10
//obj.pono = Convert.ToInt32(row.Cells[0].Text);
obj.pono = Convert.ToInt32("10");
obj.item = row.Cells[0].Text.ToUpper(); //.Trim();
//JC 180821 Grabar la bodega por defecto del item
//obj.cwar = row.Cells[3].Text.ToUpper(); //.Trim();
obj.cwar = Warehouse.Rows[0]["WARITEM"].ToString().Trim().ToUpper();
obj.paid = txtWorkOrder.Text.Trim().ToUpper() + "-RT" + sec;
obj.clot = string.IsNullOrEmpty(toLot) ? " " : toLot.ToUpperInvariant();
obj.reqt = Decimal.Parse(toreturn, System.Globalization.CultureInfo.InvariantCulture); //Convert.ToInt32(toreturn);
obj.refcntd = "0";
obj.refcntu = "0";
obj.mess = " ";
obj.prin = 1;
obj.conf = 2;
obj.user = Session["user"].ToString();
obj.idrecord = grdRecords.DataKeys[row.RowIndex].Value.ToString();
parameterCollection.Add(obj);
}
}
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
idal.insertarRegistro(ref parameterCollection, ref strError, Aplicacion);
printResult.Visible = true;
printLabel.Visible = true;
lblResult.Text = mensajes("msjsave");
lblResult.ForeColor = System.Drawing.Color.Green;
this.HeaderGrid.Visible = false;
grdRecords.DataSource = "";
grdRecords.DataBind();
btnSave.Visible = false;
if (strError != string.Empty)
{
btnSave.Visible = false;
lblResult.Text = mensajes("errorsave");
lblResult.ForeColor = System.Drawing.Color.Red;
throw new System.InvalidOperationException(strError);
}
}
printResult.Visible = true;
printLabel.Visible = true;
grdRecords.DataSource = "";
grdRecords.DataBind();
btnSave.Visible = false;
}