コード例 #1
0
        public static SqlCommand Create(Type type, params string[] columnValue)
        {
            string[] columns = new string[columnValue.Length / 2];
            string[] values  = new string[columnValue.Length / 2];
            int      j       = 0;

            for (int i = 0; i < columnValue.Length; i = i + 2)
            {
                columns[j] = columnValue[i];
                if (columnValue[i + 1] == null)
                {
                    values[j] = "";
                }
                else
                {
                    values[j] = columnValue[i + 1];
                }
                j++;
            }

            SqlCommand result = new SqlCommand();

            result.CommandText = CreateCommandText(columns, type);
            CommonCommandMaker <T> .AddParameters(columns, values, result);

            return(result);
        }
コード例 #2
0
        public static SqlCommand Create(T obj)
        {
            SqlCommand result = new SqlCommand();

            result.CommandText = CreateCommandText(obj);
            CommonCommandMaker <T> .AddParameters(obj, result);

            return(result);
        }