using System;

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

    }

    public static object InsertData(SqlConnection connect, SqlTransaction transact, params FieldValue[] dats)

    {

        object result = null;

​

        if (dats != null && dats.Length > 0)

        {

            var fields = from t in dats select t.Field;

            string nametable = GetMainTableInsertUpdate(fields.ToArray());

            StringBuilder strfields = new StringBuilder();

            StringBuilder strvalues = new StringBuilder();

            List<SqlParameter> lst = new List<SqlParameter>();

            int index = 1;

​

            foreach (var item in dats)

            {

                string nameparam = "@p" + index.ToString();

​

                if (item.Data != null)

                {

                    SqlParameter param = new SqlParameter(nameparam, item.Data);

                    lst.Add(param);

                    if (index == 1)

                    {

                        strfields.Append(item.Field.ColumnBase);

                        strvalues.Append(nameparam);

                    }

                    else

                    {

                        strfields.Append("," + item.Field.ColumnBase);

                        strvalues.Append("," + nameparam);

                    }

                }

                else

                {

                    if (index == 1)

                    {

                        strfields.Append(item.Field.ColumnBase);

                        strvalues.Append("null");

                    }

                    else

                    {

                        strfields.Append("," + item.Field.ColumnBase);

                        strvalues.Append(",null");

                    }

                }

​

                index++;

            }

​

            string comtext = "insert into " + nametable + "(" + strfields.ToString() + ") values (" + strvalues.ToString() + ") SELECT SCOPE_IDENTITY()";

​

            using (SqlCommand command = new SqlCommand(comtext, connect))

            {

                foreach (var pr in lst)

                {

                    command.Parameters.Add(pr);

                }

​

                if (transact != null)

                {

                    command.Transaction = transact;

                }

​

                result = command.ExecuteScalar();

            }

        }

​

        return result;

    }

}