public DataTable listaRegistrosOrden_Param(ref Ent_tticol125 parametros)
{
//System.Collections.Generic.List<EntidadRecuperaClientes> lista = new System.Collections.Generic.List<EntidadRecuperaClientes>();
DataTable lista; //= new System.Collections.Generic.List<EntidadRecuperaClientes>();
InterfazDAL_tticol125 interfazDAL = new InterfazDAL_tticol125();
string strError = string.Empty;
try
{
lista = interfazDAL.listaRegistrosOrden_Param(ref parametros, ref strError);
// int i = list.get_Count();
}
catch (System.TimeoutException e1)
{
throw new System.Exception(e1.StackTrace);
}
catch (System.ServiceModel.FaultException e2)
{
throw new System.Exception(e2.Reason.ToString());
}
catch (System.Exception e3)
{
throw new System.Exception(strError);
}
return(lista);
}
protected void generateDropDownReasonCodes()
{
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
DataTable resultado = idal.getReasonCodes(ref strError);
if (resultado.Rows.Count > 0)
{
int rowIndex = 0;
ListItem itemS = null;
itemS = new ListItem();
itemS.Text = _idioma == "INGLES" ? "-- Select an option -- " : " -- Seleccione --";
itemS.Value = "";
dropDownReasonCodes.Items.Insert(rowIndex,itemS);
//ListItem itemS = null;
foreach (DataRow dr in resultado.Rows)
{
itemS = new ListItem();
rowIndex = (int)resultado.Rows.IndexOf(dr);
itemS.Value = dr.ItemArray[0].ToString();
itemS.Text = dr.ItemArray[0].ToString() + " - " + dr.ItemArray[1].ToString();
dropDownReasonCodes.Items.Insert(rowIndex + 1,itemS);
}
}
}
public static string validarCantidades(object fila, string valor, string lote, string qty)
{
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
string strError = string.Empty;
string retorno = string.Empty;
Factor MyConvertionFactor = new Factor {
};
Array row = fila.ToString().Replace(" ", "").Replace("\"", "").Split(',');
try
{
valor = valor.Trim();
lote = lote.Trim().ToUpperInvariant();
if (!string.IsNullOrEmpty(valor))
{
if (row.GetValue(10).ToString().Trim() == "1")
{
MyConvertionFactor = FactorConversion(row.GetValue(4).ToString().Trim(), row.GetValue(6).ToString().Trim(), "plt");
decimal QUANTITYCUNI = (MyConvertionFactor.Tipo == "Div") ? Convert.ToDecimal((Convert.ToDecimal(qty) * MyConvertionFactor.FactorB) / MyConvertionFactor.FactorD) : Convert.ToDecimal((Convert.ToDecimal(qty) * MyConvertionFactor.FactorD) / MyConvertionFactor.FactorB);
if (QUANTITYCUNI > 1)
{
strError = Returnedquantityhigherthanpalletsize;
return(strError);
}
}
}
if (!string.IsNullOrEmpty(valor) && !string.IsNullOrEmpty(lote))
{
double iCantMax = 0;
obj.pdno = row.GetValue(1).ToString().Trim();
obj.pono = Convert.ToInt32(row.GetValue(2).ToString().Trim());
obj.item = row.GetValue(4).ToString().Trim();
obj.clot = lote.ToString().Trim();
iCantMax = idal.cantidadMaximaPorLote(ref obj, ref strError);
if (double.Parse(valor) <= iCantMax)
{
return(retorno);
}
else if (string.IsNullOrEmpty(strError))
{
strError = Theamounttoreturnisinvalid;
}
}
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
return(strError);
}
public static string vallidatePalletID(string palletID, string quantity)
{
//TextBox palletIdTextBox = (TextBox)e.Row.Cells[10].FindControl("palletId");
//
//quantityToReturn = "2";
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
string strError = string.Empty;
string retorno = string.Empty;
//TextBox quantity = (TextBox)e.Row.Cells[10].FindControl("palletId");
obj.paid = palletID.Trim().ToUpperInvariant();
//obj.reqt = Convert.ToInt32(fila.GetValue(8).ToString().Trim());
obj.reqt = Convert.ToDecimal(quantity);
DataTable resultado = idal.vallidatePalletID(ref obj, ref strError);
decimal palletQuantity = 0;
decimal status;
string tableName = string.Empty;
decimal givenQuantity = Convert.ToDecimal(quantity);
if (resultado.Rows.Count < 1)
{
return(PalletIDdoesntexists);
}
else
{
foreach (DataRow dr in resultado.Rows)
{
status = Convert.ToDecimal(dr.ItemArray[8].ToString());
palletQuantity = Convert.ToDecimal(dr.ItemArray[3].ToString());
tableName = dr.ItemArray[0].ToString();
if (palletQuantity < givenQuantity)
{
retorno = QuantitytoreturnmustbeequalorlessthanPalletIDquantityforpalletId + " " + palletID.Trim().ToUpperInvariant();
break;
}
if (((tableName == "whcol131") || (tableName == "whcol130")) && (status != 9))
{
retorno = PalletIDstatusdoesntallowreturn
;
break;
}
else if (((tableName == "ticol022") || (tableName == "ticol042")) && (status != 11))
{
retorno = PalletIDstatusdoesntallowreturn;
break;
}
}
}
return(retorno);
}
protected void btnSave_Click(object sender, EventArgs e)
{
List <Ent_tticol125> parameterCollection = new List <Ent_tticol125>();
Ent_tticol125 obj = new Ent_tticol125();
foreach (GridViewRow fila in grdRecords.Rows)
{
DropDownList lista = ((DropDownList)fila.Cells[7].Controls[1]);
if (lista != null)
{
if (Convert.ToInt32(lista.SelectedValue) == 1)
{
obj = new Ent_tticol125();
obj.pdno = txtWorkOrder.Text.Trim();
obj.pono = Convert.ToInt32(fila.Cells[0].Text);
obj.item = fila.Cells[1].Text;
obj.cwar = fila.Cells[3].Text.Trim();
obj.clot = string.IsNullOrEmpty(fila.Cells[4].Text) ? " " : fila.Cells[4].Text;
obj.reqt = Convert.ToDecimal(fila.Cells[5].Text);
obj.refcntd = "0";
obj.refcntu = "0";
obj.mess = " ";
obj.prin = Convert.ToInt32(((Label)fila.Cells[8].FindControl("prin")).Text);
obj.conf = Convert.ToInt32(lista.SelectedValue);;
obj.idrecord = grdRecords.DataKeys[fila.RowIndex].Value.ToString();
//Requerimiento No. 46122.
//Insertar en la tabla ticol080
//CChaverra 28/07/2017
obj.user = Session["user"].ToString();
parameterCollection.Add(obj);
}
}
}
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
idal.actualizarRegistro_Param(ref parameterCollection, ref strError, Aplicacion);
printResult.Visible = true;
lblResult.Text = "Records was saved succesfully.";
this.HeaderGrid.Visible = false;
grdRecords.DataSource = "";
grdRecords.DataBind();
if (strError != string.Empty)
{
lblResult.Text = strError;
Label control = ((Label)Page.Controls[0].FindControl("lblPageTitle"));
control.Text = strError;
return;
//throw new System.InvalidOperationException(strError);
}
}
protected void grdRecords_RowDataBound(object sender, GridViewRowEventArgs e)
{
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
string strError = string.Empty;
if (e.Row.RowType == DataControlRowType.DataRow)
{
//string prin = ((DataRowView)e.Row.DataItem).DataView.Table.Rows[e.Row.RowIndex]["T$PRIN"].ToString();
string paid = ((DataRowView)e.Row.DataItem).DataView.Table.Rows[e.Row.RowIndex]["T$PAID"].ToString();
//JC 190821 Actualiza el contador de impresiones cada vez que ingresen
if (IsPostBack)
{
idal.updateFieldPrint(ref paid, ref strError);
if (strError != string.Empty)
{
OrderError.IsValid = false;
}
}
var printed = idal.queryFieldPrint(ref paid, ref strError);
string prin = printed.Rows[0]["T$PRIN"].ToString().Trim();
valueprint = prin;
//obj.prin = idal.Rows[0].["T$PRIN"]
// ((Button)e.Row.Cells[7].FindControl("btnPrint")).OnClientClick = "printTag(" + FilaSerializada.Trim() + ")";
//((Button)e.Row.Cells[7].FindControl("btnPrint")).Text = (prin.Trim().Equals("1")
// ? _idioma == "INGLES" ? "Print" : "Imprimir" : _idioma == "INGLES" ? "Reprint" : "Reimprimir");
//Cambia el estado del campo print en la tabla ticol125
//JC 190821 Actualiza el contador de impresiones cada vez que ingresen
//if (prin.Trim().Equals("2"))
//{
//idal.updateFieldPrint(ref paid, ref strError);
//if (strError != string.Empty)
//{
// OrderError.IsValid = false;
//}
//}
//JC 190821 Actualiza el contador de impresiones cada vez que ingresen
if (Convert.ToInt16(valueprint) > 1)
{
((Button)e.Row.Cells[7].FindControl("btnPrint")).Text = (_idioma == "INGLES" ? "Reprint" : "Reimprimir");
}
else
{
((Button)e.Row.Cells[7].FindControl("btnPrint")).Text = (_idioma == "INGLES" ? "Print" : "Imprimir");
}
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtWorkOrder.Text.Trim()))
{
minlenght.Enabled = true;
minlenght.ErrorMessage = "Work Order is required";
minlenght.IsValid = false;
return;
}
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
string strError = string.Empty;
txtWorkOrder.Text = txtWorkOrder.Text.ToUpperInvariant();
obj.pdno = txtWorkOrder.Text.ToUpperInvariant();
resultado = idal.listaRegistrosOrden_Param(ref obj, ref strError, true); //DataTable resultado = TABLA; //
string findIn = string.Empty;
// Validar si el numero de orden trae registros
if (strError != string.Empty || resultado.Rows.Count < 1)
{
strError = string.Empty;
// Si no encuentra registros en la principal busca en historico
resultado = idal.listaRegistrosOrden_ParamHis(ref obj, ref strError);
if (strError != string.Empty || resultado.Rows.Count < 1)
{
OrderError.IsValid = false;
txtWorkOrder.Focus();
grdRecords.DataSource = "";
grdRecords.DataBind();
return;
}
findIn = " [ Find in History ]";
Session["update"] = 1;
}
lblOrder.Text = "Order: " + obj.pdno + findIn;
grdRecords.DataSource = resultado;
grdRecords.DataBind();
if (Session["resultado"] == null)
{
Session["resultado"] = resultado;
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
//if (string.IsNullOrEmpty(txtPalletId.Text.Trim()))
//{
// minlenght.Enabled = true;
// minlenght.ErrorMessage = mensajes("Please Fill all the Required Fields.");
// minlenght.IsValid = false;
// return;
//}
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
string strError = string.Empty;
//obj.pdno = txtWorkOrder.Text.ToUpper();
obj.conf = 2; // CONFIRMED = NO
obj.paid = txtPalletId.Text.ToUpper();
lblResult.Text = string.Empty;
DataTable resultado = idal.listaRegistrosporConfirmar_Param(ref obj, ref strError);
// Validar si el numero de orden trae registros
if (strError != string.Empty)
{
OrderError.IsValid = false;
OrderError.ForeColor = System.Drawing.Color.Red;
OrderError.ErrorMessage = strError;
txtWorkOrder.Focus();
btnSave.Visible = false;
return;
}
lblOrder.Text = _idioma == "INGLES" ? "Order: " : "Orden: " + obj.pdno;
obj.pdno = resultado.Rows[0]["T$PDNO"].ToString().Trim();
Order = obj.pdno;
grdRecords.DataSource = resultado;
grdRecords.DataBind();
this.HeaderGrid.Visible = true;
btnSave.Visible = true;
lblResult.Text = "";
}
protected void btnSend_Click(object sender, EventArgs e)
{
btnSave.Visible = false;
if (string.IsNullOrEmpty(txtWorkOrder.Text.Trim()))
{
RequiredField.Enabled = true;
RequiredField.IsValid = false;
txtWorkOrder.Focus();
grdRecords.DataSource = "";
grdRecords.DataBind();
return;
}
lblOrder.Visible = true;
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
string strError = string.Empty;
txtWorkOrder.Text = txtWorkOrder.Text.ToUpperInvariant();
obj.pdno = txtWorkOrder.Text.ToUpperInvariant();
lblResult.Text = string.Empty;
DataTable resultado = idal.listaRegistrosOrden_Param(ref obj, ref strError);
// Validar si el numero de orden trae registros
if (strError != string.Empty)
{
OrderError.IsValid = false;
txtWorkOrder.Focus();
btnSave.Visible = false;
grdRecords.DataSource = "";
grdRecords.DataBind();
return;
}
lblOrder.Text = "Order: " + obj.pdno;
grdRecords.DataSource = resultado;
grdRecords.DataBind();
this.HeaderGrid.Visible = true;
btnSave.Visible = true;
lblResult.Text = "";
}
public static string validarCantidades(object fila, string valor, string lote)
{
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
string strError = string.Empty;
string retorno = string.Empty;
try
{
valor = valor.Trim();
lote = lote.Trim().ToUpperInvariant();
if (!string.IsNullOrEmpty(valor) && !string.IsNullOrEmpty(lote))
{
Array row = fila.ToString().Replace(" ", "").Replace("\"", "").Split(',');
double iCantMax = 0;
obj.pdno = row.GetValue(1).ToString().Trim();
obj.pono = Convert.ToInt32(row.GetValue(2).ToString().Trim());
obj.item = row.GetValue(4).ToString().Trim();
obj.clot = lote.ToString().Trim();
iCantMax = idal.cantidadMaximaPorLote(ref obj, ref strError);
if (double.Parse(valor) <= iCantMax)
{
return(retorno);
}
else if (string.IsNullOrEmpty(strError))
{
strError = "The amount to return is invalid";
}
}
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
return(strError);
}
//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 btnSend_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtWorkOrder.Text.Trim()))
{
minlenght.Enabled = true;
minlenght.ErrorMessage = "Work Order is required";
minlenght.IsValid = false;
return;
}
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
string strError = string.Empty;
txtWorkOrder.Text = txtWorkOrder.Text.ToUpperInvariant();
obj.pdno = txtWorkOrder.Text.ToUpperInvariant();
obj.conf = 2; // CONFIRMED = NO
lblResult.Text = string.Empty;
DataTable resultado = idal.listaRegistrosporConfirmar_Param(ref obj, ref strError);
// Validar si el numero de orden trae registros
if (strError != string.Empty)
{
OrderError.IsValid = false;
txtWorkOrder.Focus();
btnSave.Visible = false;
return;
}
lblOrder.Text = "Order: " + obj.pdno;
grdRecords.DataSource = resultado;
grdRecords.DataBind();
this.HeaderGrid.Visible = true;
btnSave.Visible = true;
lblResult.Text = "";
}
public static string validaExistLot(object Fila, string valor)
{
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
string strError = string.Empty;
Array fila = Fila.ToString().Replace(" ", "").Replace("\"", "").Split(',');
string retorno = string.Empty;
obj.pdno = valor.Trim().ToUpperInvariant();
obj.pono = Convert.ToInt32(fila.GetValue(2).ToString().Trim());
// obj.clot = valor.Trim().ToUpperInvariant();
//lblResult.Text = string.Empty;
int resultado = idal.listaRegistrosPendConfItem_Param(ref obj, ref strError);
// Validar si el numero de orden trae registros
if (strError != string.Empty)
{
return(strError);
}
return(retorno);
}
public static string vallidatePalletID(string palletID, string position, string returnOrder)
{
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
string strError = string.Empty;
string retorno = string.Empty;
//TextBox quantity = (TextBox)e.Row.Cells[10].FindControl("palletId");
obj.paid = palletID.Trim().ToUpperInvariant();
DataTable resultado = idal.vallidatePalletData(ref obj, ref strError);
//decimal palletQuantity = 0;
//decimal status;
//string tableName = string.Empty;
//decimal givenQuantity = Convert.ToDecimal(quantity);
/* select col131.t$paid "palletid", col131.t$loaa "current_location",
* col131.t$qtya "current_qty", col131.t$item "item", ibd001.t$dsca "description"*/
string item, description, palletid, current_location, unit, war, stat;
decimal current_qty;
if (resultado.Rows.Count < 1)
{
return(null);
}
else
{
foreach (DataRow dr in resultado.Rows)
{
palletid = dr.ItemArray[0].ToString();
current_location = dr.ItemArray[1].ToString();
current_qty = Convert.ToDecimal(dr.ItemArray[2].ToString());
item = dr.ItemArray[3].ToString();
description = dr.ItemArray[4].ToString();
unit = dr.ItemArray[5].ToString();
war = dr.ItemArray[6].ToString();
stat = dr.ItemArray[7].ToString();
// lblItemValue.Text = item;
//lblItemDescValue.Text = description;
//lblUnitValue.Text = unit;
//lbllotValue.Text = lot;
string warehouse, itemcode;
decimal qty;
InterfazDAL_twhcol130 idal2 = new InterfazDAL_twhcol130();
DataTable resultado1 = idal2.vallidatePurchaseOrderWithPosition(ref returnOrder, ref position, ref strError);
if (resultado1.Rows.Count < 1)
{
return(null);
}
else
{
foreach (DataRow dr1 in resultado1.Rows)
{
itemcode = dr1.ItemArray[0].ToString();
warehouse = dr1.ItemArray[1].ToString();
qty = Convert.ToDecimal(dr1.ItemArray[2].ToString());
if (warehouse.Trim() != war.Trim())
{
return(PalletWarehousedoesnotmatch);
}
if (itemcode.Trim() != item.Trim())
{
return(PalletItemcodedoesnotmatch);
}
if (current_qty < qty)
{
return(ActualquantitypalletIDequalorlessthanorderedquantity
);
}
}
}
}
return(JsonConvert.SerializeObject(resultado));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
List <Ent_tticol125> parameterCollection = new List <Ent_tticol125>();
Ent_tticol125 obj = new Ent_tticol125();
foreach (GridViewRow fila in grdRecords.Rows)
{
DropDownList lista = ((DropDownList)fila.Cells[8].Controls[1]);
if (lista != null)
{
if (Convert.ToInt32(lista.SelectedValue) == 1)
{
obj = new Ent_tticol125();
//obj.pdno = txtWorkOrder.Text.Trim().ToUpper();
obj.pdno = Order;
obj.pono = Convert.ToInt32(fila.Cells[0].Text);
obj.item = fila.Cells[1].Text;
obj.cwar = fila.Cells[3].Text.Trim();
obj.clot = string.IsNullOrEmpty(fila.Cells[4].Text) ? " " : fila.Cells[4].Text;
obj.reqt = Convert.ToDecimal(fila.Cells[6].Text);
obj.refcntd = "0";
obj.refcntu = "0";
obj.mess = " ";
obj.paid = txtPalletId.Text.Trim().ToUpper();
obj.prin = Convert.ToInt32(((Label)fila.Cells[8].FindControl("prin")).Text);
obj.conf = Convert.ToInt32(lista.SelectedValue);;
obj.idrecord = grdRecords.DataKeys[fila.RowIndex].Value.ToString();
//Requerimiento No. 46122.
//Insertar en la tabla ticol080
//CChaverra 28/07/2017
obj.user = Session["user"].ToString();
parameterCollection.Add(obj);
}
}
}
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
idal.actualizarRegistro_Param(ref parameterCollection, ref strError, Aplicacion);
//Update status updataPalletStatus on table (whcol131, ticol022, ticol042) to delivered. paramList.Add("p2", 9);// , whcol131 -Delieverd status=9
// paramList.Add("p3", 11); // , ticol022, ticol042 -Delieverd status=11
bool resultado = idal.updataPalletStatus(ref obj, ref strError);
printResult.Visible = true;
lblResult.Text = mensajes("msjsave");
lblResult.ForeColor = System.Drawing.Color.Green;
this.HeaderGrid.Visible = false;
grdRecords.DataSource = "";
grdRecords.DataBind();
if (strError != string.Empty)
{
lblResult.Text = strError;
lblResult.ForeColor = System.Drawing.Color.Red;
Label control = ((Label)Page.Controls[0].FindControl("lblPageTitle"));
control.Text = strError;
return;
//throw new System.InvalidOperationException(strError);
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
lblError.Text = "";
lblConfirm.Text = "";
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
string strError = string.Empty;
obj.paid = txtPalletId.Text.ToUpperInvariant();
HttpContext.Current.Session["flag022"] = 0;
HttpContext.Current.Session["flag042"] = 0;
HttpContext.Current.Session["flag131"] = 0;
divPrint.Visible = false;
string retorno = string.Empty;
decimal palletQuantity = 0;
decimal status;
string tableName = string.Empty;
DataTable resultadoPaid = idal.vallidatePalletID(ref obj, ref strError);
if (resultadoPaid.Rows.Count < 1) { retorno = PalletIDdoesntexists; }
else
{
foreach (DataRow dr in resultadoPaid.Rows)
{
status = Convert.ToDecimal(dr.ItemArray[8].ToString());
palletQuantity = Convert.ToDecimal(dr.ItemArray[3].ToString());
tableName = dr.ItemArray[0].ToString();
if (((tableName == "whcol131") || (tableName == "whcol130")) && (status != 3))
{
lblError.Text = PalletIDstatusdoesntallowadjustment;
return;
}
else if (((tableName == "ticol022") || (tableName == "ticol042")) && (status != 7))
{
lblError.Text = PalletIDstatusdoesntallowadjustment;
return;
}
}
}
if (string.IsNullOrEmpty(txtPalletId.Text.Trim()))
{
//minlenght.Enabled = true;
//minlenght.ErrorMessage = mensajes("Please Fill all the Required Fields.");
//minlenght.IsValid = false;
//return;
}
DataTable resultado = idal.invGetPalletInfo(ref obj, ref strError);
DataTable resultadoSerie = idal.invGetPalletInfoSerie(ref strError);
if (resultado == null || resultado.Rows.Count == 0)
{
lblError.Text = PalletIDdoesntexists;
return;
}
string palletId, item, warehouse, lot, location, quantity, dsca, unit, waredesc, machine, tbl, pono;
if (resultado.Rows.Count == 1)
{
if (resultadoSerie.Rows.Count > 0)
{
Session["emno"] = resultadoSerie.Rows[0]["EMNO"].ToString();
Session["cdis"] = resultadoSerie.Rows[0]["CDIS"].ToString();
lblReason.Text = resultadoSerie.Rows[0]["CDIS"].ToString() + " - " + resultadoSerie.Rows[0]["DSCA"].ToString();
lblCost.Text = resultadoSerie.Rows[0]["EMNO"].ToString() + " - " + resultadoSerie.Rows[0]["NAMA"].ToString();
}
else
{
lblReason.Text = string.Empty;
lblCost.Text = string.Empty;
}
DataRow dr = resultado.Rows[0];
tbl = dr.ItemArray[0].ToString();
if (tbl.Trim() == "ticol022")
{
HttpContext.Current.Session["flag022"] = 1;
HttpContext.Current.Session["flag131"] = 0;
HttpContext.Current.Session["flag042"] = 0;
}
else if (tbl.Trim() == "whcol131")
{
HttpContext.Current.Session["flag022"] = 0;
HttpContext.Current.Session["flag131"] = 1;
HttpContext.Current.Session["flag042"] = 0;
}
else if (tbl.Trim() == "ticol042")
{
HttpContext.Current.Session["flag022"] = 0;
HttpContext.Current.Session["flag131"] = 0;
HttpContext.Current.Session["flag042"] = 1;
}
palletId = dr.ItemArray[2].ToString();
quantity = dr.ItemArray[3].ToString();
item = dr.ItemArray[4].ToString();
dsca = dr.ItemArray[5].ToString();
unit = dr.ItemArray[6].ToString();
warehouse = dr.ItemArray[7].ToString();
waredesc = dr.ItemArray[8].ToString();
lot = dr.ItemArray[10].ToString();
location = dr.ItemArray[9].ToString();
Pquantity = Convert.ToDouble(quantity);
machine = dr.ItemArray[11].ToString();
pono = dr.ItemArray[12].ToString();
HttpContext.Current.Session["pono"] = pono;
lblPalletId1Value.Text = palletId;
lblItemValue.Text = item;
lblItemDescValue.Text = dsca;
lblWarehouseValue.Text = warehouse;
lblWarehouseDescValue.Text = waredesc;
lblLotValue.Text = lot;
lblLocationValue.Text = location;
lblQuantityValue.Text = quantity;
lblUnitValue.Text = unit;
lblUnitValue1.Text = unit;
tblPalletInfo.Visible = true;
btnSend.Visible = false;
btnSave.Visible = true;
lblMachine.Text = machine;
generateDropDownReasonCodes();
generateDropDownCostCenters();
dropDownCostCenters.SelectedValue = Session["emno"].ToString();
dropDownReasonCodes.SelectedValue = Session["cdis"].ToString();
if (Session["emno"].ToString() == "DO3062" && Session["cdis"].ToString() == "CS1004")
{
dropDownCostCenters.Visible = true;
dropDownReasonCodes.Visible = true;
lblReason.Visible = false;
lblCost.Visible = false;
}
else
{
dropDownCostCenters.Visible = false;
dropDownReasonCodes.Visible = false;
lblReason.Visible = true;
lblCost.Visible = true;
}
}
}
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);
}
}
protected void printLabel_Click(object sender, EventArgs e)
{
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
string strError = string.Empty;
obj.pdno = txtWorkOrder.Text;
lblResult.Text = string.Empty;
DataTable resultado = idal.listaRegistrosOrden_Param(ref obj, ref strError, true);
// Validar si el numero de orden trae registros
if (strError != string.Empty)
{
string MsgError = OrderError.ErrorMessage;
OrderError.ErrorMessage = mensajes("worktag");
OrderError.ForeColor = System.Drawing.Color.Red;
OrderError.IsValid = false;
OrderError.ErrorMessage = MsgError;
return;
}
//lblOrder.Text = _idioma == "INGLES" ? "Order: " : "Orden: " + obj.pdno;
Session["resultado"] = resultado;
Session["RemotePrint"] = "yes";
StringBuilder paramurl = new StringBuilder();
paramurl.Append("?");
paramurl.Append("valor1=" + Request.QueryString[0].ToString() + "&");
paramurl.Append("valor2=" + Request.QueryString[1].ToString() + "&");
paramurl.Append("valor3=" + Request.QueryString[2].ToString());
Session["IsPreviousPage"] = "";
//Server.Transfer("whInvMaterialDevolReprintLabel.aspx", true);
Response.Redirect("whInvMaterialDevolReprintLabel.aspx" + paramurl.ToString());
// //grdRecords.DataSource = resultado;
// //grdRecords.DataBind();
// printResult.Visible = false;
// string printerHtml = printerDiv.InnerHtml;
// printerDiv.Style.Add(HtmlTextWriterStyle.BackgroundColor, "White");
// printerDiv.Style.Add(HtmlTextWriterStyle.Height, "400px");
// printerDiv.Style.Add(HtmlTextWriterStyle.Width, "500px");
//// printerDiv.Style.Add(HtmlTextWriterStyle., BorderStyle.Solid.ToString());
// foreach (DataRow reg in resultado.Rows)
// {
// if (scriptBlock.IsClientScriptBlockRegistered("printTag"))
// {
// scriptBlock.RegisterClientScriptBlock(csType, "printTag", string.Empty, false);
// }
// DataRow drv = reg;
// Session["FilaImprimir"] = reg;
// printerDiv.InnerHtml = printerHtml; //
// // Validar que la division exista en el documento
// Control div = FindControl("printer");
// if (div == null)
// {
// // this.Controls.Add(createDiv);
// }
// printerDiv.InnerHtml = "<iframe src='../Labels/whInvPrintLabel.aspx' width='100%'; height='100%'; onload='this.contentWindow.print()></iframe>"; //
// printerDiv.Focus();
// //csType = this.GetType();
// //scriptBlock = Page.ClientScript;
// //scriptBlock.RegisterClientScriptBlock(csType, "printTag", this.crearScriptImp(pagina), false);
// //String cstext1 = "printTag();";
// //scriptBlock.RegisterStartupScript(csType, "ButtonClickScript", cstext1, true);
// }
}
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 btnSend_Click(object sender, EventArgs e)
{
Session["save"] = null;
btnSave.Visible = false;
if (string.IsNullOrEmpty(txtWorkOrder.Text.Trim()))
{
RequiredField.Enabled = true;
RequiredField.IsValid = false;
txtWorkOrder.Focus();
grdRecords.DataSource = "";
grdRecords.DataBind();
return;
}
//lblOrder.Visible = true;
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
Ent_tticol125 obj = new Ent_tticol125();
string strError = string.Empty;
txtWorkOrder.Text = txtWorkOrder.Text.ToUpperInvariant();
obj.pdno = txtWorkOrder.Text.ToUpperInvariant();
lblResult.Text = string.Empty;
DataTable resultado = idal.listaRegistrosOrden_Param(ref obj, ref strError);
if (resultado.Rows.Count > 0)
{
foreach (DataRow item in resultado.Rows)
{
Ent_tticol125 MyObj = new Ent_tticol125();
MyObj.pdno = item["Orden"].ToString();
//JC 061221 MyObj.pono = Convert.ToInt32(item["Pos"].ToString());
MyObj.item = item["Articulo"].ToString();
DataTable ResQtdl = idal.ConsultarQtdl(ref MyObj, ref strError);
decimal Qtdl = 0;
if (ResQtdl.Rows.Count > 0)
{
Qtdl = Convert.ToDecimal(ResQtdl.Rows[0]["REQT"].ToString());
}
item["CANT"] = Convert.ToString(Convert.ToDecimal(item["CANT"].ToString()) - Qtdl);
}
}
// Validar si el numero de orden trae registros
if (strError != string.Empty)
{
OrderError.IsValid = false;
txtWorkOrder.Focus();
btnSave.Visible = false;
grdRecords.DataSource = "";
grdRecords.DataBind();
return;
}
//lblOrder.Text = _idioma == "INGLES" ? "Order: " : "Orden: " + obj.pdno;
grdRecords.DataSource = resultado;
grdRecords.DataBind();
printLabel.Visible = false;
this.HeaderGrid.Visible = true;
btnSave.Visible = true;
lblResult.Text = "";
}
protected void Page_Load(object sender, EventArgs e)
{
string rutaServ = string.Empty;
DataRow fila = (DataRow)Session["FilaImprimir"];
if (fila == null)
{
return;
}
// string id =
LblWorkOrder.Text = fila.ItemArray[0].ToString().Trim();
lblLotCode.Text = fila.ItemArray[4].ToString().Trim();
lblItem.Text = fila.ItemArray[2].ToString().Trim();
lblArticulo.Text = fila.ItemArray[15].ToString().Trim();
lblQuantity.Text = fila.ItemArray[5].ToString().Trim();
lblUnit.Text = fila.ItemArray[14].ToString().Trim();
lblUser.Text = fila.ItemArray[6].ToString().Trim();
lblStatPrint.Text = fila.ItemArray[8].ToString().Trim() == "1"?"Reprinted":"Printed";
string PalletId = fila.ItemArray[13].ToString().Trim();
//lblDate.Text = fila.ItemArray[7].ToString().Trim();
string siteName = ConfigurationManager.AppSettings["enlaceRet"].ToString();
rutaServ = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + PalletId + "&code=Code128&dpi=96";
imgPalletId.Src = !string.IsNullOrEmpty(PalletId) ? rutaServ : "";
rutaServ = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + LblWorkOrder.Text + "&code=Code128&dpi=96";
imgWorkOrder.Src = !string.IsNullOrEmpty(LblWorkOrder.Text) ? rutaServ : "";
rutaServ = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + lblLotCode.Text + "&code=Code128&dpi=96";
imgLotCode.Src = !string.IsNullOrEmpty(lblLotCode.Text) ? rutaServ : "";
rutaServ = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + lblItem.Text + "&code=Code128&dpi=96";
imgItem.Src = !string.IsNullOrEmpty(lblItem.Text) ? rutaServ : "";
Type csType = this.GetType();
ClientScriptManager scriptBlock = Page.ClientScript;
string cstext1 = "printDiv('Label');";
scriptBlock.RegisterStartupScript(csType, "printerLabel", cstext1, true);
if (Session["update"] != null)
{
return;
}
List <Ent_tticol125> parameterCollection = new List <Ent_tticol125>();
Ent_tticol125 obj = new Ent_tticol125();
//Actualizar estado de impresion
obj = new Ent_tticol125();
obj.paid = fila.ItemArray[13].ToString().Trim();
obj.pdno = fila.ItemArray[0].ToString().Trim();
obj.pono = Convert.ToInt32(fila.ItemArray[1].ToString().Trim());
obj.item = fila.ItemArray[2].ToString();
obj.cwar = fila.ItemArray[3].ToString().Trim();
obj.clot = string.IsNullOrEmpty(fila.ItemArray[4].ToString().Trim()) ? " " : fila.ItemArray[4].ToString().Trim();
obj.reqt = Convert.ToDecimal(fila.ItemArray[5].ToString().Trim());
obj.refcntd = "0";
obj.refcntu = "0";
obj.mess = " ";
obj.conf = Convert.ToInt32(fila.ItemArray[9].ToString().Trim());
obj.prin = 1;
obj.idrecord = fila.ItemArray[16].ToString().Trim();
parameterCollection.Add(obj);
InterfazDAL_tticol125 idal = new InterfazDAL_tticol125();
if (fila.ItemArray.Count() > 16)
{
if (fila.ItemArray[16].ToString().Trim() == "126")
{
idal.actualizarRegistro_Param(ref parameterCollection, ref strError, Aplicacion, true);
return;
}
}
idal.actualizarRegistro_Param(ref parameterCollection, ref strError, Aplicacion);
Session.Remove("IsPreviousPage");
//ScriptManager.RegisterStartupScript(this, this.GetType(), "printDiv", "javascript:printDiv('Label');", true);
}
