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)); }