batchprepare.cs

我的一个Ado.Net一个框架设计

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace DAL
{
    public static partial class BatchHelper
    {
        private static string GetUpdateColumn(string[] updateColumn)
        {
            StringBuilder columnName = new StringBuilder("");
            foreach (string name in updateColumn)
            {
                //设置set语句
                columnName.Append(name);

                columnName.Append("=@");
                columnName.Append(name);
                columnName.Append(",");

            }
            columnName.Remove(columnName.Length - 1, 1);//去掉最后的逗号
            return columnName.ToString();
        }

        private static string GetWhereString(string[] whereColumn)
        {
            if (null != whereColumn)
            {
                StringBuilder whereConstraint = new StringBuilder(" Where ");
                foreach (string column in whereColumn)
                {
                    whereConstraint.Append(column);
                    whereConstraint.Append("=@");
                    whereConstraint.Append(column);
                    whereConstraint.Append(" and ");
                }
                whereConstraint.Remove(whereConstraint.Length - 4, 4);
                return whereConstraint.ToString();
            }
            else
            {
                return string.Empty;
            }
        }
        private static string GetInsertColumn(DataTable addingTable, out string columnParam)
        {
            StringBuilder insertColumnName = new StringBuilder();
            StringBuilder insertColumnParam = new StringBuilder();
            foreach (DataColumn column in addingTable.Columns)
            {
                insertColumnName.Append(column.ColumnName);
                insertColumnName.Append(",");

                insertColumnParam.Append("@");
                insertColumnParam.Append(column.ColumnName);
                insertColumnParam.Append(",");
            }
            insertColumnName.Remove(insertColumnName.Length - 1, 1);
            insertColumnParam.Remove(insertColumnParam.Length - 1, 1);
            columnParam = insertColumnParam.ToString();
            return insertColumnName.ToString();
        }
    }
}