public static void SaveDBConfig(string str_SetObjectName, string str_SetPrimaryKey) { string src = CommonCode.projSrc + "/BigDataAnalysis.Config/DbConfig.cs"; var str = JsonHelper.GetFile(src); string[] arr = JsonHelper.SplitString(str, "\r\n"); StringBuilder sb = new StringBuilder(); foreach (var item in arr) { if (item.Contains("#endregion 数据库表名配置")) { sb.AppendLine(str_SetObjectName); } else if (item.Contains("#endregion 数据表主键配置")) { sb.AppendLine(str_SetPrimaryKey); } sb.AppendLine(item); } string file_Model = "C:\\Code\\BigDataAnalysis.Config"; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/DbConfig.cs", sb.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("using System;"); sb_body.AppendLine("using System.Collections.Generic;"); sb_body.AppendLine("using System.Linq;"); sb_body.AppendLine("using System.Text;"); sb_body.AppendLine("using System.Threading.Tasks;"); sb_body.AppendLine("using Lee.Command;"); sb_body.AppendLine("using " + str_nameSpace + ".Entity;"); sb_body.AppendLine("using " + str_nameSpace + ".Entity." + tablePrefix + ";"); sb_body.AppendLine(""); sb_body.AppendLine("namespace " + str_nameSpace + ".DataAccessInterface." + tablePrefix + ""); sb_body.AppendLine("{"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 数据访问接口:" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public interface I" + tableName + "DataAccess : IDataAccess<" + tableName + "Entity>"); sb_body.AppendLine(" {"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 数据库接口:" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public interface I" + tableName + "DbAccess : I" + tableName + "DataAccess"); sb_body.AppendLine(" {"); sb_body.AppendLine(" }"); sb_body.AppendLine("}"); string file_Model = "C:\\Code\\" + str_nameSpace + ".DataAccessInterface\\" + tablePrefix + ""; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/I" + tableName + "DataAccess.cs", sb_body.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); StringBuilder sb_body = new StringBuilder(); SetData(tableName, tablePrefix, tableDesc, sb_body); string filePath = "C:\\Code\\Sql"; if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } CommonCode.Save(filePath + "/" + tableName + ".txt", sb_body.ToString()); CommonCode.Save(filePath + "/" + tableName + "_Delete.txt", GetSql_Delete(tableDesc)); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("using System;"); sb_body.AppendLine("using System.Collections.Generic;"); sb_body.AppendLine("using System.Linq;"); sb_body.AppendLine("using System.Text;"); sb_body.AppendLine("using System.Threading.Tasks;"); sb_body.AppendLine("using Lee.Command;"); sb_body.AppendLine("using Lee.CQuery;"); sb_body.AppendLine("using Lee.CQuery.Paging;"); sb_body.AppendLine("using Lee.Domain.Repository;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain." + tablePrefix + ".Model;"); sb_body.AppendLine(""); sb_body.AppendLine("namespace " + str_nameSpace + ".Domain." + tablePrefix + ".Repository"); sb_body.AppendLine("{"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 存储:" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public interface I" + tableName + "Repository : IRepository<" + tableName + ">"); sb_body.AppendLine(" {"); sb_body.AppendLine(" }"); sb_body.AppendLine("}"); string file_Model = "C:\\Code\\" + str_nameSpace + ".Domain\\" + tablePrefix + "\\Repository"; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/I" + tableName + "Repository.cs", sb_body.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("using System;"); sb_body.AppendLine("using System.Collections.Generic;"); sb_body.AppendLine("using Lee.Domain.Repository;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain." + tablePrefix + ".Model;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain." + tablePrefix + ".Repository;"); sb_body.AppendLine("using " + str_nameSpace + ".Entity." + tablePrefix + ";"); sb_body.AppendLine("using " + str_nameSpace + ".DataAccessInterface." + tablePrefix + ";"); sb_body.AppendLine(""); sb_body.AppendLine(""); sb_body.AppendLine("namespace " + str_nameSpace + ".Repository." + tablePrefix + ""); sb_body.AppendLine("{"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 存储:" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public class " + tableName + "Repository : DefaultRepository<" + tableName + ", " + tableName + "Entity, I" + tableName + "DataAccess>, I" + tableName + "Repository"); sb_body.AppendLine(" {"); sb_body.AppendLine(" }"); sb_body.AppendLine("}"); string file_Model = "C:\\Code\\" + str_nameSpace + ".Repository\\" + tablePrefix + ""; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/" + tableName + "Repository.cs", sb_body.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); bool isPrimeKey = false; string primaryKey = ""; bool isSortIndex = false; StringBuilder sb = new StringBuilder(); StringBuilder sb_search = new StringBuilder(); #region Model //遍历每个字段 foreach (DataRow dr in dt_tables.Rows) { string columnName = dr["columnName"].ToString().Trim(); //字段名 string columnType = dr["columnType"].ToString().Trim(); //字段类型 string columnComment = dr["columnComment"].ToString().Trim(); //字段注释 string nullable = dr["nullable"].ToString().Trim(); //是否可空(Y是不为空,N是为空) string data_default = dr["data_default"].ToString().Trim(); //默認值 string data_maxLength = dr["char_col_decl_length"].ToString().Trim(); //最大長度 string bool_primaryKey = dr["primaryKey"].ToString().Trim(); //主键 值为Y或N if (bool_primaryKey.ToUpper() == "Y") //存在主键 { isPrimeKey = true; primaryKey = columnName.ToUpper(); } if (string.IsNullOrEmpty(columnComment)) { columnComment = columnName; } CommonCode.GetColumnType(ref columnType, ref data_default); nullable = CommonCode.GetNullable(columnType, nullable); if (columnType == "string") { sb.AppendLine(" if (!filter." + columnName + ".IsNullOrEmpty())"); sb.AppendLine(" {"); sb.AppendLine(" query.Equal<" + tableName + "Query>(c => c." + columnName + ", filter." + columnName + ");"); sb.AppendLine(" }"); sb_search.AppendLine(" if (!filter." + columnName + "_Search.IsNullOrEmpty())"); sb_search.AppendLine(" {"); sb_search.AppendLine(" query.Like<" + tableName + "Query>(c => c." + columnName + ", filter." + columnName + "_Search);"); sb_search.AppendLine(" }"); } else if (columnName == "IsDelete") { sb_search.AppendLine(""); sb_search.AppendLine(" query.Equal<" + tableName + "Query>(c => c." + columnName + ", false);"); sb_search.AppendLine(""); } else { sb.AppendLine(" if (filter." + columnName + ".HasValue)"); sb.AppendLine(" {"); sb.AppendLine(" query.Equal<" + tableName + "Query>(c => c." + columnName + ", filter." + columnName + ");"); sb.AppendLine(" }"); } if (columnName == "SortIndex") { isSortIndex = true; } } #endregion Model bool IsSetFilter = false; bool IsSaveHistory = true; StringBuilder sb2 = new StringBuilder(); var listModel = CommonCode.GetTableModel(tableName); if (listModel != null) { foreach (var item in listModel) { SetSB(sb2, item, tableName); if (item.IsSetFilter.HasValue) { IsSetFilter = item.IsSetFilter.Value; } if (item.IsSaveHistory.HasValue) { IsSaveHistory = item.IsSaveHistory.Value; } } } var tableModels = CommonCode.GetTableModel(tableName); foreach (var item in tableModels) { } StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("using System;"); sb_body.AppendLine("using System.Collections.Generic;"); sb_body.AppendLine("using System.Linq;"); sb_body.AppendLine("using System.Data.SqlClient;"); sb_body.AppendLine("using System.Transactions;"); sb_body.AppendLine("using Lee.Command.UnitOfWork;"); sb_body.AppendLine("using Lee.CQuery;"); sb_body.AppendLine("using Lee.CQuery.Paging;"); sb_body.AppendLine("using Lee.Utility;"); sb_body.AppendLine("using Lee.Utility.Extension;"); sb_body.AppendLine("using " + str_nameSpace + ".BusinessInterface." + tablePrefix + ";"); sb_body.AppendLine("using " + str_nameSpace + ".Domain." + tablePrefix + ".Model;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain." + tablePrefix + ".Service;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO." + tablePrefix + ".Query.Filter;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO." + tablePrefix + ".Cmd;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO." + tablePrefix + ".Query;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO.Query;"); sb_body.AppendLine("using " + str_nameSpace + ".Query." + tablePrefix + ";"); sb_body.AppendLine("using " + str_nameSpace + ".DTO.Bcl.Cmd;"); sb_body.AppendLine("using " + str_nameSpace + ".Enum;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain.Bcl.Service;"); sb_body.AppendLine("using " + str_nameSpace + ".Tools;"); sb_body.AppendLine("using " + str_nameSpace + ".Tools.Helper;"); sb_body.AppendLine("using " + str_nameSpace + ".Business.Common;"); sb_body.AppendLine(""); sb_body.AppendLine("namespace " + str_nameSpace + ".Business." + tablePrefix + ""); sb_body.AppendLine("{"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 业务:" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public class " + tableName + "Business : I" + tableName + "Business"); sb_body.AppendLine(" {"); sb_body.AppendLine(" public " + tableName + "Business()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 保存"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 保存" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"saveInfo\">保存信息</param>"); sb_body.AppendLine(" /// <returns>执行结果</returns>"); sb_body.AppendLine(" public Result<" + tableName + "Dto> Save" + tableName + "(Save" + tableName + "CmdDto saveInfo)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" if (saveInfo == null)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return Result<" + tableName + "Dto>.ErrorResult(\"没有指定任何要保存的信息\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(" using (var businessWork = UnitOfWork.Create())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" var saveResult = " + tableName + "Service.Save" + tableName + "(saveInfo." + tableName + ".MapTo<" + tableName + ">());"); sb_body.AppendLine(" if (!saveResult.Success)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return Result<" + tableName + "Dto>.ErrorResult(saveResult.Message);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" SaveHistory(saveInfo." + tableName + ", saveResult.Data.SysNo);"); sb_body.AppendLine(""); sb_body.AppendLine(" var commitResult = businessWork.Commit();"); sb_body.AppendLine(" Result<" + tableName + "Dto> result = null;"); sb_body.AppendLine(" if (commitResult.ExecutedSuccess)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" result = Result<" + tableName + "Dto>.SuccessResult(\"保存成功!\");"); sb_body.AppendLine(" result.Data = saveResult.Data.MapTo<" + tableName + "Dto>();"); sb_body.AppendLine(" }"); sb_body.AppendLine(" else"); sb_body.AppendLine(" {"); sb_body.AppendLine(" result = Result<" + tableName + "Dto>.ErrorResult(\"保存失败!\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(" return result;"); sb_body.AppendLine(" }"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 批量保存" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"saveInfo\">保存信息</param>"); sb_body.AppendLine(" /// <returns>执行结果</returns>"); sb_body.AppendLine(" public Result SaveList" + tableName + "(Save" + tableName + "CmdDto saveInfo)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" if (saveInfo == null || saveInfo.List" + tableName + ".IsNullOrEmpty())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return Result.ErrorResult(\"没有指定任何要保存的信息\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" try"); sb_body.AppendLine(" {"); sb_body.AppendLine(" saveInfo.List" + tableName + ".Where(d => d.SysNo == Guid.Empty).ToList().ForEach(d => d.SysNo = Guid.NewGuid());"); sb_body.AppendLine(" var bulk = new SqlBulkTools.BulkOperations();"); sb_body.AppendLine(""); sb_body.AppendLine(" using (TransactionScope trans = new TransactionScope())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" using (SqlConnection conn = new SqlConnection(Keys.connectionString))"); sb_body.AppendLine(" {"); sb_body.AppendLine(" bulk.Setup<" + tableName + "CmdDto>()"); sb_body.AppendLine(" .ForCollection(saveInfo.List" + tableName + ")"); sb_body.AppendLine(" .WithTable(\"" + tablePrefix + "_" + tableName + "\")"); sb_body.AppendLine(" .AddAllColumns()"); sb_body.AppendLine(" .BulkInsertOrUpdate()"); sb_body.AppendLine(" .SetIdentityColumn(x => x.SysNo)"); sb_body.AppendLine(" .MatchTargetOn(x => x.SysNo)"); sb_body.AppendLine(" .Commit(conn);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" trans.Complete();"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); if (IsSaveHistory) { sb_body.AppendLine(" using (var businessWork = UnitOfWork.Create())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" foreach (var item in saveInfo.List" + tableName + ")"); sb_body.AppendLine(" {"); sb_body.AppendLine(" SaveHistory(item, item.SysNo);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" var commitResult = businessWork.Commit();"); sb_body.AppendLine(" }"); } sb_body.AppendLine(" return Result.SuccessResult(\"修改成功!\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(" catch (Exception ex)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" LogHelper.WriteError(ex);"); sb_body.AppendLine(" return Result.ErrorResult(\"修改失败!\" + ex.Message);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); //sb_body.AppendLine(" /// <summary>"); //sb_body.AppendLine(" /// 批量保存" + tableDesc); //sb_body.AppendLine(" /// </summary>"); //sb_body.AppendLine(" /// <param name=\"saveInfo\">保存信息</param>"); //sb_body.AppendLine(" /// <returns>执行结果</returns>"); //sb_body.AppendLine(" public Result SaveList" + tableName + "(Save" + tableName + "CmdDto saveInfo)"); //sb_body.AppendLine(" {"); //sb_body.AppendLine(" if (saveInfo == null || saveInfo.List" + tableName + ".IsNullOrEmpty())"); //sb_body.AppendLine(" {"); //sb_body.AppendLine(" return Result.ErrorResult(\"没有指定任何要保存的信息\");"); //sb_body.AppendLine(" }"); //sb_body.AppendLine(" using (var businessWork = UnitOfWork.Create())"); //sb_body.AppendLine(" {"); //sb_body.AppendLine(" var saveResult = " + tableName + "Service.SaveList" + tableName + "(saveInfo.List" + tableName + ".Select(c => c.MapTo<" + tableName + ">()));"); //sb_body.AppendLine(" if (!saveResult.Success)"); //sb_body.AppendLine(" {"); //sb_body.AppendLine(" return saveResult;"); //sb_body.AppendLine(" }"); //sb_body.AppendLine(""); //sb_body.AppendLine(" foreach (var item in saveInfo.List" + tableName + ")"); //sb_body.AppendLine(" {"); //sb_body.AppendLine(" SaveHistory(item, item.SysNo);"); //sb_body.AppendLine(" }"); //sb_body.AppendLine(""); //sb_body.AppendLine(" var commitResult = businessWork.Commit();"); //sb_body.AppendLine(" return commitResult.ExecutedSuccess ? Result.SuccessResult(\"修改成功\") : Result.ErrorResult(\"修改失败\");"); //sb_body.AppendLine(""); //sb_body.AppendLine(" }"); //sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion 保存"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 获取"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"filter\">查询条件</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public " + tableName + "Dto Get" + tableName + "(" + tableName + "FilterDto filter)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" var " + tableName + " = " + tableName + "Service.Get" + tableName + "(CreateQueryObject(filter));"); sb_body.AppendLine(" return " + tableName + ".MapTo<" + tableName + "Dto>();"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion 获取"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 获取列表"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取" + tableDesc + "列表"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"filter\">查询条件</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public List<" + tableName + "Dto> Get" + tableName + "List(" + tableName + "FilterDto filter)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" var " + tableName + "List = " + tableName + "Service.Get" + tableName + "List(CreateQueryObject(filter));"); sb_body.AppendLine(" return " + tableName + "List.Select(c => c.MapTo<" + tableName + "Dto>()).ToList();"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion 获取列表"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 获取分页"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取" + tableDesc + "分页"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"filter\">查询条件</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public IPaging<" + tableName + "Dto> Get" + tableName + "Paging(" + tableName + "FilterDto filter)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" var " + tableName + "Paging = " + tableName + "Service.Get" + tableName + "Paging(CreateQueryObject(filter));"); sb_body.AppendLine(" return " + tableName + "Paging.Convert<" + tableName + ", " + tableName + "Dto>();"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion 获取分页"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 删除"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 删除" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"deleteInfo\">删除信息</param>"); sb_body.AppendLine(" /// <returns>执行结果</returns>"); sb_body.AppendLine(" public Result Delete" + tableName + "(Delete" + tableName + "CmdDto deleteInfo)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" if (!deleteInfo.IsRealDeleted)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return Delete" + tableName + "2(deleteInfo);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 参数判断"); sb_body.AppendLine(""); sb_body.AppendLine(" if (deleteInfo == null || deleteInfo." + tableName + "Ids.IsNullOrEmpty())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return Result.ErrorResult(\"没有指定要删除的\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion 参数判断"); sb_body.AppendLine(""); sb_body.AppendLine(" using (var businessWork = UnitOfWork.Create())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" var " + tableName + "s = deleteInfo." + tableName + "Ids.Select(c => " + tableName + ".Create" + tableName + "(c));"); sb_body.AppendLine(" var deleteResult = " + tableName + "Service.Delete" + tableName + "(" + tableName + "s);"); sb_body.AppendLine(" if (!deleteResult.Success)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return deleteResult;"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" SaveDeleteHistory(deleteInfo);"); sb_body.AppendLine(""); sb_body.AppendLine(" var commitResult = businessWork.Commit();"); sb_body.AppendLine(" return commitResult.ExecutedSuccess ? Result.SuccessResult(\"删除成功\") : Result.ErrorResult(\"删除失败\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 删除客户(假删除)"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"deleteInfo\"></param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public Result Delete" + tableName + "2(Delete" + tableName + "CmdDto deleteInfo)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" #region 参数判断"); sb_body.AppendLine(""); sb_body.AppendLine(" if (deleteInfo == null || deleteInfo." + tableName + "Ids.IsNullOrEmpty())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return Result.ErrorResult(\"没有指定要删除的\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion 参数判断"); sb_body.AppendLine(""); sb_body.AppendLine(" try"); sb_body.AppendLine(" {"); sb_body.AppendLine(" var List" + tableName + " = deleteInfo." + tableName + "Ids.Select(c => " + tableName + ".Create" + tableName + "(c)).MapTo<List<" + tableName + "CmdDto>>();"); sb_body.AppendLine(" List" + tableName + ".ForEach(d => d.UpdateDate = DateTime.Now);"); sb_body.AppendLine(" List" + tableName + ".ForEach(d => d.UpdateUserID = deleteInfo.UpdateUserID);"); sb_body.AppendLine(" List" + tableName + ".ForEach(d => d.IsDelete = true);"); sb_body.AppendLine(""); sb_body.AppendLine(" var bulk = new SqlBulkTools.BulkOperations();"); sb_body.AppendLine(""); sb_body.AppendLine(" using (TransactionScope trans = new TransactionScope())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" using (SqlConnection conn = new SqlConnection(Keys.connectionString))"); sb_body.AppendLine(" {"); sb_body.AppendLine(" bulk.Setup<" + tableName + "CmdDto>()"); sb_body.AppendLine(" .ForCollection(List" + tableName + ")"); sb_body.AppendLine(" .WithTable(\"" + tablePrefix + "_" + tableName + "\")"); sb_body.AppendLine(" .AddColumn(d => d.UpdateDate)"); sb_body.AppendLine(" .AddColumn(d => d.UpdateUserID)"); sb_body.AppendLine(" .AddColumn(d => d.IsDelete)"); sb_body.AppendLine(" .BulkUpdate()"); sb_body.AppendLine(" .SetIdentityColumn(x => x.SysNo)"); sb_body.AppendLine(" .MatchTargetOn(x => x.SysNo)"); sb_body.AppendLine(" .Commit(conn);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" trans.Complete();"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); if (IsSaveHistory) { sb_body.AppendLine(" using (var businessWork = UnitOfWork.Create())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" SaveDeleteHistory(deleteInfo);"); sb_body.AppendLine(" var commitResult = businessWork.Commit();"); sb_body.AppendLine(" }"); } sb_body.AppendLine(""); sb_body.AppendLine(" return Result.SuccessResult(\"删除成功!\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(" catch (Exception ex)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" LogHelper.WriteError(ex);"); sb_body.AppendLine(" return Result.ErrorResult(\"删除失败!\" + ex.Message);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" }"); sb_body.AppendLine(" #endregion 删除"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 历史记录"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 保存时,记录历史记录"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"saveInfo\"></param>"); sb_body.AppendLine(" /// <param name=\"SysNo\"></param>"); sb_body.AppendLine(" private static void SaveHistory(" + tableName + "CmdDto saveInfo, Guid SysNo)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" SaveHistoryCmdDto saveHistoryCmdDto = new SaveHistoryCmdDto()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" History = new HistoryCmdDto()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" OperationID = SysNo,"); sb_body.AppendLine(" OperationType = OperationTypeEnum." + tableName + ".ToString(),"); sb_body.AppendLine(" OperationName = saveInfo.SysNo == Guid.Empty ? OperationNameEnum.Add.ToString() : OperationNameEnum.Edit.ToString(),"); sb_body.AppendLine(" CreateUserID = saveInfo.UpdateUserID ?? Guid.Empty,"); sb_body.AppendLine(" }"); sb_body.AppendLine(" };"); sb_body.AppendLine(" HistoryService.SaveHistory(saveHistoryCmdDto.History.MapTo<Domain.Bcl.Model.History>());"); sb_body.AppendLine(""); sb_body.AppendLine(" LogHelper.WriteHistory(\"Save" + tableName + "\", JsonConvertHelper.SerializeObject(saveInfo), saveInfo.UpdateUserID);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 删除时,记录历史记录"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"deleteInfo\"></param>"); sb_body.AppendLine(" private void SaveDeleteHistory(Delete" + tableName + "CmdDto deleteInfo)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" foreach (var item in deleteInfo." + tableName + "Ids)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" SaveHistoryCmdDto saveHistoryCmdDto = new SaveHistoryCmdDto()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" History = new HistoryCmdDto()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" OperationID = item,"); sb_body.AppendLine(" OperationType = OperationTypeEnum." + tableName + ".ToString(),"); sb_body.AppendLine(" OperationName = OperationNameEnum.Delete.ToString(),"); sb_body.AppendLine(" CreateUserID = deleteInfo.UpdateUserID,"); sb_body.AppendLine(" }"); sb_body.AppendLine(" };"); sb_body.AppendLine(" HistoryService.SaveHistory(saveHistoryCmdDto.History.MapTo<Domain.Bcl.Model.History>());"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" LogHelper.WriteHistory(\"Delete" + tableName + "\", JsonConvertHelper.SerializeObject(deleteInfo), deleteInfo.UpdateUserID);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion 历史记录"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 根据查询条件生成查询对象"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 根据查询条件生成查询对象"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"filter\">查询条件</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" private IQuery CreateQueryObject(" + tableName + "FilterDto filter)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" if (filter == null)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return null;"); sb_body.AppendLine(" }"); sb_body.AppendLine(" IQuery query = QueryFactory.Create<" + tableName + "Query>(filter);"); sb_body.AppendLine(" if (!filter.SysNos.IsNullOrEmpty())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" query.In<" + tableName + "Query>(c => c.SysNo, filter.SysNos);"); sb_body.AppendLine(" }"); sb_body.AppendLine(sb.ToString()); sb_body.AppendLine(""); if (IsSetFilter) { sb_body.AppendLine(" CommonSetFilter.SetFilter_" + tableName + "(filter, query);"); } sb_body.AppendLine(""); sb_body.AppendLine(" #region Search"); sb_body.AppendLine(""); sb_body.AppendLine(sb_search.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 数据加载"); sb_body.AppendLine(sb2.ToString()); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); if (isSortIndex) { sb_body.AppendLine(" query.Desc<" + tableName + "Query>(c => c.SortIndex);"); } sb_body.AppendLine(" query.Desc<" + tableName + "Query>(c => c.CreateDate);"); sb_body.AppendLine(" return query;"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion 根据查询条件生成查询对象"); sb_body.AppendLine(" }"); sb_body.AppendLine("}"); sb_body.AppendLine(""); string file_Model = "C:\\Code\\" + str_nameSpace + ".Business\\" + tablePrefix + ""; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/" + tableName + "Business.cs", sb_body.ToString()); }
public void Create(string file_Model, string str_nameSpace, DataTable dt_tables, string str_ModelName) { bool isPrimeKey = false; string primaryKey = ""; StringBuilder sb = new StringBuilder(); #region Model sb.AppendLine(" #region Model"); //遍历每个字段 foreach (DataRow dr in dt_tables.Rows) { string columnName = dr["columnName"].ToString().Trim(); //字段名 string columnType = dr["columnType"].ToString().Trim(); //字段类型 string columnComment = dr["columnComment"].ToString().Trim(); //字段注释 string nullable = dr["nullable"].ToString().Trim(); //是否可空(Y是不为空,N是为空) string data_default = dr["data_default"].ToString().Trim(); //默認值 string data_maxLength = dr["char_col_decl_length"].ToString().Trim(); //最大長度 string bool_primaryKey = dr["primaryKey"].ToString().Trim(); //主键 值为Y或N if (bool_primaryKey.ToUpper() == "Y") //存在主键 { isPrimeKey = true; primaryKey = columnName.ToUpper(); } if (string.IsNullOrEmpty(columnComment)) { columnComment = columnName; } #region 数据类型判断 switch (columnType.ToLower()) { case "bit": columnType = "bool"; if (!string.IsNullOrEmpty(data_default)) { data_default = " = " + data_default.TrimStart('(').TrimEnd(')'); } break; case "int": case "tinyint": case "bigint": columnType = "int"; if (!string.IsNullOrEmpty(data_default)) { data_default = " = " + data_default.TrimStart('(').TrimEnd(')'); } break; case "binary": case "decimal": case "float": case "money": case "numeric": case "smallint": case "smallmoney": case "varbinary": columnType = "decimal"; if (!string.IsNullOrEmpty(data_default)) { data_default = " = " + data_default.TrimStart('(').TrimEnd(')'); } break; case "date": case "datetime": case "datetime2": case "smalldatetime": case "time": columnType = "DateTime"; if (!string.IsNullOrEmpty(data_default)) { if (data_default.ToLower() == "(getdate())") { data_default = " = DateTime.Now"; } } break; default: columnType = "string"; if (!string.IsNullOrEmpty(data_default)) { data_default = " = \"" + data_default.Trim('(', ')').Trim('\'') + "\""; } break; } #endregion 数据类型判断 nullable = CommonCode.GetNullable(columnType, nullable); sb.AppendLine(""); sb.AppendLine(@" /// <summary>"); sb.AppendLine(@" /// " + columnComment); sb.AppendLine(@" /// </summary>"); //if (dr["nullable"].ToString().ToUpper().Trim() == "Y")//不為空 //{ // sb.AppendLine(@" [Required]"); //} //if (!string.IsNullOrEmpty(data_maxLength))//最大長度 //{ // sb.AppendLine(@" [StringLength(" + data_maxLength + ")]"); //} sb.AppendLine(" public " + columnType + nullable + " " + columnName + " { get; set; }"); } sb.AppendLine(" #endregion Model"); #endregion Model string st_prime_tip = ""; if (!isPrimeKey) { st_prime_tip = "没有主键,默认主键为:" + primaryKey; } else { st_prime_tip = "有主键,主键为:" + primaryKey; } StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("using System;"); sb_body.AppendLine(""); sb_body.AppendLine("namespace " + str_nameSpace + ".Model"); sb_body.AppendLine("{"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// Model实体类:" + str_ModelName); sb_body.AppendLine(" /// 创建时间:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public partial class " + str_ModelName); sb_body.AppendLine(" {"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// " + st_prime_tip); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public " + str_ModelName + "() { }"); sb_body.AppendLine(""); sb_body.Append(sb.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(""); sb_body.AppendLine(" }"); sb_body.AppendLine("}"); CommonCode.Save(file_Model + "/" + str_ModelName + ".cs", sb_body.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); bool isPrimeKey = false; string primaryKey = ""; StringBuilder sb = new StringBuilder(); StringBuilder sb2 = new StringBuilder(); StringBuilder sb3 = new StringBuilder(); #region Model //遍历每个字段 foreach (DataRow dr in dt_tables.Rows) { string columnName = dr["columnName"].ToString().Trim(); //字段名 string columnType = dr["columnType"].ToString().Trim(); //字段类型 string columnComment = dr["columnComment"].ToString().Trim(); //字段注释 string nullable = dr["nullable"].ToString().Trim(); //是否可空(Y是不为空,N是为空) string data_default = dr["data_default"].ToString().Trim(); //默認值 string data_maxLength = dr["char_col_decl_length"].ToString().Trim(); //最大長度 string bool_primaryKey = dr["primaryKey"].ToString().Trim(); //主键 值为Y或N if (bool_primaryKey.ToUpper() == "Y") //存在主键 { isPrimeKey = true; primaryKey = columnName.ToUpper(); } if (string.IsNullOrEmpty(columnComment)) { columnComment = columnName; } CommonCode.GetColumnType(ref columnType, ref data_default); nullable = CommonCode.GetNullable(columnType, nullable); sb.AppendLine(""); sb.AppendLine(@" /// <summary>"); sb.AppendLine(@" /// " + columnComment); sb.AppendLine(@" /// </summary>"); sb.AppendLine(" protected " + columnType + nullable + " _" + columnName + ";"); sb2.AppendLine(" /// <summary>"); sb2.AppendLine(" /// " + columnComment); sb2.AppendLine(" /// </summary>"); sb2.AppendLine(" public " + columnType + nullable + " " + columnName); sb2.AppendLine(" {"); sb2.AppendLine(" get { return _" + columnName + "; }"); sb2.AppendLine(" protected set { _" + columnName + " = value; }"); sb2.AppendLine(" }"); sb2.AppendLine(""); SetExcludePropertys(tableName, sb3, columnName); } StringBuilder sb_instance = new StringBuilder(); StringBuilder sb_instanceMethod = new StringBuilder(); StringBuilder sb_SetLazyMember = new StringBuilder(); StringBuilder sb_attribute = new StringBuilder(); var listModel = CommonCode.GetTableModel(tableName); if (listModel != null) { foreach (var item in listModel) { SetSB(sb, item); SetInstance(tableName, sb_instance, sb_instanceMethod, sb_SetLazyMember, item); SetAttribute(sb_attribute, item); } } #endregion Model StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("using System;"); sb_body.AppendLine("using System.Collections.Generic;"); sb_body.AppendLine("using System.Linq;"); sb_body.AppendLine("using Lee.CQuery;"); sb_body.AppendLine("using Lee.Domain.Aggregation;"); sb_body.AppendLine("using Lee.Utility;"); sb_body.AppendLine("using Lee.Utility.Extension;"); sb_body.AppendLine("using Lee.Utility.ValueType;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain.Model;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain.Service;"); sb_body.AppendLine("using " + str_nameSpace + ".Query;"); sb_body.AppendLine("using " + str_nameSpace + ".Query." + tablePrefix + ";"); sb_body.AppendLine("using " + str_nameSpace + ".Domain." + tablePrefix + ".Model;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain." + tablePrefix + ".Repository;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain." + tablePrefix + ".Service;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain.Repository;"); if (tablePrefix != "Data") { sb_body.AppendLine("using " + str_nameSpace + ".Domain.Data.Model;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain.Data.Service;"); } sb_body.AppendLine(""); sb_body.AppendLine("namespace " + str_nameSpace + ".Domain." + tablePrefix + ".Model"); sb_body.AppendLine("{"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// DomainModel:" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public class " + tableName + " : AggregationRoot<" + tableName + ">"); sb_body.AppendLine(" {"); sb_body.AppendLine(" I" + tableName + "Repository " + tableName + "Repository = null;"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 字段"); sb_body.AppendLine(""); sb_body.AppendLine(sb.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 构造方法"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 实例化对象"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"SysNo\">编号</param>"); sb_body.AppendLine(" internal " + tableName + "(Guid? SysNo = null)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" _SysNo = SysNo ?? Guid.Empty;"); sb_body.AppendLine(" " + tableName + "Repository = this.Instance<I" + tableName + "Repository>();"); sb_body.AppendLine(""); sb_body.AppendLine(sb_instance.ToString()); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(sb_instanceMethod.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 设置LazyMember"); sb_body.AppendLine(""); sb_body.AppendLine(sb_SetLazyMember.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 属性"); sb_body.AppendLine(""); sb_body.AppendLine(sb2.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(sb_attribute.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 方法"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 功能方法"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 保存"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 保存"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public override void Save()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" " + tableName + "Repository.Save(this);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 移除"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 移除"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public override void Remove()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" " + tableName + "Repository.Remove(this);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 初始化标识信息"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 初始化标识信息"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public override void InitPrimaryValue()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" base.InitPrimaryValue();"); sb_body.AppendLine(" _SysNo = Generate" + tableName + "Id();"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 内部方法"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 判断标识对象值是否为空"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 判断标识对象值是否为空"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" protected override bool PrimaryValueIsNone()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return _SysNo == Guid.Empty;"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 静态方法"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 生成一个编号"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 生成一个编号"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public static Guid Generate" + tableName + "Id()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return Guid.NewGuid();"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 创建"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 创建一个对象"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"SysNo\">编号</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public static " + tableName + " Create" + tableName + "(Guid? SysNo = null)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" SysNo = SysNo == Guid.Empty ? Generate" + tableName + "Id() : SysNo;"); sb_body.AppendLine(" return new " + tableName + "(SysNo);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 根据给定的对象更新当前信息"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 根据给定的对象更新当前信息"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"" + tableName + "\">信息</param>"); sb_body.AppendLine(" /// <param name=\"excludePropertys\">排除更新的属性</param>"); sb_body.AppendLine(" public virtual void ModifyFromOther" + tableName + "(" + tableName + " " + tableName + ", IEnumerable<string> excludePropertys = null)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" if (" + tableName + " == null)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return;"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" CopyDataFromSimilarObject(" + tableName + ", excludePropertys);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 从指定对象复制值"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 从指定对象复制值"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <typeparam name=\"DT\">数据类型</typeparam>"); sb_body.AppendLine(" /// <param name=\"similarObject\">数据对象</param>"); sb_body.AppendLine(" /// <param name=\"excludePropertys\">排除不复制的属性</param>"); sb_body.AppendLine(" protected override void CopyDataFromSimilarObject<DT>(DT similarObject, IEnumerable<string> excludePropertys = null)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" base.CopyDataFromSimilarObject<DT>(similarObject, excludePropertys);"); sb_body.AppendLine(" if (similarObject == null)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return;"); sb_body.AppendLine(" }"); sb_body.AppendLine(" excludePropertys = excludePropertys ?? new List<string>(0);"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 复制值"); sb_body.AppendLine(""); sb_body.AppendLine(sb3.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(" }"); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 设置默认值"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public void SetDefaultValue()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" CreateDate = DateTime.Now;"); sb_body.AppendLine(" IsDelete = false;"); sb_body.AppendLine(" }"); sb_body.AppendLine(" }"); sb_body.AppendLine("}"); sb_body.AppendLine(""); string file_Model = "C:\\Code\\" + str_nameSpace + ".Domain\\" + tablePrefix + "\\Model"; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/" + tableName + "" + ".cs", sb_body.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); StringBuilder sb_body = new StringBuilder(); StringBuilder sb_List = new StringBuilder(); StringBuilder sb_AllowLoad = new StringBuilder(); StringBuilder sb_SetData = new StringBuilder(); var listModel = CommonCode.GetTableModel(tableName); if (listModel != null) { foreach (var item in listModel) { SetInstance(tableName, sb_List, sb_AllowLoad, sb_SetData, item); } } sb_body.AppendLine("using Lee.CQuery;"); sb_body.AppendLine("using Lee.CQuery.Paging;"); sb_body.AppendLine("using Lee.Utility;"); sb_body.AppendLine("using Lee.Utility.IoC;"); sb_body.AppendLine("using System;"); sb_body.AppendLine("using System.Collections.Generic;"); sb_body.AppendLine("using System.Linq;"); sb_body.AppendLine("using System.Text;"); sb_body.AppendLine("using System.Threading.Tasks;"); sb_body.AppendLine("using Lee.Utility.Extension;"); sb_body.AppendLine("using Lee.Utility.ExpressionUtil;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain.Model;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain.Service;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain." + tablePrefix + ".Model;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain." + tablePrefix + ".Repository;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain." + tablePrefix + ".Service;"); sb_body.AppendLine("using " + str_nameSpace + ".Query." + tablePrefix + ";"); if (tablePrefix != "Data") { sb_body.AppendLine("using " + str_nameSpace + ".Domain.Data.Model;"); sb_body.AppendLine("using " + str_nameSpace + ".Domain.Data.Service;"); } sb_body.AppendLine(""); sb_body.AppendLine("namespace " + str_nameSpace + ".Domain." + tablePrefix + ".Service"); sb_body.AppendLine("{"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 服务:" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public static class " + tableName + "Service"); sb_body.AppendLine(" {"); sb_body.AppendLine(" static I" + tableName + "Repository " + tableName + "Repository = ContainerManager.Container.Resolve<I" + tableName + "Repository>();"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 保存"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 保存" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"" + tableName + "\">信息</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public static Result<" + tableName + "> Save" + tableName + "(" + tableName + " " + tableName + ")"); sb_body.AppendLine(" {"); sb_body.AppendLine(" if (" + tableName + " == null)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return Result<" + tableName + ">.ErrorResult(\"信息为空\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(" Result<" + tableName + "> result = null;"); sb_body.AppendLine(" if (" + tableName + ".SysNo == Guid.Empty)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" result = Add" + tableName + "(" + tableName + ");"); sb_body.AppendLine(" }"); sb_body.AppendLine(" else"); sb_body.AppendLine(" {"); sb_body.AppendLine(" result = Update" + tableName + "(" + tableName + ");"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" return result;"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 批量保存" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"" + tableName + "\">信息</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public static Result SaveList" + tableName + "(IEnumerable<" + tableName + "> List" + tableName + ")"); sb_body.AppendLine(" {"); sb_body.AppendLine(" if (List" + tableName + ".IsNullOrEmpty())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return Result.ErrorResult(\"信息为空\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" foreach (var item in List" + tableName + ")"); sb_body.AppendLine(" {"); sb_body.AppendLine(" Save" + tableName + "(item);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" return Result.SuccessResult(\"修改成功\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 添加"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 添加" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"" + tableName + "\">信息</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" static Result<" + tableName + "> Add" + tableName + "(" + tableName + " " + tableName + ")"); sb_body.AppendLine(" {"); sb_body.AppendLine(" " + tableName + ".SetDefaultValue();"); sb_body.AppendLine(" " + tableName + ".Save();"); sb_body.AppendLine(" var result = Result<" + tableName + ">.SuccessResult(\"保存成功\");"); sb_body.AppendLine(" result.Data = " + tableName + ";"); sb_body.AppendLine(" return result;"); sb_body.AppendLine(" }"); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 修改"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 修改" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"" + tableName + "\">信息</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" static Result<" + tableName + "> Update" + tableName + "(" + tableName + " " + tableName + ")"); sb_body.AppendLine(" {"); sb_body.AppendLine(" var this" + tableName + " = Get" + tableName + "(" + tableName + ".SysNo);"); sb_body.AppendLine(" if (this" + tableName + " == null)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return Result<" + tableName + ">.ErrorResult(\"请指定要编辑的数据\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(" var excludeModifyPropertys = ExpressionHelper.GetExpressionPropertyNames<" + tableName + ">(u => u.CreateDate);"); sb_body.AppendLine(""); sb_body.AppendLine(" this" + tableName + ".ModifyFromOther" + tableName + "(" + tableName + ", excludeModifyPropertys);//更新"); sb_body.AppendLine(" this" + tableName + ".Save();"); sb_body.AppendLine(" var result = Result<" + tableName + ">.SuccessResult(\"更新成功\");"); sb_body.AppendLine(" result.Data = this" + tableName + ";"); sb_body.AppendLine(" return result;"); sb_body.AppendLine(" }"); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 获取"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"query\">查询条件</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public static " + tableName + " Get" + tableName + "(IQuery query)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" var " + tableName + " = " + tableName + "Repository.Get(query);"); sb_body.AppendLine(" return " + tableName + ";"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"SysNo\">编号</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public static " + tableName + " Get" + tableName + "(Guid? SysNo)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return Get" + tableName + "(SysNo ?? Guid.Empty);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"SysNo\">编号</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public static " + tableName + " Get" + tableName + "(Guid SysNo)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" if (SysNo == Guid.Empty)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return null;"); sb_body.AppendLine(" }"); sb_body.AppendLine(" IQuery query = QueryFactory.Create<" + tableName + "Query>(c => c.SysNo == SysNo);"); sb_body.AppendLine(" return Get" + tableName + "(query);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 获取列表"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取" + tableDesc + "列表"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"query\">查询条件</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public static List<" + tableName + "> Get" + tableName + "List(IQuery query)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" var " + tableName + "List = " + tableName + "Repository.GetList(query);"); sb_body.AppendLine(" " + tableName + "List = LoadOtherObjectData(" + tableName + "List, query);"); sb_body.AppendLine(" return " + tableName + "List;"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取" + tableDesc + "列表"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"listID\"></param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public static List<" + tableName + "> Get" + tableName + "List(IEnumerable<Guid> listID)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" if (listID.IsNullOrEmpty())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return new List<" + tableName + ">(0);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" IQuery query = QueryFactory.Create<" + tableName + "Query>(c => listID.Contains(c.SysNo));"); sb_body.AppendLine(" return Get" + tableName + "List(query);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 获取分页"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取" + tableDesc + "分页"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"query\">查询条件</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public static IPaging<" + tableName + "> Get" + tableName + "Paging(IQuery query)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" var " + tableName + "Paging = " + tableName + "Repository.GetPaging(query);"); sb_body.AppendLine(" var list = LoadOtherObjectData(" + tableName + "Paging, query);"); sb_body.AppendLine(" return new Paging<" + tableName + ">(" + tableName + "Paging.Page, " + tableName + "Paging.PageSize, " + tableName + "Paging.TotalCount, list);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 删除"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 删除" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"" + tableName + "s\">要删除的信息</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public static Result Delete" + tableName + "(IEnumerable<" + tableName + "> " + tableName + "s)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" if (" + tableName + "s.IsNullOrEmpty())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return Result.ErrorResult(\"没有指定任何要删除的数据\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(" " + tableName + "Repository.Remove(" + tableName + "s.ToArray());"); sb_body.AppendLine(" return Result.SuccessResult(\"删除成功\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 删除" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"" + tableName + "Ids\">编号</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" public static Result Delete" + tableName + "(IEnumerable<Guid> " + tableName + "Ids)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" if (" + tableName + "Ids.IsNullOrEmpty())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return Result.ErrorResult(\"没有指定要删除的数据\");"); sb_body.AppendLine(" }"); sb_body.AppendLine(" IEnumerable<" + tableName + "> " + tableName + "s = " + tableName + "Ids.Select(c => " + tableName + ".Create" + tableName + "(c)).ToList();"); sb_body.AppendLine(" return Delete" + tableName + "(" + tableName + "s);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" "); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(""); sb_body.AppendLine(" #region 加载其它数据"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 加载其它数据"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"" + tableName + "s\">数据</param>"); sb_body.AppendLine(" /// <param name=\"query\">筛选条件</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" private static List<" + tableName + "> LoadOtherObjectData(IEnumerable<" + tableName + "> " + tableName + "s, IQuery query)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" if (" + tableName + "s.IsNullOrEmpty())"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return new List<" + tableName + ">(0);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" if (query == null)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return " + tableName + "s.ToList();"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 获取数据"); sb_body.AppendLine(""); sb_body.AppendLine(sb_List.ToString()); sb_body.AppendLine(sb_AllowLoad.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" foreach (var item in " + tableName + "s)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" if (item == null)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" continue;"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(sb_SetData.ToString()); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" return " + tableName + "s.ToList();"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" }"); sb_body.AppendLine("}"); sb_body.AppendLine(""); string file_Model = "C:\\Code\\" + str_nameSpace + ".Domain\\" + tablePrefix + "\\Service"; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/" + tableName + "Service.cs", sb_body.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); bool isPrimeKey = false; string primaryKey = ""; StringBuilder sb = new StringBuilder(); #region Model sb.AppendLine(" #region Model"); //遍历每个字段 foreach (DataRow dr in dt_tables.Rows) { string columnName = dr["columnName"].ToString().Trim(); //字段名 string columnType = dr["columnType"].ToString().Trim(); //字段类型 string columnComment = dr["columnComment"].ToString().Trim(); //字段注释 string nullable = dr["nullable"].ToString().Trim(); //是否可空(Y是不为空,N是为空) string data_default = dr["data_default"].ToString().Trim(); //默認值 string data_maxLength = dr["char_col_decl_length"].ToString().Trim(); //最大長度 string bool_primaryKey = dr["primaryKey"].ToString().Trim(); //主键 值为Y或N if (bool_primaryKey.ToUpper() == "Y") //存在主键 { isPrimeKey = true; primaryKey = columnName.ToUpper(); } if (string.IsNullOrEmpty(columnComment)) { columnComment = columnName; } CommonCode.GetColumnType(ref columnType, ref data_default); nullable = CommonCode.GetNullable(columnType, nullable); sb.AppendLine(""); sb.AppendLine(@" /// <summary>"); sb.AppendLine(@" /// " + columnComment); sb.AppendLine(@" /// </summary>"); sb.AppendLine(" public " + columnType + nullable + " " + columnName + " { get; set; }"); } sb.AppendLine(""); sb.AppendLine(" #endregion Model"); SetData(tableName, sb); #endregion Model StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("using System;"); sb_body.AppendLine("using System.Collections.Generic;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO.Data.Query;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO.Query;"); sb_body.AppendLine(""); sb_body.AppendLine("namespace " + str_nameSpace + ".DTO." + tablePrefix + ".Query"); sb_body.AppendLine("{"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// Dto:"+ tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public class " + tableName + "Dto"); sb_body.AppendLine(" {"); sb_body.AppendLine(""); sb_body.Append(sb.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" }"); sb_body.AppendLine("}"); string file_Model = "C:\\Code\\" + str_nameSpace + ".DTO\\" + tablePrefix + "\\Query"; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/" + tableName + "Dto" + ".cs", sb_body.ToString()); }
public void Create(string file_DAL, string str_table, string str_DALName, string str_IDALName, string str_ModelName, StringBuilder sb_column1, StringBuilder sb_column2, StringBuilder sb_column3, StringBuilder sb_column4, StringBuilder sb_column5, ConfigModel configModel) { StringBuilder sb = new StringBuilder(); sb.AppendLine("using System;"); sb.AppendLine("using System.Data;"); sb.AppendLine("using System.Text;"); sb.AppendLine("using System.Data.SqlClient;"); sb.AppendLine("using " + configModel.str_nameSpace + ".IDAL;"); sb.AppendLine("using " + configModel.str_nameSpace + ".DBUtility;"); sb.AppendLine("using " + configModel.str_nameSpace + ".Common;"); sb.AppendLine("using System.Collections.Generic;"); sb.AppendLine("using " + configModel.str_nameSpace + ".Model;"); sb.AppendLine(""); sb.AppendLine("namespace " + configModel.str_nameSpace + ".SqlDAL"); sb.AppendLine("{"); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 数据访问类:" + str_DALName); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public partial class " + str_DALName + " : " + str_IDALName); sb.AppendLine(" {"); sb.AppendLine(" public " + str_DALName + "() { }"); sb.AppendLine(""); #region BasicMethod sb.AppendLine(" #region BasicMethod"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 是否存在该记录"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public bool Exists(string ST_CODE)"); sb.AppendLine(" {"); sb.AppendLine(" StringBuilder sb = new StringBuilder();"); sb.AppendLine(" sb.Append(\"select count(1) from " + str_table.ToUpper() + "\");"); sb.AppendLine(" sb.Append(\" where ST_CODE=" + configModel.MARK + "ST_CODE \");"); sb.AppendLine(" SqlParameter[] parameters ={"); sb.AppendLine(" new SqlParameter(\"" + configModel.MARK + "ST_CODE\",ST_CODE)"); sb.AppendLine(" };"); sb.AppendLine(" return " + configModel.str_SqlHelper + "." + configModel.str_ExecuteScalar + "(sb.ToString(), parameters);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 增加一条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public bool Add(" + str_ModelName + " model)"); sb.AppendLine(" {"); sb.AppendLine(" StringBuilder strSql;"); sb.AppendLine(" SqlParameter[] parameters;"); sb.AppendLine(" AddModel(model, out strSql, out parameters);"); sb.AppendLine(""); sb.AppendLine(" return new SqlCode().ReturnBool(strSql.ToString(), parameters);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 增加多条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public int AddList(List<" + str_ModelName + "> list_model)"); sb.AppendLine(" {"); sb.AppendLine(" StringBuilder strSql;"); sb.AppendLine(" SqlParameter[] parameters;"); sb.AppendLine(" List<" + configModel.str_nameSpace + ".DBUtility.CommandInfo> ci = new List<CommandInfo>();"); sb.AppendLine(""); sb.AppendLine(" foreach (" + str_ModelName + " item in list_model)"); sb.AppendLine(" {"); sb.AppendLine(" strSql = new StringBuilder();"); sb.AppendLine(" parameters = null;"); sb.AppendLine(" AddModel(item, out strSql, out parameters);"); sb.AppendLine(""); sb.AppendLine(" " + configModel.str_nameSpace + ".DBUtility.CommandInfo subci = new CommandInfo();"); sb.AppendLine(" subci.CommandText = strSql.ToString();"); sb.AppendLine(" subci.Parameters = parameters;"); sb.AppendLine(" subci.Type = CommandType.Text;"); sb.AppendLine(" ci.Add(subci);"); sb.AppendLine(" }"); sb.AppendLine(" return " + configModel.str_SqlHelper + "." + configModel.str_UpdateDatabase + "(ci);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 更新一条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public bool Update(" + str_ModelName + " model)"); sb.AppendLine(" {"); sb.AppendLine(" StringBuilder strSql;"); sb.AppendLine(" SqlParameter[] parameters;"); sb.AppendLine(" UpdateModel(model, out strSql, out parameters);"); sb.AppendLine(""); sb.AppendLine(" return new SqlCode().ReturnBool(strSql.ToString(), parameters);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 更新多条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public int UpdateList(List<" + str_ModelName + "> list_model)"); sb.AppendLine(" {"); sb.AppendLine(" StringBuilder strSql;"); sb.AppendLine(" SqlParameter[] parameters;"); sb.AppendLine(" List<" + configModel.str_nameSpace + ".DBUtility.CommandInfo> ci = new List<CommandInfo>();"); sb.AppendLine(""); sb.AppendLine(" foreach (" + str_ModelName + " item in list_model)"); sb.AppendLine(" {"); sb.AppendLine(" strSql = new StringBuilder();"); sb.AppendLine(" parameters = null;"); sb.AppendLine(" UpdateModel(item, out strSql, out parameters);"); sb.AppendLine(""); sb.AppendLine(" " + configModel.str_nameSpace + ".DBUtility.CommandInfo subci = new CommandInfo();"); sb.AppendLine(" subci.CommandText = strSql.ToString();"); sb.AppendLine(" subci.Parameters = parameters;"); sb.AppendLine(" subci.Type = CommandType.Text;"); sb.AppendLine(" ci.Add(subci);"); sb.AppendLine(""); sb.AppendLine(" }"); sb.AppendLine(" return " + configModel.str_SqlHelper + "." + configModel.str_UpdateDatabase + "(ci);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 删除一条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public bool Delete(string ST_CODE)"); sb.AppendLine(" {"); sb.AppendLine(" //该表无主键信息,请自定义主键/条件字段"); sb.AppendLine(" StringBuilder strSql = new StringBuilder();"); sb.AppendLine(" strSql.Append(\"delete from " + str_table.ToUpper() + " \");"); sb.AppendLine(" strSql.Append(\" where \");"); sb.AppendLine(" SqlParameter[] parameters = {"); sb.AppendLine(" };"); sb.AppendLine(""); sb.AppendLine(" return new SqlCode().ReturnBool(strSql.ToString(), parameters);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 删除多条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" /// <param name=\"ST_CODElist\"></param>"); sb.AppendLine(" /// <returns></returns>"); sb.AppendLine(" public bool DeleteList(List<string> ST_CODElist)"); sb.AppendLine(" {"); sb.AppendLine(" List<string> list_sql = new List<string>();"); sb.AppendLine(" foreach (string item in ST_CODElist)"); sb.AppendLine(" {"); sb.AppendLine(" list_sql.Add(\"delete from " + str_table.ToUpper() + " where ST_CODE ='\" + item + \"'\");"); sb.AppendLine(" }"); sb.AppendLine(" int rows = " + configModel.str_SqlHelper + "." + configModel.str_UpdateDatabase + "(list_sql);"); sb.AppendLine(" if (rows > 0)"); sb.AppendLine(" {"); sb.AppendLine(" return true;"); sb.AppendLine(" }"); sb.AppendLine(" else"); sb.AppendLine(" {"); sb.AppendLine(" return false;"); sb.AppendLine(" }"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 获得实体对象"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public " + str_ModelName + " GetModel(string ST_CODE)"); sb.AppendLine(" {"); sb.AppendLine(" //该表无主键信息,请自定义主键/条件字段"); sb.AppendLine(" StringBuilder strSql = new StringBuilder();"); sb.AppendLine(" strSql.Append(\"select " + sb_column1 + " from " + str_table.ToUpper() + " \");"); sb.AppendLine(" strSql.Append(\" where \");"); sb.AppendLine(" SqlParameter[] parameters = {"); sb.AppendLine(" };"); sb.AppendLine(" return " + configModel.str_SqlHelper + "." + configModel.str_GetModel + "<" + str_ModelName + ">(strSql.ToString(), parameters);"); sb.AppendLine(""); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 获得实体列表"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public List<" + str_ModelName + "> GetModelList(string strWhere)"); sb.AppendLine(" {"); sb.AppendLine(" StringBuilder strSql = new StringBuilder();"); sb.AppendLine(" strSql.Append(\"select " + sb_column1 + " \");"); sb.AppendLine(" strSql.Append(\" FROM " + str_table.ToUpper() + " \");"); sb.AppendLine(" if (!string.IsNullOrEmpty(strWhere.Trim()))"); sb.AppendLine(" {"); sb.AppendLine(" strSql.Append(\" where \" + strWhere);"); sb.AppendLine(" }"); sb.AppendLine(" return " + configModel.str_SqlHelper + "." + configModel.str_GetModelList + "<" + str_ModelName + ">(strSql.ToString());"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 获得数据列表"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public DataTable GetList(string strWhere)"); sb.AppendLine(" {"); sb.AppendLine(" StringBuilder strSql = new StringBuilder();"); sb.AppendLine(" strSql.Append(\"select " + sb_column1 + " \");"); sb.AppendLine(" strSql.Append(\" FROM " + str_table.ToUpper() + " \");"); sb.AppendLine(" if (!string.IsNullOrEmpty(strWhere.Trim()))"); sb.AppendLine(" {"); sb.AppendLine(" strSql.Append(\" where \" + strWhere);"); sb.AppendLine(" }"); sb.AppendLine(" return " + configModel.str_SqlHelper + "." + configModel.str_ExecuteNonQuery + "(strSql.ToString());"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 获取记录总数"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public int GetRecordCount(string strWhere)"); sb.AppendLine(" {"); sb.AppendLine(" StringBuilder strSql = new StringBuilder();"); sb.AppendLine(" strSql.Append(\"select count(1) FROM " + str_table.ToUpper() + " \");"); sb.AppendLine(" if (!string.IsNullOrEmpty(strWhere.Trim()))"); sb.AppendLine(" {"); sb.AppendLine(" strSql.Append(\" where \" + strWhere);"); sb.AppendLine(" }"); sb.AppendLine(" object obj = " + configModel.str_SqlHelper + "." + configModel.str_ExecuteScalar + "(strSql.ToString());"); sb.AppendLine(" if (obj == null)"); sb.AppendLine(" {"); sb.AppendLine(" return 0;"); sb.AppendLine(" }"); sb.AppendLine(" else"); sb.AppendLine(" {"); sb.AppendLine(" return Convert.ToInt32(obj);"); sb.AppendLine(" }"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 分页获取数据列表"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public DataTable GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)"); sb.AppendLine(" {"); sb.AppendLine(" StringBuilder strSql = new StringBuilder();"); sb.AppendLine(" strSql.Append(\"SELECT * FROM ( \");"); sb.AppendLine(" strSql.Append(\" SELECT ROW_NUMBER() OVER (\");"); sb.AppendLine(" if (!string.IsNullOrEmpty(orderby.Trim()))"); sb.AppendLine(" {"); sb.AppendLine(" strSql.Append(\"order by T.\" + orderby);"); sb.AppendLine(" }"); sb.AppendLine(" else"); sb.AppendLine(" {"); sb.AppendLine(" strSql.Append(\"order by T.ST_CODE desc\");"); sb.AppendLine(" }"); sb.AppendLine(" strSql.Append(\")AS Row, T.* from " + str_table.ToUpper() + " T \");"); sb.AppendLine(" if (!string.IsNullOrEmpty(strWhere.Trim()))"); sb.AppendLine(" {"); sb.AppendLine(" strSql.Append(\" WHERE \" + strWhere);"); sb.AppendLine(" }"); sb.AppendLine(" strSql.Append(\" ) TT\");"); sb.AppendLine(" strSql.AppendFormat(\" WHERE TT.Row between {0} and {1}\", startIndex, endIndex);"); sb.AppendLine(" return " + configModel.str_SqlHelper + "." + configModel.str_ExecuteNonQuery + "(strSql.ToString());"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /*"); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 分页获取数据列表"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public DataTable GetList(int PageSize,int PageIndex,string strWhere)"); sb.AppendLine(" {"); sb.AppendLine(" SqlParameter[] parameters = {"); sb.AppendLine(" new SqlParameter(\"" + configModel.MARK + "tblName\", SqlType.VarChar, 255),"); sb.AppendLine(" new SqlParameter(\"" + configModel.MARK + "fldName\", SqlType.VarChar, 255),"); sb.AppendLine(" new SqlParameter(\"" + configModel.MARK + "PageSize\", SqlType.Number),"); sb.AppendLine(" new SqlParameter(\"" + configModel.MARK + "PageIndex\", SqlType.Number),"); sb.AppendLine(" new SqlParameter(\"" + configModel.MARK + "IsReCount\", SqlType.Clob),"); sb.AppendLine(" new SqlParameter(\"" + configModel.MARK + "OrderType\", SqlType.Clob),"); sb.AppendLine(" new SqlParameter(\"" + configModel.MARK + "strWhere\", SqlType.VarChar,1000),"); sb.AppendLine(" };"); sb.AppendLine(" parameters[0].Value = \"" + str_table.ToUpper() + "\";"); sb.AppendLine(" parameters[1].Value = \"ST_CODE\";"); sb.AppendLine(" parameters[2].Value = PageSize;"); sb.AppendLine(" parameters[3].Value = PageIndex;"); sb.AppendLine(" parameters[4].Value = 0;"); sb.AppendLine(" parameters[5].Value = 0;"); sb.AppendLine(" parameters[6].Value = strWhere; "); sb.AppendLine(" return " + configModel.str_SqlHelper + ".RunProcedure(\"UP_GetRecordByPage\",parameters,\"ds\");"); sb.AppendLine(" }*/"); sb.AppendLine(""); sb.AppendLine(" #endregion BasicMethod"); sb.AppendLine(""); #endregion BasicMethod #region HelperMethod sb.AppendLine(" #region HelperMethod"); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 添加一个Model"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" /// <param name=\"model\">Model类型</param>"); sb.AppendLine(" /// <param name=\"strSql\">给sql语句赋值</param>"); sb.AppendLine(" /// <param name=\"parameters\">给参数赋值</param>"); sb.AppendLine(" private static void AddModel(" + str_ModelName + " model, out StringBuilder strSql, out SqlParameter[] parameters)"); sb.AppendLine(" {"); sb.AppendLine(" strSql = new StringBuilder();"); sb.AppendLine(" strSql.Append(\"insert into " + str_table.ToUpper() + "(\");"); sb.AppendLine(" strSql.Append(\"" + sb_column1 + ")\");"); sb.AppendLine(" strSql.Append(\" values (\");"); sb.AppendLine(" strSql.Append(\"" + sb_column2 + "\");"); sb.AppendLine(" strSql.Append(\")\");"); sb.AppendLine(" parameters = SetParameters(model);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 修改一个Model"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" /// <param name=\"model\">Model类型</param>"); sb.AppendLine(" /// <param name=\"strSql\">给sql语句赋值</param>"); sb.AppendLine(" /// <param name=\"parameters\">给参数赋值</param>"); sb.AppendLine(" private static void UpdateModel(" + str_ModelName + " model, out StringBuilder strSql, out SqlParameter[] parameters)"); sb.AppendLine(" {"); sb.AppendLine(" strSql = new StringBuilder();"); sb.AppendLine(" strSql.Append(\"update " + str_table.ToUpper() + " set \");"); sb.AppendLine(sb_column5.ToString()); sb.AppendLine(" strSql.Append(\" where \");"); sb.AppendLine(" strSql.Append(\"NO_ID=" + configModel.MARK + "NO_ID\");"); sb.AppendLine(" parameters = SetParameters(model);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 给参数列表赋值"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" /// <param name=\"model\">Model类型</param>"); sb.AppendLine(" /// <returns>SqlParameter[]</returns>"); sb.AppendLine(" private static SqlParameter[] SetParameters(" + str_ModelName + " model)"); sb.AppendLine(" {"); sb.AppendLine(" SqlParameter[] parameters;"); sb.AppendLine(" parameters = new SqlParameter[]{"); sb.AppendLine(sb_column3.ToString()); sb.AppendLine(""); sb.AppendLine(sb_column4.ToString()); sb.AppendLine(" return parameters;"); sb.AppendLine(" }"); sb.AppendLine(" #endregion HelperMethod"); #endregion HelperMethod sb.AppendLine(""); sb.AppendLine(" }"); sb.AppendLine("}"); CommonCode.Save(file_DAL + "/" + str_DALName + ".cs", sb.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); bool isPrimeKey = false; string primaryKey = ""; int index = 0; StringBuilder sb = new StringBuilder(); StringBuilder sb2 = new StringBuilder(); StringBuilder sb3 = new StringBuilder(); StringBuilder sb4 = new StringBuilder(); StringBuilder sb5 = new StringBuilder(); #region Model //遍历每个字段 foreach (DataRow dr in dt_tables.Rows) { string columnName = dr["columnName"].ToString().Trim(); //字段名 string columnType = dr["columnType"].ToString().Trim(); //字段类型 string columnComment = dr["columnComment"].ToString().Trim(); //字段注释 string nullable = dr["nullable"].ToString().Trim(); //是否可空(Y是不为空,N是为空) string data_default = dr["data_default"].ToString().Trim(); //默認值 string data_maxLength = dr["char_col_decl_length"].ToString().Trim(); //最大長度 string bool_primaryKey = dr["primaryKey"].ToString().Trim(); //主键 值为Y或N if (bool_primaryKey.ToUpper() == "Y") //存在主键 { isPrimeKey = true; primaryKey = columnName.ToUpper(); } if (string.IsNullOrEmpty(columnComment)) { columnComment = columnName; } CommonCode.GetColumnType(ref columnType, ref data_default); nullable = CommonCode.GetNullable(columnType, nullable); var arr = new List <string> { "SysNo", "OutsideCode", "ShopID", "StatisticalDate", "Remark", "CreateDate", "UpdateDate", "CreateUserID", "UpdateUserID", }; if (!arr.Contains(columnName)) { if (columnType == "string") { sb2.AppendLine("model." + columnName + " = GetColumnValue(listColumn, listDesc, row, \"" + columnName + "\");"); sb4.AppendLine(" model." + columnName + " = GetColumnValue(listColumn, dr, \"" + columnName + "\");"); } else if (columnType == "DateTime") { string col = columnType[0].ToString().ToUpper(); col += columnType.Substring(1, columnType.Length - 1); sb2.AppendLine("model." + columnName + " = GetColumnValue(listColumn, listDesc, row, \"" + columnName + "\").StrTo" + col + "();"); sb4.AppendLine(" model." + columnName + " = GetColumnValue(listColumn, dr, \"" + columnName + "\").StrTo" + col + "();"); } else { string col = columnType[0].ToString().ToUpper(); col += columnType.Substring(1, columnType.Length - 1); sb2.AppendLine("model." + columnName + " = GetColumnValue(listColumn, listDesc, row, \"" + columnName + "\").StrTo" + col + "(-1);"); sb4.AppendLine(" model." + columnName + " = GetColumnValue(listColumn, dr, \"" + columnName + "\").StrTo" + col + "(-1);"); } sb3.AppendLine(" Map(m => m." + columnName + ").Name(\"" + columnComment + "\");"); sb5.AppendLine(" ExcelHelper.SetCellValue(sheet, thisRow, " + index + ", item." + columnName + ", cellStyle);"); ++index; } sb.AppendLine(" {"); sb.AppendLine(" \"ColumnName\": \""+ columnName + "\","); sb.AppendLine(" \"ColumnDesc\": \""+ columnComment + "\""); sb.AppendLine(" },"); } #endregion Model StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("["); sb_body.AppendLine(" {"); sb_body.AppendLine(" \"TableName\": \""+ tableName + "\","); sb_body.AppendLine(" \"List\": ["); sb_body.Append(sb.ToString()); sb_body.AppendLine(" ]"); sb_body.AppendLine(" }"); sb_body.AppendLine("]"); StringBuilder sb_body3 = new StringBuilder(); sb_body3.AppendLine("using BigDataAnalysis.DTO.Original.Cmd;"); sb_body3.AppendLine("using System;"); sb_body3.AppendLine("using System.Collections.Generic;"); sb_body3.AppendLine("using System.Linq;"); sb_body3.AppendLine("using System.Text;"); sb_body3.AppendLine("using System.Threading.Tasks;"); sb_body3.AppendLine(""); sb_body3.AppendLine("namespace BigDataAnalysis.DTO.CSVMap"); sb_body3.AppendLine("{"); sb_body3.AppendLine(" /// <summary>"); sb_body3.AppendLine(" /// CSVHeaderMap:" + tableDesc + ""); sb_body3.AppendLine(" /// </summary>"); sb_body3.AppendLine(" public class CSVHeaderMap_" + tableName + " : CsvHelper.Configuration.ClassMap<" + tableName + "CmdDto>"); sb_body3.AppendLine(" {"); sb_body3.AppendLine(" public CSVHeaderMap_" + tableName + "()"); sb_body3.AppendLine(" {"); sb_body3.AppendLine(sb3.ToString()); sb_body3.AppendLine(" }"); sb_body3.AppendLine(" }"); sb_body3.AppendLine("}"); sb_body3.AppendLine(""); string file_Model = "C:\\Code\\Json"; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/" + tableName + ".json", sb_body.ToString()); CommonCode.Save(file_Model + "/" + tableName + "_GetColumnValue.txt", sb2.ToString()); CommonCode.Save(file_Model + "/CSVHeaderMap_" + tableName + ".cs", sb_body3.ToString()); CommonCode.Save(file_Model + "/DT_" + tableName + ".txt", sb4.ToString()); CommonCode.Save(file_Model + "/Export_" + tableName + ".txt", sb5.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); bool isPrimeKey = false; string primaryKey = ""; StringBuilder sb = new StringBuilder(); #region Model sb.AppendLine(" #region Model"); //遍历每个字段 foreach (DataRow dr in dt_tables.Rows) { string columnName = dr["columnName"].ToString().Trim(); //字段名 string columnType = dr["columnType"].ToString().Trim(); //字段类型 string columnComment = dr["columnComment"].ToString().Trim(); //字段注释 string nullable = dr["nullable"].ToString().Trim(); //是否可空(Y是不为空,N是为空) string data_default = dr["data_default"].ToString().Trim(); //默認值 string data_maxLength = dr["char_col_decl_length"].ToString().Trim(); //最大長度 string bool_primaryKey = dr["primaryKey"].ToString().Trim(); //主键 值为Y或N if (bool_primaryKey.ToUpper() == "Y") //存在主键 { isPrimeKey = true; primaryKey = columnName.ToUpper(); } if (string.IsNullOrEmpty(columnComment)) { columnComment = columnName; } CommonCode.GetColumnType(ref columnType, ref data_default); nullable = CommonCode.GetNullable(columnType, nullable); sb.AppendLine(""); sb.AppendLine(@" /// <summary>"); sb.AppendLine(@" /// " + columnComment); sb.AppendLine(@" /// </summary>"); //if (dr["nullable"].ToString().ToUpper().Trim() == "Y")//不為空 //{ // sb.AppendLine(@" [Required]"); //} //if (!string.IsNullOrEmpty(data_maxLength))//最大長度 //{ // sb.AppendLine(@" [StringLength(" + data_maxLength + ")]"); //} sb.AppendLine(" public " + columnType + nullable + " " + columnName); sb.AppendLine(" {"); sb.AppendLine(" get { return valueDic.GetValue<" + columnType + nullable + ">(\"" + columnName + "\"); }"); sb.AppendLine(" set { valueDic.SetValue(\"" + columnName + "\", value); }"); sb.AppendLine(" }"); } sb.AppendLine(""); sb.AppendLine(" #endregion Model"); #endregion Model StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("using System;"); sb_body.AppendLine("using System.Collections.Generic;"); sb_body.AppendLine("using Lee.Command;"); sb_body.AppendLine("using Lee.Utility.Extension;"); sb_body.AppendLine(""); sb_body.AppendLine("namespace " + str_nameSpace + ".Entity." + tablePrefix + ""); sb_body.AppendLine("{"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// Entity:"+ tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" [Serializable]"); sb_body.AppendLine(" public class "+ tableName + "Entity:CommandEntity<" + tableName + "Entity>"); sb_body.AppendLine(" {"); sb_body.AppendLine(""); sb_body.Append(sb.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" }"); sb_body.AppendLine("}"); string file_Model = "C:\\Code\\" + str_nameSpace + ".Entity\\" + tablePrefix + ""; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/" + tableName + "Entity.cs", sb_body.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); bool isPrimeKey = false; string primaryKey = ""; StringBuilder sb_GetEditData = new StringBuilder(); StringBuilder sb_SetEditData = new StringBuilder(); StringBuilder sb_Table_Th = new StringBuilder(); StringBuilder sb_EditDiv = new StringBuilder(); StringBuilder sb_Formatter = new StringBuilder(); var listModel = CommonCode.GetTableModel(tableName); #region Model //遍历每个字段 foreach (DataRow dr in dt_tables.Rows) { string columnName = dr["columnName"].ToString().Trim(); //字段名 string columnType = dr["columnType"].ToString().Trim(); //字段类型 string columnComment = dr["columnComment"].ToString().Trim(); //字段注释 string nullable = dr["nullable"].ToString().Trim(); //是否可空(Y是不为空,N是为空) string data_default = dr["data_default"].ToString().Trim(); //默認值 string data_maxLength = dr["char_col_decl_length"].ToString().Trim(); //最大長度 string bool_primaryKey = dr["primaryKey"].ToString().Trim(); //主键 值为Y或N if (bool_primaryKey.ToUpper() == "Y") //存在主键 { isPrimeKey = true; primaryKey = columnName.ToUpper(); } if (string.IsNullOrEmpty(columnComment)) { columnComment = columnName; } CommonCode.GetColumnType(ref columnType, ref data_default); nullable = CommonCode.GetNullable(columnType, nullable); string required = "true"; if (columnName == "Remark" || columnName == "SortIndex") { required = "false"; } var arr = new List <string> { "SysNo", "CreateDate", "UpdateDate", "Status", "Enable", "IsDeleted", "CreateUserID", "UpdateUserID", "IsDelete", }; if (!arr.Contains(columnName)) { if (columnType == "bool") { sb_GetEditData.AppendLine(" " + columnName + ": $(\"." + columnName + "\").combobox(\"getValue\"),"); sb_SetEditData.AppendLine(" $(\"." + columnName + "\").combobox(\"select\", row." + columnName + ");"); sb_Formatter.AppendLine(" function formatter" + columnName + "(value, row, index) {"); sb_Formatter.AppendLine(" if (value == true) {"); sb_Formatter.AppendLine(" return \"是\";"); sb_Formatter.AppendLine(" } else {"); sb_Formatter.AppendLine(" return \"否\";"); sb_Formatter.AppendLine(" }"); sb_Formatter.AppendLine(" return value;"); sb_Formatter.AppendLine(" }"); sb_Table_Th.AppendLine(" <th data-options=\"field:'" + columnName + "',width:100,align:'center',formatter:formatter" + columnName + "\">" + columnComment + "</th>"); sb_EditDiv.AppendLine(" <div class=\"layer_form_div\">"); sb_EditDiv.AppendLine(" <input class=\"easyui-combobox " + columnName + "\" name=\"" + columnName + "\" style=\"width: 300px;\" data-options=\"label:'" + columnComment + "',required:" + required + ",editable:false,valueField:'value',textField:'label',data:[{'value':true,label:'是',selected:true},{'value':false,label:'否'}],panelHeight:true\" />"); sb_EditDiv.AppendLine(" </div>"); sb_EditDiv.AppendLine(""); } else if (columnType == "DateTime") { sb_Table_Th.AppendLine(" <th data-options=\"field:'" + columnName + "',width:120,align:'center',formatter:fmDate\">" + columnComment + "</th>"); sb_GetEditData.AppendLine(" " + columnName + ": $(\"." + columnName + "\").textbox(\"getText\"),"); sb_SetEditData.AppendLine(" $(\"." + columnName + "\").textbox(\"setText\", fmDate(row." + columnName + "));"); sb_EditDiv.AppendLine(" <div class=\"layer_form_div\">"); sb_EditDiv.AppendLine(" <input class=\"easyui-datebox " + columnName + "\" name=\"" + columnName + "\" data-options=\"label:'" + columnComment + "',prompt:'请输入" + columnComment + "',required:" + required + ",validType:['length[1," + data_maxLength + "]'],missingMessage:'请输入" + columnComment + "'\" style=\"width: 300px;\" />"); sb_EditDiv.AppendLine(" </div>"); sb_EditDiv.AppendLine(""); } else { if (columnName.Length > 3 && columnName.Substring(columnName.Length - 2, 2) == "ID") { sb_Table_Th.AppendLine(" <th data-options=\"field:'" + columnName.Replace("ID", "Name") + "',width:100,align:'center'\">" + columnComment.Replace("ID", "") + "</th>"); string textField = GetTextField(listModel, columnName); sb_GetEditData.AppendLine(" " + columnName + ": $(\"." + columnName + "\").combobox(\"getValue\"),"); sb_SetEditData.AppendLine(" $(\"." + columnName + "\").combobox(\"select\", row." + columnName + ");"); sb_EditDiv.AppendLine(" <div class=\"layer_form_div\">"); sb_EditDiv.AppendLine(" <input class=\"easyui-combobox " + columnName + "\" name=\"" + columnName + "\" data-options=\"label:'" + columnComment.Replace("ID", "") + "',editable:false,valueField:'SysNo',textField:'" + textField + "',method:'get',url:'/Data/Get" + columnName.Replace("ID", "") + "List',panelHeight:200\" style=\"width: 300px;\" />"); sb_EditDiv.AppendLine(" </div>"); sb_EditDiv.AppendLine(""); } else { sb_Table_Th.AppendLine(" <th data-options=\"field:'" + columnName + "',width:100,align:'center'\">" + columnComment + "</th>"); sb_GetEditData.AppendLine(" " + columnName + ": $(\"." + columnName + "\").textbox(\"getText\"),"); sb_SetEditData.AppendLine(" $(\"." + columnName + "\").textbox(\"setText\", row." + columnName + ");"); if (columnName == "Remark") { sb_EditDiv.AppendLine(" <div class=\"layer_form_div\">"); sb_EditDiv.AppendLine(" <input class=\"easyui-textbox " + columnName + "\" name=\"" + columnName + "\" data-options=\"label:'" + columnComment + "',prompt:'请输入" + columnComment + "',required:" + required + ",validType:['length[1," + data_maxLength + "]'],missingMessage:'请输入" + columnComment + "',multiline:true\" style=\"width: 300px;height:100px;\" />"); sb_EditDiv.AppendLine(" </div>"); sb_EditDiv.AppendLine(""); } else { sb_EditDiv.AppendLine(" <div class=\"layer_form_div\">"); sb_EditDiv.AppendLine(" <input class=\"easyui-textbox " + columnName + "\" name=\"" + columnName + "\" data-options=\"label:'" + columnComment + "',prompt:'请输入" + columnComment + "',required:" + required + ",validType:['length[1," + data_maxLength + "]'],missingMessage:'请输入" + columnComment + "'\" style=\"width: 300px;\" />"); sb_EditDiv.AppendLine(" </div>"); sb_EditDiv.AppendLine(""); } } } } } #endregion Model StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("@{"); sb_body.AppendLine(" ViewBag.Title = \"" + tableDesc + "详情\";"); sb_body.AppendLine(" Layout = \"~/Views/Shared/_Layout.cshtml\";"); sb_body.AppendLine("}"); sb_body.AppendLine(""); sb_body.AppendLine("<script>"); sb_body.AppendLine(""); sb_body.AppendLine(" $(function () {"); sb_body.AppendLine(""); sb_body.AppendLine(" //加载表格"); sb_body.AppendLine(" grid(\"#dtGrid\", \"#dtGridToolber\");"); sb_body.AppendLine(""); sb_body.AppendLine(" //添加"); sb_body.AppendLine(" $(\"#add\").on(\"click\", function () {"); sb_body.AppendLine(" content(\"添加" + tableDesc + "\", \"insertRow\", true);"); sb_body.AppendLine(" });"); sb_body.AppendLine(""); sb_body.AppendLine(" //搜索"); sb_body.AppendLine(" $(\"#searchList\").on(\"click\", function () {"); sb_body.AppendLine(" $('#dtGrid').datagrid('load', GetQueryParams());"); sb_body.AppendLine(" });"); sb_body.AppendLine(""); sb_body.AppendLine(" //删除选中"); sb_body.AppendLine(" $('#remove').linkbutton({"); sb_body.AppendLine(" onClick: function () {"); sb_body.AppendLine(" var gridID = \"#dtGrid\";"); sb_body.AppendLine(" var rows = $(gridID).datagrid('getSelections');"); sb_body.AppendLine(""); sb_body.AppendLine(" if (rows.length > 0) {"); sb_body.AppendLine(" layer.alert(\"确定删除选中的" + tableDesc + "吗?\", {"); sb_body.AppendLine(" icon: 3,"); sb_body.AppendLine(" btn: ['确定', '取消'],"); sb_body.AppendLine(" yes: function (closeIndex) {"); sb_body.AppendLine(" deleSelected(gridID, rows, closeIndex);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" })"); sb_body.AppendLine(""); sb_body.AppendLine(" } else {"); sb_body.AppendLine(" layer.alert('请选择要删除的" + tableDesc + "', { icon: 0, time: 2000 });"); sb_body.AppendLine(" }"); sb_body.AppendLine(" }"); sb_body.AppendLine(" })"); sb_body.AppendLine(" });"); sb_body.AppendLine(""); sb_body.AppendLine(" //删除选中"); sb_body.AppendLine(" function deleSelected(gridID, rows, closeIndex) {"); sb_body.AppendLine(" var " + tableName + "Ids = new Array();"); sb_body.AppendLine(" for (var i = 0; i < rows.length; i++) {"); sb_body.AppendLine(" " + tableName + "Ids.push(rows[i].SysNo);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" var parm = {"); sb_body.AppendLine(" " + tableName + "Ids: " + tableName + "Ids,"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" var loadLayer = null;"); sb_body.AppendLine(" $.ajax({"); sb_body.AppendLine(" type: \"Post\","); sb_body.AppendLine(" url: \"Delete" + tableName + "\","); sb_body.AppendLine(" dataType: \"json\","); sb_body.AppendLine(" data: JSON.stringify(parm),"); sb_body.AppendLine(" contentType: \"application/json\","); sb_body.AppendLine(" beforeSend: function () {"); sb_body.AppendLine(" loadLayer = layer.load(2);"); sb_body.AppendLine(" },"); sb_body.AppendLine(" success: function (data) {"); sb_body.AppendLine(" layer.close(loadLayer);"); sb_body.AppendLine(" if (data.Success) {"); sb_body.AppendLine(" layer.close(closeIndex);"); sb_body.AppendLine(" //layer.msg(data.Message, { time: 1000, btn: ['关闭'] });"); sb_body.AppendLine(" $('#dtGrid').datagrid('reload');"); sb_body.AppendLine(" } else {"); sb_body.AppendLine(" layer.alert(data.Message);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" }"); sb_body.AppendLine(" });"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" //实例化表格"); sb_body.AppendLine(" function grid(id, toolbar) {"); sb_body.AppendLine(" $(id).datagrid({"); sb_body.AppendLine(" url: 'Get" + tableName + "Paging',"); sb_body.AppendLine(" method: 'get',"); sb_body.AppendLine(" height: \"100%\","); sb_body.AppendLine(" width: \"100%\","); sb_body.AppendLine(" autoRowHeight: true,"); sb_body.AppendLine(" fitColumns: true,"); sb_body.AppendLine(" collapsible: true,"); sb_body.AppendLine(" pagination: true,"); sb_body.AppendLine(" pageList: [10, 50, 100, 200, 500, 1000],"); sb_body.AppendLine(" pageSize: 100,"); sb_body.AppendLine(" queryParams: GetQueryParams(),"); sb_body.AppendLine(" striped: true,"); sb_body.AppendLine(" loading: true,"); sb_body.AppendLine(" singleSelect: false,"); sb_body.AppendLine(" //nowrap:true,"); sb_body.AppendLine(" //rownumbers: true,"); sb_body.AppendLine(" scrollbarSize: 0,"); sb_body.AppendLine(" toolbar: toolbar,"); sb_body.AppendLine(" onLoadSuccess: function (data) {"); sb_body.AppendLine(" if (data.total > 0) {"); sb_body.AppendLine(" //加载完成 实例化按钮"); sb_body.AppendLine(" handle_edit(id);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" }"); sb_body.AppendLine(" })"); sb_body.AppendLine(" };"); sb_body.AppendLine(""); sb_body.AppendLine(" //弹框"); sb_body.AppendLine(" function content(title, type, check, _index) {"); sb_body.AppendLine(" layer.open({"); sb_body.AppendLine(" type: 1,"); sb_body.AppendLine(" area: [],"); sb_body.AppendLine(" title: title,"); sb_body.AppendLine(" zIndex: 100,"); sb_body.AppendLine(" content: $(\"#Layer_" + tableName + "\"),"); sb_body.AppendLine(" btn: ['保存', '取消'],"); sb_body.AppendLine(" btn1: function (closeIndex) {"); sb_body.AppendLine(" submit(type, closeIndex);"); sb_body.AppendLine(" },"); sb_body.AppendLine(" btn2: function (closeIndex) {"); sb_body.AppendLine(" layer.close(closeIndex);"); sb_body.AppendLine(" },"); sb_body.AppendLine(" success: function () {"); sb_body.AppendLine(" if (check) {"); sb_body.AppendLine(" $(\"#Layer_Form_" + tableName + "\").form(\"reset\");"); sb_body.AppendLine(" } else {"); sb_body.AppendLine(" var rows = $('#dtGrid').datagrid('getRows');"); sb_body.AppendLine(" var row = rows[_index];"); sb_body.AppendLine(" SetEditData(row);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" }"); sb_body.AppendLine(" });"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" //弹框 提交表单"); sb_body.AppendLine(" function submit(type, closeIndex) {"); sb_body.AppendLine(""); sb_body.AppendLine(" $(\"#Layer_Form_" + tableName + "\").form(\"submit\", {"); sb_body.AppendLine(" onSubmit: function () {"); sb_body.AppendLine(" if ($(this).form(\"validate\")) {"); sb_body.AppendLine(" var loadLayer = null;"); sb_body.AppendLine(" $.ajax({"); sb_body.AppendLine(" url: \"Edit" + tableName + "\","); sb_body.AppendLine(" type: 'post',"); sb_body.AppendLine(" contentType: \"application/json\","); sb_body.AppendLine(" data: JSON.stringify(GetEditData(type)),"); sb_body.AppendLine(" beforeSend: function () {"); sb_body.AppendLine(" loadLayer = layer.load(2);"); sb_body.AppendLine(" },"); sb_body.AppendLine(" success: function (data) {"); sb_body.AppendLine(" layer.close(loadLayer);"); //sb_body.AppendLine(" data = $.parseJSON(data);"); sb_body.AppendLine(" if (!data.Success) {"); sb_body.AppendLine(" layer.alert(data.Message, { icon: 0, tiem: 1500 });"); sb_body.AppendLine(" return;"); sb_body.AppendLine(" }"); sb_body.AppendLine(" var rows = $(\"#dtGrid\").datagrid(\"getRows\");"); sb_body.AppendLine(" $(\"#dtGrid\").datagrid('loadData', rows);"); sb_body.AppendLine(" layer.close(closeIndex);//关闭面板"); sb_body.AppendLine(" $('#dtGrid').datagrid('reload');"); sb_body.AppendLine(" },"); sb_body.AppendLine(" error: function (s) {"); sb_body.AppendLine(""); sb_body.AppendLine(" }"); sb_body.AppendLine(" });"); sb_body.AppendLine(" } else {"); sb_body.AppendLine(" layer.alert(\"信息填写不完整\", { icon: 0, tiem: 1500 });"); sb_body.AppendLine(" }"); sb_body.AppendLine(" }"); sb_body.AppendLine(" });"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" //查询条件"); sb_body.AppendLine(" function GetQueryParams() {"); sb_body.AppendLine(" var parm = {"); sb_body.AppendLine(" " + tableName + "Name_Search: $('#" + tableName + "Name').val(),"); sb_body.AppendLine(" };"); sb_body.AppendLine(" return parm;"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" //提交数据"); sb_body.AppendLine(" function GetEditData(type) {"); sb_body.AppendLine(" var parm = {"); sb_body.AppendLine(" SysNo: type == \"updateRow\" ? $(\".SysNo\").textbox(\"getText\") : \"00000000-0000-0000-0000-000000000000\","); sb_body.AppendLine(sb_GetEditData.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" };"); sb_body.AppendLine(" return parm;"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" //编辑页面赋值"); sb_body.AppendLine(" function SetEditData(row) {"); sb_body.AppendLine(" $(\".SysNo\").textbox(\"setText\", row.SysNo);"); sb_body.AppendLine(sb_SetEditData.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" //格式化操作栏"); sb_body.AppendLine(" function formatterHandle(val, row, index) {"); sb_body.AppendLine(" var ops = \"\";"); sb_body.AppendLine(" ops += \"<a class='easyui-linkbutton style-primary edit'>编辑</a>\";"); sb_body.AppendLine(" return ops;"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" //编辑"); sb_body.AppendLine(" function handle_edit(id) {"); sb_body.AppendLine(" $(id).datagrid(\"getPanel\").find(\"tr .edit\").linkbutton({"); sb_body.AppendLine(" iconCls: 'icon iconfont icon-edit',"); sb_body.AppendLine(" onClick: function (item) {"); sb_body.AppendLine(" var EditIndex = $(this).parents(\"tr\").index();"); sb_body.AppendLine(" $(id).datagrid(\"selectRow\", EditIndex);"); sb_body.AppendLine(""); sb_body.AppendLine(" //var rows = $(id).datagrid('getRows');"); sb_body.AppendLine(" //var row = rows[EditIndex];"); sb_body.AppendLine(""); sb_body.AppendLine(" content(\"编辑" + tableDesc + "\", \"updateRow\", false, EditIndex);"); sb_body.AppendLine(" }"); sb_body.AppendLine(" });"); sb_body.AppendLine(" }"); sb_body.AppendLine("</script>"); sb_body.AppendLine(""); sb_body.AppendLine("<body class=\"easyui-layout\">"); sb_body.AppendLine(" <div style=\"padding: 10px;\" id=\"dtGridToolber\">"); sb_body.AppendLine(" <input class=\"easyui-textbox\" style=\"width: 300px;\" id=\"" + tableName + "Name\" data-options=\"label:'" + tableDesc + "名称',prompt:'请输入" + tableDesc + "名称'\" />"); sb_body.AppendLine(""); sb_body.AppendLine(" <a id=\"searchList\" class=\"easyui-linkbutton style-primary\" style=\"margin: 0\" data-options=\"iconCls:'icon iconfont icon-sousuo'\">搜索</a>"); sb_body.AppendLine(" <a id=\"remove\" class=\"easyui-linkbutton style-red\" style=\"float: right;margin: 0 5px 0 0;\" data-options=\"iconCls:'icon iconfont icon-delete2'\">删除选中</a>"); sb_body.AppendLine(" <a id=\"add\" class=\"easyui-linkbutton style-blue\" style=\"float: right;margin: 0 5px 0 0;\" data-options=\"iconCls:'icon iconfont icon-tianjia1'\">添加" + tableDesc + "</a>"); sb_body.AppendLine(""); sb_body.AppendLine(" </div>"); sb_body.AppendLine(" <table id=\"dtGrid\" scroll=\"on\">"); sb_body.AppendLine(" <thead>"); sb_body.AppendLine(" <tr>"); sb_body.AppendLine(" <th data-options=\"field:'ck',checkbox:true,fixed:true\"></th>"); sb_body.AppendLine(" <th data-options=\"field:'SysNo',width:100,align:'center',hidden:true\">编号</th>"); sb_body.AppendLine(sb_Table_Th.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" <th data-options=\"field:'CreateDate',width:120,align:'center',formatter:fmDate\">添加时间</th>"); sb_body.AppendLine(" <th data-options=\"field:'UpdateDate',width:120,align:'center',formatter:fmDate\">更新时间</th>"); sb_body.AppendLine(" <th data-options=\"field:'handle',width:100,align:'center',fixed:true,formatter:formatterHandle\">操作</th>"); sb_body.AppendLine(" </tr>"); sb_body.AppendLine(" </thead>"); sb_body.AppendLine(" </table>"); sb_body.AppendLine(""); sb_body.AppendLine(" <div id=\"Layer_" + tableName + "\" style=\"width: 600px;height: 400px;display: none;\">"); sb_body.AppendLine(" <form class=\"easyui-form\" id=\"Layer_Form_" + tableName + "\" style=\"width: 80%;margin: 20px auto;\">"); sb_body.AppendLine(" <div class=\"layer_form_div\" style=\"display:none\">"); sb_body.AppendLine(" <input class=\"easyui-textbox SysNo\" name=\"SysNo\" data-options=\"label:'编号'\" />"); sb_body.AppendLine(" </div>"); sb_body.AppendLine(sb_EditDiv.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" </form>"); sb_body.AppendLine(""); sb_body.AppendLine(" </div>"); sb_body.AppendLine(""); sb_body.AppendLine("</body>"); sb_body.AppendLine(""); string file_Model = "C:\\Code\\" + str_nameSpace + ".Web\\Views\\" + tablePrefix + "\\"; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/" + tableName + ".cshtml", sb_body.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); bool isPrimeKey = false; string primaryKey = ""; StringBuilder sb = new StringBuilder(); StringBuilder sb_ext = new StringBuilder(); StringBuilder sb_search = new StringBuilder(); SetData(tableName, sb_ext); StringBuilder sb_load = new StringBuilder(); var listModel = CommonCode.GetTableModel(tableName); if (listModel != null) { foreach (var item in listModel) { SetLoad(sb_load, item); } } #region Model sb.AppendLine(" #region Model"); //遍历每个字段 foreach (DataRow dr in dt_tables.Rows) { string columnName = dr["columnName"].ToString().Trim(); //字段名 string columnType = dr["columnType"].ToString().Trim(); //字段类型 string columnComment = dr["columnComment"].ToString().Trim(); //字段注释 string nullable = dr["nullable"].ToString().Trim(); //是否可空(Y是不为空,N是为空) string data_default = dr["data_default"].ToString().Trim(); //默認值 string data_maxLength = dr["char_col_decl_length"].ToString().Trim(); //最大長度 string bool_primaryKey = dr["primaryKey"].ToString().Trim(); //主键 值为Y或N if (bool_primaryKey.ToUpper() == "Y") //存在主键 { isPrimeKey = true; primaryKey = columnName.ToUpper(); } if (string.IsNullOrEmpty(columnComment)) { columnComment = columnName; } CommonCode.GetColumnType(ref columnType, ref data_default); nullable = CommonCode.GetNullable(columnType, nullable); nullable = columnType == "string" ? "" : "?"; sb.AppendLine(""); sb.AppendLine(@" /// <summary>"); sb.AppendLine(@" /// " + columnComment); sb.AppendLine(@" /// </summary>"); sb.AppendLine(" public " + columnType + nullable + " " + columnName + " { get; set; }"); if (columnType == "string") { sb_search.AppendLine(""); sb_search.AppendLine(@" /// <summary>"); sb_search.AppendLine(@" /// " + columnComment); sb_search.AppendLine(@" /// </summary>"); sb_search.AppendLine(" public " + columnType + nullable + " " + columnName + "_Search { get; set; }"); } } sb.AppendLine(""); sb.AppendLine(" #endregion Model"); #endregion Model StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("using System;"); sb_body.AppendLine("using System.Collections.Generic;"); sb_body.AppendLine("using Lee.CQuery.Paging;"); sb_body.AppendLine(""); sb_body.AppendLine("namespace " + str_nameSpace + ".ViewModel." + tablePrefix + ".Filter"); sb_body.AppendLine("{"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// FilterViewModel:" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public class " + tableName + "FilterViewModel: PagingFilter"); sb_body.AppendLine(" {"); sb_body.AppendLine(""); sb_body.Append(sb.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" #region Search"); sb_body.Append(sb_search.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion Search"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 数据加载"); sb_body.AppendLine(""); sb_body.AppendLine(sb_load.ToString()); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 扩展"); sb_body.AppendLine(""); sb_body.AppendLine(sb_ext.ToString()); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(" }"); sb_body.AppendLine("}"); string file_Model = "C:\\Code\\" + str_nameSpace + ".ViewModel\\" + tablePrefix + "\\Filter"; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/" + tableName + "FilterViewModel" + ".cs", sb_body.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); bool isPrimeKey = false; string primaryKey = ""; StringBuilder sb = new StringBuilder(); #region Model //遍历每个字段 foreach (DataRow dr in dt_tables.Rows) { string columnName = dr["columnName"].ToString().Trim(); //字段名 string columnType = dr["columnType"].ToString().Trim(); //字段类型 string columnComment = dr["columnComment"].ToString().Trim(); //字段注释 string nullable = dr["nullable"].ToString().Trim(); //是否可空(Y是不为空,N是为空) string data_default = dr["data_default"].ToString().Trim(); //默認值 string data_maxLength = dr["char_col_decl_length"].ToString().Trim(); //最大長度 string bool_primaryKey = dr["primaryKey"].ToString().Trim(); //主键 值为Y或N if (bool_primaryKey.ToUpper() == "Y") //存在主键 { isPrimeKey = true; primaryKey = columnName.ToUpper(); } if (string.IsNullOrEmpty(columnComment)) { columnComment = columnName; } CommonCode.GetColumnType(ref columnType, ref data_default); nullable = CommonCode.GetNullable(columnType, nullable); sb.Append("\"" + columnName + "\", "); } string str = sb.ToString().Substring(0, sb.ToString().Length - 2); #endregion Model StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("using System;"); sb_body.AppendLine("using System.Collections.Generic;"); sb_body.AppendLine("using System.Linq;"); sb_body.AppendLine("using System.Text;"); sb_body.AppendLine("using System.Threading.Tasks;"); sb_body.AppendLine("using Lee.Command;"); sb_body.AppendLine("using Lee.Command.RDB;"); sb_body.AppendLine("using Lee.Command.UnitOfWork;"); sb_body.AppendLine("using Lee.Utility.Extension;"); sb_body.AppendLine("using " + str_nameSpace + ".DataAccessInterface." + tablePrefix + ";"); sb_body.AppendLine("using " + str_nameSpace + ".Entity." + tablePrefix + ";"); sb_body.AppendLine(""); sb_body.AppendLine("namespace " + str_nameSpace + ".DataAccess." + tablePrefix + ""); sb_body.AppendLine("{"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 数据访问:" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public class " + tableName + "DataAccess : RdbDataAccess<" + tableName + "Entity>, I" + tableName + "DbAccess"); sb_body.AppendLine(" {"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 获取添加字段"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取添加字段"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" protected override string[] GetEditFields()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return new string[] { " + str + " };"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 获取查询字段"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取查询字段"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" protected override string[] GetQueryFields()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return new string[] { " + str + " };"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(" }"); sb_body.AppendLine("}"); string file_Model = "C:\\Code\\" + str_nameSpace + ".DataAccess\\" + tablePrefix + ""; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/" + tableName + "DataAccess" + ".cs", sb_body.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); bool isPrimeKey = false; string primaryKey = ""; StringBuilder sb = new StringBuilder(); StringBuilder sb_load = new StringBuilder(); var listModel = CommonCode.GetTableModel(tableName); if (listModel != null) { foreach (var item in listModel) { SetLoad(sb_load, item); } } StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("using Lee.Web.Mvc;"); sb_body.AppendLine("using System;"); sb_body.AppendLine("using System.Collections.Generic;"); sb_body.AppendLine("using System.Linq;"); sb_body.AppendLine("using System.Web;"); sb_body.AppendLine("using System.Web.Mvc;"); sb_body.AppendLine("using Lee.Utility.Extension;"); sb_body.AppendLine("using Lee.Utility.Serialize;"); sb_body.AppendLine("using Lee.CQuery;"); sb_body.AppendLine("using Lee.CQuery.Paging;"); sb_body.AppendLine("using Lee.Utility;"); sb_body.AppendLine("using Lee.Application.Identity.User;"); sb_body.AppendLine("using Lee.Application.Identity.Auth;"); sb_body.AppendLine("using " + str_nameSpace + ".Web.Controllers.Base;"); sb_body.AppendLine("using " + str_nameSpace + ".ServiceInterface;"); sb_body.AppendLine("using " + str_nameSpace + ".ViewModel;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO.Cmd;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO.Query.Filter;"); sb_body.AppendLine("using " + str_nameSpace + ".ViewModel.Common;"); sb_body.AppendLine("using " + str_nameSpace + ".ViewModel.Filter;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO.Query;"); sb_body.AppendLine("using " + str_nameSpace + ".ServiceInterface." + tablePrefix + ";"); sb_body.AppendLine("using Lee.Utility.IoC;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO." + tablePrefix + ".Query.Filter;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO." + tablePrefix + ".Query;"); sb_body.AppendLine("using " + str_nameSpace + ".ViewModel." + tablePrefix + ";"); sb_body.AppendLine("using " + str_nameSpace + ".ViewModel." + tablePrefix + ".Filter;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO." + tablePrefix + ".Cmd;"); sb_body.AppendLine("using " + str_nameSpace + ".Web.Helper;"); sb_body.AppendLine(""); sb_body.AppendLine("namespace " + str_nameSpace + ".Web.Controllers"); sb_body.AppendLine("{"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// Controller:" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public partial class " + tablePrefix + "Controller : WebBaseController"); sb_body.AppendLine(" {"); sb_body.AppendLine(" I" + tableName + "Service " + tableName + "Service = ContainerManager.Container.Resolve<I" + tableName + "Service>();"); sb_body.AppendLine(" //Guid LoginUserId = UserHelper.GetLoginUserId();"); sb_body.AppendLine(""); //sb_body.AppendLine(" public " + tableName + "Controller() { }"); sb_body.AppendLine(""); sb_body.AppendLine(" #region " + tableDesc + "管理"); sb_body.AppendLine(" public ActionResult " + tableName + "()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" return View();"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// " + tableDesc + "列表"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"filter\"></param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" [HttpGet]"); sb_body.AppendLine(" public JsonResult Get" + tableName + "Paging(" + tableName + "FilterViewModel filter)"); sb_body.AppendLine(" {"); sb_body.AppendLine(""); sb_body.AppendLine(" filter.PageSize = filter.rows;"); sb_body.AppendLine(sb_load.ToString()); sb_body.AppendLine(""); sb_body.AppendLine(" var pager = " + tableName + "Service.Get" + tableName + "Paging(filter.MapTo<" + tableName + "FilterDto>()).Convert<" + tableName + "Dto, " + tableName + "ViewModel>();"); sb_body.AppendLine(" object objResult = new"); sb_body.AppendLine(" {"); sb_body.AppendLine(" total = pager.TotalCount,"); sb_body.AppendLine(" rows = pager,"); sb_body.AppendLine(" };"); sb_body.AppendLine(" return Json(objResult, JsonRequestBehavior.AllowGet);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 下拉框:" + tableDesc + "列表"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"filter\"></param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" [HttpGet]"); sb_body.AppendLine(" public JsonResult Get" + tableName + "List(" + tableName + "FilterViewModel filter)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" var list = " + tableName + "Service.Get" + tableName + "List(filter.MapTo<" + tableName + "FilterDto>());"); sb_body.AppendLine(" list.Insert(0, new " + tableName + "Dto { SysNo = Guid.Empty, " + tableName + "Name = \"\" });"); sb_body.AppendLine(" var result = list.Select(d => new { d.SysNo, d." + tableName + "Name });"); sb_body.AppendLine(" return Json(result, JsonRequestBehavior.AllowGet);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 添加、修改" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"user\"></param>"); sb_body.AppendLine(" /// <param name=\"userRoles\"></param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" [HttpPost]"); sb_body.AppendLine(" public JsonResult Edit" + tableName + "(" + tableName + "ViewModel vm)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" #region 验证是否存在"); sb_body.AppendLine(""); sb_body.AppendLine(" var model = " + tableName + "Service.Get" + tableName + "(new " + tableName + "FilterDto()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" " + tableName + "Name = vm." + tableName + "Name,"); sb_body.AppendLine(" });"); sb_body.AppendLine(" if (model != null && (vm.SysNo == Guid.Empty || model.SysNo != vm.SysNo))"); sb_body.AppendLine(" {"); sb_body.AppendLine(" var result2 = Result<" + tableName + "ViewModel>.ErrorResult(\"" + tableDesc + "名称已存在!\");"); sb_body.AppendLine(" return Json(result2);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion 验证是否存在"); sb_body.AppendLine(" vm.UpdateDate = DateTime.Now;"); sb_body.AppendLine(" vm.UpdateUserID = LoginUserId;"); sb_body.AppendLine(" if (vm.SysNo == Guid.Empty)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" vm.CreateUserID = LoginUserId;"); sb_body.AppendLine(" }"); sb_body.AppendLine(" var saveInfo = new Save" + tableName + "CmdDto()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" " + tableName + " = vm.MapTo<" + tableName + "CmdDto>()"); sb_body.AppendLine(" };"); sb_body.AppendLine(" var result = " + tableName + "Service.Save" + tableName + "(saveInfo);"); sb_body.AppendLine(" return Json(result);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 批量添加、修改" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"user\"></param>"); sb_body.AppendLine(" /// <param name=\"userRoles\"></param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" [HttpPost]"); sb_body.AppendLine(" public JsonResult EditList" + tableName + "(List<" + tableName + "ViewModel> list_vm)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" list_vm.ForEach(d => d.UpdateDate = DateTime.Now);"); sb_body.AppendLine(" list_vm.ForEach(d => d.UpdateUserID = LoginUserId);"); sb_body.AppendLine(" list_vm.Where(d => d.SysNo == Guid.Empty).ToList().ForEach(d => d.CreateUserID = LoginUserId);"); sb_body.AppendLine(" list_vm.Where(d => d.SysNo == Guid.Empty).ToList().ForEach(d => d.CreateDate = DateTime.Now);"); sb_body.AppendLine(""); sb_body.AppendLine(" Result result = " + tableName + "Service.SaveList" + tableName + "(new Save" + tableName + "CmdDto()"); sb_body.AppendLine(" {"); sb_body.AppendLine(" List" + tableName + " = list_vm.Select(d => d.MapTo<" + tableName + "CmdDto>()).ToList(),"); sb_body.AppendLine(" });"); sb_body.AppendLine(" return Json(result);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 删除" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"user\"></param>"); sb_body.AppendLine(" /// <param name=\"userRoles\"></param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" [HttpPost]"); sb_body.AppendLine(" public JsonResult Delete" + tableName + "(Delete" + tableName + "CmdDto vm)"); sb_body.AppendLine(" {"); sb_body.AppendLine(" vm.UpdateUserID = LoginUserId;"); sb_body.AppendLine(" vm.IsRealDeleted = false;"); sb_body.AppendLine(" var result = " + tableName + "Service.Delete" + tableName + "(vm);"); sb_body.AppendLine(" return Json(result);"); sb_body.AppendLine(" }"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion " + tableDesc + "管理"); sb_body.AppendLine(""); sb_body.AppendLine(" }"); sb_body.AppendLine("}"); string file_Model = "C:\\Code\\" + str_nameSpace + ".Web\\Controllers\\" + tablePrefix; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/" + tableName + "Controller.cs", sb_body.ToString()); }
public void Create(string str_nameSpace, DataTable dt_tables, string tableName) { string tablePrefix = CommonCode.GetTablePrefix(tableName); tableName = CommonCode.GetTableName(tableName); string tableDesc = CommonCode.GetTableDesc(tableName); StringBuilder sb_body = new StringBuilder(); sb_body.AppendLine("using System;"); sb_body.AppendLine("using System.Collections.Generic;"); sb_body.AppendLine("using System.Linq;"); sb_body.AppendLine("using System.Text;"); sb_body.AppendLine("using System.Threading.Tasks;"); sb_body.AppendLine("using Lee.CQuery;"); sb_body.AppendLine("using Lee.CQuery.Paging;"); sb_body.AppendLine("using Lee.Utility;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO." + tablePrefix + ".Cmd;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO." + tablePrefix + ".Query;"); sb_body.AppendLine("using " + str_nameSpace + ".DTO." + tablePrefix + ".Query.Filter;"); sb_body.AppendLine(""); sb_body.AppendLine("namespace " + str_nameSpace + ".ServiceInterface." + tablePrefix + ""); sb_body.AppendLine("{"); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 服务接口:" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" public interface I" + tableName + "Service"); sb_body.AppendLine(" {"); sb_body.AppendLine(" #region 保存"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 保存" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"saveInfo\">保存信息</param>"); sb_body.AppendLine(" /// <returns>执行结果</returns>"); sb_body.AppendLine(" Result<" + tableName + "Dto> Save" + tableName + "(Save" + tableName + "CmdDto saveInfo);"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 批量保存" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"saveInfo\">保存信息</param>"); sb_body.AppendLine(" /// <returns>执行结果</returns>"); sb_body.AppendLine(" Result SaveList" + tableName + "(Save" + tableName + "CmdDto saveInfo);"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 获取"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"filter\">查询条件</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" " + tableName + "Dto Get" + tableName + "(" + tableName + "FilterDto filter);"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 获取列表"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取" + tableDesc + "列表"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"filter\">查询条件</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" List<" + tableName + "Dto> Get" + tableName + "List(" + tableName + "FilterDto filter);"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 获取分页"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 获取" + tableDesc + "分页"); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"filter\">查询条件</param>"); sb_body.AppendLine(" /// <returns></returns>"); sb_body.AppendLine(" IPaging<" + tableName + "Dto> Get" + tableName + "Paging(" + tableName + "FilterDto filter);"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(""); sb_body.AppendLine(" #region 删除"); sb_body.AppendLine(""); sb_body.AppendLine(" /// <summary>"); sb_body.AppendLine(" /// 删除" + tableDesc); sb_body.AppendLine(" /// </summary>"); sb_body.AppendLine(" /// <param name=\"deleteInfo\">删除信息</param>"); sb_body.AppendLine(" /// <returns>执行结果</returns>"); sb_body.AppendLine(" Result Delete" + tableName + "(Delete" + tableName + "CmdDto deleteInfo);"); sb_body.AppendLine(""); sb_body.AppendLine(" #endregion"); sb_body.AppendLine(" }"); sb_body.AppendLine("}"); string file_Model = "C:\\Code\\" + str_nameSpace + ".ServiceInterface\\" + tablePrefix + ""; if (!Directory.Exists(file_Model)) { Directory.CreateDirectory(file_Model); } CommonCode.Save(file_Model + "/I" + tableName + "Service.cs", sb_body.ToString()); }
//生成 private void btn_save_Click(object sender, EventArgs e) { ConfigModel configModel = new ConfigModel(); configModel.MARK = "@"; //SQL的连接类型 configModel.str_nameSpace = textBox1.Text.Trim(); //命名空间 configModel.str_SqlHelper = textBox2.Text.Trim(); //数据访问类名 configModel.str_ExecuteNonQuery = textBox5.Text.Trim(); configModel.str_UpdateDatabase = textBox6.Text.Trim(); configModel.str_ExecuteScalar = textBox4.Text.Trim(); configModel.str_GetDataTable = textBox7.Text.Trim(); configModel.str_Exists = textBox10.Text.Trim(); configModel.str_GetModel = textBox8.Text.Trim(); configModel.str_GetModelList = textBox9.Text.Trim(); #region 生成文件夹 //string file_BLL = textBox3.Text.Trim(); //string file_DAL = textBox11.Text.Trim(); //string file_IDAL = textBox12.Text.Trim(); //string file_Model = textBox13.Text.Trim(); //if (!Directory.Exists(file_Model)) //{ // Directory.CreateDirectory(file_Model); //} //if (!Directory.Exists(file_IDAL)) //{ // Directory.CreateDirectory(file_IDAL); //} //if (!Directory.Exists(file_BLL)) //{ // Directory.CreateDirectory(file_BLL); //} //if (!Directory.Exists(file_DAL)) //{ // Directory.CreateDirectory(file_DAL); //} //if (comboBox1.SelectedIndex == 1) //{ // string path = textBox3.Text.Trim(); // if (!string.IsNullOrEmpty(path)) // { // if (path.Contains("\\BLL")) // { // path = path.Replace("\\BLL", ""); // string BaseBLLSrc = Directory.GetCurrentDirectory() + "/BaseBll.cs"; // string BaseDALSrc = Directory.GetCurrentDirectory() + "/BaseDAL.cs"; // string BaseIDALSrc = Directory.GetCurrentDirectory() + "/BaseIDAL.cs"; // File.Copy(BaseBLLSrc, path + "\\BaseBll.cs"); // File.Copy(BaseDALSrc, path + "\\BaseDAL.cs"); // File.Copy(BaseIDALSrc, path + "\\BaseIDAL.cs"); // } // } //} #endregion 生成文件夹 string str_CreateMap = ""; string str_SetObjectName = ""; string str_SetPrimaryKey = ""; string str_AddColumn = ""; List <string> listTableName = new List <string>(); //遍历每个表 for (int i = 0; i < listBox2.Items.Count; i++) { string str_table = listBox2.Items[i].ToString();//表名 //string str_BLLName = str_table + textBox17.Text.Trim(); //string str_DALName = str_table + textBox16.Text.Trim(); //string str_IDALName = str_table + textBox15.Text.Trim(); //string str_ModelName = str_table + textBox14.Text.Trim(); string sql = @" SELECT 表名 = case when a.colorder=1 then d.name else '' end, 表说明 = case when a.colorder=1 then isnull(f.value,'') else '' end, 字段序号 = a.colorder, columnName = a.name, 标识 = case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then 'Y'else 'N' end, primaryKey = case when exists(SELECT 1 FROM sysobjects where xtype='PK' and parent_obj=a.id and name in ( SELECT name FROM sysindexes WHERE indid in( SELECT indid FROM sysindexkeys WHERE id = a.id AND colid=a.colid))) then 'Y' else 'N' end, columnType = b.name, 占用字节数 = a.length, char_col_decl_length = COLUMNPROPERTY(a.id,a.name,'PRECISION'), 小数位数 = isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0), nullable = case when a.isnullable=1 then 'N'else 'Y' end, data_default = isnull(e.text,''), columnComment = isnull(g.[value],'') FROM syscolumns a left join systypes b on a.xusertype=b.xusertype inner join sysobjects d on a.id=d.id and d.xtype='U' and d.name<>'dtproperties' left join syscomments e on a.cdefault=e.id left join sys.extended_properties g on a.id=g.major_id and a.colid=g.minor_id left join sys. extended_properties f on d.id=f.major_id and f.major_id=0 where d.name=" + configModel.MARK + "a order by a.id,a.colorder"; SqlParameter[] sps = { new SqlParameter(configModel.MARK + "a", str_table) }; DataTable dt_tables = SqlHelper.GetDataTable(sql, sps); if (dt_tables == null) { return; } if (dt_tables.Rows.Count > 0) { listTableName.Add(str_table); #region 生成内容 StringBuilder sb_column1 = new StringBuilder(); //格式如 NO_ID,ST_NAME,ST_VALUES,NO_ORDER,ST_OTHER,ST_VALUES_ENG StringBuilder sb_column2 = new StringBuilder(); //格式如 @NO_ID,@ST_NAME,@ST_VALUES,@NO_ORDER,@ST_OTHER,@ST_VALUES_ENG StringBuilder sb_column3 = new StringBuilder(); //格式如 new SqlParameter("@NO_ID", SqlType.Number,4), StringBuilder sb_column4 = new StringBuilder(); //格式如 parameters[0].Value = model.NO_ID; StringBuilder sb_column5 = new StringBuilder(); //格式如 strSql.Append("ST_NAME=@ST_NAME,"); for (int j = 0; j < dt_tables.Rows.Count; j++) { string colName = dt_tables.Rows[j]["columnName"].ToString().Trim(); //字段名 string colType = CommonCode.GetColType(dt_tables.Rows[j]["columnType"].ToString()); //字段类型 if (j == dt_tables.Rows.Count - 1) { sb_column1.Append(colName); sb_column2.Append(configModel.MARK + colName); sb_column3.AppendLine(" new SqlParameter(\""+ configModel.MARK + colName + "\", model." + colName + ")};"); //sb_column4.AppendLine(" parameters[" + j + "].Value = model." + colName + ";"); sb_column4.AppendLine("item." + colName + "=model." + colName + ";"); sb_column5.AppendLine(" strSql.Append(\"" + colName + "=" + configModel.MARK + colName + "\");"); } else { sb_column1.Append(colName + ","); sb_column2.Append(configModel.MARK + colName + ","); sb_column3.AppendLine(" new SqlParameter(\""+ configModel.MARK + colName + "\", model." + colName + "),"); //sb_column4.AppendLine(" parameters[" + j + "].Value = model." + colName + ";"); sb_column4.AppendLine("item." + colName + "=model." + colName + ";"); sb_column5.AppendLine(" strSql.Append(\"" + colName + "=" + configModel.MARK + colName + ",\");"); } } #endregion 生成内容 ////生成model //new CreateModel().Create(file_Model, configModel.str_nameSpace, dt_tables, str_ModelName); ////生成IDAL //new CreateIDAL().Create(file_IDAL, configModel.str_nameSpace, str_IDALName, str_ModelName); ////生成BLL //new CreateBLL().Create(file_BLL, configModel.str_nameSpace, str_table, str_BLLName, str_IDALName, str_ModelName); ////生成DAL //new CreateDAL().Create(file_DAL, str_table, str_DALName, str_IDALName, str_ModelName, sb_column1, sb_column2, sb_column3, sb_column4, sb_column5, configModel); //new Create_DeleteCmdDto().Create(configModel.str_nameSpace, dt_tables, str_table); //new Create_SaveCmdDto().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_CmdDto().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_Dto().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_FilterDto().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_Query().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_ViewModel().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_FilterViewModel().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_Entity().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_Repository().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_IRepository().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_DomainService().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_Business().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_IDataAccess().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_DataAccess().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_IService().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_Service().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_IBusiness().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_DomainModel().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_Web_Page().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_Web_Controller().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_Sql().Create(configModel.str_nameSpace, dt_tables, str_table); new Create_Json().Create(configModel.str_nameSpace, dt_tables, str_table); if (checkBox1.Checked) { new Create_csproj().Create(configModel.str_nameSpace, dt_tables, str_table, "Business"); new Create_csproj().Create(configModel.str_nameSpace, dt_tables, str_table, "BusinessInterface"); new Create_csproj().Create(configModel.str_nameSpace, dt_tables, str_table, "DataAccess"); new Create_csproj().Create(configModel.str_nameSpace, dt_tables, str_table, "DataAccessInterface"); new Create_csproj().Create(configModel.str_nameSpace, dt_tables, str_table, "Domain"); new Create_csproj().Create(configModel.str_nameSpace, dt_tables, str_table, "Dto"); new Create_csproj().Create(configModel.str_nameSpace, dt_tables, str_table, "Entity"); new Create_csproj().Create(configModel.str_nameSpace, dt_tables, str_table, "Query"); new Create_csproj().Create(configModel.str_nameSpace, dt_tables, str_table, "Repository"); new Create_csproj().Create(configModel.str_nameSpace, dt_tables, str_table, "Service"); new Create_csproj().Create(configModel.str_nameSpace, dt_tables, str_table, "ServiceInterface"); new Create_csproj().Create(configModel.str_nameSpace, dt_tables, str_table, "ViewModel"); //new Create_csproj().Create(configModel.str_nameSpace, dt_tables, str_table, "Web"); } str_CreateMap += new Create_Config().GetStr_CreateMap(configModel.str_nameSpace, dt_tables, str_table); str_SetObjectName += new Create_Config().GetStr_SetObjectName(configModel.str_nameSpace, dt_tables, str_table); str_SetPrimaryKey += new Create_Config().GetStr_SetPrimaryKey(configModel.str_nameSpace, dt_tables, str_table); str_AddColumn += new Create_Sql().GetSql_AddColumn(str_table, "IsDelete", "bit not null default(0)", "是否删除"); } label4.Text = "提示信息:" + (i + 1) + "个文件,全部生成成功!" + DateTime.Now; } string filePath = "C:\\Code\\Config"; if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } CommonCode.Save(filePath + "/AutoMapMapper CreateMap.txt", str_CreateMap); CommonCode.Save(filePath + "/DbConfig SetObjectName.txt", str_SetObjectName); CommonCode.Save(filePath + "/DbConfig SetPrimaryKey.txt", str_SetPrimaryKey); CommonCode.Save(filePath + "/AddColumn.txt", str_AddColumn); if (checkBox3.Checked) { Create_Config.SaveAutoMapMapper(str_CreateMap); Create_Config.SaveDBConfig(str_SetObjectName, str_SetPrimaryKey); } if (checkBox2.Checked) { new Create_Enum().Create(configModel.str_nameSpace, listTableName); } if (textBox3.Text != "") { var arr = textBox3.Text.Split(','); if (arr[0] != "ControllerCode") { StringBuilder sb_body = new StringBuilder(); Create_Sql.SetData2(arr[0], arr[1], arr[2], sb_body); filePath = "C:\\Code\\Sql"; if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } CommonCode.Save(filePath + "/生成的.txt", sb_body.ToString()); CommonCode.Save(filePath + "/生成的_Delete.txt", Create_Sql.GetSql_Delete(arr[2])); } } //OpenFolder(); }
public void Create(string file_IDAL, string str_nameSpace, string str_IDALName, string str_ModelName) { StringBuilder sb = new StringBuilder(); sb.AppendLine("using System;"); sb.AppendLine("using System.Collections.Generic;"); sb.AppendLine("using System.Data;"); sb.AppendLine("using " + str_nameSpace + ".Model;"); sb.AppendLine(""); sb.AppendLine("namespace " + str_nameSpace + ".IDAL"); sb.AppendLine("{"); sb.AppendLine(" public interface " + str_IDALName); sb.AppendLine(" {"); #region BasicMethod sb.AppendLine(" #region BasicMethod"); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 是否存在该记录"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" bool Exists(string ST_CODE);"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 增加一条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" bool Add("+ str_ModelName + " model);"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 增加多条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" int AddList(List<" + str_ModelName + "> list_model);"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 更新一条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" bool Update("+ str_ModelName + " model);"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 更新多条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" int UpdateList(List<"+ str_ModelName + "> list_model);"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 删除一条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" bool Delete(string ST_CODE);"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 删除多条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" bool DeleteList(List<string> ST_CODElist);"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 得到实体对象"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" "+ str_ModelName + " GetModel(string ST_CODE);"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 得到实体列表"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" List<" + str_ModelName + "> GetModelList(string strWhere);"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 获得数据列表"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" DataTable GetList(string strWhere);"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 获取记录总数"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" int GetRecordCount(string strWhere);"); sb.AppendLine(""); sb.AppendLine(" ///// <summary>"); sb.AppendLine(" ///// 分页获取数据列表"); sb.AppendLine(" ///// </summary>"); sb.AppendLine(" //public int GetRecordCount(string strWhere);"); sb.AppendLine(""); sb.AppendLine(" ///// <summary>"); sb.AppendLine(" ///// 根据分页获得数据列表"); sb.AppendLine(" ///// </summary>"); sb.AppendLine(" //DataTable GetList(int PageSize,int PageIndex,string strWhere);"); sb.AppendLine(" #endregion BasicMethod"); #endregion sb.AppendLine(""); sb.AppendLine(""); sb.AppendLine(" }"); sb.AppendLine("}"); CommonCode.Save(file_IDAL + "/" + str_IDALName + ".cs", sb.ToString()); }
public void Create(string file_BLL, string str_nameSpace, string str_table, string str_BLLName, string str_IDALName, string str_ModelName) { StringBuilder sb = new StringBuilder(); sb.AppendLine("using System;"); sb.AppendLine("using System.Data;"); sb.AppendLine("using System.Collections.Generic;"); sb.AppendLine("using " + str_nameSpace + ".Model;"); sb.AppendLine("using " + str_nameSpace + ".IDAL;"); sb.AppendLine("using " + str_nameSpace + ".DALFactory;"); sb.AppendLine(""); sb.AppendLine("namespace " + str_nameSpace + ".BLL"); sb.AppendLine("{"); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// " + str_BLLName); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public partial class " + str_BLLName); sb.AppendLine(" {"); sb.AppendLine(" private readonly " + str_IDALName + " dal = DataAccess.Create" + str_table.ToUpper() + "();"); sb.AppendLine(" public " + str_BLLName + "() { }"); sb.AppendLine(""); #region BasicMethod sb.AppendLine(" #region BasicMethod"); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 是否存在该记录"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public bool Exists(string ST_CODE)"); sb.AppendLine(" {"); sb.AppendLine(" return dal.Exists(ST_CODE);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 增加一条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public bool Add(" + str_ModelName + " model)"); sb.AppendLine(" {"); sb.AppendLine(" return dal.Add(model);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 增加多条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public int AddList(List<" + str_ModelName + "> list_model)"); sb.AppendLine(" {"); sb.AppendLine(" return dal.AddList(list_model);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 更新一条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public bool Update(" + str_ModelName + " model)"); sb.AppendLine(" {"); sb.AppendLine(" return dal.Update(model);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 更新多条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public int UpdateList(List<" + str_ModelName + "> list_model)"); sb.AppendLine(" {"); sb.AppendLine(" return dal.UpdateList(list_model);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 删除一条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public bool Delete(string ST_CODE)"); sb.AppendLine(" {"); sb.AppendLine(" return dal.Delete(ST_CODE);"); sb.AppendLine(" }"); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 删除多条数据"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public bool DeleteList(List<string> ST_CODElist)"); sb.AppendLine(" {"); sb.AppendLine(" return dal.DeleteList(ST_CODElist);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 得到实体对象"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public " + str_ModelName + " GetModel(string ST_CODE)"); sb.AppendLine(" {"); sb.AppendLine(" return dal.GetModel(ST_CODE);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 获得实体列表"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public List<" + str_ModelName + "> GetModelList(string strWhere)"); sb.AppendLine(" {"); sb.AppendLine(" return dal.GetModelList(strWhere);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 获得数据列表"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public DataTable GetList(string strWhere)"); sb.AppendLine(" {"); sb.AppendLine(" return dal.GetList(strWhere);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 获得数据列表"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public DataTable GetAllList()"); sb.AppendLine(" {"); sb.AppendLine(" return GetList(\"\");"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" /// <summary>"); sb.AppendLine(" /// 获取记录总数"); sb.AppendLine(" /// </summary>"); sb.AppendLine(" public int GetRecordCount(string strWhere)"); sb.AppendLine(" {"); sb.AppendLine(" return dal.GetRecordCount(strWhere);"); sb.AppendLine(" }"); sb.AppendLine(""); sb.AppendLine(" ///// <summary>"); sb.AppendLine(" ///// 分页获取数据列表"); sb.AppendLine(" ///// </summary>"); sb.AppendLine(" //public int GetRecordCount(string strWhere)"); sb.AppendLine(" //{"); sb.AppendLine(" // return dal.GetRecordCount(strWhere);"); sb.AppendLine(" //}"); sb.AppendLine(""); sb.AppendLine(" ///// <summary>"); sb.AppendLine(" ///// 分页获取数据列表"); sb.AppendLine(" ///// </summary>"); sb.AppendLine(" //public DataTable GetList(int PageSize,int PageIndex,string strWhere)"); sb.AppendLine(" //{"); sb.AppendLine(" //return dal.GetList(PageSize,PageIndex,strWhere);"); sb.AppendLine(" //}"); sb.AppendLine(""); sb.AppendLine(" #endregion BasicMethod"); #endregion sb.AppendLine(""); sb.AppendLine(""); sb.AppendLine(" }"); sb.AppendLine("}"); CommonCode.Save(file_BLL + "/" + str_BLLName + ".cs", sb.ToString()); }