public GetDbNameReturn GetDbName(string dbIns, int CurUserId, string CurUserIden)
{
base.SetHeader();
CurUserIden = CPAppContext.FormatSqlPara(CurUserIden);
GetDbNameReturn re = new GetDbNameReturn();
if (this.CheckUserIden(CurUserId, CurUserIden) == false)
{
re.Result = false;
re.ErrorMsg = "系统检测到非法获取数据，请传入正确的用户会话Key与用户Id参数！";
return(re);
}
re.Result = true;
try
{
re.DbName = CPAppContext.GetDbName(dbIns);
return(re);
}
catch (Exception ex)
{
re.Result = false;
re.ErrorMsg = ex.Message.ToString();
return(re);
}
}
public GetDbInfoReturn GetDbInfo(string dbIns, int CurUserId, string CurUserIden)
{
base.SetHeader();
CurUserIden = CPAppContext.FormatSqlPara(CurUserIden);
GetDbInfoReturn re = new GetDbInfoReturn();
if (this.CheckUserIden(CurUserId, CurUserIden) == false)
{
re.Result = false;
re.ErrorMsg = "系统检测到非法获取数据，请传入正确的用户会话Key与用户Id参数！";
return(re);
}
re.Result = true;
try
{
re.DbName = CPAppContext.GetDbName(dbIns);
List <CPDbTable> tableCol = CPAppContext.GetTable(dbIns);
re.TableCol = new List <GetDbInfoReturnItem>();
tableCol.ForEach(t =>
{
GetDbInfoReturnItem i = new GetDbInfoReturnItem();
i.TableName = t.TableName;
i.PKNames = t.PKNames;
re.TableCol.Add(i);
});
List <CPDbTable> viewCol = CPAppContext.GetView(dbIns);
viewCol.ForEach(t =>
{
GetDbInfoReturnItem i = new GetDbInfoReturnItem();
i.TableName = t.TableName;
i.PKNames = t.PKNames;
re.TableCol.Add(i);
});
re.TableCol = re.TableCol.OrderBy(c => c.TableName).ToList();
return(re);
}
catch (Exception ex)
{
re.Result = false;
re.ErrorMsg = ex.Message.ToString();
return(re);
}
}
