public string GetString(COLUMN col)
{
switch (col)
{
case COLUMN.NO:
return((no + 1).ToString());
case COLUMN.TYPE:
return(StringMgr.Instance.Get(typeStringKey[(int)type]));
case COLUMN.TITLE:
return(title);
case COLUMN.STATUS:
return(StringMgr.Instance.Get(statusStringKey[(int)status]));
case COLUMN.NUM_PLAYER:
return(curPlayer.ToString() + "/" + maxPlayer.ToString());
case COLUMN.MAP_ALIAS:
return(curMapAlias);
case COLUMN.PING:
return(ping.ToString());
case COLUMN.COUNTRY:
return(CountryFilter.ToString());
case COLUMN.WPN_OPT:
return(weaponOption.ToString());
default:
return(string.Empty);
}
}
public PageElement this[COLUMN column]
{
get
{
if (_columnMap == null)
{
InitColumnMap();
}
int columnIndex = 0;
PageElement pageElement = null;
try
{
columnIndex = _columnMap[column];
}
catch (KeyNotFoundException)
{
throw new InvalidOperationException("Index was not found for: " + column);
}
try
{
pageElement = this[columnIndex];
}
catch (KeyNotFoundException)
{
throw new InvalidOperationException("Page Element was not found for: " + column);
}
return(pageElement);
}
}
public int Compare(Room arg, COLUMN sortedBy, bool ascending)
{
int num = 0;
switch (sortedBy)
{
case COLUMN.NO:
num = no.CompareTo(arg.No);
break;
case COLUMN.TYPE:
{
int num3 = (int)type;
num = num3.CompareTo((int)arg.Type);
break;
}
case COLUMN.TITLE:
num = title.CompareTo(arg.Title);
break;
case COLUMN.STATUS:
{
int num2 = (int)status;
num = num2.CompareTo((int)arg.Status);
break;
}
case COLUMN.NUM_PLAYER:
num = curPlayer.CompareTo(arg.CurPlayer);
break;
case COLUMN.MAP_ALIAS:
num = curMapAlias.CompareTo(arg.curMapAlias);
break;
case COLUMN.PING:
num = ping.CompareTo(arg.ping);
break;
case COLUMN.COUNTRY:
num = CountryFilter.CompareTo(arg.CountryFilter);
break;
case COLUMN.WPN_OPT:
num = weaponOption.CompareTo(arg.weaponOption);
break;
}
if (!ascending)
{
num = -num;
}
return(num);
}
private string Make_Sub_Query(COLUMN colColumnList, int iCurrentIndex)
{
StringBuilder strQuery = new StringBuilder();
int i;
strQuery.Append("SELECT FACTORY, MAT_ID, MAT_VER, FLOW, FLOW_SEQ_NUM, OPER, LOT_TYPE, ORDER_ID, CM_KEY_1, CM_KEY_2, CM_KEY_3, CM_KEY_4, CM_KEY_5 \n");
for (i = 0; i < colColumnList.count; i++)
{
if (i == iCurrentIndex)
{
switch (colColumnList.column[i].period)
{
case "CS1":
case "CS2":
case "CS3":
case "PS1":
case "PS2":
case "PS3":
strQuery.AppendFormat(", NVL(SUM({0}), 0) AS {1} \n", colColumnList.column[i].column_header_name.Substring(1), colColumnList.column[i].column_header_name);
break;
case "CS":
case "PS":
strQuery.AppendFormat(", NVL(SUM({0}), 0) AS {0} \n", colColumnList.column[i].column_header_name);
break;
case "CD":
case "PD":
case "CW":
case "PW":
case "CM":
case "PM":
strQuery.AppendFormat(", NVL(SUM(S1_{0}), 0) + NVL(SUM(S2_{0}), 0) + NVL(SUM(S3_{0}), 0) + NVL(SUM(S4_{0}), 0) AS {1} \n", colColumnList.column[i].column_header_name.Substring(2), colColumnList.column[i].column_header_name);
break;
}
}
else
{
strQuery.AppendFormat(", 0 AS {0} \n", colColumnList.column[i].column_header_name);
}
}
if (colColumnList.column[iCurrentIndex].column_header_name.IndexOf("BOH") > -1)
{
strQuery.Append("FROM RSUMWIPBOH \n");
}
else if (colColumnList.column[iCurrentIndex].column_header_name.IndexOf("EOH") > -1)
{
strQuery.Append("FROM RSUMWIPBOH \n");
}
else
{
strQuery.Append("FROM RSUMWIPMOV \n");
}
strQuery.Append(colColumnList.column[iCurrentIndex].query);
strQuery.Append("GROUP BY FACTORY, MAT_ID, MAT_VER, FLOW, FLOW_SEQ_NUM, OPER, LOT_TYPE, ORDER_ID, CM_KEY_1, CM_KEY_2, CM_KEY_3, CM_KEY_4, CM_KEY_5 \n");
return(strQuery.ToString());
}
private bool View_Inquiry()
{
DataTable rtDataTable = new DataTable();
StringBuilder strQuery = new StringBuilder();
COLUMN colColumn = new COLUMN();
string QueryCond = null;
string strSelectItem = null;
string strSelectValue = null;
string strTable = null;
string strGroup = null;
int iStartColumn = 2;
int i = 0;
try
{
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvFactory.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvInqName.Text);
rtDataTable = CmnFunction.oComm.SelectData("RWEBFLXINQ", "1", QueryCond);
if (rtDataTable.Rows.Count > 0)
{
strSelectItem = rtDataTable.Rows[i]["SELECT_ITEM"].ToString();
strSelectValue = rtDataTable.Rows[i]["SELECT_VALUE"].ToString();
txtGrpItem.Text = rtDataTable.Rows[i]["GROUP_ITEM"].ToString();
txtValue.Text = strSelectItem + " : " + strSelectValue;
txtFilter.Text = rtDataTable.Rows[i]["FILTER_QUERY"].ToString();
}
if (rtDataTable.Rows.Count > 0)
{
rtDataTable.Dispose();
}
switch (txtGrpItem.Text)
{
case "MAT":
strQuery.Append("SELECT MAT.MAT_ID, MAT.MAT_VER \n");
break;
case "FLOW":
strQuery.Append("SELECT FLW.FLOW, RSW.FLOW_SEQ_NUM \n");
break;
case "OPER":
strQuery.Append("SELECT OPR.OPER, OPR.OPER_DESC \n");
break;
default:
strQuery.AppendFormat("SELECT GCM.KEY_1 AS {0} \n", txtGrpItem.Text);
break;
}
QueryCond = null;
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvFactory.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvInqName.Text);
rtDataTable = CmnFunction.oComm.FillData("RWEBFLXCOL", "1", QueryCond);
if (rtDataTable.Rows.Count == 0)
{
return(false);
}
if (rtDataTable.Rows.Count > 0)
{
colColumn.column = new FLX_COLUMN[rtDataTable.Rows.Count];
colColumn.count = rtDataTable.Rows.Count;
for (i = 0; i < rtDataTable.Rows.Count; i++)
{
colColumn.column[i] = new FLX_COLUMN();
colColumn.column[i].period = rtDataTable.Rows[i]["COLUMN_PERIOD"].ToString();
colColumn.column[i].column_name = rtDataTable.Rows[i]["COLUMN_NAME"].ToString();
colColumn.column[i].column_alias_1 = rtDataTable.Rows[i]["COLUMN_ALIAS_1"].ToString();
colColumn.column[i].column_alias_2 = rtDataTable.Rows[i]["COLUMN_ALIAS_2"].ToString();
if (Make_Column_Query(ref colColumn.column[i]) == false)
{
return(false);
}
}
}
for (i = 0; i < colColumn.count; i++)
{
strQuery.AppendFormat(", NVL(SUM(RSW.{0}), 0) AS {1}_{2} \n", colColumn.column[i].column_header_name, colColumn.column[i].period, colColumn.column[i].column_name);
}
strQuery.Append("FROM ( \n");
for (i = 0; i < colColumn.count; i++)
{
strQuery.Append(Make_Sub_Query(colColumn, i));
if (i + 1 != colColumn.count)
{
strQuery.Append("UNION ALL \n");
}
}
strQuery.Append(" ) RSW, MWIPMATDEF MAT, MWIPFLWDEF FLW, MWIPOPRDEF OPR, MGCMTBLDAT GCM \n");
strQuery.Append("WHERE RSW.FACTORY = MAT.FACTORY ");
strQuery.Append(" AND RSW.MAT_ID = MAT.MAT_ID ");
strQuery.Append(" AND RSW.MAT_VER = MAT.MAT_VER ");
strQuery.Append(" AND RSW.FACTORY = FLW.FACTORY ");
strQuery.Append(" AND RSW.FLOW = FLW.FLOW ");
strQuery.Append(" AND RSW.FACTORY = OPR.FACTORY ");
strQuery.Append(" AND RSW.OPER = OPR.OPER ");
strQuery.Append(" AND RSW.FACTORY = GCM.FACTORY ");
strQuery.Append(" AND (GCM.TABLE_NAME like 'MATERIAL_GRP%' OR GCM.TABLE_NAME like 'FLOW_GRP%' OR GCM.TABLE_NAME like 'OPER_GRP%') ");
switch (strSelectItem)
{
case "MAT":
strQuery.AppendFormat(" AND MAT.MATERIAL = '{0}'", strSelectValue);
break;
case "FLOW":
strQuery.AppendFormat(" AND FLW.FLOW = '{0}'", strSelectValue);
break;
case "OPER":
strQuery.AppendFormat(" AND OPR.OPER = '{0}'", strSelectValue);
break;
default:
if (strSelectItem.LastIndexOf("MAT") > -1)
{
strSelectItem = strSelectItem.Replace("MATERIAL", "MAT");
strQuery.AppendFormat(" AND MAT.{0} = '{1}' \n", strSelectItem, strSelectValue);
}
else if (strSelectItem.LastIndexOf("FLOW") > -1)
{
strQuery.AppendFormat(" AND FLW.{0} = '{1}' \n", strSelectItem, strSelectValue);
}
else if (strSelectItem.LastIndexOf("OPER") > -1)
{
strQuery.AppendFormat(" AND OPR.{0} = '{1}' \n", strSelectItem, strSelectValue);
}
break;
}
strQuery.Append(txtFilter.Text);
switch (txtGrpItem.Text)
{
case "MAT":
strQuery.Append(" GROUP BY MAT.MAT_ID, MAT.MAT_VER \n");
break;
case "FLOW":
strQuery.Append(" GROUP BY FLW.FLOW, RSW.FLOW_SEQ_NUM \n");
break;
case "OPER":
strQuery.Append(" GROUP BY OPR.OPER, OPR.OPER_DESC \n");
break;
default:
strGroup = txtGrpItem.Text;
if (txtGrpItem.Text.LastIndexOf("MAT") > -1)
{
strTable = "MAT";
strGroup = strGroup.Replace("MATERIAL", "MAT");
}
else if (txtGrpItem.Text.LastIndexOf("FLOW") > -1)
{
strTable = "FLW";
}
else if (txtGrpItem.Text.LastIndexOf("OPER") > -1)
{
strTable = "OPR";
}
strQuery.AppendFormat(" AND GCM.FACTORY = '{0}' \n", cdvFactory.Text);
strQuery.AppendFormat(" AND GCM.TABLE_NAME = '{0}' \n", txtGrpItem.Text);
strQuery.AppendFormat(" AND GCM.KEY_1 = {0}.{1} \n", strTable, strGroup);
strQuery.Append(" GROUP BY GCM.KEY_1 \n");
//Start Column
iStartColumn = 1;
break;
}
strQuery = strQuery.Replace("\n", "");
if (strQuery.ToString().Trim() == "")
{
return(false);
}
QueryCond = null;
QueryCond = FwxCmnFunction.PackCondition(QueryCond, strQuery.ToString());
spdData_Sheet1.RowCount = 0;
this.Refresh();
rtDataTable = CmnFunction.oComm.FillData("RSUMWIPLTH", "1", QueryCond);
spdData_Sheet1.DataSource = rtDataTable;
CmnFunction.FitColumnHeader(spdData);
spdData_Sheet1.ColumnHeader.RowCount = 2;
for (i = 0; i < colColumn.count; i++)
{
spdData_Sheet1.ColumnHeader.Cells[0, iStartColumn + i].Text = colColumn.column[i].period + "_" + colColumn.column[i].column_name;
spdData_Sheet1.ColumnHeader.Cells[1, iStartColumn + i].Text = colColumn.column[i].column_alias_1;
}
if (rtDataTable.Rows.Count > 0)
{
rtDataTable.Dispose();
}
return(true);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
return(false);
}
}
