NAssintModelToDbCommand/SqlServer2000/CreateSQL2000DbCommand.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Common;
using System.Reflection;
using NLKIRAModel;

namespace NLKIRAModelToDbCommand
{
    public class CreateSQL2000DbCommand
    {
        public static IDbCommand FillDbCommand(BLLDALInfo bllDalInfo)
        {
            switch (bllDalInfo.ExecuteType)
            {
                case ExecuteType.Insert:
                    CreateDbCommandBase.FillInsertCmd(bllDalInfo);
                    break;
                case ExecuteType.Delete:
                    CreateDbCommandBase.FillDeleteCmd(bllDalInfo);
                    break;
                case ExecuteType.Update:
                    CreateDbCommandBase.FillUpdateCmd(bllDalInfo);
                    break;
                case ExecuteType.SelectRow:
                    FillSelectRowCmd(bllDalInfo);
                    break;
                case ExecuteType.SelectRows:
                    FillSelectRowsCmd(bllDalInfo);
                    break;
                case ExecuteType.SelectDataSet:
                    FillSelectDataSetCmd(bllDalInfo);
                    break;
                case ExecuteType.RowCount:
                    CreateDbCommandBase.FillRowCountCmd(bllDalInfo);
                    break;
                case ExecuteType.SelectTables:
                    FillSelectTablesCmd(bllDalInfo);
                    break;
                default:
                    break;
            }

            bllDalInfo.SqlString = CommandToSQLString(bllDalInfo.Command);
            return bllDalInfo.Command;
        }

        public static void FillSelectRowCmd(BLLDALInfo bllDalInfo)
        {
            FillSelectCmd(bllDalInfo, bllDalInfo.Model);
        }
        public static void FillSelectRowsCmd(BLLDALInfo bllDalInfo)
        {
            FillSelectCmd(bllDalInfo, bllDalInfo.Model);
        }
        public static void FillSelectDataSetCmd(BLLDALInfo bllDalInfo)
        {
            FillSelectCmd(bllDalInfo, bllDalInfo.ModelByWhere);
        }