private void btnView_Click(object sender, EventArgs e)
{
DataTable dt = null;
string QueryCond = null;
CheckField();
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvFactory.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvLotType.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvMatType.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvMatGrpList.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, txtMatGrp.Text);
spdData_Sheet1.RowCount = 0;
this.Refresh();
dt = CmnFunction.oComm.GetFuncDataTable("STD1102", QueryCond);
if (dt.Rows.Count == 0)
{
spdData.Visible = false;
//MessageBox.Show(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage), "STD1102");
}
else
{
spdData.Visible = true;
}
spdData_Sheet1.DataSource = dt;
ultraChart1.Visible = false;
if (dt.Rows.Count > 0)
{
CmnFunction.FitColumnHeader(spdData);
MakeChart(dt);
ultraChart1.SaveTo(Environment.GetFolderPath(Environment.SpecialFolder.MyPictures) + @"\myChart.png", System.Drawing.Imaging.ImageFormat.Png);
}
dt.Dispose();
}
private void btnView_Click(object sender, EventArgs e)
{
/****************************************************
* comment : 조회버튼을 선택하면
*
* created by : bee-jae jung(2011-01-17-월요일)
*
* modified by : bee-jae jung(2011-01-17-월요일)
****************************************************/
try
{
Cursor.Current = Cursors.WaitCursor;
fnDataFind();
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void btnExcelExport_Click(object sender, EventArgs e)
{
/****************************************************
* Comment : Excel Export Button을 클릭하면
*
* Created By : bee-jae jung(2016-06-15-수요일)
*
* Modified By : bee-jae jung(2016-06-15-수요일)
****************************************************/
try
{
Cursor.Current = Cursors.WaitCursor;
SS01.ExportExcel();
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void btnView_Click(object sender, EventArgs e)
{
DataTable dt = null;
string QueryCond = null;
CheckField();
spdDataDetail.Sheets[0].RowCount = 0;
spdDataDetail.Sheets[0].ColumnCount = 0;
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvFactory.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, StartDate());
QueryCond = FwxCmnFunction.PackCondition(QueryCond, EndDate());
spdData_Sheet1.RowCount = 0;
this.Refresh();
dt = CmnFunction.oComm.GetFuncDataTable("STD1605", QueryCond);
if (dt.Rows.Count == 0)
{
spdData.Visible = false;
}
else
{
spdData.Visible = true;
}
spdDataDetail.Visible = false;
spdDataDetail.Sheets[0].RowCount = 0;
spdDataDetail.Sheets[0].ColumnCount = 0;
spdData.Sheets[0].DataSource = dt;
ultraChart1.Visible = false;
if (dt.Rows.Count > 0)
{
CmnFunction.FitColumnHeader(spdData);
MakeChart(dt);
ultraChart1.SaveTo(Environment.GetFolderPath(Environment.SpecialFolder.MyPictures) + @"\myChart.png", System.Drawing.Imaging.ImageFormat.Png);
}
dt.Dispose();
}
/// <summary>
/// Delete RWEBUSRDEF Table.
/// </summary>
/// <param name="secUserId">Delete UserID value</param>
/// <returns>bool : True or False</returns>
private bool Delete_Security_User(string secUserId)
{
DataTable rtDataTable = new DataTable();
try
{
string DeleteCond;
DeleteCond = "";
DeleteCond = FwxCmnFunction.PackCondition(DeleteCond, GlobalVariable.gsCentralFactory);
DeleteCond = FwxCmnFunction.PackCondition(DeleteCond, secUserId);
rtDataTable = CmnFunction.oComm.SelectData("RWEBUSRDEF", "1", DeleteCond);
if (rtDataTable.Rows.Count <= 0)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD013", GlobalVariable.gcLanguage));
return(false);
}
else
{
if (CmnFunction.oComm.DeleteData("RWEBUSRDEF", "1", DeleteCond) != true)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD000", GlobalVariable.gcLanguage));
return(false);
}
return(true);
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("SEC1101.Delete_Security_User() : " + ex.ToString());
return(false);
}
}
private void cboCategory_SelectionChanged(object sender, System.EventArgs e)
{
try
{
cdvFactory.Text = "";
cdvLayout.Text = "";
if (cboCategory.SelectedIndex == 0)
{
modCommonFunction.CheckAllFactoryOption(cdvFactory);
}
else if (cboCategory.SelectedIndex == 1)
{
cdvFactory.Text = GlobalVariable.gsFactory;
cdvFactory.ReadOnly = true;
cdvFactory.VisibleButton = false;
cdvFactory.BackColor = SystemColors.Control;
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("frmFMBArrangeLayout.frmFMBArrangeLayout_Load()" + "\r\n" + ex.Message, "FMB Client", MessageBoxButtons.OK, 1);
}
}
/// <summary 1. 유효성 검사>
/// <remarks></remarks>
/// </summary>
/// <returns></returns>
private Boolean CheckField()
{
if (cdvFactory.Text.TrimEnd() == "")
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD001", GlobalVariable.gcLanguage));
return(false);
}
if (rdoDetail.Checked == true)
{
if (cdvOper.Text.TrimEnd() == "")
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD005", GlobalVariable.gcLanguage));
return(false);
}
if (cdvFactory.txtValue == GlobalVariable.gsAssyDefaultFactory)
{
if (cdvOper.Text.TrimEnd() == "ALL" || cdvOper.SelectCount > 40)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD053", GlobalVariable.gcLanguage));
return(false);
}
}
}
else
{
if (cdvOperGroup.FromText == "" || cdvOperGroup.ToText == "")
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD005", GlobalVariable.gcLanguage));
return(false);
}
}
return(true);
}
/// <summary>
/// DataTable을 입력받는 생성자
/// </summary>
/// <param name="title"></param>
/// <param name="dt"></param>
/// <param name="strTotal"></param>
public MAT070503_P4(string title, DataTable dt, string strMatCode)
{
InitializeComponent();
this.Text = title;
spdData.RPT_ColumnInit();
try
{
spdData.RPT_AddBasicColumn("Material Code", 0, 0, Visibles.True, Frozen.True, Align.Left, Merge.True, Formatter.String, 90);
spdData.RPT_AddBasicColumn("SAP CODE", 0, 1, Visibles.True, Frozen.True, Align.Left, Merge.True, Formatter.String, 90);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
}
spdData.DataSource = dt;
spdData.RPT_AutoFit(false);
dt.Dispose();
}
private void btnExcelExport_Click(object sender, EventArgs e)
{
/****************************************************
* Comment : SS의 데이터를 Excel파일로 내보내기 한다.
*
* Created By : 안시홍(2010-08-10)
*
* Modified By :
****************************************************/
try
{
Cursor.Current = Cursors.WaitCursor;
SS.ExportExcel();
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void btnExcelExport_Click(object sender, EventArgs e)
{
/****************************************************
* comment : excel로 내보내기를 선택하면
*
* created by : bee-jae jung(2011-01-17-월요일)
*
* modified by : bee-jae jung(2011-01-17-월요일)
****************************************************/
try
{
Cursor.Current = Cursors.WaitCursor;
SS01.ExportExcel();
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void btnView_Click(object sender, EventArgs e)
{
DataTable dt = null;
string QueryCond = null;
CheckField();
QueryCond = FwxCmnFunction.PackCondition(QueryCond, txtLotID.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, (chkDeleteHis.Checked == true ? "1" : "0"));
spdData_Sheet1.RowCount = 0;
this.Refresh();
dt = CmnFunction.oComm.GetFuncDataTable("STD1902", QueryCond);
if (dt.Rows.Count == 0)
{
spdData.Visible = false;
}
else
{
spdData.Visible = true;
}
spdData_Sheet1.DataSource = dt;
CmnFunction.FitColumnHeader(spdData);
dt.Dispose();
}
private void btnExit_Click(object sender, EventArgs e)
{
/****************************************************
* comment : 확인 버튼을 클릭하면
*
* created by : bee-jae jung(2010-09-02-목요일)
*
* modified by : bee-jae jung(2010-09-02-목요일)
****************************************************/
try
{
Cursor.Current = Cursors.WaitCursor;
this.Close();
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void bntExcelExport_Click(object sender, EventArgs e)
{
/****************************************************
* comment : Sheet의 데이터를 Excel로 내보낸다.
*
* created by : bee-jae jung(2010-09-02-목요일)
*
* modified by : bee-jae jung(2010-09-02-목요일)
****************************************************/
try
{
Cursor.Current = Cursors.WaitCursor;
SS.ExportExcel();
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnView_Click(object sender, EventArgs e)
{
DataTable dt = null;
if (CheckField() == false)
{
return;
}
LoadingPopUp.LoadIngPopUpShow(this);
Cursor.Current = Cursors.WaitCursor;
try
{
// 검색중 화면 표시
// LoadingPopUp.LoadIngPopUpShow(this);
this.Refresh();
GridColumnInit();
GridColumnInit2();
udcChartFX1.RPT_1_ChartInit();
// Query문으로 데이터를 검색한다.
dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString());
if (dt.Rows.Count == 0)
{
dt.Dispose();
LoadingPopUp.LoadingPopUpHidden();
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage));
return;
}
spdData.DataSource = dt;
//spdData.isShowZero = true;
//// Sub Total
int[] rowType = spdData.RPT_DataBindingWithSubTotal(dt, 0, 0, 1, null, null);
//// Total
spdData.RPT_FillDataSelectiveCells("Total", 0, 1, 0, 1, true, Align.Center, VerticalAlign.Center);
////4. Column Auto Fit
spdData.RPT_AutoFit(false);
ShowChart(dt);
//dt.Dispose();
}
catch (Exception ex)
{
LoadingPopUp.LoadingPopUpHidden();
CmnFunction.ShowMsgBox(ex.Message);
}
finally
{
LoadingPopUp.LoadingPopUpHidden();
Cursor.Current = Cursors.Default;
}
}
/// <summary>
/// 조회
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnView_Click(object sender, EventArgs e)
{
if (!CheckField())
{
return;
}
DataTable dt = null;
GridColumnInit();
try
{
LoadingPopUp.LoadIngPopUpShow(this);
spdData_Sheet1.RowCount = 0;
this.Refresh();
dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString());
if (dt.Rows.Count == 0)
{
dt.Dispose();
LoadingPopUp.LoadingPopUpHidden();
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage));
return;
}
//그루핑 순서 1순위만 SubTotal을 사용하기 위해서 첫번째 값을 가져옴
//int sub = ((udcTableForm)(this.btnSort.BindingForm)).GetCheckedValue(2);
////by John (한줄짜리)
////1.Griid 합계 표시
int[] rowType = spdData.RPT_DataBindingWithSubTotal(dt, 0, 0, 3, null, null, btnSort);
////2. 칼럼 고정(필요하다면..)
//spdData.Sheets[0].FrozenColumnCount = 11;
////3. Total부분 셀머지
spdData.RPT_FillDataSelectiveCells("Total", 0, 3, 0, 1, true, Align.Center, VerticalAlign.Center);
//4. Column Auto Fit
spdData.RPT_AutoFit(false);
//spdData.ActiveSheet.Columns[9].AllowAutoSort = true;
//spdData.ActiveSheet.Columns[11].AllowAutoSort = true;
//spdData.ActiveSheet.Columns[12].AllowAutoSort = true;
//5. TAT 값 평균값 구하기(GrandTotal부분만 구함. SubTotal은 없음)
double sum = 0;
double avr = 0;
for (int i = 1; i < spdData.ActiveSheet.Rows.Count; i++) // GrandTotal 부분 제외하기 위해 1부터 시작
{
sum += Convert.ToDouble(spdData.ActiveSheet.Cells[i, 11].Value);
}
avr = sum / (spdData.ActiveSheet.Rows.Count - 1); // GrandTotal Count 제외하기 위해 -1일함.
spdData.ActiveSheet.Cells[0, 11].Value = avr.ToString();
dt.Dispose();
}
catch (Exception ex)
{
LoadingPopUp.LoadingPopUpHidden();
CmnFunction.ShowMsgBox(ex.Message);
}
finally
{
LoadingPopUp.LoadingPopUpHidden();
}
}
/// <summary>
///
/// </summary>
/// <param name="funcName">Function name</param>
/// <returns>bool : True or False</returns>
private bool FindFunctionInfo(string funcName)
{
string QueryCond, value = "";
try
{
DataTable rtDataTable = new DataTable();
QueryCond = "";
QueryCond = FwxCmnFunction.PackCondition(QueryCond, funcName);
rtDataTable = CmnFunction.oComm.SelectData("RWEBFUNDEF", "1", QueryCond);
if (rtDataTable.Rows.Count > 0)
{
txtFunc.Text = rtDataTable.Rows[0]["FUNC_NAME"].ToString().Trim();
txtDesc.Text = rtDataTable.Rows[0]["FUNC_DESC"].ToString().Trim();
value = rtDataTable.Rows[0]["CREATE_USER_ID"].ToString().Trim();
if (value != "")
{
txtCreateUser.Text = value;
}
else
{
txtCreateUser.Text = "";
}
value = rtDataTable.Rows[0]["CREATE_TIME"].ToString().Trim();
if (value != "")
{
txtCreateTime.Text = CmnFunction.ChangeDateTimeString(value, "yyyyMMddHHmmss", "yyyy-MM-dd HH:mm:ss");
}
else
{
txtCreateTime.Text = "";
}
value = rtDataTable.Rows[0]["UPDATE_USER_ID"].ToString().Trim();
if (value != "")
{
txtUpdateUser.Text = value;
}
else
{
txtUpdateUser.Text = "";
}
value = rtDataTable.Rows[0]["UPDATE_TIME"].ToString().Trim();
if (value != "")
{
txtUpdateTime.Text = CmnFunction.ChangeDateTimeString(value, "yyyyMMddHHmmss", "yyyy-MM-dd HH:mm:ss");
}
else
{
txtUpdateTime.Text = "";
}
// 2016-05-23-임종우 : 화면 개발 요청자 추가
value = rtDataTable.Rows[0]["HELP_URL"].ToString().Trim();
if (value != "")
{
txtRequester.Text = value;
}
else
{
txtRequester.Text = "";
}
// 2016-05-27-임종우 : 삭제 User 정보 추가
value = rtDataTable.Rows[0]["DELETE_USER_ID"].ToString().Trim();
if (value != "")
{
txtDeleteUser.Text = value;
}
else
{
txtDeleteUser.Text = "";
}
// 2016-05-27-임종우 : 삭제 시간 정보 추가
value = rtDataTable.Rows[0]["DELETE_TIME"].ToString().Trim();
if (value != "")
{
txtDeleteTime.Text = CmnFunction.ChangeDateTimeString(value, "yyyyMMddHHmmss", "yyyy-MM-dd HH:mm:ss");
}
else
{
txtDeleteTime.Text = "";
}
// 2019-11-22-임종우 : LANGUAGE 부분 추가
value = rtDataTable.Rows[0]["LANGUAGE_1"].ToString().Trim();
if (value != "")
{
txtLang1.Text = value;
}
else
{
txtLang1.Text = "";
}
value = rtDataTable.Rows[0]["LANGUAGE_2"].ToString().Trim();
if (value != "")
{
txtLang2.Text = value;
}
else
{
txtLang2.Text = "";
}
//// 20200130 chulho.wee ; lang 4 (vietnam), 5, etc added
value = rtDataTable.Rows[0]["LANGUAGE_3"].ToString().Trim();
if (value != "")
{
txtLang3.Text = value;
}
else
{
txtLang3.Text = "";
}
//// 20200130 chulho.wee ; lang 4 (brazil), 5, etc added
value = rtDataTable.Rows[0]["LANGUAGE_4"].ToString().Trim();
if (value != "")
{
txtLang4.Text = value;
}
else
{
txtLang4.Text = "";
}
//// 20200130 chulho.wee ; lang 5 (etcm), 5, etc added
value = rtDataTable.Rows[0]["LANGUAGE_5"].ToString().Trim();
if (value != "")
{
txtLang5.Text = value;
}
else
{
txtLang5.Text = "";
}
}
if (rtDataTable.Rows.Count > 0)
{
rtDataTable.Dispose();
}
return(true);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("SEC1103.FindFunctionInfo() : " + ex.ToString());
return(false);
}
}
/// <summary>
/// Delete RWEBGRPFUN Table.
/// </summary>
/// <param name="functionName">Function name</param>
/// <returns>bool : True or False</returns>
private bool Delete_Function(string functionName)
{
string QueryCond = null;
string UpdateValue = "";
string sysCurrentDate;
DataTable rtDataTable = new DataTable();
try
{
QueryCond = "";
QueryCond = FwxCmnFunction.PackCondition(QueryCond, functionName);
rtDataTable = CmnFunction.oComm.SelectData("RWEBFUNDEF", "1", QueryCond);
if (rtDataTable.Rows.Count <= 0)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD018", GlobalVariable.gcLanguage));
return(false);
}
sysCurrentDate = "";
sysCurrentDate = CmnFunction.GetSysDateTime();
if (sysCurrentDate == null)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD000", GlobalVariable.gcLanguage));
return(false);
}
UpdateValue = "";
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, functionName);
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtDesc.Text.Trim());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, " ");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, " ");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, " ");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtRequester.Text.Trim()); // 요청자 정보 추가
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtCreateUser.Text.Trim());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, CmnFunction.ChangeDateTimeString(txtCreateTime.Text, "yyyy-MM-dd HH:mm:ss", "yyyyMMddHHmmss"));
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtUpdateUser.Text.Trim());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, CmnFunction.ChangeDateTimeString(txtUpdateUser.Text, "yyyy-MM-dd HH:mm:ss", "yyyyMMddHHmmss"));
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, GlobalVariable.gsUserID);
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, sysCurrentDate);
//2019-11-22-임종우 : Language 부분 추가
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtLang1.Text.Trim());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtLang2.Text.Trim());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtLang3.Text.Trim());
//// 20200130 chulho.wee ; lang 2ea added. vietnam, brazil
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtLang4.Text.Trim());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtLang5.Text.Trim());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, functionName);
// 2016-05-30-임종우 : 실제 데이터를 삭제 하지 않고 업데이트로 변경 함.
if (CmnFunction.oComm.UpdateData("RWEBFUNDEF", "1", UpdateValue) != true)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD000", GlobalVariable.gcLanguage));
return(false);
}
//if (CmnFunction.oComm.DeleteData("RWEBFUNDEF", "1", QueryCond) != true)
//{
// CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD000", GlobalVariable.gcLanguage));
// return false;
//}
return(true);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("SEC1103.Delete_Function() : " + ex.ToString());
return(false);
}
}
/// <summary>
/// Insert RWEBGRPFUN Table.
/// </summary>
/// <returns>bool : True or False</returns>
private bool Create_Function()
{
string QueryCond, InsertValue = "";
string sysCurrentDate;
DataTable rtDataTable = new DataTable();
try
{
QueryCond = "";
QueryCond = FwxCmnFunction.PackCondition(QueryCond, txtFunc.Text.Trim());
rtDataTable = CmnFunction.oComm.SelectData("RWEBFUNDEF", "1", QueryCond);
if (rtDataTable.Rows.Count > 0)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD019", GlobalVariable.gcLanguage));
return(false);
}
sysCurrentDate = "";
sysCurrentDate = CmnFunction.GetSysDateTime();
if (sysCurrentDate == null)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD000", GlobalVariable.gcLanguage));
return(false);
}
InsertValue = "";
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtFunc.Text.Trim());
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtDesc.Text.Trim());
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtRequester.Text.Trim()); // 요청자 정보 추가
//CREATE_USER_ID
InsertValue = FwxCmnFunction.PackCondition(InsertValue, GlobalVariable.gsUserID);
InsertValue = FwxCmnFunction.PackCondition(InsertValue, sysCurrentDate);
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
//2019-11-22-임종우 : Language 저장 추가
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtLang1.Text.Trim());
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtLang2.Text.Trim());
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtLang3.Text.Trim());
//// 20200130 chulho.wee ; lang 2ea added. vietnam, brazil
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtLang4.Text.Trim());
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtLang5.Text.Trim());
if (CmnFunction.oComm.InsertData("RWEBFUNDEF", "1", InsertValue) != true)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD000", GlobalVariable.gcLanguage));
return(false);
}
return(true);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("SEC1103.Create_Function() : " + ex.ToString());
return(false);
}
}
/// <summary>
/// 버튼 이벤트
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
#region Button Click Event
private void btnView_Click(object sender, EventArgs e)
{
if (CheckField() == false)
{
return;
}
LoadingPopUp.LoadIngPopUpShow(this);
DataTable dt = null;
GridColumnInit();
try
{
this.Refresh();
LoadingPopUp.LoadIngPopUpShow(this);
spdData_Sheet1.RowCount = 0;
dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString());
if (dt.Rows.Count == 0)
{
dt.Dispose();
LoadingPopUp.LoadingPopUpHidden();
udcMSChart1.RPT_1_ChartInit();
udcMSChart1.RPT_2_ClearData();
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage));
return;
}
//그루핑 순서 1순위만 SubTotal을 사용하기 위해서 첫번째 값을 가져옴
int sub = ((udcTableForm)(this.btnSort.BindingForm)).GetCheckedValue(2);
int nGroupCount = ((udcTableForm)(this.btnSort.BindingForm)).GetSelectedCount();
////by John (한줄짜리)
////1.Griid 합계 표시
int[] rowType = spdData.RPT_DataBindingWithSubTotal(dt, 0, sub + 1, 17, null, null, btnSort);
////3. Total부분 셀머지
spdData.RPT_FillDataSelectiveCells("Total", 0, 17, 0, 1, true, Align.Center, VerticalAlign.Center);
//4. Column Auto Fit
spdData.RPT_AutoFit(false);
//--------------------------------------------
//5. 평균값
spdData.RPT_SetAvgSubTotalAndGrandTotal(1, 19, nGroupCount, true);
spdData.RPT_SetAvgSubTotalAndGrandTotal(1, 25, nGroupCount, true);
spdData.RPT_SetPerSubTotalAndGrandTotal(1, 20, 17, 22);
spdData.RPT_SetPerSubTotalAndGrandTotal(1, 21, 17, 23);
Color color = spdData.ActiveSheet.Cells[1, 24].BackColor;
Decimal dYield;
// 2012-11-22-임종우 : Retest yield 5% 이상인 제품 색상 표시 (최윤혁 요청)
// 2013-04-25-임종우 : Retest yield 4% 이상인 제품 색상 표시 (황혜리 요청)
// 2013-07-24-임종우 : Retest yield Sub Total, Grand Total 구하는 부분 추가 (황혜리 요청)
// 2013-09-27-임종우 : Retest yield 3% 이상인 제품 색상 표시 (김문한 요청)
for (int i = 1; i < spdData.ActiveSheet.RowCount; i++)
{
dYield = Convert.ToDecimal(spdData.ActiveSheet.Cells[i, 24].Value);
if (spdData.ActiveSheet.Cells[i, 24].BackColor == color && spdData.ActiveSheet.Cells[i, 24].Value != null)
{
if (dYield >= 3)
{
for (int y = 17; y <= 29; y++)
{
spdData.ActiveSheet.Cells[i, y].BackColor = Color.Pink;
}
}
}
// Retest yield Sub Total 부분
if (spdData.ActiveSheet.Cells[i, 24].BackColor != color)
{
spdData.ActiveSheet.Cells[i, 24].Value = Convert.ToDouble(spdData.ActiveSheet.Cells[i, 23].Value) - Convert.ToDouble(spdData.ActiveSheet.Cells[i, 22].Value);
}
}
// Retest yield Grand Total 부분
spdData.ActiveSheet.Cells[0, 24].Value = Convert.ToDouble(spdData.ActiveSheet.Cells[0, 23].Value) - Convert.ToDouble(spdData.ActiveSheet.Cells[0, 22].Value);
dt.Dispose();
ShowChart();
}
catch (Exception ex)
{
LoadingPopUp.LoadingPopUpHidden();
CmnFunction.ShowMsgBox(ex.Message);
}
finally
{
LoadingPopUp.LoadingPopUpHidden();
}
}
private void btnView_Click(object sender, EventArgs e)
{
DataTable dt = null;
if (CheckField() == false)
{
return;
}
GridColumnInit();
spdData_Sheet1.RowCount = 0;
try
{
LoadingPopUp.LoadIngPopUpShow(this);
this.Refresh();
dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString());
if (dt.Rows.Count == 0)
{
dt.Dispose();
LoadingPopUp.LoadingPopUpHidden();
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage));
return;
}
//by John
//1.Griid 합계 표시
int[] rowType = spdData.RPT_DataBindingWithSubTotalAndDivideRows(dt, 0, 1, 17, 17, 4, udcFromToDate.SubtractBetweenFromToDate + 1, btnSort);
//spdData.DataSource = dt;
//2. 칼럼 고정(필요하다면..)
//spdData.Sheets[0].FrozenColumnCount = 10;
//3. Total부분 셀머지
spdData.RPT_FillDataSelectiveCells("Total", 0, 16, 0, 4, true, Align.Center, VerticalAlign.Center);
//4. Column Auto Fit4
spdData.RPT_AutoFit(false);
spdData.RPT_FillColumnData(16, new string[] { "Yield", "In", "Out", "Loss" });
// Yield 셀 타입 변경
SetSpreadExpression();
if (chkGroup.Checked)
{
ShowChartByGroup(4, 0, 0, 17, 14, udcFromToDate.SubtractBetweenFromToDate + 1);
}
else
{
ShowChart(0);
}
}
catch (Exception ex)
{
LoadingPopUp.LoadingPopUpHidden();
CmnFunction.ShowMsgBox(ex.Message);
}
finally
{
LoadingPopUp.LoadingPopUpHidden();
}
}
private void mnuPasteTag_Click(System.Object sender, System.EventArgs e)
{
try
{
if (!(ClipboardControl == null))
{
clsCtrlStatus ResourceStatus = new clsCtrlStatus();
ResourceStatus.Key = ClipboardControl.Name + "_" + GetTagNumber(ClipboardControl.Name + "_").ToString();
ResourceStatus.SetLocation(PointToClient(MousePosition));
ResourceStatus.Size = ClipboardControl.CtrlStatus.Size;
ResourceStatus.ResTagFlag = ClipboardControl.CtrlStatus.ResTagFlag;
ResourceStatus.ResourceType = ClipboardControl.CtrlStatus.ResourceType;
ResourceStatus.Text = ClipboardControl.CtrlStatus.Text;
ResourceStatus.TextColor = ClipboardControl.CtrlStatus.TextColor;
ResourceStatus.BackColor = ClipboardControl.CtrlStatus.BackColor;
ResourceStatus.TextFontName = ClipboardControl.CtrlStatus.TextFontName;
ResourceStatus.TextSize = ClipboardControl.CtrlStatus.TextSize;
ResourceStatus.TextStyle = ClipboardControl.CtrlStatus.TextStyle;
ResourceStatus.ToolType = ClipboardControl.CtrlStatus.ToolType;
ResourceStatus.IsNoEvent = ClipboardControl.CtrlStatus.IsNoEvent;
ResourceStatus.IsViewSignal = ClipboardControl.CtrlStatus.IsViewSignal;
string sFactory = "";;
string sLayoutID = "";
string sTagID = "";
char sResType = ' ';
string sText = "";
int iTagType = 0;
int iTextSize = 0;
char sTextStyle = ' ';
int iTextColor = 0;
int iBackColor = 0;
int iLocX = 0;
int iLocY = 0;
int iLocWidth = 0;
int iLocHeight = 0;
char sNoMouseEvent = ' ';
char sSignalFlag = ' ';
if (System.Convert.ToString(m_ParentForm.Tag) == modGlobalConstant.FMB_CATEGORY_LAYOUT)
{
sFactory = modCommonFunction.GetStringBySeperator(m_ParentForm.Name, ":", 1);
sLayoutID = modCommonFunction.GetStringBySeperator(m_ParentForm.Name, ":", 2);
}
else if (System.Convert.ToString(m_ParentForm.Tag) == modGlobalConstant.FMB_CATEGORY_GROUP)
{
sFactory = GlobalVariable.gsFactory;
sLayoutID = m_ParentForm.Name;
}
sTagID = ResourceStatus.Key;
sResType = ResourceStatus.ResTagFlag[0];
sText = ResourceStatus.Text;
iTagType = CmnFunction.ToInt(ResourceStatus.ToolType);
iTextSize = ResourceStatus.TextSize;
if (ResourceStatus.TextStyle < 0)
{
sTextStyle = '0';
}
else
{
sTextStyle = (char)(ResourceStatus.TextStyle + '0');
}
iTextColor = ResourceStatus.TextColor;
iBackColor = ResourceStatus.BackColor;
iLocX = ResourceStatus.GetLocation().X;
iLocY = ResourceStatus.GetLocation().Y;
iLocWidth = ResourceStatus.GetSize().Width;
iLocHeight = ResourceStatus.GetSize().Height;
if (ResourceStatus.IsNoEvent == true)
{
sNoMouseEvent = 'Y';
}
else
{
sNoMouseEvent = ' ';
}
if (ResourceStatus.IsViewSignal == true)
{
sSignalFlag = 'Y';
}
else
{
sSignalFlag = ' ';
}
if (System.Convert.ToString(m_ParentForm.Tag) == modGlobalConstant.FMB_CATEGORY_LAYOUT)
{
if (modCommonFunction.UpdateResourceLocation(modGlobalConstant.MP_STEP_CREATE, sFactory, sLayoutID, sTagID, sResType, sText, iTagType, iTextSize, sTextStyle, iTextColor, iBackColor, iLocX, iLocY, iLocWidth, iLocHeight, sNoMouseEvent, sSignalFlag) == false)
{
return;
}
}
else if (System.Convert.ToString(m_ParentForm.Tag) == modGlobalConstant.FMB_CATEGORY_GROUP)
{
if (modCommonFunction.UpdateUDRResourceLocation(modGlobalConstant.MP_STEP_CREATE, sFactory, sLayoutID, sTagID, sResType, sText, iTagType, iTextSize, sTextStyle, iTextColor, iBackColor, iLocX, iLocY, iLocWidth, iLocHeight, sNoMouseEvent, sSignalFlag) == false)
{
return;
}
}
if (m_ParentForm.AddControl(ResourceStatus, true, false) == false)
{
return;
}
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("frmFMBDesign.mnuPasteTag_Click()" + "\r\n" + ex.Message, "FMB Client", MessageBoxButtons.OK, 1);
}
}
/// <summary>
/// 조회
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnView_Click(object sender, EventArgs e)
{
if (!CheckField())
{
return;
}
DataTable dt = null;
GridColumnInit();
try
{
LoadingPopUp.LoadIngPopUpShow(this);
spdData_Sheet1.RowCount = 0;
this.Refresh();
dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString());
if (dt.Rows.Count == 0)
{
dt.Dispose();
LoadingPopUp.LoadingPopUpHidden();
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage));
return;
}
//그루핑 순서 1순위만 SubTotal을 사용하기 위해서 첫번째 값을 가져옴
int sub = ((udcTableForm)(this.btnSort.BindingForm)).GetCheckedValue(2);
////by John (한줄짜리)
////1.Griid 합계 표시
int[] rowType = spdData.RPT_DataBindingWithSubTotal(dt, 0, sub + 1, 4, null, null, btnSort);
//spdData.DataSource = dt;
////2. 칼럼 고정(필요하다면..)
//spdData.Sheets[0].FrozenColumnCount = 9;x
////3. Total부분 셀머지
spdData.RPT_FillDataSelectiveCells("Total", 0, 4, 0, 1, true, Align.Center, VerticalAlign.Center);
//4. Column Auto Fit
spdData.RPT_AutoFit(false);
SetAvgVertical(1, 4, false);
SetAvgVertical(1, 5, false);
SetAvgVertical(1, 6, false);
SetAvgVertical(1, 7, false);
SetAvgVertical(1, 8, false);
dt.Dispose();
}
catch (Exception ex)
{
LoadingPopUp.LoadingPopUpHidden();
CmnFunction.ShowMsgBox(ex.Message);
}
finally
{
LoadingPopUp.LoadingPopUpHidden();
}
}
private void btnView_Click(object sender, EventArgs e)
{
//DurationTime_Check();
DataTable dt = null;
if (CheckField() == false)
{
return;
}
spdData_Sheet1.RowCount = 0;
try
{
LoadingPopUp.LoadIngPopUpShow(this);
this.Refresh();
dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", MakeSqlString());
GridColumnInit();
if (dt.Rows.Count == 0)
{
dt.Dispose();
LoadingPopUp.LoadingPopUpHidden();
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage));
return;
}
//그루핑 순서 1순위만 SubTotal을 사용하기 위해서 첫번째 값을 가져옴
int sub = ((udcTableForm)(this.btnSort.BindingForm)).GetCheckedValue(2);
//by John
//1.Griid 합계 표시
int[] rowType = spdData.RPT_DataBindingWithSubTotal(dt, 0, sub + 1, 9, null, null, btnSort);
//토탈 시작할 셀넘버, 시작 부터 서브토탈 몇개 쓸건지, 첫셀부터 몇번째 셀까지 TOTAL 적용안함
//3. Total부분 셀머지
spdData.RPT_FillDataSelectiveCells("Total", 0, 10, 0, 1, true, Align.Center, VerticalAlign.Center);
//4. Column Auto Fit
spdData.RPT_AutoFit(false);
// 데이타가 0인 컬럼을 삭제
spdData.RPT_RemoveZeroColumn(10, 1);
// YIELD 부분의 TOTAL값 및 SUB TOTAL을 계산하지 않고 직접 계산
string subtotal = null;
for (int i = 0; i < spdData.ActiveSheet.Columns.Count; i++)
{
if (spdData.ActiveSheet.Columns[i].Label == "YIELD")
{
if (Convert.ToDouble(spdData.ActiveSheet.Cells[0, i - 2].Value) != 0)
{
spdData.ActiveSheet.Cells[0, i].Value = ((Convert.ToDouble(spdData.ActiveSheet.Cells[0, i - 1].Value) / Convert.ToDouble(spdData.ActiveSheet.Cells[0, i - 2].Value)) * 100).ToString();
}
for (int j = 0; j < spdData.ActiveSheet.Rows.Count; j++)
{
for (int k = 0; k < sub + 1; k++)
{
if (spdData.ActiveSheet.Cells[j, k].Value != null)
{
subtotal = spdData.ActiveSheet.Cells[j, k].Value.ToString();
}
subtotal.Trim();
if (subtotal.Length > 5)
{
if (subtotal.Substring(subtotal.Length - 5, 5) == "Total")
{
if (Convert.ToInt32(spdData.ActiveSheet.Cells[j, i - 2].Value) != 0)
{
spdData.ActiveSheet.Cells[j, i].Value = ((Convert.ToDouble(spdData.ActiveSheet.Cells[j, i - 1].Value) / Convert.ToDouble(spdData.ActiveSheet.Cells[j, i - 2].Value)) * 100).ToString();
}
else
{
spdData.ActiveSheet.Cells[j, i].Value = 0;
}
}
}
}
}
}
}
}
catch (Exception ex)
{
LoadingPopUp.LoadingPopUpHidden();
CmnFunction.ShowMsgBox(ex.Message);
}
finally
{
LoadingPopUp.LoadingPopUpHidden();
}
}
//공정 미선택 시 LOSS 수량과 YIELD 차트
private void fnMakeChart2(Miracom.SmartWeb.UI.Controls.udcFarPoint SS, int iselrow)
{
/****************************************************
* Comment : SS의 데이터를 Chart에 표시한다.
*
* Created By : min-woo kim(2010-10-20)
*
* Modified By : min-woo kim(2010-10-20)
****************************************************/
int[] ich_mm = new int[iselrow - 1]; int[] icols_mm = new int[iselrow - 1]; int[] irows_mm = new int[iselrow - 1]; string[] stitle_mm = new string[1];
int[] yield_rows = new int[iselrow - 1];
int icol = 0, irow = 0;
try
{
Cursor.Current = Cursors.WaitCursor;
if (SS.Sheets[0].RowCount <= 0)
{
return;
}
cf02.RPT_1_ChartInit();
cf02.RPT_2_ClearData();
cf02.AxisX.Staggered = false;
for (icol = 0; icol < ich_mm.Length; icol++)
{
icols_mm[icol] = icol + 1;
}
for (irow = 0; irow < irows_mm.Length; irow++)
{
irows_mm[irow] = irow + 1;
yield_rows[irow] = irow + 1;
}
String legendDescLoss = "LOSS [단위 : pcs]";
String legendDescYield = "YIELD [단위 :%]";
cf02.RPT_3_OpenData(2, icols_mm.Length);
double max1 = cf02.RPT_4_AddData(SS, irows_mm, new int[] { 4 }, SeriseType.Column);
double max2 = cf02.RPT_4_AddData(SS, irows_mm, new int[] { 3 }, SeriseType.Column);
cf02.RPT_5_CloseData();
cf02.RPT_6_SetGallery(ChartType.Bar, 0, 1, legendDescLoss, AsixType.Y, DataTypes.Initeger, max1 * 1.2);
cf02.RPT_6_SetGallery(ChartType.Line, 1, 1, legendDescYield, AsixType.Y2, DataTypes.Initeger, max2 * 1.2);
cf02.Series[0].PointLabels = true;
cf02.Series[1].PointLabels = true;
cf02.RPT_7_SetXAsixTitleUsingSpread(SS, irows_mm, 0);
cf02.RPT_8_SetSeriseLegend(new string[] { "LOSS", "YIELD" }, SoftwareFX.ChartFX.Docked.Top);
cf02.AxisY.Gridlines = true;
cf02.AxisY2.Gridlines = true;
cf02.AxisY.DataFormat.Decimals = 0;
cf02.AxisY2.DataFormat.Decimals = 3;
cf02.AxisY2.Step = 1;
cf02.AxisY2.Max = 100;
cf02.AxisY2.Min = 97;
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
return;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
// 불량율 차트
private void fnMakeChart(Miracom.SmartWeb.UI.Controls.udcFarPoint SS, int iselrow)
{
/****************************************************
* Comment : SS의 데이터를 Chart에 표시한다.
*
* Created By : min-woo kim(2010-10-20)
*
* Modified By : min-woo kim(2010-10-20)
****************************************************/
int[] ich_mm = new int[6]; int[] icols_mm = new int[dtLoss.Rows.Count]; int[] irows_mm = new int[1]; string[] stitle_mm = new string[1];
int[] ich_ww = new int[iselrow - 1]; int[] icols_ww = new int[iselrow - 1]; int[] irows_ww = new int[iselrow]; string[] stitle_ww = new string[iselrow];
try
{
Cursor.Current = Cursors.WaitCursor;
if (SS.Sheets[0].RowCount <= 0)
{
return;
}
cf01.RPT_1_ChartInit();
cf01.RPT_2_ClearData();
cf01.AxisX.Title.Text = "Defect Status";
cf01.Gallery = SoftwareFX.ChartFX.Gallery.Pie;
cf01.LeftGap = 1;
cf01.RightGap = 1;
cf01.TopGap = 1;
cf01.BottomGap = 1;
cf01.AxisY.DataFormat.Format = 0;
cf01.AxisX.Staggered = false;
cf01.PointLabels = true;
for (int i = 0; i < dtLoss.Rows.Count; i++)
{
icols_mm[i] = 9 + i;
}
irows_mm[0] = iselrow;
stitle_mm[0] = SS.Sheets[0].Cells[iselrow, 0].Text;
cf01.RPT_3_OpenData(irows_mm.Length, icols_mm.Length);
cf01.RPT_4_AddData(SS, irows_mm, icols_mm, SeriseType.Rows);
cf01.RPT_5_CloseData();
//cf01.RPT_7_SetXAsixTitleUsingSpreadHeader(SS, 1, 6);
//cf01.Legend[0] = "LOSS_123";// SS.Sheets[0].Cells[0, 7].Text;
for (int i = 0; i < dtLoss.Rows.Count; i++)
{
cf01.Legend[i] = SS.Sheets[0].Columns[9 + i].Label;
}
cf01.RPT_8_SetSeriseLegend(stitle_mm, SoftwareFX.ChartFX.Docked.Top);
cf01.AxisY.DataFormat.Decimals = 0;
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
return;
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void btnView_Click(object sender, EventArgs e)
{
DataTable dt = null;
string QueryCond = null;
string FromDate = "";
string ToDate = "";
CheckField();
if (optYesterday.Checked == true)
{
FromDate = DateTime.Now.AddDays(-1).ToString("yyyyMMdd").Substring(0, 8);
ToDate = DateTime.Now.AddDays(-1).ToString("yyyyMMdd").Substring(0, 8);
}
else if (optLastWeek.Checked == true)
{
FromDate = DateTime.Now.AddDays(-(int)(DateTime.Now.DayOfWeek) - 7).ToString("yyyyMMdd").Substring(0, 8);
ToDate = DateTime.Now.AddDays(-(int)(DateTime.Now.DayOfWeek) - 1).ToString("yyyyMMdd").Substring(0, 8);
}
else if (optLastMonth.Checked == true)
{
FromDate = DateTime.Now.AddMonths(-1).ToString("yyyyMMdd").Substring(0, 6) + "01";
ToDate = DateTime.Now.AddDays(-(DateTime.Now.Day)).ToString("yyyyMMdd").Substring(0, 8);
}
else if (optPeriod.Checked == true)
{
FromDate = dtpFromDate.Value.ToString("yyyyMMdd");
ToDate = dtpToDate.Value.ToString("yyyyMMdd");
}
else if (optToday.Checked == true)
{
FromDate = DateTime.Now.ToString("yyyyMMdd").Substring(0, 8);
ToDate = DateTime.Now.ToString("yyyyMMdd").Substring(0, 8);
}
else if (optThisWeek.Checked == true)
{
FromDate = DateTime.Now.AddDays(-(int)(DateTime.Now.DayOfWeek)).ToString("yyyyMMdd").Substring(0, 8);
ToDate = DateTime.Now.AddDays(-(int)(DateTime.Now.DayOfWeek) + 6).ToString("yyyyMMdd").Substring(0, 8);
}
else if (optThisMonth.Checked == true)
{
FromDate = DateTime.Now.ToString("yyyyMMdd").Substring(0, 6) + "01";
ToDate = DateTime.Now.ToString("yyyyMMdd").Substring(0, 6) + "31";
}
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvFactory.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, FromDate);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, ToDate);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvMatGrpList.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, txtMatGrp.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvOper.Text);
spdData_Sheet1.RowCount = 0;
this.Refresh();
dt = CmnFunction.oComm.GetFuncDataTable("STD1205", QueryCond);
if (dt.Rows.Count == 0)
{
spdData.Visible = false;
}
else
{
spdData.Visible = true;
}
spdData_Sheet1.DataSource = dt;
CmnFunction.FitColumnHeader(spdData);
dt.Dispose();
}
public PRD010223_P1(string title, DataTable dt)
{
InitializeComponent();
//this.Text = title + " 상세 조회";
spdData.RPT_ColumnInit();
try
{
spdData.RPT_AddBasicColumn("MERGE PART", 0, 0, Visibles.True, Frozen.True, Align.Left, Merge.False, Formatter.String, 120);
spdData.RPT_AddBasicColumn("MAT_ID", 0, 1, Visibles.True, Frozen.True, Align.Left, Merge.False, Formatter.String, 120);
spdData.RPT_AddBasicColumn("차수", 0, 2, Visibles.True, Frozen.True, Align.Center, Merge.False, Formatter.String, 70);
spdData.RPT_AddBasicColumn("DA WIP", 0, 3, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.String, 80);
spdData.RPT_AddBasicColumn("순수", 1, 3, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("Merge", 1, 4, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("TTL", 1, 5, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_MerageHeaderColumnSpan(0, 3, 3);
spdData.RPT_AddBasicColumn("WIP Status by degree", 0, 6, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("KIT shortage status", 0, 7, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("WIP", 0, 8, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.String, 80);
spdData.RPT_AddBasicColumn("TTL", 1, 8, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("UV", 1, 9, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("Gate", 1, 10, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("DDS", 1, 11, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("SAW", 1, 12, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("BG", 1, 13, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("Steath", 1, 14, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("Pre GR", 1, 15, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("Lami", 1, 16, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("Stock", 1, 17, Visibles.True, Frozen.True, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_MerageHeaderColumnSpan(0, 8, 10);
spdData.RPT_MerageHeaderRowSpan(0, 0, 2);
spdData.RPT_MerageHeaderRowSpan(0, 1, 2);
spdData.RPT_MerageHeaderRowSpan(0, 2, 2);
spdData.RPT_MerageHeaderRowSpan(0, 6, 2);
spdData.RPT_MerageHeaderRowSpan(0, 7, 2);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
}
//spdData.DataSource = dt;
int[] rowType = spdData.RPT_DataBindingWithSubTotal(dt, 0, 1, 3);
spdData.RPT_FillDataSelectiveCells("Total", 0, 3, 0, 1, true, Align.Center, VerticalAlign.Center);
spdData.RPT_AutoFit(false);
int frmWidth = 0;
for (int i = 0; i < spdData.ActiveSheet.Columns.Count; i++)
{
frmWidth += spdData.ActiveSheet.GetColumnWidth(i);
}
Width = frmWidth + 70;
}
protected override void OnDragDrop(System.Windows.Forms.DragEventArgs drgevent)
{
try
{
if (m_ParentForm.IsDesignMode == false)
{
Cursor.Current = Cursors.No;
return;
}
if (drgevent.Effect == DragDropEffects.Copy || drgevent.Effect == DragDropEffects.Move)
{
if (modGlobalVariable.giToolType <= ListBox.NoMatches)
{
return;
}
//string sKey = "";
//string sText = "";
Size szRegion = new Size();
string sFactory = "";
if (System.Convert.ToString(m_ParentForm.Tag) == modGlobalConstant.FMB_CATEGORY_LAYOUT)
{
sFactory = modCommonFunction.GetStringBySeperator(m_ParentForm.Name, ":", 1);
}
else if (System.Convert.ToString(m_ParentForm.Tag) == modGlobalConstant.FMB_CATEGORY_GROUP)
{
sFactory = GlobalVariable.gsFactory;
}
if (modGlobalVariable.giToolType == CmnFunction.ToInt(Miracom.FMBUI.Enums.eToolType.Resource))
{
szRegion = new Size(((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultResourceSize)).Width, ((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultResourceSize)).Height);
}
else if (modGlobalVariable.giToolType == CmnFunction.ToInt(Miracom.FMBUI.Enums.eToolType.Rectangle))
{
szRegion = new Size(((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultRectangleSize)).Width, ((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultRectangleSize)).Height);
}
else if (modGlobalVariable.giToolType == CmnFunction.ToInt(Miracom.FMBUI.Enums.eToolType.Ellipse))
{
szRegion = new Size(((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultEllipseSize)).Width, ((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultEllipseSize)).Height);
}
else if (modGlobalVariable.giToolType == CmnFunction.ToInt(Miracom.FMBUI.Enums.eToolType.Triangle))
{
szRegion = new Size(((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultTriangleSize)).Width, ((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultTriangleSize)).Height);
}
else if (modGlobalVariable.giToolType == CmnFunction.ToInt(Miracom.FMBUI.Enums.eToolType.VerticalLine))
{
szRegion = new Size(((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultVerticalLineSize)).Width, ((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultVerticalLineSize)).Height);
}
else if (modGlobalVariable.giToolType == CmnFunction.ToInt(Miracom.FMBUI.Enums.eToolType.HorizontalLine))
{
szRegion = new Size(((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultHorizontalLineSize)).Width, ((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultHorizontalLineSize)).Height);
}
else if (modGlobalVariable.giToolType == CmnFunction.ToInt(Miracom.FMBUI.Enums.eToolType.PieType1))
{
szRegion = new Size(((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultPie1Size)).Width, ((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultPie1Size)).Height);
}
else if (modGlobalVariable.giToolType == CmnFunction.ToInt(Miracom.FMBUI.Enums.eToolType.PieType2))
{
szRegion = new Size(((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultPie2Size)).Width, ((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultPie2Size)).Height);
}
else if (modGlobalVariable.giToolType == CmnFunction.ToInt(Miracom.FMBUI.Enums.eToolType.PieType3))
{
szRegion = new Size(((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultPie3Size)).Width, ((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultPie3Size)).Height);
}
else if (modGlobalVariable.giToolType == CmnFunction.ToInt(Miracom.FMBUI.Enums.eToolType.PieType4))
{
szRegion = new Size(((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultPie4Size)).Width, ((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultPie4Size)).Height);
}
else if (modGlobalVariable.giToolType == CmnFunction.ToInt(Miracom.FMBUI.Enums.eToolType.TextType))
{
szRegion = new Size(((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultRectangleSize)).Width, ((Size)modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultRectangleSize)).Height);
}
Point ptLocation = this.PointToClient(new Point(drgevent.X, drgevent.Y));
ptLocation.X -= szRegion.Width / 2;
ptLocation.Y -= szRegion.Height / 2;
if (ptLocation.X < 0)
{
ptLocation.X = 0;
}
if (ptLocation.Y < 0)
{
ptLocation.Y = 0;
}
if (modGlobalVariable.giToolType > ListBox.NoMatches)
{
switch (modGlobalVariable.giToolType)
{
case 0: //CmnFunction.ToInt(Miracom.FMBUI.Enums.eToolType.Resource):
frmFMBCreateResource form = new frmFMBCreateResource(modGlobalConstant.MP_STEP_CREATE);
form.Tag = m_ParentForm.Tag;
if (!(modGlobalVariable.gNodeSelectedRes == null))
{
form.cdvResID.Text = ((clsDesignListTag)modGlobalVariable.gNodeSelectedRes.Tag).Key;
}
if (System.Convert.ToString(m_ParentForm.Tag) == modGlobalConstant.FMB_CATEGORY_LAYOUT)
{
form.txtFactory.Text = sFactory;
form.cdvLayOut.Text = modCommonFunction.GetStringBySeperator(m_ParentForm.Name, ":", 2);
}
else if (System.Convert.ToString(m_ParentForm.Tag) == modGlobalConstant.FMB_CATEGORY_GROUP)
{
form.txtFactory.Text = sFactory;
form.cdvLayOut.Text = m_ParentForm.Name;
}
else
{
CmnFunction.ShowMsgBox("pnlFMBDesign_DragDrop() Failed.", "FMB Client", MessageBoxButtons.OK, 1);
return;
}
form.txtX.Text = ptLocation.X.ToString();
form.txtY.Text = ptLocation.Y.ToString();
form.txtWidth.Text = szRegion.Width.ToString();
form.txtHeight.Text = szRegion.Height.ToString();
if (form.ShowDialog(this) == System.Windows.Forms.DialogResult.OK)
{
clsCtrlStatus ResourceStatus = new clsCtrlStatus();
ResourceStatus.Key = form.cdvResID.Text;
ResourceStatus.SetLocation(new Point(CmnFunction.ToInt(form.txtX.Text), CmnFunction.ToInt(form.txtY.Text)));
ResourceStatus.SetSize(new Size(CmnFunction.ToInt(form.txtWidth.Text), CmnFunction.ToInt(form.txtHeight.Text)));
ResourceStatus.Text = form.txtText.Text;
ResourceStatus.ResTagFlag = form.txtResTagFlag.Text;
if (form.utcText.Color.IsSystemColor == true || form.utcText.Color.IsKnownColor == true)
{
ResourceStatus.TextColor = CmnFunction.ToInt(form.utcText.Color.ToKnownColor());
}
else
{
ResourceStatus.TextColor = form.utcText.Color.ToArgb();
}
ResourceStatus.TextFontName = System.Convert.ToString(modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultFontName));
if (form.cboSize.Text == "")
{
ResourceStatus.TextSize = 0;
}
else
{
ResourceStatus.TextSize = CmnFunction.ToInt(form.cboSize.Text);
}
ResourceStatus.TextStyle = form.cboTextStyle.SelectedIndex;
ResourceStatus.ToolType = (Enums.eToolType)modGlobalVariable.giToolType;
ResourceStatus.LastEvent = form.txtLastEvent.Text;
ResourceStatus.PrimaryStatus = form.txtPriSts.Text;
ResourceStatus.ProcMode = form.txtProcMode.Text;
if (form.txtCtrlMode.Text == "ON LINE")
{
ResourceStatus.CtrlMode = "OL";
}
else if (form.txtCtrlMode.Text == "ON LINE REAL")
{
ResourceStatus.CtrlMode = "OR";
}
else if (form.txtCtrlMode.Text == "OFF LINE")
{
ResourceStatus.CtrlMode = "OF";
}
ResourceStatus.ResourceType = form.txtResourceType.Text;
ResourceStatus.UpDownFlag = form.txtUpDown.Text;
ResourceStatus.AreaID = form.txtArea.Text;
ResourceStatus.SubAreaID = form.txtSubArea.Text;
if (System.Convert.ToString(modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.IsProcessMode)) == "P")
{
ResourceStatus.IsProcessMode = true;
}
else
{
ResourceStatus.IsProcessMode = false;
}
if (System.Convert.ToString(modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.UseEventColor)) == "Y")
{
ResourceStatus.IsUseEventColor = true;
ResourceStatus.EventBackColor = modGlobalVariable.gGlobalOptions.GetOptions(sFactory, ResourceStatus.LastEvent).ToArgb();
}
else
{
ResourceStatus.IsUseEventColor = false;
ResourceStatus.EventBackColor = modGlobalVariable.gGlobalOptions.GetOptions(sFactory, ResourceStatus.LastEvent).ToArgb();
}
if (form.utcBack.Color.IsSystemColor == true || form.utcBack.Color.IsKnownColor == true)
{
ResourceStatus.BackColor = CmnFunction.ToInt(form.utcBack.Color.ToKnownColor());
}
else
{
ResourceStatus.BackColor = form.utcBack.Color.ToArgb();
}
ResourceStatus.ImageIndex = form.iImageIndex;
ResourceStatus.IsViewSignal = form.chkSignalFlag.Checked;
if (m_ParentForm.AddControl(ResourceStatus, true, false) == false)
{
return;
}
}
break;
default:
frmFMBCreateTag form1 = new frmFMBCreateTag(modGlobalConstant.MP_STEP_CREATE);
form1.Tag = m_ParentForm.Tag;
if (System.Convert.ToString(m_ParentForm.Tag) == modGlobalConstant.FMB_CATEGORY_LAYOUT)
{
form1.txtFactory.Text = sFactory;
form1.txtLayOut.Text = modCommonFunction.GetStringBySeperator(m_ParentForm.Name, ":", 2);
}
else if (System.Convert.ToString(m_ParentForm.Tag) == modGlobalConstant.FMB_CATEGORY_GROUP)
{
form1.txtFactory.Text = sFactory;
form1.txtLayOut.Text = m_ParentForm.Name;
}
else
{
CmnFunction.ShowMsgBox("pnlFMBDesign_DragDrop() Failed.", "FMB Client", MessageBoxButtons.OK, 1);
return;
}
int iTagNumber;
iTagNumber = GetTagNumber("Tag");
form1.txtTagID.Text = "Tag" + iTagNumber.ToString();
form1.txtX.Text = ptLocation.X.ToString();
form1.txtY.Text = ptLocation.Y.ToString();
form1.txtWidth.Text = szRegion.Width.ToString();
form1.txtHeight.Text = szRegion.Height.ToString();
form1.SelectedShapeIndex = modGlobalVariable.giToolType - 1;
if (form1.ShowDialog(this) == System.Windows.Forms.DialogResult.OK)
{
clsCtrlStatus ResourceStatus = new clsCtrlStatus();
ResourceStatus.Key = form1.txtTagID.Text;
ResourceStatus.SetLocation(new Point(CmnFunction.ToInt(form1.txtX.Text), CmnFunction.ToInt(form1.txtY.Text)));
if (form1.cboShape.SelectedIndex == CmnFunction.ToInt(Miracom.FMBUI.Enums.eToolType.VerticalLine) - 1)
{
ResourceStatus.SetSize(new Size(CmnFunction.ToInt(form1.txtHeight.Text), CmnFunction.ToInt(form1.txtWidth.Text)));
}
else
{
ResourceStatus.SetSize(new Size(CmnFunction.ToInt(form1.txtWidth.Text), CmnFunction.ToInt(form1.txtHeight.Text)));
}
ResourceStatus.Text = form1.txtText.Text;
ResourceStatus.ResTagFlag = form1.txtResTagFlag.Text;
if (form1.utcText.Color.IsSystemColor == true || form1.utcText.Color.IsKnownColor == true)
{
ResourceStatus.TextColor = CmnFunction.ToInt(form1.utcText.Color.ToKnownColor());
}
else
{
ResourceStatus.TextColor = form1.utcText.Color.ToArgb();
}
if (form1.utcBack.Color.IsSystemColor == true || form1.utcBack.Color.IsKnownColor == true)
{
ResourceStatus.BackColor = CmnFunction.ToInt(form1.utcBack.Color.ToKnownColor());
}
else
{
ResourceStatus.BackColor = form1.utcBack.Color.ToArgb();
}
ResourceStatus.TextFontName = System.Convert.ToString(modGlobalVariable.gGlobalOptions.GetOptions(sFactory, clsOptionData.Options.DefaultFontName));
if (form1.cboSize.Text == "")
{
ResourceStatus.TextSize = 0;
}
else
{
ResourceStatus.TextSize = CmnFunction.ToInt(form1.cboSize.Text);
}
ResourceStatus.TextStyle = form1.cboTextStyle.SelectedIndex;
ResourceStatus.ToolType = (Miracom.FMBUI.Enums.eToolType)form1.cboShape.SelectedIndex + 1;
ResourceStatus.IsNoEvent = form1.chkNoMouseEvent.Checked;
if (m_ParentForm.AddControl(ResourceStatus, true, false) == false)
{
return;
}
}
break;
}
modGlobalVariable.gNodeSelectedRes = null;
modGlobalVariable.giToolType = ListBox.NoMatches;
}
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("frmFMBDesign.pnlFMBDesign_DragDrop()" + "\r\n" + ex.Message, "FMB Client", MessageBoxButtons.OK, 1);
}
}
/// <summary>
/// 한줄헤더생성
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void GridColumnInit()
{
spdData.RPT_ColumnInit();
try
{
//spdData.ActiveSheet.ColumnHeader.Rows.Count = 1;
spdData.RPT_AddBasicColumn("Item name", 0, 0, Visibles.False, Frozen.True, Align.Center, Merge.True, Formatter.String, 50);
spdData.RPT_AddBasicColumn("Item Code", 0, 1, Visibles.True, Frozen.True, Align.Center, Merge.True, Formatter.String, 70);
spdData.RPT_AddBasicColumn("Item specification", 0, 2, Visibles.True, Frozen.True, Align.Left, Merge.True, Formatter.String, 150);
spdData.RPT_AddBasicColumn("BASE UNIT", 0, 3, Visibles.False, Frozen.False, Align.Center, Merge.True, Formatter.String, 50);
//spdData.RPT_AddBasicColumn("Operation WIP", 0, 4, Visibles.True, Frozen.False, Align.Center, Merge.True, Formatter.String, 120);
spdData.RPT_AddBasicColumn("A", 0, 4, Visibles.True, Frozen.False, Align.Right, Merge.True, Formatter.String, 40);
spdData.RPT_AddBasicColumn("B", 0, 5, Visibles.True, Frozen.False, Align.Right, Merge.True, Formatter.String, 40);
spdData.RPT_AddBasicColumn("Equipment", 0, 6, Visibles.True, Frozen.False, Align.Right, Merge.True, Formatter.String, 40);
spdData.RPT_AddBasicColumn("TOTAL(SP)", 0, 7, Visibles.True, Frozen.False, Align.Right, Merge.True, Formatter.String, 70);
spdData.RPT_AddBasicColumn("TOTAL(QTY)", 0, 8, Visibles.True, Frozen.False, Align.Right, Merge.True, Formatter.String, 70);
//spdData.RPT_MerageHeaderColumnSpan(0, 4, 5);
spdData.RPT_AddBasicColumn("USAGE", 0, 9, Visibles.True, Frozen.False, Align.Right, Merge.True, Formatter.String, 50);
spdData.RPT_AddBasicColumn("Estimated Requirements", 0, 10, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("Required number", 0, 11, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("Unit", 0, 12, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 40);
spdData.RPT_AddBasicColumn("Customer", 0, 13, Visibles.False, Frozen.False, Align.Center, Merge.False, Formatter.String, 60);
spdData.RPT_AddBasicColumn("Family", 0, 14, Visibles.False, Frozen.False, Align.Center, Merge.False, Formatter.String, 80);
spdData.RPT_AddBasicColumn("Package", 0, 15, Visibles.False, Frozen.False, Align.Center, Merge.False, Formatter.String, 60);
spdData.RPT_AddBasicColumn("Type1", 0, 16, Visibles.False, Frozen.False, Align.Center, Merge.False, Formatter.String, 70);
spdData.RPT_AddBasicColumn("Type2", 0, 17, Visibles.False, Frozen.False, Align.Center, Merge.False, Formatter.String, 70);
spdData.RPT_AddBasicColumn("LD Count", 0, 18, Visibles.False, Frozen.False, Align.Center, Merge.False, Formatter.String, 70);
spdData.RPT_AddBasicColumn("Density", 0, 19, Visibles.False, Frozen.False, Align.Center, Merge.False, Formatter.String, 70);
spdData.RPT_AddBasicColumn("Generation", 0, 20, Visibles.False, Frozen.False, Align.Center, Merge.False, Formatter.String, 70);
spdData.RPT_AddBasicColumn("Pin Type", 0, 21, Visibles.False, Frozen.False, Align.Left, Merge.False, Formatter.String, 70);
spdData.RPT_AddBasicColumn("Product", 0, 22, Visibles.True, Frozen.False, Align.Left, Merge.False, Formatter.String, 120);
//spdData.RPT_AddBasicColumn("WIP", 0, 23, Visibles.True, Frozen.False, Align.Center, Merge.False, Formatter.String, 120);
spdData.RPT_AddBasicColumn("HMKA2", 1, 23, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("B/G", 1, 24, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("SAW", 1, 25, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("D/A", 1, 26, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
if (cboMatType.Text == "LF" || cboMatType.Text == "PB" || cboMatType.Text == "AE")
{
spdData.RPT_AddBasicColumn("W/B", 1, 27, Visibles.False, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("MOLD", 1, 28, Visibles.False, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("SBA", 1, 29, Visibles.False, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("TOTAL", 1, 30, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
}
else if (cboMatType.Text == "GW")
{
spdData.RPT_AddBasicColumn("W/B", 1, 27, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("MOLD", 1, 28, Visibles.False, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("SBA", 1, 29, Visibles.False, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("TOTAL", 1, 30, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
}
else if (cboMatType.Text == "MC")
{
spdData.RPT_AddBasicColumn("W/B", 1, 27, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("MOLD", 1, 28, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("SBA", 1, 29, Visibles.False, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("TOTAL", 1, 30, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
}
else
{
spdData.RPT_AddBasicColumn("W/B", 1, 27, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("MOLD", 1, 28, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("SBA", 1, 29, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
spdData.RPT_AddBasicColumn("TOTAL", 1, 30, Visibles.True, Frozen.False, Align.Right, Merge.False, Formatter.Number, 70);
}
spdData.RPT_MerageHeaderColumnSpan(0, 23, 8);
//spdData.RPT_AddDynamicColumn("PRODUCT WIP", new string[] { "B/G", "SAW", "D/A", "W/B", "MOLD", "TOTAL" },
// 0, 14, Visibles.True, Frozen.False, Align.Right, Merge.False, new Formatter[] { Formatter.Number, Formatter.Number, Formatter.Number, Formatter.Number, Formatter.Number, Formatter.Number }, 60);
for (int i = 0; i < 23; i++)
{
spdData.RPT_MerageHeaderRowSpan(0, i, 2);
}
//spdData.RPT_MerageHeaderRowSpan(0, 0, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 1, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 2, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 3, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 4, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 5, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 6, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 7, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 8, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 9, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 10, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 11, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 12, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 13, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 14, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 15, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 16, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 17, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 18, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 19, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 20, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 21, 2);
//spdData.RPT_MerageHeaderRowSpan(0, 22, 2);
//spdData.RPT_AddDynamicColumn(udcDurationDate1, 0, 14, Visibles.False, Frozen.False, Align.Right, Merge.False, Formatter.String, 60);
spdData.RPT_ColumnConfigFromTable(btnSort); //Group항목이 있을경우 반드시 선업해줄것.
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.Message);
}
}
protected override void OnDragOver(System.Windows.Forms.DragEventArgs drgevent)
{
try
{
if (m_ParentForm.IsDesignMode == false)
{
Cursor.Current = Cursors.No;
drgevent.Effect = DragDropEffects.None;
return;
}
if (modGlobalVariable.giToolType == ListBox.NoMatches)
{
Cursor.Current = Cursors.No;
drgevent.Effect = DragDropEffects.None;
return;
}
if (!(modGlobalVariable.gNodeSelectedRes == null))
{
if (System.Convert.ToString(m_ParentForm.Tag) == modGlobalConstant.FMB_CATEGORY_LAYOUT)
{
if (((clsDesignListTag)modGlobalVariable.gNodeSelectedRes.Tag).Factory != modCommonFunction.GetStringBySeperator(m_ParentForm.Name, ":", 1))
{
Cursor.Current = Cursors.No;
drgevent.Effect = DragDropEffects.None;
return;
}
}
else if (System.Convert.ToString(m_ParentForm.Tag) == modGlobalConstant.FMB_CATEGORY_GROUP)
{
Cursor.Current = Cursors.No;
drgevent.Effect = DragDropEffects.None;
return;
}
else
{
Cursor.Current = Cursors.No;
drgevent.Effect = DragDropEffects.None;
return;
}
}
// Set the effect based upon the KeyState.
if ((drgevent.KeyState & 40) == (8 + 32) &&
(drgevent.AllowedEffect & DragDropEffects.Link) == DragDropEffects.Link)
{
// KeyState 8 + 32 = CTL + ALT
// Link drag and drop effect.
drgevent.Effect = DragDropEffects.Link;
}
else if ((drgevent.KeyState & 32) == 32 && (drgevent.AllowedEffect & DragDropEffects.Link) == DragDropEffects.Link)
{
// ALT KeyState for link.
drgevent.Effect = DragDropEffects.Link;
}
else if ((drgevent.KeyState & 4) == 4 && (drgevent.AllowedEffect & DragDropEffects.Move) == DragDropEffects.Move)
{
// SHIFT KeyState for move.
drgevent.Effect = DragDropEffects.Move;
}
else if ((drgevent.KeyState & 8) == 8 && (drgevent.AllowedEffect & DragDropEffects.Copy) == DragDropEffects.Copy)
{
// CTL KeyState for copy.
drgevent.Effect = DragDropEffects.Copy;
}
else if ((drgevent.AllowedEffect & DragDropEffects.Move) == DragDropEffects.Move)
{
// By default, the drop action should be move, if allowed.
drgevent.Effect = DragDropEffects.Move;
}
else
{
drgevent.Effect = DragDropEffects.None;
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("frmFMBDesign.pnlFMBDesign_DragOver()" + "\r\n" + ex.Message, "FMB Client", MessageBoxButtons.OK, 1);
}
}
