private string[] GetDBAccessInfoFromXML(ref PX_COMMON PX_COMMONData)
{
string[] syspara = new string[] { "", "", "" };
// Configファイルの読込み
string path = hostingEnvironment.ContentRootPath + "/DBConnect.xml";
XmlRoot xmlData = PXLIB.PXCL_com.LoadXmlData <XmlRoot>(path);
foreach (var item in xmlData.Domain)
{
if (ms_DomainHost == item.DomainName)
{
PX_COMMONData.SYSDBSVRNM = item.SVRName;
PX_COMMONData.SYSDBSVRIP = item.SVRIP;
PX_COMMONData.SYSDBNM = item.DBName;
PX_COMMONData.SYSDBSVRUR = item.DBUser;
PX_COMMONData.SYSDBSVRPW = item.DBPass;
PX_COMMONData.COPCD = item.COPCD;
syspara[0] = item.SYSPARAID1;
syspara[1] = item.SYSPARAID2;
syspara[2] = item.SYSPARAID3;
break;
}
}
return(syspara);
}
/// <summary>
/// Login準備２
/// </summary>
/// <param name="BrowserType">起動元判定</param>
/// <param name="SelectedLanguage">選択された言語</param>
/// <returns></returns>
public PX_PJ3CONFIG PrepareLogin(string BrowserType, string SelectedLanguage)
{
PX_COMMON PX_COMMONData = new PX_COMMON();
string[] syspara = GetDBAccessInfoFromXML(ref PX_COMMONData);
//* 事前準備(DBより情報取得) *//
// PJ3SystemConfig(SysPara)の取得
PX_PJ3CONFIG sysParaList = new PX_PJ3CONFIG();
try
{
sysParaList = PXLIB.PXCL_com.GetPJ3Config(syspara, ref PX_COMMONData);
if (PX_COMMONData.ERRORCODE != "")
{
PX_COMMONData.ERRORMSG = string.Format(ms_dlgErrMsgFormat, PX_COMMONData.ERRORCODE, PX_COMMONData.ERRORCODE);
return(new PX_PJ3CONFIG());
}
if (SelectedLanguage == null)
{
SelectedLanguage = "1041";
// TEST
}
sysParaList = PXLIB.PXCL_com.GetLoginCaption(SelectedLanguage, sysParaList, PX_COMMONData);
sysParaList.PAGETP = ms_DomainTP;
}
catch
{
PX_COMMONData.ERRORCODE = "PXERR300";
PX_COMMONData.ERRORMSG = string.Format(ms_dlgErrMsgFormat, PX_COMMONData.ERRORCODE);
return(new PX_PJ3CONFIG());
}
return(sysParaList);
}
public String GetDialogData(JsonGetDialogData data)
{
string result = "";
string path = _hostingEnvironment.ContentRootPath + "/DBConnect.xml";
XmlRoot xmlData = PXCL_com.LoadXmlData <XmlRoot>(path);
//PX_COMMON PX_COMMONData = SetSysDB(_appSettings.Value, Request, data);
PX_COMMON PX_COMMONData = new PX_COMMON();
result = PXCL_com.GetDialogIndication(data.COPCD, data.SNDMSGKBN, data.SNDMSGNO, PX_COMMONData);
return(result);
}
private PX_COMMON GetErrMessageForDialog(string errcode, PX_COMMON pX_COMMON)
{
//ToDo: SNDMSGKBN部分入れ替え
pX_COMMON.ERRORCODE = errcode;
string SNDMSGKBN = "";
if (errcode.Contains("SYSTEM"))
{
SNDMSGKBN = "SYSTEM";
}
else
{
SNDMSGKBN = "PXAS0000WP";
}
pX_COMMON.ERRORMSG = PXLIB.PXCL_com.GetDialogIndication(pX_COMMON.COPCD, SNDMSGKBN, pX_COMMON.ERRORCODE, pX_COMMON);
return(pX_COMMON);
}
/// <summary>
/// Login準備1（画面生成に必要な最低限の情報を取得する）
/// </summary>
/// <returns></returns>
public List <PX_LANGUAGE> PrepareStartView()
{
PX_COMMON PX_COMMONData = new PX_COMMON();
string[] syspara = GetDBAccessInfoFromXML(ref PX_COMMONData);
//* 事前準備(DBより情報取得) *//
// システムDBへの接続
// PJ3SystemConfig(SysPara)の取得
PXLIB.PXCL_dba cnn = null;
List <PX_LANGUAGE> LangList = new List <PX_LANGUAGE>
{
new PX_LANGUAGE("JPN")
};
try
{
// DBへの接続確認
cnn = new PXLIB.PXCL_dba(PXLIB.PXCL_dba.ConnectionSystem, PX_COMMONData);
if (cnn.DBConect() != "")
{
PX_COMMONData.ERRORCODE = "PXERR301";
PX_COMMONData.ERRORMSG = string.Format(ms_dlgErrMsgFormat, PX_COMMONData.ERRORCODE);
return(LangList);
}
cnn.DBClose();
PX_PJ3CONFIG sysParaList = PXLIB.PXCL_com.GetPJ3Config(syspara, ref PX_COMMONData);
if (PX_COMMONData.ERRORCODE != "")
{
PX_COMMONData.ERRORMSG = string.Format(ms_dlgErrMsgFormat, PX_COMMONData.ERRORCODE, PX_COMMONData.ERRORCODE);
return(LangList);
}
LangList = PXLIB.PXCL_com.GetLanguageList(sysParaList.DEFLANG, PX_COMMONData);
}
catch
{
PX_COMMONData.ERRORCODE = "PXERR300";
PX_COMMONData.ERRORMSG = string.Format(ms_dlgErrMsgFormat, PX_COMMONData.ERRORCODE);
}
return(LangList);
}
public PX_COMMON UserAuthenticationProcess(string userid, string pass)
{
// ログイン情報の取得
//* ユーザー認証 *//
PX_COMMON PX_COMMONData = new PX_COMMON();
string[] syspara = GetDBAccessInfoFromXML(ref PX_COMMONData);
// For Debug Only
if (userid == null)
{
userid = "1600008"; pass = "******";
//userid = "*****@*****.**";pass = "******";
}
List <string> passinfo = PXLIB.PXCL_com.GetUserKeyInfo(userid, ref PX_COMMONData);
if (PX_COMMONData.ERRORCODE != "")
{
// エラーメッセージ生成
return(GetErrMessageForDialog("PASSERR-02", PX_COMMONData));
}
string nowdateOT = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss");
string nowdate = DateTime.Today.ToString("yyyyMMdd");
if (passinfo[0].Length == 0)
{
// 通常のユーザー
// 未入力時
if (pass.Trim().Length == 0)
{
if (passinfo[3] == "YES")
{
if (passinfo[4].CompareTo(nowdate) < 0)
{
// 有効期限切れ
return(GetErrMessageForDialog("PASSERR - 01", PX_COMMONData));
}
}
else
{
return(GetErrMessageForDialog("PASSERR - 01", PX_COMMONData));
}
}
else
{
// 入力あり
if (pass == passinfo[4])
{
if (passinfo[5] != "00000000")
{
if (passinfo[5].CompareTo(nowdate) < 0)
{
// 期限切れ
return(GetErrMessageForDialog("PASSERR - 02", PX_COMMONData));
}
else
{
if (passinfo[6] != "00000000")
{
if (passinfo[6].CompareTo(nowdate) < 0)
{
// 警告なので処理続行
PX_COMMONData = GetErrMessageForDialog("PASSALM - 01", PX_COMMONData);
}
}
}
}
}
else
{
// パスワードUnMatch
return(GetErrMessageForDialog("PASSERR - 01", PX_COMMONData));
}
}
}
else
{
// *ワンタイムユーザー* //
// パスワード未入力
if (pass.Trim().Length == 0)
{
return(GetErrMessageForDialog("PASSERR - 01", PX_COMMONData));
}
else
{
if (pass == passinfo[0])
{
// 有効期限チェック
if (passinfo[1] != "")
{
if (passinfo[1].CompareTo(nowdateOT) < 0)
{
// 期限切れ
return(GetErrMessageForDialog("PASSERR - 02", PX_COMMONData));
}
}
if (passinfo[2] != "")
{
if (passinfo[2].CompareTo(nowdateOT) < 0)
{
// 警告期限切れ（警告なので処理続行）
PX_COMMONData = GetErrMessageForDialog("PASSALM-01", PX_COMMONData);
}
}
}
else
{
// パスワードUnMatch
return(GetErrMessageForDialog("PASSERR - 01", PX_COMMONData));
}
}
}
// LoginOK
PX_COMMONData.DEFCOPTP = passinfo[7];
switch (passinfo[7])
{
case "DEF":
PX_COMMONData.COPCD = passinfo[8];
break;
case "END":
PX_COMMONData.COPCD = passinfo[9];
break;
default:
// ToDo
break;
}
// ユーザーファイル(制御)情報読込み
PX_COMMONData = PXLIB.PXCL_com.GetUserCTL(PX_COMMONData);
// ユーザーファイル(オプション)情報読込みー今は不要
//PXLIB.PXCL_com.GetUserOPT(PX_COMMONData);
// システム情報(ユーザーDB情報)
PX_COMMONData = PXLIB.PXCL_com.GetSystemParam(PX_COMMONData);
// ユーザーDBへの接続確認
PXLIB.PXCL_dba cnn = new PXLIB.PXCL_dba(PXLIB.PXCL_dba.ConnectionUser, PX_COMMONData);
if (cnn.DBConect() != "")
{
return(GetErrMessageForDialog("SYSERR-00", PX_COMMONData));
}
cnn.DBClose();
int mcount = PXLIB.PXCL_com.GetCopMasterCount(PX_COMMONData);
if (mcount == 0)
{
return(GetErrMessageForDialog("SYSERR-00", PX_COMMONData));
}
string status = PXLIB.PXCL_com.GetSystemProcessingStatus(PX_COMMONData);
switch (status)
{
case "NOT":
return(GetErrMessageForDialog("SYSERR-11", PX_COMMONData));
case "MNT":
return(GetErrMessageForDialog("SYSERR-12", PX_COMMONData));
case "000":
break;
default:
return(GetErrMessageForDialog("SYSERR-10", PX_COMMONData));
}
PXLIB.PXCL_com.UpdateLoginStatus(PX_COMMONData);
return(PX_COMMONData);
}
public List <RowData> CreateMenu(PX_COMMON data)
{
System.IO.Path.GetTempPath();
// log設定
//String logPass = HttpContext.Current.Server.MapPath("~/App_Data/log4net.xml");
//log4net.Config.XmlConfigurator.Configure(new System.IO.FileInfo(logPass));
StringBuilder LogMsg = new StringBuilder();
log4net.ILog Lg4nLogger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
PXAS0010CW PXAS0010Data = new PXAS0010CW();
PXAS0010Data.PX_COMMONData = data;
JsonData loadData = new JsonData();
loadData.RowData = new List <RowDataJson>();
try
{
loadData = PXAS0010Data.GetMenuList();
#region
//RowDataJson jsonData = new RowDataJson();
//RowChildDataJson jsonDataChild = new RowChildDataJson();
//jsonData.ChildData = new List<RowChildDataJson>();
//jsonData.ChildRowURL = "#";
//jsonData.ChildRowURLType = "";
//jsonData.ChildRowTitle = "入荷";
//jsonData.ChildRowCSS = "fa-cube";
//jsonData.ChildRowContent = "入荷";
//jsonData.ChildRowAfterCSS = "";
//jsonData.ChildRowAfterTxt = "";
//jsonData.ParentClass = "";
//jsonDataChild = new RowChildDataJson();
//jsonDataChild.ChildRowURL = "LNAS/LNAS0000/Test1";
//jsonDataChild.ChildRowURLType = "0";
//jsonDataChild.ChildRowTitle = "入荷予定入力";
//jsonDataChild.ChildRowCSS = "";
//jsonDataChild.ChildRowContent = "入荷予定入力";
//jsonDataChild.ChildRowAfterCSS = "";
//jsonDataChild.ChildRowAfterTxt = "";
//jsonDataChild.ParentClass = "";
//jsonDataChild.ChildRowImage = "icon_01.png";
//jsonDataChild.ChildRowComment = "入荷予定情報の登録";
//jsonData.ChildData.Add(jsonDataChild);
//jsonDataChild = new RowChildDataJson();
//jsonDataChild.ChildRowURL = "http://localhost:8088/HBM";
//jsonDataChild.ChildRowURLType = "1";
//jsonDataChild.ChildRowTitle = "入荷予定問合せ";
//jsonDataChild.ChildRowCSS = "";
//jsonDataChild.ChildRowContent = "入荷予定問合せ";
//jsonDataChild.ChildRowAfterCSS = "";
//jsonDataChild.ChildRowAfterTxt = "";
//jsonDataChild.ParentClass = "";
//jsonDataChild.ChildRowImage = "icon_02.png";
//jsonDataChild.ChildRowComment = "入荷予定情報の検索・参照・進捗表";
//jsonData.ChildData.Add(jsonDataChild);
//loadData.RowData.Add(jsonData);
//jsonData = new RowDataJson();
//jsonData.ChildData = new List<RowChildDataJson>();
//jsonData.ChildRowURL = "#";
//jsonData.ChildRowURLType = "";
//jsonData.ChildRowTitle = "マスタ";
//jsonData.ChildRowCSS = "fa-cubes";
//jsonData.ChildRowContent = "マスタ";
//jsonData.ChildRowAfterCSS = "";
//jsonData.ChildRowAfterTxt = "";
//jsonData.ParentClass = "";
//jsonDataChild = new RowChildDataJson();
//jsonDataChild.ChildRowURL = "LNMS/LNMS0140/LNMS0140VW";
//jsonDataChild.ChildRowURLType = "0";
//jsonDataChild.ChildRowTitle = "商品マスタ";
//jsonDataChild.ChildRowCSS = "";
//jsonDataChild.ChildRowContent = "商品マスタ";
//jsonDataChild.ChildRowAfterCSS = "";
//jsonDataChild.ChildRowAfterTxt = "";
//jsonDataChild.ParentClass = "";
//jsonDataChild.ChildRowImage = "icon_16.png";
//jsonDataChild.ChildRowComment = "商品の管理（検索・商品情報編集）";
//jsonData.ChildData.Add(jsonDataChild);
//jsonDataChild = new RowChildDataJson();
//jsonDataChild.ChildRowURL = "#";
//jsonDataChild.ChildRowURLType = "";
//jsonDataChild.ChildRowTitle = "ロケ在庫移動";
//jsonDataChild.ChildRowCSS = "";
//jsonDataChild.ChildRowContent = "ロケ在庫移動";
//jsonDataChild.ChildRowAfterCSS = "";
//jsonDataChild.ChildRowAfterTxt = "";
//jsonDataChild.ParentClass = "";
//jsonDataChild.ChildRowImage = "icon_17.png";
//jsonDataChild.ChildRowComment = "ロケーション在庫の移動";
//jsonData.ChildData.Add(jsonDataChild);
//loadData.RowData.Add(jsonData);
#endregion
}
catch (Exception ex)
{
Lg4nLogger.Info("エラー：" + ex.Message);
}
List <RowData> row = new List <RowData>();
RowData rowData = new RowData();
List <String[]> childData = new List <String[]>();
int menyuCount = 0;
foreach (RowDataJson dataJson in loadData.RowData)
{
rowData = new RowData();
// 左リストメニュー部分
String id = dataJson.ChildRowID;
String url = dataJson.ChildRowURL;
String type = dataJson.ChildRowURLType;
String title = dataJson.ChildRowTitle;
String image = "";
String status = "\"" + url + "\", \"" + type + "\", \"" + id + "\", 0, \"" + title
+ "\", \"\", \"" + image + "\"";
rowData.ChildRow = "<a href='#' id='" + id + "' title='" + title + "' class='ListLink'";
rowData.ChildRow += " onclick='MenuLink(\"" + url + "\", \"" + type + "\", \"" + id + "\", 0)' >";
rowData.ChildRow += " <i class='fa fa-lg fa-fw " + dataJson.ChildRowCSS + "'></i>";
rowData.ChildRow += " <span class='menu-item-parent'>" + dataJson.ChildRowContent + "</span>";
if (dataJson.ChildRowAfterCSS != null && dataJson.ChildRowAfterCSS != "")
{
rowData.ChildRow += " <span class='" + dataJson.ChildRowAfterCSS + "'>" + dataJson.ChildRowAfterTxt + "</span>";
}
rowData.ChildRow += "</a>";
rowData.ParentClass = "" + dataJson.ParentClass;
// 中央一覧メニュー部分
rowData.ChildRowMain = "<span class='widget-icon'> <i class='fa " + dataJson.ChildRowCSS + "'></i> </span>";
rowData.ChildRowMain += "<h2 class='font-md'><strong>" + dataJson.ChildRowContent + "</strong></h2>";
Lg4nLogger.Info(loadData.RowData.Count() / 2);
if (menyuCount < loadData.RowData.Count() / 2)
{
// メニューの件数が全体の半分以下の場合は左に表示
rowData.ChildRowMainFlag = "left";
}
else
{
// メニューの件数が全体の半数を超えたら右に表示
rowData.ChildRowMainFlag = "";
}
childData = new List <String[]>();
foreach (RowChildDataJson ChildDataJson in dataJson.ChildData)
{
String[] childRow = { "", "", "" };
// 左リストメニュー部分
id = ChildDataJson.ChildRowID;
childRow[0] = "<a href='#' id='" + ChildDataJson.ChildRowID + "' title='" + ChildDataJson.ChildRowTitle + "'";
childRow[0] += " onclick='MenuLink(\"" + ChildDataJson.ChildRowURL + "\", \"" + ChildDataJson.ChildRowURLType + "\", \"" + id + "\", 1)' >";
if (ChildDataJson.ChildRowCSS != null && ChildDataJson.ChildRowCSS != "")
{
childRow[0] += "<i class='fa fa-lg fa-fw " + ChildDataJson.ChildRowCSS + "'></i>";
}
if (dataJson.ParentClass == "active")
{
childRow[0] += "<span class='menu-item-parent'>" + ChildDataJson.ChildRowContent + "</span>";
}
else
{
childRow[0] += "" + ChildDataJson.ChildRowContent;
}
if (ChildDataJson.ChildRowAfterCSS != null && ChildDataJson.ChildRowAfterCSS != "")
{
childRow[0] += " <span class='" + ChildDataJson.ChildRowAfterCSS + "'>" + ChildDataJson.ChildRowAfterTxt + "</span>";
}
childRow[0] += "</a>";
childRow[1] = "" + ChildDataJson.ParentClass;
// 中央一覧メニュー部分
childRow[2] = "<a href='#' title='" + ChildDataJson.ChildRowTitle + "' ";
childRow[2] += " onclick='MenuLink(\"" + ChildDataJson.ChildRowURL + "\", \"" + ChildDataJson.ChildRowURLType + "\", \"" + id + "\", 1)' >";
childRow[2] += "<img src='../../img/" + ChildDataJson.ChildRowImage + "'>";
childRow[2] += "<h3>" + ChildDataJson.ChildRowContent + "</h3>";
childRow[2] += "<p>" + ChildDataJson.ChildRowComment + "</p>";
childRow[2] += "</a>";
childData.Add(childRow);
}
rowData.ChildData = childData;
row.Add(rowData);
menyuCount++;
}
return(row);
}
