PSI.DAL/CreateSql.cs

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

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

using PSI.Common;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;

namespace PSI.DAL
{
        public class CreateSql
        {
                /// <summary>
                /// 生成Insert语句
                /// </summary>
                /// <typeparam name="T"></typeparam>
                /// <param name="t"></param>
                /// <param name="cols"></param>
                /// <returns></returns>
                public static SqlModel GetInsertSqlAndParas<T>(T t, string cols, int isReturn)
                {
                        Type type = typeof(T);
                        PropertyInfo[] properties = PropertyHelper.GetTypeProperties<T>(cols);
                        string priName = type.GetPrimary();
                        //生成要插入的列 {1}
                        string columns = string.Join(",", properties.Where(p => p.Name != priName).Select(p => $"[{p.GetColName()}]"));
                        //生成插入的参数{2}
                        string paraColumns = string.Join(",", properties.Where(p => p.Name != priName).Select(p => $"@{p.GetColName()}"));
                        //参数数组的生成
                        SqlParameter[] arrParas = CreateParameters<T>(properties, t);

                        //sql语句
                        string sql = $"INSERT INTO [{type.GetTName()}] ({columns}) VALUES ({paraColumns}) ";
                        if (isReturn == 1)
                                sql += ";select @@identity";
                        return new SqlModel() { Sql = sql, SqlParaArray = arrParas };

                }

                /// <summary>
                /// 生成Update语句
                /// </summary>
                /// <typeparam name="T"></typeparam>
                /// <param name="t"></param>
                /// <param name="cols"></param>
                /// <returns></returns>
                public static SqlModel GetUpdateSqlAndParas<T>(T t, string cols, string strWhere)
                {
                        Type type = typeof(T);
                        //获取所有属性
                        PropertyInfo[] properties = PropertyHelper.GetTypeProperties<T>(cols);
                        string priName = type.GetPrimary();
                        //生成要更新的列 {1}
                        string columns = string.Join(",", properties.Where(p => p.Name != priName).Select(p => string.Format("[{0}]=@{0}", p.GetColName())));
                        ;            //参数数组的生成
                        SqlParameter[] arrParas = CreateParameters<T>(properties, t);

                        if (string.IsNullOrEmpty(strWhere))
                        {