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; } }