public IActionResult Assortment()
{
// ◆遷移元URL情報
string host = Request.Host.ToString();
string domain = host.Split(".")[0];
string parameter = "?";
try
{
string path = hostingEnvironment.ContentRootPath + "/DomainAccess.xml";
XmlRoot xmlData = PXCL_com.LoadXmlData <XmlRoot>(path);
foreach (DomainCL DomainData in xmlData.Domain)
{
if (DomainData.DomainName == domain)
{
parameter += "SysURL=" + DomainData.SysURL;
parameter += "&DomainType=" + DomainData.DomainType;
parameter += "&SysDB=" + "";
}
}
}
catch (Exception ex)
{
string LogTitle = "ドメイン判定処理";
string LogMsg = "エラー「" + ex.Message + "」";
PXCL_log.writeLog(PXCL_log.ERR, PXCL_log.SELECT, LogTitle, LogMsg, System.Reflection.MethodBase.GetCurrentMethod(), new PX_COMMON());
}
parameter += "SysURL=" + "test1";
parameter += "&SysDB=" + "KN";
parameter += "&DomainType=" + "PJ3_Next_PXAPI_";
return(Redirect("~/PXAS/PXAS0000/PXAS0000VW" + parameter));
}
/// <summary>
/// メニュー一覧取得
/// </summary>
public JsonData GetMenuList()
{
JsonData loadData = new JsonData();
StringBuilder cmdTxt = new StringBuilder();
PXCL_dba dbAccess = new PXCL_dba(PXCL_dba.ConnectionSystem, PX_COMMONData);
RowChildDataJson jsonDataChild = new RowChildDataJson();
int setLv01 = 0;
int setLv02 = 0;
try
{
loadData.RowData = new List <RowDataJson>();
// データベース接続
dbAccess.DBConect();
// ◆SELECT文の設定
cmdTxt.AppendLine("SELECT");
cmdTxt.AppendLine(" WEB.MENULV01,");
cmdTxt.AppendLine(" WEB.MENULV02,");
cmdTxt.AppendLine(" WEB.MENULV03,");
cmdTxt.AppendLine(" WEB.CALLTP,");
cmdTxt.AppendLine(" PRG.LIBNM,");
cmdTxt.AppendLine(" WEB.SUBCMM,");
cmdTxt.AppendLine(" WEB.MENUICON1,");
cmdTxt.AppendLine(" WEB.MENUNM,");
cmdTxt.AppendLine(" WEB.MENUICON2,");
cmdTxt.AppendLine(" WEB.MENUICON3,");
cmdTxt.AppendLine(" WEB.WEBCMM");
cmdTxt.AppendLine("FROM P3AS_MENU_WEB AS WEB");
cmdTxt.AppendLine("LEFT JOIN P3AS_PROGRAM AS PRG ON PRG.PRGID = WEB.PROGRAMID");
cmdTxt.AppendLine("WHERE WEB.MENUID = @MENUID");
cmdTxt.AppendLine("ORDER BY WEB.MENUID, WEB.MENULV01, WEB.MENULV02, WEB.MENULV03");
// ◆パラメータ設定
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.Parameters.Add("@MENUID", SqlDbType.VarChar).Value = PX_COMMONData.MENUID;
// ◆SELECT文実行
using (SqlDataReader res = dbAccess.SQLSelectParameter(cmdTxt.ToString(), sqlCmd))
{
if (res != null && res.HasRows)
{
while (res.Read())
{
int menuLv01 = (Int16)res["MENULV01"];
int menuLv02 = (Int16)res["MENULV02"];
string libNm = res["LIBNM"] as string;
string callTp = res["CALLTP"] as string;
string subCmm = res["SUBCMM"] as string;
string menuNm = res["MENUNM"] as string;
string webCmm = res["WEBCMM"] as string;
string menuIcon1 = res["MENUICON1"] as string;
string menuIcon2 = res["MENUICON2"] as string;
string menuIcon3 = res["MENUICON3"] as string;
if (setLv01 != menuLv01)
{
RowDataJson jsonData = new RowDataJson();
setLv01 = menuLv01;
setLv02 = 0;
jsonData.ChildData = new List <RowChildDataJson>();
jsonData.ChildRowID = setLv01.ToString();
jsonData.ChildRowURL = libNm;
switch (callTp)
{
case "URL":
jsonData.ChildRowURLType = "0";
break;
case "OUT":
jsonData.ChildRowURLType = "1";
break;
default:
jsonData.ChildRowURLType = "";
break;
}
jsonData.ChildRowTitle = subCmm;
jsonData.ChildRowCSS = menuIcon1;
jsonData.ChildRowContent = menuNm;
jsonData.ChildRowAfterCSS = menuIcon2;
jsonData.ChildRowAfterTxt = "";
jsonData.ParentClass = "";
loadData.RowData.Add(jsonData);
}
else if (setLv02 != menuLv02)
{
jsonDataChild = new RowChildDataJson();
setLv02 = menuLv02;
jsonDataChild.ChildRowID = setLv01 + "_" + setLv02;
jsonDataChild.ChildRowURL = libNm;
switch (callTp)
{
case "URL":
jsonDataChild.ChildRowURLType = "0";
break;
case "OUT":
jsonDataChild.ChildRowURLType = "1";
break;
default:
jsonDataChild.ChildRowURLType = "";
break;
}
jsonDataChild.ChildRowTitle = subCmm;
jsonDataChild.ChildRowCSS = menuIcon1;
jsonDataChild.ChildRowContent = menuNm;
jsonDataChild.ChildRowAfterCSS = menuIcon2;
jsonDataChild.ChildRowAfterTxt = "";
jsonDataChild.ParentClass = "";
jsonDataChild.ChildRowImage = menuIcon3;
jsonDataChild.ChildRowComment = webCmm;
RowDataJson jsonData = loadData.RowData[(loadData.RowData.Count() - 1)];
jsonData.ChildData.Add(jsonDataChild);
loadData.RowData[(loadData.RowData.Count() - 1)] = jsonData;
}
}
}
}
}
}
catch (Exception Exc)
{
string logTitle = "メニュー一覧取得";
string logMsg = "エラー「" + Exc.Message + "」";
PXCL_log.writeLog(PXCL_log.ERR, PXCL_log.LOGIN, logTitle, logMsg, System.Reflection.MethodBase.GetCurrentMethod(), PX_COMMONData);
}
finally
{
if (dbAccess != null)
{
// データベースの接続解除
dbAccess.DBClose();
}
}
return(loadData);
}
