public IActionResult GetSqlTableDetails(string TableName, string ProcName)
{
DynamicParameters dy = new DynamicParameters();
DataTable TableDetails = new DataTable();
List <ModelEntityDto> list = new List <ModelEntityDto>();
if (TableName != "RPG_Proc_Report")
{
dy.Add("TableName", TableName);
TableDetails = DapperHelper.ExcuteProduce("TableDetails", dy);
}
else
{
dy.Add("TableName", ProcName);
TableDetails = DapperHelper.ExcuteProduce("GetProcDetails", dy);
ModelEntityDto modelEntity = new ModelEntityDto();
//序号
modelEntity.txt_Number = 1;
//列名
modelEntity.columnName = ProcName;
//默认值
modelEntity.defaultValue = ProcName;
//显示名称
modelEntity.displayShowName = "存储过程名称";
//是否下拉框
modelEntity.isCombobox = "N";
//是否禁用
modelEntity.isDisable = "N";
//是否必填
modelEntity.isRequest = "N";
//跨行
modelEntity.columnSpan = 1;
//隐藏显示
modelEntity.isShow = "Y";
list.Add(modelEntity);
}
foreach (DataRow item in TableDetails.Rows)
{
ModelEntityDto modelEntity = new ModelEntityDto();
//序号
modelEntity.txt_Number = (list.Count + 1);
//列名
modelEntity.columnName = item[1].ToString();
//默认值
modelEntity.defaultValue = (string)item[2];
//显示名称
modelEntity.displayShowName = (string)item[3];
//是否下拉框
modelEntity.isCombobox = "N";
//是否禁用
modelEntity.isDisable = "N";
//是否必填
modelEntity.isRequest = "N";
//跨行
modelEntity.columnSpan = 1;
//隐藏显示
modelEntity.isShow = "Y";
list.Add(modelEntity);
}
return(Json(list));
}
public IActionResult Edit(string Query)
{
ModelEntityDto entityDto = JsonConvert.DeserializeObject <ModelEntityDto>(Query);
return(View(entityDto));
}