示例#1
0
        public void insertClusteringSettingDetail(Cluster_Setting_Value csv)
        {
            Dictionary <string, object> parameters = new Dictionary <string, object>();

            parameters.Add("@Key", csv.Key);
            parameters.Add("@Value", csv.Value);
            parameters.Add("@isDefault", csv.isDedault);
            executeNonQuery("INSERT INTO [RS].[CLUSTER_SETTING_VALUE_TBL]([Key] ,[Value],[isDefault])VALUES(@Key,@Value,@isDefault)", parameters);
        }
示例#2
0
        public void updateClusteringSettingDetail(Cluster_Setting_Value csv)
        {
            Dictionary <string, object> parameters = new Dictionary <string, object>();

            parameters.Add("@Key", csv.Key);
            parameters.Add("@Value", csv.Value);
            parameters.Add("@isDefault", csv.isDedault);
            parameters.Add("@ValueID", csv.ValueID);
            executeNonQuery("UPDATE [RS].[CLUSTER_SETTING_VALUE_TBL] SET [Key] = @Key ,[Value] = @Value ,[isDefault] = @isDefault WHERE ValueID = @ValueID", parameters);
        }
示例#3
0
        public List <Cluster_Setting_Value> getListClusteringSettingValue(string Key)
        {
            Dictionary <string, object> parameters = new Dictionary <string, object>();

            parameters.Add("@Key", Key);
            SqlDataReader reader = executeReader("SELECT ValueID,Value,isDefault FROM RS.CLUSTER_SETTING_VALUE_TBL WHERE [Keys] = @Key ORDER BY isDefault DESC", parameters);
            List <Cluster_Setting_Value> lstClusteringSettingValue = new List <Cluster_Setting_Value>();

            while (reader.Read())
            {
                Cluster_Setting_Value csv = new Cluster_Setting_Value();
                csv.ValueID   = reader.GetInt32(reader.GetOrdinal("ValueID"));
                csv.Value     = reader.GetString(reader.GetOrdinal("Value"));
                csv.isDedault = reader.GetBoolean(reader.GetOrdinal("isDefault"));
                csv.Key       = Key;
                lstClusteringSettingValue.Add(csv);
            }
            reader.Close();
            return(lstClusteringSettingValue);
        }