[C#] Mssql Parameter

[C#] Mssql Parameter

 

MSSQL 파라미터 만들기, 값 가져와서 파싱하기

public static class DBCommon
{
    public static SqlParameter MakeParam(string name, int value)
    {
        var paramName = new SqlParameter();
        paramName.ParameterName = name;
        paramName.Value = value;
        return paramName;
    }
 
    public static SqlParameter MakeParam(string name, DBNull value)
    {
        var paramName = new SqlParameter();
        paramName.ParameterName = name;
        paramName.Value = value;
        return paramName;
    }
 
    public static SqlParameter MakeParam(string name, double value)
    {
        var paramName = new SqlParameter();
        paramName.ParameterName = name;
        paramName.Value = value;
        return paramName;
    }
 
    public static SqlParameter MakeParam(string name, bool value)
    {
        var paramName = new SqlParameter();
        paramName.ParameterName = name;
        paramName.Value = value;
        return paramName;
    }
 
    public static SqlParameter MakeParam(string name, string value)
    {
        var paramName = new SqlParameter();
        paramName.ParameterName = name;
        if (value == null)
        {
            paramName.Value = DBNull.Value;
        }
        else
        {
            paramName.Value = value;
        }
        return paramName;
    }
 
    public static SqlParameter MakeParam(string name, DateTime value)
    {
        var paramName = new SqlParameter();
        paramName.ParameterName = name;
        if (value == null)
        {
            paramName.Value = DBNull.Value;
        }
        else
        {
            paramName.Value = value;
        }
        return paramName;
    }
 
    public static int GetInt(object sqlDataReader)
    {
        int value = sqlDataReader == DBNull.Value ? 0 : int.Parse(sqlDataReader.ToString());
        return value;
    }
 
    public static double GetDouble(object sqlDataReader)
    {
        double value = sqlDataReader == DBNull.Value ? 0 : float.Parse(sqlDataReader.ToString());
        return value;
    }
 
    public static double GetFloat(object sqlDataReader)
    {
        double value = sqlDataReader == DBNull.Value ? 0 : float.Parse(sqlDataReader.ToString());
        return value;
    }
 
    public static string GetString(object sqlDataReader)
    {
        string value = sqlDataReader == DBNull.Value ? string.Empty : sqlDataReader.ToString();
        return value;
    }
 
    public static bool GetBool(object sqlDataReader)
    {
        bool value = sqlDataReader == DBNull.Value ? false : Convert.ToBoolean(sqlDataReader.ToString());
        return value;
    }
 
    public static DateTime GetDateTime(object sqlDataReader)
    {
        DateTime value = sqlDataReader == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(sqlDataReader);
        return value;
    }
}