private void MyRefresh()
{
try
{
using (SqlExcuteCommand get = new SqlExcuteCommand()
{
DBCnnStr = DBEndososCnnStr
})
{
_MyCriteriosTable = get.MyGetCriterios(WhatIsModo);
Explicacion = string.Empty;
chk.Clear();
foreach (DataRow row in _MyCriteriosTable.Rows)
{
chk.Add(new Criterios
{
Campo = row["Campo"].ToString(),
Editar = row["Editar"].ToString().Trim() == "1" ? true : false,
Desc = row["Desc"].ToString(),
Warning = row["Warning"].ToString().Trim() == "1" ? true : false
});
}
}
}
catch (Exception)
{
throw;
}
}
private void MyRefresh()
{
try
{
CanView = false;
CanCmdSalir = true;
_RunProcess = false;
CanCmdProcess = false;
CanCmdRefresh = true;
ProgressBar_Maximum.Clear();
ProgressBar_Value.Clear();
ProgressBar_Maximum.Add(100);
ProgressBar_Value.Add(0);
Resultados.Clear();
Resultados.Add("0"); //lblLote 0
Resultados.Add("0"); //lblTota 1
Resultados.Add("0"); //lblProcesadas 2
Resultados.Add("0"); //lblAprobadas 3
Resultados.Add("0"); //lblRechazadas 4
Resultados.Add("0"); //lblWarnings 5
lblNReasons.Clear();
for (int i = 0; i <= CollCriterios.Count; i++)//17
{
lblNReasons.Add("0");
}
using (SqlExcuteCommand get = new SqlExcuteCommand()
{
DBCnnStr = DBEndososCnnStr,
DBCeeMasterCnnStr = DBCeeMasterCnnStr,
DBImagenesCnnStr = DBImagenesCnnStr
})
{
_MyCriteriosTable = get.MyGetCriterios(WhatIsModo);
CollCriterios.Clear();
Foreground_Desc.Clear();
foreach (DataRow row in _MyCriteriosTable.Rows)
{
CollCriterios.Add(new Criterios
{
Campo = row["Campo"].ToString(),
Editar = row["Editar"].ToString().Trim() == "1" ? true : false,
Desc = row["Desc"].ToString(),
Warning = row["Warning"].ToString().Trim() == "1" ? true : false
});
if (row["Editar"].ToString().Trim() != "1")
{
if (row["Warning"].ToString().Trim() != "1")
{
Foreground_Desc.Add(Brushes.Yellow);
}
else
{
Foreground_Desc.Add(Brushes.Red);
}
}
else
{
Foreground_Desc.Add(Brushes.Black);
}
}
lblNReasons.Clear();
for (int i = 0; i <= CollCriterios.Count; i++)//17
{
lblNReasons.Add("0");
}
_MyLotsTable = get.MyGetLotToProcess(WhatIsModo);
cbLots.Clear();
foreach (DataRow row in _MyLotsTable.Rows)
{
Lots myLots = new Lots();
myLots.Partido = row["Partido"].ToString();
myLots.Lot = row["Lot"].ToString();
myLots.Amount = row["Amount"].ToString();
myLots.Usercode = row["Usercode"].ToString();
myLots.AuthDate = row["AuthDate"].ToString();
myLots.Status = row["Status"].ToString();
myLots.VerDate = row["VerDate"].ToString();
myLots.VerUser = row["VerUser"].ToString();
myLots.FinUser = row["FinUser"].ToString();
myLots.FinDate = row["FinDate"].ToString();
myLots.RevDate = row["RevDate"].ToString();
myLots.RevUser = row["RevUser"].ToString();
myLots.conditions = row["conditions"].ToString();
myLots.ImportDate = row["ImportDate"].ToString();
myLots.Modo = int.Parse(row["Modo"].ToString());
cbLots.Add(myLots.Lot);
//if (WhatIsModo == 1)
//{
// if (myLots.Modo == 1)
// cbLots.Add(myLots.Lot);
//}
//else
//{
// if (myLots.Modo == 2)
// cbLots.Add(myLots.Lot);
//}
}
cbLots_Item_Id = -1;
MySendTab();
}
}
catch (Exception)
{
throw;
}
}