private void GridColumnInit(Miracom.SmartWeb.UI.Controls.udcFarPoint SS)
{
/************************************************
* comment : SS의 Column의 Header를 설정한다.
*
* created by :
*
* modified by : bee-jae jung(2010-08-10-화요일)
************************************************/
try
{
Cursor.Current = Cursors.WaitCursor;
SS.RPT_ColumnInit();
SS.RPT_AddBasicColumn("RES_ID", 0, 0, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 80);
SS.RPT_AddBasicColumn("OPER", 0, 1, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 80);
SS.RPT_AddBasicColumn("START_TIME", 0, 2, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 80);
SS.RPT_AddBasicColumn("END_TIME", 0, 3, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 80);
SS.RPT_AddBasicColumn("LOT_ID", 0, 4, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 80);
SS.RPT_AddBasicColumn("↓", 0, 5, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 20);
SS.RPT_AddBasicColumn("MAT_ID", 0, 6, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 120);
SS.RPT_AddBasicColumn("PATTERN_NO", 0, 7, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 80);
SS.RPT_AddBasicColumn("START_TIME", 0, 8, Visibles.False, Frozen.False, Align.Center, Merge.True, Formatter.String, 80);
// 특정 Columns의 색상을 지정한다.
SS.ActiveSheet.Columns[4].BackColor = Color.AliceBlue;
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void fnSSInitial(Miracom.SmartWeb.UI.Controls.udcFarPoint SS)
{
/****************************************************
* Comment : SS의 Header를 설정한다.
*
* Created By : KIM-MINWOO(2010-10-04-월요일)
*
* Modified By :KIM-MINWOO(2010-10-04-월요일)
****************************************************/
try
{
Cursor.Current = Cursors.WaitCursor;
SS.RPT_ColumnInit();
// CUSTOMER
SS.RPT_AddBasicColumn("CUSTOMER", 0, 0, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 80);
SS.RPT_AddBasicColumn("MM-2", 0, 1, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("MM-1", 0, 2, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("MM", 0, 3, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("WW-3", 0, 4, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("WW-2", 0, 5, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("WW-1", 0, 6, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("WW", 0, 7, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("DD-6", 0, 8, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("DD-5", 0, 9, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("DD-4", 0, 10, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("DD-3", 0, 11, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("DD-2", 0, 12, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("DD-1", 0, 13, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("DD", 0, 14, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
return;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void fnSSInitial(Miracom.SmartWeb.UI.Controls.udcFarPoint SS)
{
/****************************************************
* Comment : Spread Sheet의 Header를 설정한다.
*
* Created By : bee-jae jung(2016-06-15-수요일)
*
* Modified By : bee-jae jung(2016-06-15-수요일)
****************************************************/
int iIdx = 0;
try
{
Cursor.Current = Cursors.WaitCursor;
SS.RPT_ColumnInit();
SS.RPT_AddBasicColumn("WORK_MONTH", 0, iIdx + 0, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
SS.RPT_AddBasicColumn("CUSTOMER", 0, iIdx + 1, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
SS.RPT_AddBasicColumn("PACKAGE", 0, iIdx + 2, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
SS.RPT_AddBasicColumn("RETURN_QTY_1", 0, iIdx + 3, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 100);
SS.RPT_AddBasicColumn("RETURN_PRICE_1", 0, iIdx + 4, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 100);
SS.RPT_AddBasicColumn("RECEIVE_QTY_1", 0, iIdx + 5, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 100);
SS.RPT_AddBasicColumn("RECEIVE_PRICE_1", 0, iIdx + 6, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 100);
SS.RPT_AddBasicColumn("ISSUE_QTY_1", 0, iIdx + 7, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 100);
SS.RPT_AddBasicColumn("ISSUE_PRICE_1", 0, iIdx + 8, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 100);
SS.RPT_AddBasicColumn("WIP_QTY_1", 0, iIdx + 9, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 100);
SS.RPT_AddBasicColumn("WIP_PRICE_1", 0, iIdx + 10, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 100);
SS.RPT_AddBasicColumn("SHIP_QTY_1", 0, iIdx + 11, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 100);
SS.RPT_AddBasicColumn("SHIP_PRICE_1", 0, iIdx + 12, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 100);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
return;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void fnSSInitial(Miracom.SmartWeb.UI.Controls.udcFarPoint SS)
{
/****************************************************
* Comment : SS의 Header를 설정한다.
*
* Created By : bee-jae jung(2010-05-11-화요일)
*
* Modified By : bee-jae jung(2010-05-11-화요일)
****************************************************/
int iIdx = 0;
try
{
Cursor.Current = Cursors.WaitCursor;
SS.RPT_ColumnInit();
// CUSTOMER
if (udcWIPCondition1.Text != "ALL" && udcWIPCondition1.Text != "")
{
iIdx = 0;
SS.RPT_AddBasicColumn("CUSTOMER", 0, iIdx, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// FAMILY
if (udcWIPCondition2.Text != "ALL" && udcWIPCondition2.Text != "")
{
iIdx++;
SS.RPT_AddBasicColumn("FAMILY", 0, iIdx, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// PACKAGE
if (udcWIPCondition3.Text != "ALL" && udcWIPCondition3.Text != "")
{
iIdx++;
SS.RPT_AddBasicColumn("PACKAGE", 0, iIdx, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// TYPE1
if (udcWIPCondition4.Text != "ALL" && udcWIPCondition4.Text != "")
{
iIdx++;
SS.RPT_AddBasicColumn("TYPE1", 0, iIdx, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// TYPE2
if (udcWIPCondition5.Text != "ALL" && udcWIPCondition5.Text != "")
{
iIdx++;
SS.RPT_AddBasicColumn("TYPE2", 0, iIdx, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// LEAD COUNT
if (udcWIPCondition6.Text != "ALL" && udcWIPCondition6.Text != "")
{
iIdx++;
SS.RPT_AddBasicColumn("LEAD_COUNT", 0, iIdx, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// DENSITY
if (udcWIPCondition7.Text != "ALL" && udcWIPCondition7.Text != "")
{
iIdx++;
SS.RPT_AddBasicColumn("DENSITY", 0, iIdx, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// GENERATION
if (udcWIPCondition8.Text != "ALL" && udcWIPCondition8.Text != "")
{
iIdx++;
SS.RPT_AddBasicColumn("GENERATION", 0, iIdx, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
if (iIdx > 0)
{
iIdx++;
}
switch (SS.Name.ToUpper())
{
case "SS01":
SS.RPT_AddBasicColumn("USER_ID", 0, iIdx, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 80);
SS.RPT_AddBasicColumn("USER_DESC", 0, iIdx + 1, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
SS.RPT_AddBasicColumn("FAIL_PERCENT", 0, iIdx + 2, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("RETURN_PERCENT", 0, iIdx + 3, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double2, 80);
SS.RPT_AddBasicColumn("TOTAL_QTY", 0, iIdx + 4, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("PASS_QTY", 0, iIdx + 5, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("FAIL_QTY", 0, iIdx + 6, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("RETURN_QTY", 0, iIdx + 7, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("DEFECT_QTY", 0, iIdx + 8, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
break;
case "SS02":
SS.RPT_AddBasicColumn("DEFECT_CODE", 0, iIdx, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
SS.RPT_AddBasicColumn("DEFECT_DESC", 0, iIdx + 1, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
SS.RPT_AddBasicColumn("DEFECT_QTY", 0, iIdx + 2, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
// 2010-05-11-정비재 : 일자별로 가로로 출력하는 것은 추후에 작업할 것
//spdData.RPT_AddDynamicColumn(cdvFromToDate, 0, 13, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
break;
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
return;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void fnSSInitial(Miracom.SmartWeb.UI.Controls.udcFarPoint SS)
{
/****************************************************
* Comment : SS의 Header를 설정한다.
*
* Created By : bee-jae jung(2011-03-28-월요일)
*
* Modified By : bee-jae jung(2011-03-28-월요일)
****************************************************/
int iIdx = 0;
try
{
Cursor.Current = Cursors.WaitCursor;
SS.RPT_ColumnInit();
SS.RPT_AddBasicColumn("classification", 0, iIdx + 0, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
if (rbS01.Checked == true)
{
SS.RPT_AddBasicColumn("Last month (M-1)", 0, iIdx + 1, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Current month (M)", 0, iIdx + 2, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
}
else if (rbS02.Checked == true)
{
SS.RPT_AddBasicColumn("Last month (M-2)", 0, iIdx + 1, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Last month (M-1)", 0, iIdx + 2, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Current month (M)", 0, iIdx + 3, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
}
else if (rbS03.Checked == true)
{
SS.RPT_AddBasicColumn("Last month (M-3)", 0, iIdx + 1, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Last month (M-2)", 0, iIdx + 2, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Last month (M-1)", 0, iIdx + 3, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Current month (M)", 0, iIdx + 4, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
}
else if (rbS04.Checked == true)
{
SS.RPT_AddBasicColumn("Last month (M-4)", 0, iIdx + 1, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Last month (M-3)", 0, iIdx + 2, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Last month (M-2)", 0, iIdx + 3, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Last month (M-1)", 0, iIdx + 4, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Current month (M)", 0, iIdx + 5, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
}
else if (rbS05.Checked == true)
{
SS.RPT_AddBasicColumn("Last month (M-5)", 0, iIdx + 1, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Last month (M-4)", 0, iIdx + 2, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Last month (M-3)", 0, iIdx + 3, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Last month (M-2)", 0, iIdx + 4, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Last month (M-1)", 0, iIdx + 5, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
SS.RPT_AddBasicColumn("Current month (M)", 0, iIdx + 6, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.Number, 100);
}
fnSSSortInit();
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
return;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void fnSSInitial(Miracom.SmartWeb.UI.Controls.udcFarPoint SS)
{
/****************************************************
* comment : ss의 header를 설정한다.
*
* created by : bee-jae jung(2010-07-23-금요일)
*
* modified by : bee-jae jung(2010-07-23-금요일)
****************************************************/
string qry = "";
int iindex = 0;
Formatter nf;
try
{
Cursor.Current = Cursors.WaitCursor;
SS.RPT_ColumnInit();
// CUSTOMER
if (udcWIPCondition1.Text != "ALL" && udcWIPCondition1.Text != "")
{
iindex = 0;
SS.RPT_AddBasicColumn("CUSTOMER", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// FAMILY
if (udcWIPCondition2.Text != "ALL" && udcWIPCondition2.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("FAMILY", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// PACKAGE
if (udcWIPCondition3.Text != "ALL" && udcWIPCondition3.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("PACKAGE", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// TYPE1
if (udcWIPCondition4.Text != "ALL" && udcWIPCondition4.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("TYPE1", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// TYPE2
if (udcWIPCondition5.Text != "ALL" && udcWIPCondition5.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("TYPE2", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// LEAD COUNT
if (udcWIPCondition6.Text != "ALL" && udcWIPCondition6.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("LEAD_COUNT", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// DENSITY
if (udcWIPCondition7.Text != "ALL" && udcWIPCondition7.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("DENSITY", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// GENERATION
if (udcWIPCondition8.Text != "ALL" && udcWIPCondition8.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("GENERATION", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 40);
}
// 2010-07-23-정비재 : 검색구분에 따라서 숫자 format을 설정한다.
if (rb01.Checked == true)
{
nf = Formatter.Double3;
}
else
{
nf = Formatter.Number;
}
// 2010-07-20-정비재 : sheet의 headeer를 설정한다.
SS.RPT_AddBasicColumn("Classification", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
SS.RPT_AddBasicColumn("Period average", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Double3, 100);
// 2010-07-23-정비재 : 기준일자(basedate) 기준으로 일자를 설정한다.
qry = "SELECT SUBSTR(TO_CHAR(TO_DATE('" + cdvBaseDate.Value.ToString("yyyyMMdd") + "', 'YYYYMMDD') - 7, 'YYYYMMDD'), -4) AS DD_7\n"
+ " , SUBSTR(TO_CHAR(TO_DATE('" + cdvBaseDate.Value.ToString("yyyyMMdd") + "', 'YYYYMMDD') - 6, 'YYYYMMDD'), -4) AS DD_6\n"
+ " , SUBSTR(TO_CHAR(TO_DATE('" + cdvBaseDate.Value.ToString("yyyyMMdd") + "', 'YYYYMMDD') - 5, 'YYYYMMDD'), -4) AS DD_5\n"
+ " , SUBSTR(TO_CHAR(TO_DATE('" + cdvBaseDate.Value.ToString("yyyyMMdd") + "', 'YYYYMMDD') - 4, 'YYYYMMDD'), -4) AS DD_4\n"
+ " , SUBSTR(TO_CHAR(TO_DATE('" + cdvBaseDate.Value.ToString("yyyyMMdd") + "', 'YYYYMMDD') - 3, 'YYYYMMDD'), -4) AS DD_3\n"
+ " , SUBSTR(TO_CHAR(TO_DATE('" + cdvBaseDate.Value.ToString("yyyyMMdd") + "', 'YYYYMMDD') - 2, 'YYYYMMDD'), -4) AS DD_2\n"
+ " , SUBSTR(TO_CHAR(TO_DATE('" + cdvBaseDate.Value.ToString("yyyyMMdd") + "', 'YYYYMMDD') - 1, 'YYYYMMDD'), -4) AS DD_1\n"
+ " FROM DUAL";
if (GlobalVariable.gsUserGroup == "ADMIN_GROUP" || GlobalVariable.gsUserGroup == "HANA_ADMIN_GROUP")
{
Clipboard.SetText(qry.Replace((char)Keys.Tab, ' '));
}
dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", qry.Replace((char)Keys.Tab, ' '));
if (dt.Rows.Count <= 0)
{
SS.RPT_AddBasicColumn("DD-7", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
SS.RPT_AddBasicColumn("DD-6", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
SS.RPT_AddBasicColumn("DD-5", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
SS.RPT_AddBasicColumn("DD-4", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
SS.RPT_AddBasicColumn("DD-3", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
SS.RPT_AddBasicColumn("DD-2", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
SS.RPT_AddBasicColumn("DD-1", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
}
else
{
SS.RPT_AddBasicColumn(dt.Rows[0][0].ToString(), 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
SS.RPT_AddBasicColumn(dt.Rows[0][1].ToString(), 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
SS.RPT_AddBasicColumn(dt.Rows[0][2].ToString(), 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
SS.RPT_AddBasicColumn(dt.Rows[0][3].ToString(), 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
SS.RPT_AddBasicColumn(dt.Rows[0][4].ToString(), 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
SS.RPT_AddBasicColumn(dt.Rows[0][5].ToString(), 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
SS.RPT_AddBasicColumn(dt.Rows[0][6].ToString(), 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, nf, 100);
}
dt.Dispose();
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
return;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void fnSSInitial(Miracom.SmartWeb.UI.Controls.udcFarPoint SS)
{
/****************************************************
* Comment : SS의 Header를 설정한다.
*
* Created By : bee-jae jung(2010-08-30-월요일)
*
* Modified By : bee-jae jung(2010-11-29-월요일)
****************************************************/
int iIdx = 0;
try
{
Cursor.Current = Cursors.WaitCursor;
SS.RPT_ColumnInit();
if (rbSearch01.Checked == true || rbSearch02.Checked == true)
{
SS.RPT_AddBasicColumn("Customer", 0, iIdx + 0, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
SS.RPT_AddBasicColumn("PACKAGE", 0, iIdx + 1, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
if (rbSearch01.Checked == true)
{
// 2010-11-29-정비재 : 일자별
SS.RPT_AddBasicColumn("WORK_DATE", 0, iIdx + 2, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
}
else if (rbSearch02.Checked == true)
{
// 2010-11-29-정비재 : 월별
SS.RPT_AddBasicColumn("WORK_MONTH", 0, iIdx + 2, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
}
SS.RPT_AddBasicColumn("RETURN_LOT", 0, iIdx + 3, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("RETURN_QTY", 0, iIdx + 4, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("RECEIVE_LOT", 0, iIdx + 5, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("RECEIVE_QTY", 0, iIdx + 6, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("ISSUE_LOT", 0, iIdx + 7, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("ISSUE_QTY", 0, iIdx + 8, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("WIP_LOT", 0, iIdx + 9, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("WIP_QTY", 0, iIdx + 10, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("SHIP_LOT", 0, iIdx + 11, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("SHIP_QTY", 0, iIdx + 12, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
}
else if (rbSearch03.Checked == true || rbSearch04.Checked == true)
{
if (rbSearch03.Checked == true)
{
// 2010-11-29-정비재 : 일자별
SS.RPT_AddBasicColumn("WORK_DATE", 0, iIdx + 0, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
}
else if (rbSearch04.Checked == true)
{
// 2010-11-29-정비재 : 월별
SS.RPT_AddBasicColumn("WORK_MONTH", 0, iIdx + 0, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 100);
}
SS.RPT_AddBasicColumn("RETURN_LOT", 0, iIdx + 1, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("RETURN_QTY", 0, iIdx + 2, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("RECEIVE_LOT", 0, iIdx + 3, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("RECEIVE_QTY", 0, iIdx + 4, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("ISSUE_LOT", 0, iIdx + 5, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("ISSUE_QTY", 0, iIdx + 6, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("WIP_LOT", 0, iIdx + 7, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("WIP_QTY", 0, iIdx + 8, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("SHIP_LOT", 0, iIdx + 9, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
SS.RPT_AddBasicColumn("SHIP_QTY", 0, iIdx + 10, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 80);
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
return;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void fnSSInitial(Miracom.SmartWeb.UI.Controls.udcFarPoint SS)
{
/****************************************************
* comment : ss의 header를 설정한다.
*
* created by : bee-jae jung(2010-07-20-화요일)
*
* modified by : bee-jae jung(2010-07-20-화요일)
****************************************************/
int iindex = 0;
try
{
Cursor.Current = Cursors.WaitCursor;
SS.RPT_ColumnInit();
// CUSTOMER
if (udcWIPCondition1.Text != "ALL" && udcWIPCondition1.Text != "")
{
iindex = 0;
SS.RPT_AddBasicColumn("CUSTOMER", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 40);
}
// FAMILY
if (udcWIPCondition2.Text != "ALL" && udcWIPCondition2.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("FAMILY", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 40);
}
// PACKAGE
if (udcWIPCondition3.Text != "ALL" && udcWIPCondition3.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("PACKAGE", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 40);
}
// TYPE1
if (udcWIPCondition4.Text != "ALL" && udcWIPCondition4.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("TYPE1", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 40);
}
// TYPE2
if (udcWIPCondition5.Text != "ALL" && udcWIPCondition5.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("TYPE2", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 40);
}
// LEAD COUNT
if (udcWIPCondition6.Text != "ALL" && udcWIPCondition6.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("LEAD_COUNT", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 40);
}
// DENSITY
if (udcWIPCondition7.Text != "ALL" && udcWIPCondition7.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("DENSITY", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 40);
}
// GENERATION
if (udcWIPCondition8.Text != "ALL" && udcWIPCondition8.Text != "")
{
iindex++;
SS.RPT_AddBasicColumn("GENERATION", 0, iindex, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 40);
}
// 2010-07-20-정비재 : sheet의 headeer를 설정한다.
SS.RPT_AddBasicColumn("GCT_PROJECT_NO", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("GCT_DEVICE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("PACKAGE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 100);
SS.RPT_AddBasicColumn("LD_COUNT", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 100);
SS.RPT_AddBasicColumn("DIMENSION", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 100);
SS.RPT_AddBasicColumn("CUSTOMER_DEVICE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("WFR_LOT_ID", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 100);
SS.RPT_AddBasicColumn("GCT_ASSY_LOT_ID", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("GCT_TEST_LOT_ID", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("VENDOR_LOT_ID", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("PROD_RLSESCHED_NO", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("VENDOR_ORDER_NO", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("TEST_RCVD_QTY", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("TEST_RCVD_DATE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("TEST_QUE", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("TEST_START_DATE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("FINAL_TEST_CAS_OS", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("QA_EL_TEST", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("TEST_HOLD", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("LOT_HOLD_DATE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("LOT_HOLD_REL_DATE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("TEST_OUT_QTY", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("TEST_OUT_FCST_DATE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("TEST_OUT_DATE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("VM", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("BAKE", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("TNR", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("PACK", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("PACK_OUT_QTY", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("PACK_OUT_DATE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("FGS", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("SHIP_OUT_QTY", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("FCST_SHIP_DATE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("ACT_SHIP_DATE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("CUST_REQ_DATE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("PR_NO", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("TEST_PO", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("HOLD_CODE", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("REJECT", 0, iindex++, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 120);
SS.RPT_AddBasicColumn("REMARK", 0, iindex++, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
SS.RPT_AddBasicColumn("UPDATE_TIME", 0, iindex++, Visibles.False, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
return;
}
finally
{
Cursor.Current = Cursors.Default;
}
}