//public int actualizarInfoCliente(Ent_tticol125 parametros)
//{
// int i2;
// int i1 = 0;
// InterfazDAL_tticol125 interfazDAL = new InterfazDAL_tticol125();
// try
// {
// i1 = interfazDAL.actualizarInfoCliente(parametros, ref strError, Aplicacion);
// strError = "Actualizar Informacion del cliente";
// interfazDAL.guardaErrores(ref strError, Aplicacion);
// strError = System.String.Empty;
// i2 = i1;
// }
// catch (System.TimeoutException e1)
// {
// throw new System.Exception(e1.StackTrace);
// }
// catch (System.Exception e2)
// {
// strError = strError + "| - |" + e2.Message.ToString();
// interfazDAL.guardaErrores(ref strError, Aplicacion);
// throw new System.Exception(strError);
// }
// return i2;
//}
public System.Collections.Generic.List <Ent_tticol125> enviaDatos(List <Ent_tticol125> parametros)
{
List <Ent_tticol125> list;
int i = 1;
List <Ent_tticol125> list1 = new System.Collections.Generic.List <Ent_tticol125>();
InterfazDAL_tticol125 interfazDAL = new InterfazDAL_tticol125();
try
{
strError = "CREAR tticol125";
i = interfazDAL.insertarRegistro(ref parametros, ref strError, Aplicacion);
strError = "Recuperar CalenDario";
interfazDAL.guardaErrores(ref strError, Aplicacion);
strError = System.String.Empty;
if ((i > 0) && System.String.IsNullOrEmpty(strError))
{
strError = "Recuperar tticol125 Sentencia";
interfazDAL.guardaErrores(ref strError, Aplicacion);
strError = System.String.Empty;
// list1 = recuperarClientes(ref parametros);
}
else if (strError != System.String.Empty)
{
interfazDAL.guardaErrores(ref strError, Aplicacion);
throw new System.Exception(strError);
}
list = list1;
}
catch (System.TimeoutException e1)
{
throw new System.Exception(e1.StackTrace);
}
catch (System.Exception e2)
{
strError += e2.Message.ToString();
interfazDAL.guardaErrores(ref strError, Aplicacion);
throw new System.Exception(strError);
}
return(list);
}
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;
}
protected void btnSave_Click(object sender, EventArgs e)
{
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();
foreach (GridViewRow row in grdRecords.Rows)
{
string toreturn = ((TextBox)row.Cells[6].FindControl("toReturn")).Text;
string toLot = ((DropDownList)row.Cells[8].FindControl("toLot")).SelectedValue;
string condLote = ((HiddenField)row.Cells[6].FindControl("LOTE")).Value.Trim();
bool reqLote = condLote == "1" ? true : false;
if ((reqLote && String.IsNullOrEmpty(toLot.Trim())) && !string.IsNullOrEmpty(toreturn))
{
lblResult.Text = "Lot code is required. Cannot continue";
return;
}
//string toreturn = ((TextBox)row.Cells[6].FindControl("toReturn")).Text;
//string toLot = ((TextBox)row.Cells[8].FindControl("toLot")).Text;
if (!toreturn.Equals(string.Empty))
{
obj = new Ent_tticol125();
obj.pdno = txtWorkOrder.Text.Trim().ToUpperInvariant();
obj.pono = Convert.ToInt32(row.Cells[0].Text);
obj.item = row.Cells[1].Text.ToUpperInvariant(); //.Trim();
obj.cwar = row.Cells[3].Text.ToUpperInvariant(); //.Trim();
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 = 2;
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 = "Material Return was saved succesfully.";
this.HeaderGrid.Visible = false;
grdRecords.DataSource = "";
grdRecords.DataBind();
btnSave.Visible = false;
if (strError != string.Empty)
{
btnSave.Visible = false;
lblResult.Text = strError;
throw new System.InvalidOperationException(strError);
}
}