public ActionResult <ApiResult <bool> > SaveCodetableImport([FromForm] int dbid, [FromForm] string model)
{
ApiResult <bool> result = new ApiResult <bool>();
var list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <DbTableGridViewModel> >(model);
var tableDb = base.GetTryDb(dbid);
var systemDb = Db;
var type = CodeTypeDb.GetList();
var entityList = CodeTableDb.GetList(it => it.DbId == dbid);
systemDb.BeginTran();
try
{
List <CodeTable> Inserts = new List <CodeTable>();
foreach (var item in list)
{
CodeTableViewModel code = new CodeTableViewModel()
{
ClassName = PubMehtod.GetCsharpName(item.Name),
TableName = item.Name,
DbId = dbid,
Description = item.Description,
ColumnInfoList = new List <CodeColumnsViewModel>()
};
var entity = entityList.FirstOrDefault(it => it.TableName.Equals(item.Name, StringComparison.OrdinalIgnoreCase));
if (entity == null)
{
entity = new CodeTable();
}
foreach (var columnInfo in tableDb.DbMaintenance.GetColumnInfosByTableName(item.Name, false))
{
var typeInfo = GetEntityType(type, columnInfo, this, tableDb.CurrentConnectionConfig.DbType);
CodeColumnsViewModel column = new CodeColumnsViewModel()
{
ClassProperName = PubMehtod.GetCsharpName(columnInfo.DbColumnName),
DbColumnName = columnInfo.DbColumnName,
Description = columnInfo.ColumnDescription,
IsIdentity = columnInfo.IsIdentity,
IsPrimaryKey = columnInfo.IsPrimarykey,
Required = columnInfo.IsNullable == false,
CodeTableId = entity.Id,
CodeType = typeInfo.CodeType.Name,
Length = typeInfo.DbTypeInfo.Length,
DecimalDigits = typeInfo.DbTypeInfo.DecimalDigits,
DefaultValue = columnInfo.DefaultValue
};
code.ColumnInfoList.Add(column);
}
SaveCodeTableToDb(code);
}
;
systemDb.CommitTran();
result.IsSuccess = true;
}
catch (Exception ex)
{
systemDb.RollbackTran();
throw ex;
}
return(result);
}
public ActionResult <ApiResult <TableModel <DbTableGridViewModel> > > GetTableList(int?dbId, [FromForm] DbTableViewModel model)
{
var result = new ApiResult <TableModel <DbTableGridViewModel> >();
result.Data = new TableModel <DbTableGridViewModel>();
var db = GetTryDb(dbId.Value);
result.Data.Rows = mapper.Map <List <DbTableGridViewModel> > (db.DbMaintenance.GetTableInfoList(false));
var codetable = CodeTableDb.AsQueryable().Where(it => it.DbId == dbId.Value).OrderBy(it => it.TableName).ToList();
foreach (var item in result.Data.Rows)
{
item.IsImport = codetable.Any(it => it.TableName.Equals(item.Name, StringComparison.CurrentCultureIgnoreCase)) ? "导入" : "";
}
if (!string.IsNullOrEmpty(model.name))
{
result.Data.Rows = result.Data.Rows.Where(it => it.Name.ToLower().Contains(model.name?.ToLower())).ToList();
}
if (model.typeId == "1")
{
result.Data.Rows = result.Data.Rows.Where(it => !string.IsNullOrEmpty(it.IsImport)).ToList();
}
if (model.typeId == "2")
{
result.Data.Rows = result.Data.Rows.Where(it => string.IsNullOrEmpty(it.IsImport)).ToList();
}
result.IsSuccess = true;
result.Data.PageNumber = 1;
result.Data.PageSize = result.Data.Rows.Count;
return(result);
}
public ActionResult <ApiResult <string> > Copy([FromForm] ProjectViewModel2 model)
{
var result = new ApiResult <string>();
var tables = model.Tables;
var project = ProjectDb.GetSingle(it => it.Id == model.ProjectId);
base.Check(project == null, "请选择方案，没有方案可以在手动生成里面创建");
model.Tables = tables;
var template = TemplateDb.GetById(project.TemplateId1).Content;
var tableids = Newtonsoft.Json.JsonConvert.DeserializeObject <List <CodeTypeGridViewModel> >(model.Tables).Select(it => it.Id).ToList();
var tableList = CodeTableDb.GetList(it => tableids.Contains(it.Id));
int dbId = tableList.First().DbId;
var connection = base.GetTryDb(dbId);
List <EntitiesGen> genList = GetGenList(tableList, CodeTypeDb.GetList(), connection.CurrentConnectionConfig.DbType);
string key = TemplateHelper.EntityKey + template.GetHashCode();
foreach (var item in genList.Take(1))
{
item.name_space = GetNameSpace(project.FileModel, item.name_space);
result.Data = TemplateHelper.GetTemplateValue(key, template, item);
}
ProjectController_Common.CreateProject(project.Id, model.DbId.Value);
result.IsSuccess = true;
return(result);
}
public ActionResult <ApiResult <bool> > CreateFileByProjectId([FromForm] ProjectViewModel2 model, bool disOpen = true)
{
var result = new ApiResult <bool>();
var tables = model.Tables;
var project = ProjectDb.GetSingle(it => it.Id == model.ProjectId);
base.Check(project == null, "请选择方案");
model.Tables = tables;
var template = TemplateDb.GetById(project.TemplateId1).Content;
var tableids = Newtonsoft.Json.JsonConvert.DeserializeObject <List <CodeTypeGridViewModel> >(model.Tables).Select(it => it.Id).ToList();
var tableList = CodeTableDb.GetList(it => tableids.Contains(it.Id));
int dbId = tableList.First().DbId;
var connection = base.GetTryDb(dbId);
List <EntitiesGen> genList = GetGenList(tableList, CodeTypeDb.GetList(), connection.CurrentConnectionConfig.DbType);
string key = TemplateHelper.EntityKey + template.GetHashCode();
foreach (var item in genList)
{
item.name_space = GetNameSpace(project.FileModel, item.name_space);
var html = TemplateHelper.GetTemplateValue(key, template, item);
var fileName = GetFileName(project, item);
FileSugar.CreateFileReplace(fileName, html, Encoding.UTF8);
}
OpenPath(disOpen, project);
ProjectController_Common.CreateProject(project.Id, model.DbId.Value);
result.IsSuccess = true;
result.Message = "生成生功";
return(result);
}
private void SaveCodeTableToDb(CodeTableViewModel viewModel)
{
if (!string.IsNullOrEmpty(viewModel.TableName))
{
viewModel.TableName = viewModel.TableName.Trim();
}
if (!string.IsNullOrEmpty(viewModel.ClassName))
{
viewModel.ClassName = viewModel.ClassName.Trim();
}
base.Check(string.IsNullOrEmpty(viewModel.TableName) || string.IsNullOrEmpty(viewModel.ClassName), "表名或者实体类名必须填一个");
viewModel.ColumnInfoList = viewModel.ColumnInfoList
.Where(it => !string.IsNullOrEmpty(it.ClassProperName) || !string.IsNullOrEmpty(it.DbColumnName)).ToList();
base.Check(viewModel.ColumnInfoList.Count == 0, "请配置实体属性");
var dbTable = mapper.Map <CodeTable>(viewModel);
AutoFillTable(dbTable);
var dbColumns = mapper.Map <List <CodeColumns> >(viewModel.ColumnInfoList);
AutoFillColumns(dbColumns);
if (viewModel.Id == null || viewModel.Id == 0)
{
CheckAddName(viewModel, CodeTableDb);
var id = CodeTableDb.InsertReturnIdentity(dbTable);
foreach (var item in dbColumns)
{
item.CodeTableId = id;
item.DbColumnName = GetColumnName(item.DbColumnName);
}
CodeColumnsDb.InsertRange(dbColumns);
}
else
{
CheckUpdateName(viewModel, CodeTableDb);
CodeTableDb.Update(dbTable);
foreach (var item in dbColumns)
{
item.CodeTableId = dbTable.Id;
item.DbColumnName = GetColumnName(item.DbColumnName);
}
var oldIds = CodeColumnsDb.GetList(it => it.CodeTableId == dbTable.Id).Select(it => it.Id).ToList();
var delIds = oldIds.Where(it => !dbColumns.Select(y => y.Id).Contains(it)).ToList();
CodeColumnsDb.DeleteByIds(delIds.Select(it => (object)it).ToArray());
var updateColumns = dbColumns.Where(it => it.Id > 0).ToList();
if (updateColumns.Count > 0)
{
CodeColumnsDb.UpdateRange(updateColumns);
}
var insertColumns = dbColumns.Where(it => it.Id == 0).ToList();
if (insertColumns.Count > 0)
{
CodeColumnsDb.InsertRange(insertColumns);
}
}
}
private DataTable [] Export(string model, SqlSugarClient tableDb)
{
var list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <CodeTableViewModel> >(model);
var oldList = CodeTableDb.AsQueryable().In(list.Select(it => it.Id).ToList()).ToList();
List <EntitiesGen> genList = GetGenList(oldList, CodeTypeDb.GetList(), tableDb.CurrentConnectionConfig.DbType);
List <DataTable> datatables = new List <DataTable>();
foreach (var item in genList)
{
DataTable dt = new DataTable();
dt.Columns.Add("列名");
dt.Columns.Add("列描述");
dt.Columns.Add("列类型");
dt.Columns.Add("实体类型");
dt.Columns.Add("主键");
dt.Columns.Add("自增");
dt.Columns.Add("可空");
dt.Columns.Add("长度");
dt.Columns.Add("精度");
dt.Columns.Add("默认值");
dt.Columns.Add("表名");;
dt.Columns.Add("表描述");
foreach (var it in item.PropertyGens)
{
var dr = dt.NewRow();
dr["列名"] = it.DbColumnName;
dr["列描述"] = it.Description;
dr["列类型"] = it.DbType;
dr["实体类型"] = it.Type;
dr["表名"] = item.TableName;;
dr["表描述"] = item.Description;
dr["主键"] = it.IsPrimaryKey?"是":"";
dr["自增"] = it.IsIdentity ? "是" : "";
dr["可空"] = it.IsNullable ? "是" : "";
dr["长度"] = it.Length;
dr["精度"] = it.DecimalDigits;
dr["默认值"] = it.DefaultValue;
dt.Rows.Add(dr);
}
dt.TableName = item.TableName;
datatables.Add(dt);
}
return(datatables.ToArray());
}
public ActionResult <ApiResult <bool> > DeleteCodeTable([FromForm] string model)
{
var result = new ApiResult <bool>();
if (!string.IsNullOrEmpty(model))
{
var list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <CodeTableViewModel> >(model);
Db.Utilities.PageEach(list, 50, eitem =>
{
var exp = Expressionable.Create <CodeTable>();
foreach (var item in eitem)
{
exp.Or(it => it.Id == item.Id);
}
CodeTableDb.Update(it => new CodeTable()
{
IsDeleted = true
}, exp.ToExpression());
});
}
result.IsSuccess = true;
return(result);
}
private void UpdateEntityItem(int dbid, SqlSugarClient tableDb, List <CodeTableViewModel> list)
{
var oldList = CodeTableDb.AsQueryable().In(list.Select(it => it.Id).ToList()).ToList();
var oldColumns = Db.Queryable <CodeColumns, CodeTable>((c, t) => c.CodeTableId == t.Id).Where((c, t) => oldList.Select(it => it.Id).Contains(t.Id)).Select((c, t) => new { TableId = t.Id, TableName = t.TableName, Columns = c }).ToList();
var alltables = tableDb.DbMaintenance.GetTableInfoList(false).Select(it => it.Name.ToLower()).ToList();
var ids = list.Select(it => it.Id).ToList();
var tableNames = list.Select(it => it.TableName.ToLower()).ToList();
var errorTables = list.Where(it => !alltables.Contains(it.TableName.ToLower()) && !alltables.Contains(it.ClassName.ToLower())).ToList();
base.Check(errorTables.Any(), string.Join(",", errorTables.Select(y => y.TableName ?? y.ClassName)) + "未创建表不能同步");
try
{
Db.BeginTran();
CodeTableDb.DeleteByIds(ids.Select(it => (object)it).ToArray());
var dbTableGridList = tableDb.DbMaintenance.GetTableInfoList(false).Where(it => tableNames.Contains(it.Name.ToLower())).Select(it => new DbTableGridViewModel()
{
Description = it.Description,
Name = it.Name
});
if (dbTableGridList.Any())
{
SaveCodetableImport(dbid, Newtonsoft.Json.JsonConvert.SerializeObject(dbTableGridList));
}
foreach (var item in oldList)
{
CodeTableDb.AsUpdateable(item).UpdateColumns(it => it.ClassName).WhereColumns(it => it.TableName).ExecuteCommand();
}
List <CodeColumns> UpdateColumns = new List <CodeColumns>();
foreach (var item in oldColumns.GroupBy(it => new { it.TableId, it.TableName }).ToList())
{
var tableId = CodeTableDb.AsQueryable().Where(it => it.TableName == item.Key.TableName && it.DbId == dbid).First()?.Id;
if (tableId != null)
{
var columns = CodeColumnsDb.AsQueryable().Where(it => it.CodeTableId == tableId).ToList();
foreach (var col in columns)
{
var addColumn = item.FirstOrDefault(it => it.Columns.DbColumnName == col.DbColumnName);
if (addColumn != null)
{
col.ClassProperName = addColumn.Columns.ClassProperName;
UpdateColumns.Add(col);
}
else
{
}
}
foreach (var oldItem in item.ToList())
{
if (oldItem.Columns.CodeType.Equals("ignore", StringComparison.CurrentCultureIgnoreCase))
{
var mapp = _mapper.Map <CodeColumns>(oldItem.Columns);
mapp.CodeTableId = columns[0].CodeTableId;
CodeColumnsDb.AsInsertable(mapp).ExecuteCommand();
}
}
}
}
CodeColumnsDb.AsUpdateable(UpdateColumns).UpdateColumns(it => it.ClassProperName).ExecuteCommand();
Db.CommitTran();
}
catch (Exception ex)
{
Db.RollbackTran();
throw ex;
}
}
public ActionResult <ApiResult <bool> > CreateTables([FromForm] string model, [FromForm] int dbid)
{
var tableDb = base.GetTryDb(dbid);
var result = new ApiResult <bool>();
if (!string.IsNullOrEmpty(model))
{
var list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <CodeTableViewModel> >(model);
var oldList = CodeTableDb.AsQueryable().In(list.Select(it => it.Id).ToList()).ToList();
base.Check(oldList.Any(it => it.IsLock), string.Join(",", oldList.Where(it => it.IsLock).Select(it => it.ClassName)) + "是锁表状态禁止建表");
List <EntitiesGen> genList = GetGenList(oldList, CodeTypeDb.GetList(), tableDb.CurrentConnectionConfig.DbType);
foreach (var item in genList)
{
item.PropertyGens = item.PropertyGens.Where(it => it.IsIgnore == false).ToList();
foreach (var property in item.PropertyGens)
{
if (property.IsSpecialType)
{
property.Type = "string";
}
}
}
string key = TemplateHelper.EntityKey + SyntaxTreeHelper.TemplateString.GetHashCode();
foreach (var item in genList)
{
var classString = TemplateHelper.GetTemplateValue(key, SyntaxTreeHelper.TemplateString, item);
var type = SyntaxTreeHelper.GetModelTypeByClass(classString, item.ClassName);
tableDb.CurrentConnectionConfig.ConfigureExternalServices = new ConfigureExternalServices()
{
EntityNameService = (type, info) =>
{
if (info.EntityName == item.ClassName || (info.EntityName == null && info.DbTableName == item.ClassName))
{
info.EntityName = item.ClassName;
info.DbTableName = item.TableName;
info.TableDescription = item.Description;
}
},
EntityService = (type, info) =>
{
if (info.EntityName == item.ClassName)
{
var column = item.PropertyGens.FirstOrDefault(it => it.PropertyName == info.PropertyName);
info.DbColumnName = column.DbColumnName;
info.ColumnDescription = column.Description;
info.IsNullable = column.IsNullable;
info.Length = Convert.ToInt32(column.Length);
info.DecimalDigits = Convert.ToInt32(column.DecimalDigits);
info.IsPrimarykey = column.IsPrimaryKey;
info.IsIdentity = column.IsIdentity;
info.IsIgnore = column.IsIgnore;
info.DataType = column.DbType;
if (tableDb.CurrentConnectionConfig.DbType == DbType.Sqlite && info.IsIdentity)
{
info.DataType = "integer";
}
}
}
};
tableDb.CodeFirst.InitTables(type);
}
}
result.IsSuccess = true;
return(result);
}
