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 <GridColumnModel>();
var formDetails = formDetailsFieldJson.ToList <GridColumnModel>();
MultiTable multiTable = new MultiTable();
string entitybuilder = multiTable.EntityBuilder(multiTableConfigModel, gridPrimary, false); //主表实体
string childEntitybuilder = multiTable.EntityBuilder(multiTableConfigModel, gridDetails, true); //子表实体
string entitymapbuilder = multiTable.EntityMapBuilder(multiTableConfigModel, false); //实体映射类
string childEntitymapbuilder = multiTable.EntityMapBuilder(multiTableConfigModel, true);
//服务类
string servicebuilder = multiTable.ServiceBuilder(multiTableConfigModel);
//服务接口类
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));
}
public ActionResult GetSportsList(int SLid)
{
MajorProjectEntities sd = new MajorProjectEntities();
var mymodel = new MultiTable();
mymodel.reg1 = sd.Sport_tournamentlist.ToList();
mymodel.reg2 = sd.Cultural_eventlist.ToList();
if (SLid == 1)
{
ViewBag.Sportslist = new SelectList(sd.Sport_tournamentlist, "sports_evid", "sport_name");
ViewBag.Message = "sport";
}
else
{
ViewBag.Sportslist = new SelectList(sd.Cultural_eventlist, "cul_evid", "event_name");
ViewBag.Message = "event";
}
return(PartialView("DisplaySportsList"));
}
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));
}
