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