public static string ChangeLanguageGridRowValue(ConfigLogica con)
{
string sValue = string.Empty;
try
{
string sColumn = "descripcion";
string sColumn2 = "description";
if (con.Language == "EN")
{
sColumn = "description";
sColumn2 = "descripcion";
}
string sSql = "SELECT " + sColumn + " FROM t_sysleng WHERE form = '" + con.Form + "' and control = '" + con.Control + "' and " + sColumn2 + " = '" + con.Valor + "'";
DataTable datos = AccesoDatos.Consultar(sSql);
if (datos.Rows.Count > 0)
{
sValue = datos.Rows[0][0].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
return(sValue);
}
public static DataTable Consultar(ConfigLogica config)
{
DataTable datos = new DataTable();
try
{
datos = AccesoDatos.Consultar("SELECT * FROM t_config WHERE clave = '" + config.CN + "'");
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static DataTable ChangeLanguage(ConfigLogica con)
{
DataTable datos = new DataTable();
try
{
string sColumn = "descripcion";
if (con.Language == "EN")
{
sColumn = "description";
}
else
{
datos = AccesoDatos.Consultar("SELECT " + sColumn + " FROM t_sysleng WHERE form = '" + con.Form + "' and control = '" + con.Control + "' and subcontrol = '" + con.SubControl + "' ");
}
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static int GuardarSP(ConfigLogica config)
{
string[] parametros = { "@Company", "@Jornada", "@HrsDisp", "@SegDisp", "@CajasLinea", "@KitsCaja", "@KitsLinea", "@TakTime", "@Tak80", "@AssyTime", "@MaxComp", "@MesaEns", "@MesaWrap", "@MesaSub", "@OperNA", "@Surtidor", "@InspSella", "@Sellador", "@Inspeccion", "@Usuario", "@Horiz", "@Vertical", "@Sobre", "@TuckTape", "@WrapNA", "@Detroit", "@Language", "@MaxHC", "@MinHC", "@BoxHr", "@OutAddTime", "@CycleTimer", "@Active" };
return(AccesoDatos.Actualizar("sp_mant_config", parametros, config.CN, config.Jornada, config.HorasDisp, config.SegDisp, config.Cajas, config.Kits, config.KitLinea, config.Tak, config.Tak80, config.Assy, config.MaxComp, config.Mesas, config.MesaWrap, config.MesaSub, config.OperNA, config.Surtidor, config.InspSella, config.Selladora, config.Inspeccion, config.Usuario, config.Horizontal, config.Vertical, config.Sobre, config.Tape, config.WrapNA, config.Detroit, config.Language, config.MaxHC, config.MinHC, config.BoxHr, config.OutAddTime, config.CycleTimer, config.ActiveCN));
}
public static int Guardar(ConfigLogica conf)
{
string[] parametros = { "@Clave", "@Ruta", "@Laser", "@RotMin", "@MargenW", "@MargenH", "@PaddingX", "@PaddingY", "@MargenW1", "@MargenH1", "@PorcStd" };
return(AccesoDatos.Actualizar("sp_mant_config", parametros, conf.Clave, conf.Ruta, conf.Laser, conf.RotMin, conf.MargenW, conf.MargenH, conf.PaddingX, conf.PaddingY, conf.MargenW1, conf.MargenH1, conf.PorcStd));
}
public static int Guardar(ConfigLogica config)
{
string[] parametros = { "@Activos", "@DirecAct", "@FileAct", "@HrAct1", "@HrAct2", "@CargaAct", "@Asistencia", "@DirecAsis", "@FileAsis", "@HrAsis1", "@HrAsis2", "@CargaAsis", "@Server3", "@Tipo3", "@Based3", "@User3", "@Passwd3", "@ServerOrb", "@TipoOrb", "@BasedOrb", "@UserOrb", "@PasswdOrb", "@PuertoOrb", "@AsisGenMin", "@Kanban", "@KanDirec", "@KanFile", "@KanStart", "@KanEnd", "@KanMins" };
return(AccesoDatos.Actualizar("sp_mant_config", parametros, config.Activos, config.DirecAct, config.FileAct, config.HrAct1, config.HrAct2, config.CargarAct, config.Asistencia, config.DirecAsis, config.FileAsis, config.HrAsis1, config.HrAsis2, config.CargarAsis, config.Server, config.Tipo, config.Based, config.User, config.Passwd, config.ServerOrb, config.TipoOrb, config.BasedOrb, config.UserOrb, config.PasswdOrb, config.PuertoOrb, config.AsisGenMin, config.Kanban, config.KanPath, config.KanFile, config.KanStart, config.KanEnd, config.KanMins));
}
