public static string ValidarMaquina(string sMachine)
{
string retorno = "0";
DataTable DTRetorno = null;
string strError = string.Empty;
InterfazDAL_tticol132 tticol132 = new InterfazDAL_tticol132();
if (string.IsNullOrEmpty(sMachine))
{
retorno = "0";
}
else
{
try
{
DTRetorno = tticol132.ValidarMaquina(sMachine, ref strError);
if (DTRetorno.Rows.Count > 0)
{
retorno = string.Empty;
}
}
catch (Exception ex)
{
retorno = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
}
return(retorno);
}
protected void btnConsultar_Click(object sender, EventArgs e)
{
if (txtMachine.Text.Trim() != String.Empty)
{
_machine = txtMachine.Text.Trim().ToUpper();
var ckot = slType.SelectedValue.Trim();
var validarMaquina = _idaltticol132.ValidarMaquina(_machine, ref strError);
if (validarMaquina.Rows.Count > 0)
{
_dscaMachine = validarMaquina.Rows[0]["DSCA"].ToString().Trim().ToUpper();
_recordsTask = _idalttirou003.listRecordsByCkot(ref ckot, ref strError);
if (_recordsTask.Rows.Count < 0)
{
lblError.Text = mensajes("notexiststask");
lblConfirm.Text = string.Empty;
return;
}
_recordsLaborType = _idalttihra130.listRecords(ref strError);
_recordsComments = _idaltticol077.listRecords(ref strError);
_ordersTurn = _idaltticol111.findRecordsByMcnoTimeRegistration(ref _machine, ref strError);
divBtnGuardar.Visible = true;
makeTable();
lblError.Text = string.Empty;
lblConfirm.Text = string.Empty;
}
else
{
divBtnGuardar.Visible = false;
divTable.InnerHtml = String.Empty;
lblError.Text = mensajes("notexistsmachine");
lblConfirm.Text = string.Empty;
return;
}
}
else
{
lblError.Text = mensajes("formempty");
lblConfirm.Text = string.Empty;
return;
}
}
protected void btnConsultar_Click(object sender, EventArgs e)
{
slItem1.Items.Clear();
slItem2.Items.Clear();
slItem3.Items.Clear();
slItem4.Items.Clear();
slItem5.Items.Clear();
lblError.Text = String.Empty;
var machine = txtMachine.Text.Trim().ToUpper();
if (machine == String.Empty)
{
lblError.Text = mensajes("formempty");
return;
}
//Consulta machine
var consultaMaquina = _idaltticol132.ValidarMaquina(machine, ref strError);
if (consultaMaquina.Rows.Count > 0)
{
//consulta items
var consultaItem = _idalttcibd001.findRecordsSupplies(ref strError);
if (consultaItem.Rows.Count > 0)
{
List <ListItem> _listaRegistros = new List <ListItem>();
ListItem itemSelect = new ListItem();
itemSelect.Text = _idioma == "INGLES" ? "--Select an option--" : "--Seleccione--";
itemSelect.Value = "";
_listaRegistros.Add(itemSelect);
foreach (DataRow item in consultaItem.Rows)
{
ListItem row = new ListItem();
row.Text = String.Concat(item["ITEM"].ToString().Trim().ToUpper(), " |-"
, item["DSCA"].ToString().Trim().ToUpper(), " -. "
, item["CWAR"].ToString().Trim().ToUpper(), " - "
, item["CUNI"].ToString().Trim().ToUpper(), " -|"
, item["STOCK"].ToString().Trim().ToUpper());
row.Value = item["ITEM"].ToString().Trim().ToUpper();
row.Attributes.Add("stock", item["STOCK"].ToString().Trim().ToUpper());
_listaRegistros.Add(row);
}
for (int i = 0; i < _listaRegistros.Count; i++)
{
slItem1.Items.Insert(i, _listaRegistros[i]);
slItem2.Items.Insert(i, _listaRegistros[i]);
slItem3.Items.Insert(i, _listaRegistros[i]);
slItem4.Items.Insert(i, _listaRegistros[i]);
slItem5.Items.Insert(i, _listaRegistros[i]);
}
txtMachine1.Text = txtMachine.Text.Trim().ToUpper();
txtMachine2.Text = txtMachine.Text.Trim().ToUpper();
txtMachine3.Text = txtMachine.Text.Trim().ToUpper();
txtMachine4.Text = txtMachine.Text.Trim().ToUpper();
txtMachine5.Text = txtMachine.Text.Trim().ToUpper();
txtQuantity1.Text = "0";
txtQuantity2.Text = "0";
txtQuantity3.Text = "0";
txtQuantity4.Text = "0";
txtQuantity5.Text = "0";
lblValueMachine.Text = txtMachine.Text.Trim().ToUpper();
divTable.Visible = true;
}
else
{
divTable.Visible = false;
lblError.Text = mensajes("queryblank");
return;
}
}
else
{
lblError.Text = mensajes("machinenotexists");
return;
}
}