public ActionResult LookCode(string baseInfoJson, string gridInfoJson, string gridColumnJson, string formInfoJson, string formFieldJson)
{
SingleTable default_Template = new SingleTable();
BaseConfigModel baseConfigModel = baseInfoJson.ToObject <BaseConfigModel>();
baseConfigModel.gridModel = gridInfoJson.ToObject <GridModel>();
baseConfigModel.gridColumnModel = gridColumnJson.ToList <GridColumnModel>();
baseConfigModel.formModel = formInfoJson.ToObject <FormModel>();
baseConfigModel.formFieldModel = formFieldJson.ToList <FormFieldModel>();
var tableFiled = new DataBaseTableBLL().GetTableFiledList(baseConfigModel.DataBaseLinkId, baseConfigModel.DataBaseTableName);
string entitybuilder = default_Template.EntityBuilder(baseConfigModel, DataHelper.ListToDataTable <DataBaseTableFieldEntity>(tableFiled.ToList()));
string entitymapbuilder = default_Template.EntityMapBuilder(baseConfigModel);
string servicebuilder = default_Template.ServiceBuilder(baseConfigModel);
string iservicebuilder = default_Template.IServiceBuilder(baseConfigModel);
string businesbuilder = default_Template.BusinesBuilder(baseConfigModel);
string controllerbuilder = default_Template.ControllerBuilder(baseConfigModel);
string indexbuilder = default_Template.IndexBuilder(baseConfigModel);
string formbuilder = default_Template.FormBuilder(baseConfigModel);
var jsonData = new
{
entityCode = entitybuilder,
entitymapCode = entitymapbuilder,
serviceCode = servicebuilder,
iserviceCode = iservicebuilder,
businesCode = businesbuilder,
controllerCode = controllerbuilder,
indexCode = indexbuilder,
formCode = formbuilder
};
return(ToJsonResult(jsonData));
}
public ActionResult LookCode(BaseConfigModel r)
{
ServiceClass default_Template = new ServiceClass();
BaseConfigModel baseConfigModel = r;
var tableFiled = new DataBaseTableBLL().GetTableFiledList(baseConfigModel.DataBaseLinkId, baseConfigModel.DataBaseTableName);
string entitybuilder = default_Template.EntityBuilder(baseConfigModel, DataHelper.ListToDataTable <DataBaseTableFieldEntity>(tableFiled.ToList()));
string entitymapbuilder = default_Template.EntityMapBuilder(baseConfigModel);
string servicebuilder = default_Template.ServiceBuilder(baseConfigModel);
string iservicebuilder = default_Template.IServiceBuilder(baseConfigModel);
string businesbuilder = default_Template.BusinesBuilder(baseConfigModel);
var jsonData = new
{
entityCode = entitybuilder,
entitymapCode = entitymapbuilder,
serviceCode = servicebuilder,
iserviceCode = iservicebuilder,
businesCode = businesbuilder,
};
return(ToJsonResult(jsonData));
}
public ActionResult LookCode(string baseInfoJson, string gridInfoJson, string gridColumnJson, string formInfoJson, string formFieldJson)
{
SingleTable default_Template = new SingleTable();
BaseConfigModel baseConfigModel = baseInfoJson.ToObject <BaseConfigModel>();
baseConfigModel.gridModel = gridInfoJson.ToObject <GridModel>();
baseConfigModel.gridColumnModel = gridColumnJson.ToList <GridColumnModel>();
baseConfigModel.formModel = formInfoJson.ToObject <FormModel>();
baseConfigModel.formFieldModel = formFieldJson.ToList <FormFieldModel>();
var tableFiled = new DataBaseTableBLL(baseConfigModel.DataBaseLinkId).GetTableFiledList(baseConfigModel.DataBaseLinkId, baseConfigModel.DataBaseTableName);
baseConfigModel.DataBaseLinkName = "";
DataBaseLinkEntity dataBaseLinkEntity = new DataBaseLinkBLL().GetEntity(baseConfigModel.DataBaseLinkId);
string connectionString = ConfigurationManager.ConnectionStrings["BaseDb"].ConnectionString;
if (connectionString != dataBaseLinkEntity.F_DbConnection)
{
baseConfigModel.DataBaseLinkName = dataBaseLinkEntity.F_DBName;
baseConfigModel.DataBaseLinkType = dataBaseLinkEntity.F_DbType;
if (ConfigurationManager.ConnectionStrings[dataBaseLinkEntity.F_DBName] == null)
{
string providerName = "System.Data.SqlClient";
if (dataBaseLinkEntity.F_DbType == "MySql")
{
providerName = "MySql.Data.MySqlClient";
}
else if (dataBaseLinkEntity.F_DbType == "Oracle")
{
providerName = "Oracle.ManagedDataAccess.Client";
}
Config.UpdateOrCreateConnectionString("XmlConfig\\database.config", dataBaseLinkEntity.F_DBName, dataBaseLinkEntity.F_DbConnection, providerName);
}
}
string entitybuilder = default_Template.EntityBuilder(baseConfigModel, DataHelper.ListToDataTable <DataBaseTableFieldEntity>(tableFiled.ToList()));
string entitymapbuilder = default_Template.EntityMapBuilder(baseConfigModel);
string servicebuilder = default_Template.ServiceBuilder(baseConfigModel);
string iservicebuilder = default_Template.IServiceBuilder(baseConfigModel);
string businesbuilder = default_Template.BusinesBuilder(baseConfigModel);
string controllerbuilder = default_Template.ControllerBuilder(baseConfigModel);
string indexbuilder = default_Template.IndexBuilder(baseConfigModel);
string formbuilder = default_Template.FormBuilder(baseConfigModel);
var jsonData = new
{
entityCode = entitybuilder,
entitymapCode = entitymapbuilder,
serviceCode = servicebuilder,
iserviceCode = iservicebuilder,
businesCode = businesbuilder,
controllerCode = controllerbuilder,
indexCode = indexbuilder,
formCode = formbuilder
};
return(ToJsonResult(jsonData));
}
public ActionResult GetTableDataListJson(string dataBaseLinkId, string tableName, string switchWhere, string logic, string keyword, Pagination pagination)
{
var watch = CommonHelper.TimerStart();
var data = new DataBaseTableBLL(dataBaseLinkId).GetTableDataList(dataBaseLinkId, tableName, switchWhere, logic, keyword, pagination);
var JsonData = new
{
rows = data,
total = pagination.total,
page = pagination.page,
records = pagination.records,
costtime = CommonHelper.TimerEnd(watch)
};
return(ToJsonResult(JsonData));
}
public ActionResult CreateCode(BaseConfigModel baseConfigModel)
{
baseConfigModel.DataBaseLinkName = "";
DataBaseLinkEntity dataBaseLinkEntity = new DataBaseLinkBLL().GetEntity(baseConfigModel.DataBaseLinkId);
string connectionString = ConfigurationManager.ConnectionStrings["BaseDb"].ConnectionString;
if (connectionString != dataBaseLinkEntity.F_DbConnection)
{
baseConfigModel.DataBaseLinkName = dataBaseLinkEntity.F_DBName;
baseConfigModel.DataBaseLinkType = dataBaseLinkEntity.F_DbType;
}
string[] tableNameLists = baseConfigModel.DataBaseTableName.Split(',');
string[] tablePkLists = baseConfigModel.DataBaseTablePK.Split(',');
string[] tableDescriptionLists = baseConfigModel.Description.Split(',');
ServiceCode default_Template = new ServiceCode();
for (int i = 0; i < tableNameLists.Length; i++)
{
baseConfigModel.DataBaseTableName = tableNameLists[i];
baseConfigModel.DataBaseTablePK = tablePkLists[i];
baseConfigModel.Description = tableDescriptionLists[i];
baseConfigModel.EntityClassName = tableNameLists[i] + "Entity";
baseConfigModel.MapClassName = tableNameLists[i] + "Map";
baseConfigModel.ServiceClassName = tableNameLists[i] + "Service";
baseConfigModel.IServiceClassName = tableNameLists[i] + "IService";
baseConfigModel.BusinesClassName = tableNameLists[i] + "BLL";
var tableFiled = new DataBaseTableBLL(baseConfigModel.DataBaseLinkId).GetTableFiledList(baseConfigModel.DataBaseLinkId, baseConfigModel.DataBaseTableName);
string entitybuilder = default_Template.EntityBuilder(baseConfigModel, DataHelper.ListToDataTable <DataBaseTableFieldEntity>(tableFiled.ToList()));
string entitymapbuilder = default_Template.EntityMapBuilder(baseConfigModel);
string servicebuilder = default_Template.ServiceBuilder(baseConfigModel);
string iservicebuilder = default_Template.IServiceBuilder(baseConfigModel);
string businesbuilder = default_Template.BusinesBuilder(baseConfigModel);
var jsonData = new
{
entityCode = entitybuilder,
entitymapCode = entitymapbuilder,
serviceCode = servicebuilder,
iserviceCode = iservicebuilder,
businesCode = businesbuilder,
};
CreateCodeFile.CreateExecution(baseConfigModel, jsonData.ToJson());
}
return(Success("恭喜您，创建成功！"));
}
public ActionResult LookCode(BaseConfigModel baseConfigModel)
{
ServiceCode default_Template = new ServiceCode();
var tableFiled = new DataBaseTableBLL(baseConfigModel.DataBaseLinkId).GetTableFiledList(baseConfigModel.DataBaseLinkId, baseConfigModel.DataBaseTableName);
baseConfigModel.DataBaseLinkName = "";
DataBaseLinkEntity dataBaseLinkEntity = new DataBaseLinkBLL().GetEntity(baseConfigModel.DataBaseLinkId);
string connectionString = ConfigurationManager.ConnectionStrings["BaseDb"].ConnectionString;
if (connectionString != dataBaseLinkEntity.F_DbConnection)
{
baseConfigModel.DataBaseLinkName = dataBaseLinkEntity.F_DBName;
baseConfigModel.DataBaseLinkType = dataBaseLinkEntity.F_DbType;
if (ConfigurationManager.ConnectionStrings[dataBaseLinkEntity.F_DBName] == null)
{
string providerName = "System.Data.SqlClient";
if (dataBaseLinkEntity.F_DbType == "MySql")
{
providerName = "MySql.Data.MySqlClient";
}
else if (dataBaseLinkEntity.F_DbType == "Oracle")
{
providerName = "Oracle.ManagedDataAccess.Client";
}
Config.UpdateOrCreateConnectionString("XmlConfig\\database.config", dataBaseLinkEntity.F_DBName, dataBaseLinkEntity.F_DbConnection, providerName);
}
}
string entitybuilder = default_Template.EntityBuilder(baseConfigModel, DataHelper.ListToDataTable <DataBaseTableFieldEntity>(tableFiled.ToList()));
string entitymapbuilder = default_Template.EntityMapBuilder(baseConfigModel);
string servicebuilder = default_Template.ServiceBuilder(baseConfigModel);
string iservicebuilder = default_Template.IServiceBuilder(baseConfigModel);
string businesbuilder = default_Template.BusinesBuilder(baseConfigModel);
var jsonData = new
{
entityCode = entitybuilder,
entitymapCode = entitymapbuilder,
serviceCode = servicebuilder,
iserviceCode = iservicebuilder,
businesCode = businesbuilder,
};
return(ToJsonResult(jsonData));
}
public ActionResult GetTableFiledTreeJson(string dataBaseLinkId, string tableName, string nameId)
{
List <string> nameArray = new List <string>();
if (!string.IsNullOrEmpty(nameId))
{
nameArray = new List <string>(nameId.Split(','));
}
var data = new DataBaseTableBLL(dataBaseLinkId).GetTableFiledList(dataBaseLinkId, tableName);
var treeList = new List <TreeEntity>();
TreeEntity tree = new TreeEntity();
tree.id = tableName;
tree.text = tableName;
tree.value = tableName;
tree.parentId = "0";
tree.img = "fa fa-list-alt";
tree.isexpand = true;
tree.complete = true;
tree.hasChildren = true;
treeList.Add(tree);
foreach (DataBaseTableFieldEntity item in data)
{
tree = new TreeEntity();
tree.id = item.f_column;
tree.text = item.f_remark + "（" + item.f_column + "）";
tree.value = item.f_remark;
tree.parentId = tableName;
tree.img = "fa fa-wrench";
tree.isexpand = true;
tree.complete = true;
tree.showcheck = true;
tree.checkstate = nameArray.Contains(item.f_column) == true ? 1 : 0;
tree.hasChildren = false;
tree.Attribute = "type";
tree.AttributeValue = CommHelper.FindModelsTypeEx(item.f_datatype);
treeList.Add(tree);
}
return(Content(treeList.TreeToJson()));
}
public ActionResult GetTableListJson(string dataBaseLinkId, string keyword)
{
var data = new DataBaseTableBLL(dataBaseLinkId).GetTableList(dataBaseLinkId, keyword);
return(ToJsonResult(data));
}
public ActionResult GetTableFiledListJson(string dataBaseLinkId, string tableName)
{
var data = new DataBaseTableBLL(dataBaseLinkId).GetTableFiledList(dataBaseLinkId, tableName);
return(ToJsonResult(data));
}
public ActionResult LookCode(string baseInfoJson, string gridPrimaryFieldJson, string gridDetailsFieldJson, string formPrimaryFieldJson, string formDetailsFieldJson)
{
MultiTableConfigModel multiTableConfigModel = baseInfoJson.ToObject <MultiTableConfigModel>();
var gridPrimary = gridPrimaryFieldJson.ToList <GridColumnModel>();
var gridDetails = gridDetailsFieldJson.ToList <GridColumnModel>();
var formPrimary = formPrimaryFieldJson.ToList <FormFieldModel>();
var formDetails = formDetailsFieldJson.ToList <FormFieldModel>();
var tablePrimaryFields = new DataBaseTableBLL(multiTableConfigModel.DataBaseLinkId).GetTableFiledList(multiTableConfigModel.DataBaseLinkId, multiTableConfigModel.DataBaseTableName);
var tableDetailsFields = new DataBaseTableBLL(multiTableConfigModel.DataBaseLinkId).GetTableFiledList(multiTableConfigModel.DataBaseLinkId, multiTableConfigModel.ChildTableName);
DataBaseLinkEntity dataBaseLinkEntity = new DataBaseLinkBLL().GetEntity(multiTableConfigModel.DataBaseLinkId);
string connectionString = ConfigurationManager.ConnectionStrings["BaseDb"].ConnectionString;
if (connectionString != dataBaseLinkEntity.F_DbConnection)
{
if (ConfigurationManager.ConnectionStrings[multiTableConfigModel.DataBaseName] == null)
{
multiTableConfigModel.DataBaseName = dataBaseLinkEntity.F_DBName;
multiTableConfigModel.DataBaseType = dataBaseLinkEntity.F_DbType;
string providerName = "System.Data.SqlClient";
if (dataBaseLinkEntity.F_DbType == "MySql")
{
providerName = "MySql.Data.MySqlClient";
}
else if (dataBaseLinkEntity.F_DbType == "Oracle")
{
providerName = "Oracle.ManagedDataAccess.Client";
}
Config.UpdateOrCreateConnectionString("XmlConfig\\database.config", dataBaseLinkEntity.F_DBName, dataBaseLinkEntity.F_DbConnection, providerName);
}
}
else
{
multiTableConfigModel.DataBaseName = "";
}
MultiTable multiTable = new MultiTable();
string entitybuilder = multiTable.EntityBuilder(multiTableConfigModel, DataHelper.ListToDataTable <DataBaseTableFieldEntity>(tablePrimaryFields.ToList()), false); //主表实体
string childEntitybuilder = multiTable.EntityBuilder(multiTableConfigModel, DataHelper.ListToDataTable <DataBaseTableFieldEntity>(tableDetailsFields.ToList()), true); //子表实体
string entitymapbuilder = multiTable.EntityMapBuilder(multiTableConfigModel, false); //实体映射类
string childEntitymapbuilder = multiTable.EntityMapBuilder(multiTableConfigModel, true);
//服务类
string servicebuilder = multiTable.ServiceBuilder(multiTableConfigModel, gridPrimary);
//服务接口类
string iservicebuilder = multiTable.IServiceBuilder(multiTableConfigModel);
//业务类
string businesbuilder = multiTable.BusinesBuilder(multiTableConfigModel);
//控制器
string controllerbuilder = multiTable.ControllerBuilder(multiTableConfigModel);
//主页面
string indexbuilder = multiTable.IndexBuilder(multiTableConfigModel, gridPrimary, gridDetails);
//表单页面
string formbuilder = multiTable.FormBuilder(multiTableConfigModel, formPrimary, formDetails);
var jsonData = new
{
entityCode = entitybuilder,
entityChildCode = childEntitybuilder,
entitymapCode = entitymapbuilder,
entitymapChildCode = childEntitymapbuilder,
serviceCode = servicebuilder,
iserviceCode = iservicebuilder,
businesCode = businesbuilder,
controllerCode = controllerbuilder,
indexCode = indexbuilder,
formCode = formbuilder
};
return(ToJsonResult(jsonData));
}
