public bool Actualizarttdcol022Pdno(Ent_ttdcol137 data137)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
string strError = string.Empty;
try
{
paramList = new Dictionary <string, object>();
paramList.Add(":PAID", data137.Paid.ToUpper());
paramList.Add(":PDNO", data137.Lot.ToUpper() == "" ? " " : data137.Lot.ToUpper());
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("Text", strSentencia, ref parametersOut, null, false);
//JC 0412200 Enviar al log el query de lo cambiado para seguimiento
log.escribirError("Sentencia SQL: " + strSentencia, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
return(retorno);
}
public int insertarDatos(ref Ent_ttdcol137 parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
paramList = new Dictionary <string, object>();
paramList.Add(":T$PAID", parametros.Paid.Trim().ToUpper().ToString());
paramList.Add(":T$ORNO", parametros.Orno.ToUpper().ToString());
paramList.Add(":T$CLOT", parametros.Clot.ToString());
paramList.Add(":T$CWAR", parametros.Cwar.ToString());
paramList.Add(":T$LOCA", parametros.Loca.ToString());
paramList.Add(":T$QTYA", parametros.Qtya.ToString());
paramList.Add(":T$USER", parametros.User.ToUpper().ToString());
paramList.Add(":T$REFCNTD", "0");
paramList.Add(":T$REFCNTU", "0");
try
{
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(Convert.ToInt32(retorno));
}
catch (Exception ex)
{
strError = "Error when inserting data [ttdcol137]. 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(Convert.ToInt32(retorno));
}
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_ttdcol137 parametros, bool blnUsarPRetorno = false)
{
method = MethodBase.GetCurrentMethod();
string strError = string.Empty;
List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>();
try
{
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PAID", DbType.String, parametros.Paid);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ORNO", DbType.String, parametros.Orno);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.Clot);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.Cwar);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCA", DbType.String, parametros.Loca);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTYA", DbType.String, parametros.Qtya);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$USER", DbType.String, parametros.User);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int64, parametros.refcntd);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int64, 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)
{
strError = "Error when creating parameters [137]. 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(parameterCollection);
}
protected void Save_Click(object sender, EventArgs e)
{
string TABLA = HttpContext.Current.Session["TABLA"].ToString();
string PALLET = HttpContext.Current.Session["PAID"].ToString();
string ORNO = HttpContext.Current.Session["ORNO"].ToString();
string CLOT = HttpContext.Current.Session["CLOT"].ToString();
string CWAR = HttpContext.Current.Session["CWAR"].ToString();
string LOCA = HttpContext.Current.Session["LOCA"].ToString();
string QTYA = HttpContext.Current.Session["QTYA"].ToString();
string strError = string.Empty;
Ent_ttdcol137 data137;
data137 = new Ent_ttdcol137();
data137.Paid = PALLET.ToUpper();
data137.Orno = ORNO.ToUpper();
data137.Clot = CLOT;
data137.Cwar = CWAR.ToUpper();
data137.Loca = LOCA.ToUpper();
data137.Qtya = Convert.ToDecimal(QTYA);
data137.User = HttpContext.Current.Session["USER"].ToString();
var validatesave = ITticol137.insertarDatos(ref data137, ref strError);
if (validatesave > 0)
{
if (TABLA == "whcol131")
{
data137.Dele = 11;
}
else
{
data137.Dele = 11;
}
if (TABLA == "ticol022")
{
var qt = Convert.ToDecimal(0);
var validateSaveTicol222 = ITticol137.Actualizarttdcol222Cant(ref PALLET, ref qt);
var validateSaveTicol022 = ITticol137.Actualizarttdcol022Status(data137);
}
if (TABLA == "ticol042")
{
var qt = Convert.ToDecimal(0);
var validateSaveTicol242 = ITticol137.Actualizarttdcol242Cant(ref PALLET, ref qt);
var validateSaveTicol042 = ITticol137.Actualizarttdcol042Status(data137);
}
if (TABLA == "whcol131")
{
var qt = Convert.ToDecimal(0);
var STATUS = 9;
var validateSaveWhcol131 = ITticol137.Actualizartwhcol131CantStatus(ref PALLET, ref STATUS, ref qt);
}
}
}
public int insertarDatos(ref Ent_ttdcol137 parametros, ref string strError)
{
int retorno = -1;
try
{
retorno = dal.insertarDatos(ref parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += ex.Message);
}
}
public object Actualizarttdcol242(Ent_ttdcol137 data137)
{
return(dal.Actualizarttdcol242(data137));
}
public object Actualizarttdcol222Status(Ent_ttdcol137 data137)
{
throw new NotImplementedException();
}
public bool Actualizarttdcol042Status(Ent_ttdcol137 myObj)
{
return(dal.Actualizarttdcol042Status(myObj));
}
public object Actualizarttdcol042Pdno(Ent_ttdcol137 data137)
{
return(dal.Actualizarttdcol042Pdno(data137));
}
public static void save(string STAT, string CWAR, string LOCA, string QTYA, string LOT, string RFID)
{
string TABLA = HttpContext.Current.Session["TABLA"].ToString();
string PALLET = HttpContext.Current.Session["PAID"].ToString();
//string ORNO = HttpContext.Current.Session["ORNO"].ToString();
string CLOT = HttpContext.Current.Session["CLOT"].ToString();
string strError = string.Empty;
Ent_ttdcol137 data137;
data137 = new Ent_ttdcol137();
data137.Paid = PALLET.ToUpper();
//data137.Orno = ORNO.ToUpper();
data137.Clot = CLOT;
data137.Cwar = CWAR.ToUpper();
data137.Loca = LOCA.ToUpper();
data137.Qtya = Convert.ToDecimal(QTYA);
data137.Dele = Convert.ToInt32(STAT.Trim());
data137.User = HttpContext.Current.Session["User"].ToString();
data137.Lot = LOT.ToUpper();
//var validatesave = ITticol137.insertarDatos(ref data137, ref strError);
//if (validatesave > 0)
//{
//if (TABLA == "whcol131")
//{
// data137.Dele = 11;
//}
//else
//{
// data137.Dele = 11;
//}
if (TABLA == "ticol022")
{
var qt = Convert.ToDecimal(QTYA);
var validateSaveTicol222 = ITticol137.Actualizarttdcol222Cant(ref PALLET, ref qt);;
var validateSaveTicol222N = ITticol137.Actualizarttdcol222(data137);
var validateSaveTicol022N = ITticol137.Actualizarttdcol022Pdno(data137);
var validateSaveTicol022 = ITticol137.Actualizarttdcol022Status(data137);
}
if (TABLA == "ticol042")
{
var qt = Convert.ToDecimal(QTYA);
var validateSaveTicol242 = ITticol137.Actualizarttdcol242Cant(ref PALLET, ref qt);
var validateSaveTicol242N = ITticol137.Actualizarttdcol242(data137);
var validateSaveTicol042N = ITticol137.Actualizarttdcol042Pdno(data137);
var validateSaveTicol042 = ITticol137.Actualizarttdcol042Status(data137);
}
if (TABLA == "whcol131")
{
var qt = Convert.ToDecimal(QTYA);
var STATUS = Convert.ToInt32(STAT.Trim());
var validateSaveWhcol131 = ITticol137.Actualizartwhcol131CantStatus(ref PALLET, ref STATUS, ref qt, CWAR, LOCA, LOT);
}
//JC 030222 Actualizar el rfid si hay cambio
if (HttpContext.Current.Session["RFID"].ToString().Trim() != RFID)
{
var validateSaveWhcol133 = ITticol137.Actualizartwhcol133Rfid(ref PALLET, RFID);
SrvRfidPop.Service1Client SrvRfidPop = new SrvRfidPop.Service1Client();
bool validateSaveWhcol133Ss = SrvRfidPop.Updtwhcol133RfidSS(PALLET, RFID);
}
//}
}
public static void save(string STAT, string CWAR, string LOCA, string QTYA, string LOT)
{
string TABLA = HttpContext.Current.Session["TABLA"].ToString();
string PALLET = HttpContext.Current.Session["PAID"].ToString();
//string ORNO = HttpContext.Current.Session["ORNO"].ToString();
string CLOT = HttpContext.Current.Session["CLOT"].ToString();
string strError = string.Empty;
Ent_ttdcol137 data137;
data137 = new Ent_ttdcol137();
data137.Paid = PALLET.ToUpper();
//data137.Orno = ORNO.ToUpper();
data137.Clot = CLOT;
data137.Cwar = CWAR.ToUpper();
data137.Loca = LOCA.ToUpper();
data137.Qtya = Convert.ToDecimal(QTYA);
data137.Dele = Convert.ToInt32(STAT.Trim());
data137.User = HttpContext.Current.Session["User"].ToString();
data137.Lot = LOT.ToUpper();
string ORNO = PALLET.Trim().Substring(0, PALLET.Trim().IndexOf("-"));
DataTable DTPalletContinue = twhcol130DAL.maximaSecuenciaUnion((PALLET.Trim().Substring(0, PALLET.Trim().IndexOf("-"))) + "-P");
int consecutivoPalletID = 0;
string SecuenciaPallet = "P001";
if (DTPalletContinue.Rows.Count > 0)
{
foreach (DataRow item in DTPalletContinue.Rows)
{
consecutivoPalletID = Convert.ToInt32(item["SQNB"].ToString().Trim().Substring(item["SQNB"].ToString().Trim().LastIndexOf(("P")) + 1)) + 1;
if (consecutivoPalletID.ToString().Length == 1)
{
SecuenciaPallet = "P00" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 2)
{
SecuenciaPallet = "P0" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 3)
{
SecuenciaPallet = "P" + consecutivoPalletID.ToString();
}
}
}
if (TABLA == "ticol022")
{
HttpContext.Current.Session["Table"] = "ticol022";
var qt = Convert.ToDecimal(HttpContext.Current.Session["QTYA"].ToString()) - Convert.ToDecimal(QTYA);
var validateSaveTicol222 = ITticol137.Actualizarttdcol222Cant(ref PALLET, ref qt);
var validateSaveTicol222N = ITticol137.Actualizarttdcol222(data137);
var validateSaveTicol022N = ITticol137.Actualizarttdcol022Pdno(data137);
var validateSaveTicol022 = ITticol137.Actualizarttdcol022Status(data137);
bool Auto022 = twhcol130DAL.tticol022Auto(ORNO + "-" + SecuenciaPallet, PALLET);
bool Auto222 = twhcol130DAL.tticol222Auto(ORNO + "-" + SecuenciaPallet, PALLET, QTYA);
}
if (TABLA == "ticol042")
{
HttpContext.Current.Session["Table"] = "ticol042";
var qt = Convert.ToDecimal(HttpContext.Current.Session["QTYA"].ToString()) - Convert.ToDecimal(QTYA);
var validateSaveTicol242 = ITticol137.Actualizarttdcol242Cant(ref PALLET, ref qt);
var validateSaveTicol242N = ITticol137.Actualizarttdcol242(data137);
var validateSaveTicol042N = ITticol137.Actualizarttdcol042Pdno(data137);
var validateSaveTicol042 = ITticol137.Actualizarttdcol042Status(data137);
bool Auto042 = twhcol130DAL.tticol042Auto(ORNO + "-" + SecuenciaPallet, PALLET);
bool Auto242 = twhcol130DAL.tticol242Auto(ORNO + "-" + SecuenciaPallet, PALLET, QTYA);
}
if (TABLA == "whcol131")
{
HttpContext.Current.Session["Table"] = "whcol131";
var qt = Convert.ToDecimal(HttpContext.Current.Session["QTYA"].ToString()) - Convert.ToDecimal(QTYA);
var STATUS = Convert.ToInt32(STAT.Trim());
var validateSaveWhcol131 = ITticol137.Actualizartwhcol131CantStatus(ref PALLET, ref STATUS, ref qt, CWAR, LOCA, LOT);
bool Auto131 = twhcol130DAL.InserTwhcol131Auto(ORNO + "-" + SecuenciaPallet, PALLET, QTYA);
}
HttpContext.Current.Session["codeMaterial"] = HttpContext.Current.Session["ITEM"].ToString().Trim();
HttpContext.Current.Session["codePaid"] = PALLET.Trim();
HttpContext.Current.Session["codePaid2"] = (ORNO + "-" + SecuenciaPallet).Trim();
HttpContext.Current.Session["Lot"] = LOT;
HttpContext.Current.Session["Quantity"] = Convert.ToDecimal(QTYA);
HttpContext.Current.Session["Quantity2"] = Convert.ToDecimal(HttpContext.Current.Session["QTYA"].ToString()) - Convert.ToDecimal(QTYA);
HttpContext.Current.Session["Date"] = DateTime.Now.ToString("MM/dd/yyyy");
HttpContext.Current.Session["Pallet"] = PALLET.Trim();
HttpContext.Current.Session["Machine"] = HttpContext.Current.Session["MCNO"];
HttpContext.Current.Session["Operator"] = HttpContext.Current.Session["user"].ToString();
HttpContext.Current.Session["Reprint"] = "no";
HttpContext.Current.Session["AutoPrint"] = "yes";
HttpContext.Current.Session["PickLabel"] = "yes";
HttpContext.Current.Session["Pick"] = "xxxxxxxx";
HttpContext.Current.Session["PartialLabel"] = null;
}
