public static void SetValues(ParamCodes uc, Object val) { SqlConnection sc = new SqlConnection(DEFS.ConSTR); sc.Open(); string search_obj = uc.ToString(); string field_name = ""; SqlCommand cmd = new SqlCommand(); cmd.Connection = sc; cmd.CommandType = CommandType.Text; switch (GetType(uc)) { case ParamTypes.egesz: field_name = "PARAM_VALUE_I"; break; case ParamTypes.szoveg: field_name = "PARAM_VALUE_S"; break; case ParamTypes.tizedes: field_name = "PARAM_VALUE_F"; break; case ParamTypes.image: field_name = "PARAM_VALUE_IMAGE"; break; default: field_name = ""; break; } if (field_name != "") { string sql_str = "IF EXISTS(select '' from syspar where PARAM_NAME = '" + search_obj + "') BEGIN " + " UPDATE SYSPAR SET " + field_name + " = '" + val.ToString() + "' WHERE PARAM_NAME = '" + search_obj + "' " + " end else begin INSERT INTO syspar (PARAM_NAME, " + field_name + ") VALUES ('" + search_obj + "' ,'" + val.ToString() + "') END "; cmd.CommandText = sql_str; cmd.ExecuteNonQuery(); sc.Close(); } }
public static Object GetValue(ParamCodes c) { Object ret_obj = null; string search_obj = c.ToString(); string field_name = ""; SqlConnection sc = new SqlConnection(DEFS.ConSTR); sc.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = sc; cmd.CommandType = CommandType.Text; switch (GetType(c)) { case ParamTypes.egesz: field_name = "PARAM_VALUE_I"; break; case ParamTypes.szoveg: field_name = "PARAM_VALUE_S"; break; case ParamTypes.tizedes: field_name= "PARAM_VALUE_F"; break; case ParamTypes.image: field_name = "PARAM_VALUE_IMAGE"; break; default: field_name = ""; break; } if (field_name != "") { cmd.CommandText = "select " + field_name + " as VALUE from syspar where PARAM_NAME = '" + search_obj + "'"; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { ret_obj = rdr["VALUE"]; } sc.Close(); if (ret_obj == null) { return (Object)(""); } else { return (Object)(ret_obj); } } else { return (""); } }