NAssintModelToDbCommand/CreateDbCommandBase.cs

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

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

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

namespace NLKIRAModelToDbCommand
{
    public class CreateDbCommandBase
    {
        public static void FillInsertCmd(BLLDALInfo bllDalInfo)
        {
            if (bllDalInfo.Model == null)
                throw new Exception("插入数值对象不能为空!");

            StringBuilder buf = new StringBuilder();
            StringBuilder parms1 = new StringBuilder();
            StringBuilder parms2 = new StringBuilder();
            foreach (PropertyInfo pi in bllDalInfo.Model.GetType().GetProperties())
            {
                if (!IsFilterProperty(pi))
                {
                    object value = pi.GetValue(bllDalInfo.Model, null);
                    if (value != null)
                    {
                        parms1.Append(pi.Name);
                        parms1.Append(", ");
                        parms2.Append("@" + pi.Name);
                        parms2.Append(", ");
                        AddParas(bllDalInfo.Command, "@" + pi.Name, value);
                    }
                }
            }

            if (parms1.Length > 0)
                parms1.Remove(parms1.Length - 2, 2);
            if (parms2.Length > 0)
                parms2.Remove(parms2.Length - 2, 2);

            buf.Append("INSERT INTO ");
            buf.Append(bllDalInfo.Model.TableName);
            buf.Append("( ");
            buf.Append(parms1);
            buf.Append(" )");
            buf.Append(" VALUES");
            buf.Append("( ");
            buf.Append(parms2);
            buf.Append(" )");

            bllDalInfo.Command.CommandText = buf.ToString();
        }
        public static void FillDeleteCmd(BLLDALInfo bllDalInfo)
        {
            string sqlWhereStr = SQLWhereStr(bllDalInfo.Command, bllDalInfo.Model);

            StringBuilder buf = new StringBuilder();