public Boolean View_Inquiry_Column(char cStep, string sFactory, string sInqName)
{
DataTable rtDataTable = new DataTable();
string QueryCond = null;
int i;
try
{
CmnInitFunction.InitListView(lisAttachCol);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, sFactory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, sInqName);
rtDataTable = CmnFunction.oComm.FillData("RWEBFLXCOL", "1", QueryCond);
if (rtDataTable.Rows.Count == 0)
{
return(false);
}
if (rtDataTable.Rows.Count > 0)
{
for (i = 0; i < rtDataTable.Rows.Count; i++)
{
ListViewItem itmX = null;
itmX = new ListViewItem(rtDataTable.Rows[i]["COLUMN_SEQ"].ToString());
itmX.SubItems.Add(rtDataTable.Rows[i]["COLUMN_PERIOD"].ToString());
itmX.SubItems.Add(rtDataTable.Rows[i]["COLUMN_NAME"].ToString());
lisAttachCol.Items.Add(itmX);
}
}
if (rtDataTable.Rows.Count > 0)
{
rtDataTable.Dispose();
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
return(false);
}
return(true);
}
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);
if (optLot.Checked == true)
{
QueryCond = FwxCmnFunction.PackCondition(QueryCond, "0");
}
else if (optQty1.Checked == true)
{
QueryCond = FwxCmnFunction.PackCondition(QueryCond, "1");
}
else if (optQty2.Checked == true)
{
QueryCond = FwxCmnFunction.PackCondition(QueryCond, "2");
}
spdData_Sheet1.RowCount = 0;
this.Refresh();
dt = CmnFunction.oComm.GetFuncDataTable("STD1104", QueryCond);
if (dt.Rows.Count == 0)
{
spdData.Visible = false;
}
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();
}
public static void ViewFacCMFData(Control objControl, string Factory, string Item_Name)
{
DataTable dt = null;
DataTable Redt = new DataTable();
ListViewItem itmX = null;
int iCnt;
if (Factory.TrimEnd() == "")
{
return;
}
string QueryCond = null;
QueryCond = FwxCmnFunction.PackCondition(QueryCond, Factory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, Item_Name);
dt = CmnFunction.oComm.GetFuncDataTable("VIEW_FACCMF_LIST", QueryCond);
((ListView)objControl).Items.Clear();
if (dt.Rows.Count > 0)
{
if (objControl is ListView)
{
for (iCnt = 0; iCnt < 20; iCnt++)
{
string PrtData = dt.Rows[0].ItemArray[2 + iCnt].ToString();
string TblData = dt.Rows[0].ItemArray[62 + iCnt].ToString();
itmX = new ListViewItem(PrtData);
if (PrtData != " ")
{
if (TblData == " ")
{
TblData = DefaultGcmTableName(Item_Name, iCnt);
itmX.SubItems.Add(TblData);
}
else
{
itmX.SubItems.Add(TblData);
}
itmX.Tag = dt;
((ListView)objControl).Items.Add(itmX);
}
}
}
}
}
public static bool GetTableList(Control ctlList, string sFactory, string sTable_Name)
{
DataTable rtDataTable = new DataTable();
ListViewItem itmX = null;
try
{
if (ctlList is ListView)
{
CmnInitFunction.InitListView((ListView)ctlList);
}
CmnFunction.oComm.SetUrl();
string QueryCond = null;
QueryCond = FwxCmnFunction.PackCondition(QueryCond, sFactory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, sTable_Name);
rtDataTable = CmnFunction.oComm.GetFuncDataTable("ViewGCMTableList", QueryCond);
if (rtDataTable.Rows.Count > 0)
{
for (int i = 0; i < rtDataTable.Rows.Count; i++)
{
if (ctlList is ListView)
{
itmX = new ListViewItem(rtDataTable.Rows[i][2].ToString().TrimEnd(), (int)SMALLICON_INDEX.IDX_CODE_DATA);
if (((ListView)ctlList).Columns.Count > 1)
{
itmX.SubItems.Add(rtDataTable.Rows[i][12].ToString().TrimEnd());
}
((ListView)ctlList).Items.Add(itmX);
}
}
}
return(true);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
return(false);
}
}
private void btnView_Click(object sender, EventArgs e)
{
DataTable dt = null;
string QueryCond = null;
try
{
QueryCond = FwxCmnFunction.PackCondition(QueryCond, StartDate());
QueryCond = FwxCmnFunction.PackCondition(QueryCond, EndDate());
spdData_Sheet1.RowCount = 0;
this.Refresh();
dt = CmnFunction.oComm.GetFuncDataTable("TST1107", QueryCond);
if (dt.Rows.Count == 0)
{
spdData.Visible = false;
}
else
{
spdData.Visible = true;
}
//SubTotal사용
CmnSpdFunction.DataBindingWithSubTotal(spdData, dt, 0, 0, 1);
ultraChart1.Visible = false;
if (dt.Rows.Count > 0)
{
CmnFunction.FitColumnHeader(spdData);
spdData.Sheets[0].Columns[2].Width = 120;
MakeChart(dt);
ultraChart1.SaveTo(Environment.GetFolderPath(Environment.SpecialFolder.MyPictures) + @"\myChart.png", System.Drawing.Imaging.ImageFormat.Png);
dt.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dt.Dispose();
}
}
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) + "000000";;
ToDate = DateTime.Now.AddDays(-1).ToString("yyyyMMdd").Substring(0, 8) + "235959";;
}
else if (optDate.Checked == true)
{
FromDate = dtpDate.Value.ToString("yyyyMMdd") + "000000";;
ToDate = dtpDate.Value.ToString("yyyyMMdd") + "235959";;
}
else if (optToday.Checked == true)
{
FromDate = DateTime.Now.ToString("yyyyMMdd").Substring(0, 8) + "000000";
ToDate = DateTime.Now.ToString("yyyyMMdd").Substring(0, 8) + "235959";
}
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvFactory.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvRes.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, FromDate);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, ToDate);
spdData_Sheet1.RowCount = 0;
this.Refresh();
dt = CmnFunction.oComm.GetFuncDataTable("STD1401", QueryCond);
if (dt.Rows.Count == 0)
{
spdData.Visible = false;
}
else
{
spdData.Visible = true;
}
spdData_Sheet1.DataSource = dt;
CmnFunction.FitColumnHeader(spdData);
dt.Dispose();
}
public static void ViewCmfGcmGrpList(Control objControl, string Factory, string Item_Name, string Default_Table_Name)
{
DataTable dt_Fac = null;
DataTable dt_Gcm = null;
string QueryCondFac = null;
string QueryCondGcm = null;
string Tbl_Nm = "";
ListViewItem itmX = null;
int iCnt;
QueryCondFac = FwxCmnFunction.PackCondition(QueryCondFac, Factory);
QueryCondFac = FwxCmnFunction.PackCondition(QueryCondFac, Item_Name);
dt_Fac = CmnFunction.oComm.GetFuncDataTable("VIEW_FACCMF_LIST", QueryCondFac);
if (dt_Fac.Rows.Count > 0)
{
Tbl_Nm = dt_Fac.Rows[0].ItemArray[62].ToString();
if (Tbl_Nm == " ")
{
Tbl_Nm = Default_Table_Name;
}
}
else
{
Tbl_Nm = Default_Table_Name;
}
QueryCondGcm = FwxCmnFunction.PackCondition(QueryCondGcm, Factory);
QueryCondGcm = FwxCmnFunction.PackCondition(QueryCondGcm, Tbl_Nm);
dt_Gcm = CmnFunction.oComm.GetFuncDataTable("VIEW_GCMGRP_LIST", QueryCondGcm);
((ListView)objControl).Items.Clear();
if (objControl is ListView)
{
for (iCnt = 0; iCnt < dt_Gcm.Rows.Count; iCnt++)
{
itmX = new ListViewItem(dt_Gcm.Rows[iCnt]["GROUP"].ToString().TrimEnd());
itmX.SubItems.Add(dt_Gcm.Rows[iCnt]["DESC"].ToString().TrimEnd());
itmX.Tag = dt_Gcm;
((ListView)objControl).Items.Add(itmX);
}
}
}
public DataTable GetFuncDataTable(string FunctionName, string QueryCond)
{
DataTable dt = null;
try
{
string sReturn;
//============== Log 입력 ==============//
string Log_QueryCond = null;
Log_QueryCond = FwxCmnFunction.PackCondition(Log_QueryCond, GlobalVariable.gsFactory);
Log_QueryCond = FwxCmnFunction.PackCondition(Log_QueryCond, GlobalVariable.gsUserID);
Log_QueryCond = FwxCmnFunction.PackCondition(Log_QueryCond, GlobalVariable.gsSelFunc);
Log_QueryCond = FwxCmnFunction.PackCondition(Log_QueryCond, GlobalVariable.gsSelFuncGrp);
if (GlobalVariable.gsSelFunc != null && SelectDataCount("RWEBFUNLOG", "1", Log_QueryCond) == 0) //10분내외 똑같은 function log는 쌓지않음
{
CmnFunction.oComm.InsertData("RWEBFUNLOG", "1", Log_QueryCond);
}
//============== Log 입력 ==============//
// 2012-08-22-임종우 : 모든 이벤트에 발생되어 부하 발생. 해당 기능 주석 처리
// 2010-09-02-정비재 : Query를 ClipBoard에 저장한다.
//if (GlobalVariable.gsUserGroup == "ADMIN_GROUP" || GlobalVariable.gsUserGroup == "HANA_ADMIN_GROUP")
//{
// // 2010-09-03-임종우 : QueryCond에 값이 있을 경우에만 저장
// if (!String.IsNullOrEmpty(QueryCond))
// {
// System.Windows.Forms.Clipboard.SetText(QueryCond);
// }
//}
sReturn = CmnFunction.GetErrorMessage(oWebService.GetFuncDataTable(FunctionName, QueryCond));
dt = FwxCmnFunction.StringToDataTable(sReturn);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
private string GetShift1Time()
{
DataTable rtDataTable = new DataTable();
string QueryCond = null;
string sShift1TIme = "";
try
{
CmnFunction.oComm.SetUrl();
QueryCond = FwxCmnFunction.PackCondition(QueryCond, Factory);
rtDataTable = CmnFunction.oComm.SelectData("MWIPFACDEF", "1", QueryCond);
if (rtDataTable.Rows.Count == 0)
{
QueryCond = null;
QueryCond = FwxCmnFunction.PackCondition(QueryCond, "SYSTEM");
rtDataTable = CmnFunction.oComm.SelectData("MWIPFACDEF", "1", QueryCond);
}
if (rtDataTable.Rows.Count > 0)
{
sShift1TIme = rtDataTable.Rows[0]["SHIFT_1_START"].ToString() + "00";
}
else
{
sShift1TIme = "000000";
}
rtDataTable.Dispose();
return(sShift1TIme);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
return("000000");
}
}
public static void ViewFlowList(Control objControl, string Factory, string MatID, string MatVer)
{
DataTable dt = null;
ListViewItem itmX = null;
int iCnt;
if (Factory.TrimEnd() == "")
{
return;
}
string QueryCond = null;
QueryCond = FwxCmnFunction.PackCondition(QueryCond, Factory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, MatID);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, MatVer);
dt = CmnFunction.oComm.GetFuncDataTable("ViewFlowList", QueryCond);
if (objControl is ListView)
{
for (iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
if (MatID.TrimEnd() == "")
{
itmX = new ListViewItem(dt.Rows[iCnt]["FLOW"].ToString().TrimEnd(), (int)SMALLICON_INDEX.IDX_MATERIAL);
if (((ListView)objControl).Columns.Count > 1)
{
itmX.SubItems.Add(dt.Rows[iCnt]["FLOW_DESC"].ToString().TrimEnd());
}
}
else
{
itmX = new ListViewItem(dt.Rows[iCnt]["FLOW"].ToString().TrimEnd(), (int)SMALLICON_INDEX.IDX_MATERIAL);
if (((ListView)objControl).Columns.Count > 1)
{
itmX.SubItems.Add(dt.Rows[iCnt]["FLOW_SEQ_NUM"].ToString().TrimEnd());
}
}
((ListView)objControl).Items.Add(itmX);
}
}
}
public Boolean View_Inquiry(char cStep, string sFactory, string sInqName)
{
DataTable rtDataTable = new DataTable();
string QueryCond = null;
int i = 0;
try
{
QueryCond = FwxCmnFunction.PackCondition(QueryCond, sFactory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, sInqName);
rtDataTable = CmnFunction.oComm.SelectData("RWEBFLXINQ", cStep.ToString(), QueryCond);
if (rtDataTable.Rows.Count > 0)
{
txtInqName.Text = rtDataTable.Rows[i]["INQUIRY_NAME"].ToString();
txtDesc.Text = rtDataTable.Rows[i]["INQUIRY_DESC"].ToString();
cdvFactory.Text = rtDataTable.Rows[i]["FACTORY"].ToString();
cdvInqGrp.Text = rtDataTable.Rows[i]["INQUIRY_GROUP"].ToString();
cdvSelItem.Text = rtDataTable.Rows[i]["SELECT_ITEM"].ToString();
cdvSelValue.Text = rtDataTable.Rows[i]["SELECT_VALUE"].ToString();
cdvSelGrpItem.Text = rtDataTable.Rows[i]["GROUP_ITEM"].ToString();
txtQuery.Text = rtDataTable.Rows[i]["FILTER_QUERY"].ToString();
}
if (rtDataTable.Rows.Count > 0)
{
rtDataTable.Dispose();
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
return(false);
}
return(true);
}
/// <summary>
/// View Security Group List.
/// </summary>
/// <returns>bool : True or False</returns>
private bool View_SecGrp()
{
string QueryCond;
try
{
DataTable rtDataTable = new DataTable();
QueryCond = "";
QueryCond = FwxCmnFunction.PackCondition(QueryCond, GlobalVariable.gsCentralFactory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, lisSecGrp.SelectedItems[0].Text);
rtDataTable = CmnFunction.oComm.SelectData("RWEBGRPDEF", "1", QueryCond);
if (rtDataTable.Rows.Count > 0)
{
txtSecGrp.Text = rtDataTable.Rows[0]["SEC_GRP_ID"].ToString();
txtDesc.Text = rtDataTable.Rows[0]["SEC_GRP_DESC"].ToString();
txtCreateUser.Text = rtDataTable.Rows[0]["CREATE_USER_ID"].ToString();
txtCreateTime.Text = CmnFunction.ChangeDateTimeString(rtDataTable.Rows[0]["CREATE_TIME"].ToString(), "yyyyMMddHHmmss", "yyyy-MM-dd HH:mm:ss");
txtUpdateUser.Text = rtDataTable.Rows[0]["UPDATE_USER_ID"].ToString();
txtUpdateTime.Text = CmnFunction.ChangeDateTimeString(rtDataTable.Rows[0]["UPDATE_TIME"].ToString(), "yyyyMMddHHmmss", "yyyy-MM-dd HH:mm:ss");
}
else
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD014", GlobalVariable.gcLanguage));
return(false);
}
rtDataTable.Dispose();
return(true);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("SEC1102.View_SecGrp() : " + ex.ToString());
return(false);
}
}
public static void ViewGCMGrpList(Control objControl, string Factory, string SelPrt, string SelTbl)
{
DataTable dt = null;
ListViewItem itmX = null;
int iCnt;
string QueryCond = null;
QueryCond = FwxCmnFunction.PackCondition(QueryCond, Factory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, SelTbl);
dt = CmnFunction.oComm.GetFuncDataTable("VIEW_GCMGRP_LIST", QueryCond);
((ListView)objControl).Items.Clear();
if (objControl is ListView)
{
for (iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
itmX = new ListViewItem(dt.Rows[iCnt]["GROUP"].ToString().TrimEnd());
itmX.SubItems.Add(dt.Rows[iCnt]["DESC"].ToString().TrimEnd());
itmX.Tag = dt;
((ListView)objControl).Items.Add(itmX);
}
}
}
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, cdvRes.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, StartDate());
QueryCond = FwxCmnFunction.PackCondition(QueryCond, EndDate());
spdData_Sheet1.RowCount = 0;
this.Refresh();
dt = CmnFunction.oComm.GetFuncDataTable("STD1405", 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();
}
private void spdData_CellClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
DataTable RetDT = null;
string QueryCond = null;
if (e.Row < 0)
{
return;
}
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvFactory.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, Convert.ToString(spdData.Sheets[0].GetValue(e.Row, 2)));
QueryCond = FwxCmnFunction.PackCondition(QueryCond, Convert.ToString(spdData.Sheets[0].GetValue(e.Row, 0)));
QueryCond = FwxCmnFunction.PackCondition(QueryCond, Convert.ToDateTime(spdData.Sheets[0].GetValue(e.Row, 5)).ToString("yyyyMMddHHmmss"));
QueryCond = FwxCmnFunction.PackCondition(QueryCond, Convert.ToDateTime(spdData.Sheets[0].GetValue(e.Row, 4)).ToString("yyyyMMddHHmmss"));
spdDetail_Sheet1.RowCount = 0;
this.Refresh();
RetDT = CmnFunction.oComm.GetFuncDataTable("STD1608_1", QueryCond);
if (RetDT.Rows.Count == 0)
{
spdDetail.Visible = false;
}
else
{
spdDetail.Visible = true;
spdDetail_Sheet1.DataSource = RetDT;
}
spdDetail_Sheet1.SetColumnAllowAutoSort(0, spdDetail_Sheet1.ColumnCount, true);
CmnFunction.FitColumnHeader(spdDetail);
CmnInitFunction.InitLockSpread(spdDetail);
RetDT.Dispose();
}
public static void ViewMatVerList(Control objControl, string Factory, string MatID)
{
DataTable dt = null;
ListViewItem itmX = null;
int iCnt;
if (Factory.TrimEnd() == "" || MatID.TrimEnd() == "")
{
return;
}
string QueryCond = null;
QueryCond = FwxCmnFunction.PackCondition(QueryCond, Factory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, MatID);
dt = CmnFunction.oComm.GetFuncDataTable("ViewMaterialVerList", QueryCond);
if (objControl is ListView)
{
for (iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
itmX = new ListViewItem(dt.Rows[iCnt]["MAT_VER"].ToString().TrimEnd(), (int)SMALLICON_INDEX.IDX_MATERIAL);
((ListView)objControl).Items.Add(itmX);
}
}
}
/// <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);
}
}
public static void ViewMatList(Control objControl, string Factory, string MatID)
{
DataTable dt = null;
ListViewItem itmX = null;
int iCnt;
string QueryCond = null;
QueryCond = FwxCmnFunction.PackCondition(QueryCond, Factory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, MatID);
dt = CmnFunction.oComm.GetFuncDataTable("ViewMaterialList", QueryCond);
if (objControl is ListView)
{
for (iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
itmX = new ListViewItem(dt.Rows[iCnt]["MAT_ID"].ToString().TrimEnd(), (int)SMALLICON_INDEX.IDX_MATERIAL);
if (((ListView)objControl).Columns.Count > 1)
{
itmX.SubItems.Add(dt.Rows[iCnt]["MAT_DESC"].ToString().TrimEnd());
}
((ListView)objControl).Items.Add(itmX);
}
}
}
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 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();
}
private void btnView_Click(object sender, EventArgs e)
{
DataTable RetDT = null;
DataTable ReRetDT = new DataTable();
string QueryCond = null;
if (CheckField() == false)
{
return;
}
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvFactory.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvOper.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, txtLotID.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, dtpFromDate.Value.ToString("yyyyMMdd"));
QueryCond = FwxCmnFunction.PackCondition(QueryCond, dtpToDate.Value.ToString("yyyyMMdd"));
QueryCond = FwxCmnFunction.PackCondition(QueryCond, chkIncludeZeroLot.Checked == true ? "Y" : "");
spdData_Sheet1.RowCount = 0;
this.Refresh();
RetDT = CmnFunction.oComm.GetFuncDataTable("STD1609", QueryCond);
if (RetDT.Rows.Count == 0)
{
spdData.Visible = false;
}
else
{
spdData.Visible = true;
for (int i = 0; i < RetDT.Columns.Count; i++)
{
DataColumn DetailCol = new DataColumn();
DetailCol.ReadOnly = false;
DetailCol.Unique = false;
DetailCol.ColumnName = RetDT.Columns[i].ColumnName;
DetailCol.DataType = System.Type.GetType("System.String");
ReRetDT.Columns.Add(DetailCol);
}
//New DataTable Value Á¤ÀÇ
for (int i = 0; i < RetDT.Rows.Count; i++)
{
DataRow OperRow = null;
OperRow = ReRetDT.NewRow();
OperRow[0] = RetDT.Rows[i].ItemArray[0];
ReRetDT.Rows.Add(OperRow);
for (int j = 1; j < RetDT.Columns.Count; j++)
{
if (j == 6 || j == 7 || j == 8)
{
ReRetDT.Rows[i][j] = CmnFunction.ToDate(RetDT.Rows[i].ItemArray[j].ToString().Trim());
}
else
{
if (j == 5 || j == 9 || j == 10)
{
ReRetDT.Rows[i][j] = CmnFunction.ToDbl(RetDT.Rows[i].ItemArray[j]).ToString("#########0.####");
}
else
{
ReRetDT.Rows[i][j] = RetDT.Rows[i].ItemArray[j];
}
}
}
}
}
spdData_Sheet1.DataSource = ReRetDT;
spdData_Sheet1.SetColumnAllowAutoSort(0, spdData_Sheet1.ColumnCount, true);
CmnFunction.FitColumnHeader(spdData);
CmnInitFunction.InitLockSpread(spdData);
RetDT.Dispose();
}
private void btnView_Click(object sender, EventArgs e)
{
DataTable dt = null;
string QueryCond = null;
string FromDate = "";
string ToDate = "";
if (CheckField() == false)
{
return;
}
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, cdvOper.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, FromDate);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, ToDate);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvMat.Text);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvMatVer.Text);
spdData_Sheet1.RowCount = 0;
this.Refresh();
dt = CmnFunction.oComm.GetFuncDataTable("STD1207", QueryCond);
if (dt.Rows.Count == 0)
{
spdData.Visible = false;
}
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();
}
public DataTable fnExecutePackage(String sFuncName, String sPackage, String sParameter)
{
/************************************************************
* comment : Oracle Package/Procedure를 실행하기 위하여 추가함.
*
* created by : bee-jae jung(2010-08-12-목요일)
*
* modified by : bee-jae jung(2010-08-12-목요일)
************************************************************/
DataTable dt = null;
String sReturn = "";
char cDiv = '│'; // 2010-08-12-정비재 : ㅂ + 한자 key를 클릭하면 2번
try
{
/************ Log 입력 Start ************/
String Log_QueryCond = null;
Log_QueryCond = FwxCmnFunction.PackCondition(Log_QueryCond, GlobalVariable.gsFactory);
Log_QueryCond = FwxCmnFunction.PackCondition(Log_QueryCond, GlobalVariable.gsUserID);
Log_QueryCond = FwxCmnFunction.PackCondition(Log_QueryCond, GlobalVariable.gsSelFunc);
Log_QueryCond = FwxCmnFunction.PackCondition(Log_QueryCond, GlobalVariable.gsSelFuncGrp);
// 10분 내외 똑같은 function log는 쌓지않음
if (GlobalVariable.gsSelFunc != null && SelectDataCount("RWEBFUNLOG", "1", Log_QueryCond) == 0)
{
CmnFunction.oComm.InsertData("RWEBFUNLOG", "1", Log_QueryCond);
}
/************ Log 입력 End ************/
/********************************************************************************************************/
// 2010-08-12-정비재 : Oracle Package / Procedure용 Query문을 생성한다.
String sPackageQuery = null;
sPackageQuery = FwxCmnFunction.PackCondition(sPackageQuery, "PACKAGE");
sPackageQuery = FwxCmnFunction.PackCondition(sPackageQuery, sPackage);
for (int iRow = 0; iRow < sParameter.Split(cDiv).Length; iRow++)
{
sPackageQuery = FwxCmnFunction.PackCondition(sPackageQuery, sParameter.Split(cDiv)[iRow].Trim());
}
/********************************************************************************************************/
// 2012-08-22-임종우 : 모든 이벤트에 발생되어 부하 발생. 해당 기능 주석 처리
// 2010-09-02-정비재 : Query를 ClipBoard에 저장한다.
//if (GlobalVariable.gsUserGroup == "ADMIN_GROUP" || GlobalVariable.gsUserGroup == "HANA_ADMIN_GROUP")
//{
// // 2010-09-03-임종우 : QueryCond에 값이 있을 경우에만 저장
// if (!String.IsNullOrEmpty(sPackageQuery))
// {
// System.Windows.Forms.Clipboard.SetText(sPackageQuery);
// }
//}
sReturn = CmnFunction.GetErrorMessage(oWebService.GetFuncDataTable(sFuncName, sPackageQuery));
dt = FwxCmnFunction.StringToDataTable(sReturn);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
/// <summary>
/// Update RWEBUSRDEF Table.
/// </summary>
/// <param name="secUserId">Update UserID value</param>
/// <returns>bool : True or False</returns>
private bool Update_Security_User(string secUserId)
{
string sysCurrentDate, tempValue = "";
DataTable rtDataTable = new DataTable();
if (ChkCustomer() == false)
{
return(false);
}
try
{
string QueryCond;
string UpdateValue;
QueryCond = "";
QueryCond = FwxCmnFunction.PackCondition(QueryCond, GlobalVariable.gsCentralFactory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvSecGrpId.Text);
rtDataTable = CmnFunction.oComm.SelectData("RWEBGRPDEF", "1", QueryCond);
if (rtDataTable.Rows.Count <= 0)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD014", GlobalVariable.gcLanguage));
return(false);
}
QueryCond = "";
QueryCond = FwxCmnFunction.PackCondition(QueryCond, GlobalVariable.gsCentralFactory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, txtUserId.Text);
rtDataTable = CmnFunction.oComm.SelectData("RWEBUSRDEF", "1", QueryCond);
if (rtDataTable.Rows.Count <= 0)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD013", GlobalVariable.gcLanguage));
return(false);
}
else
{
QueryCond = "";
sysCurrentDate = "";
sysCurrentDate = CmnFunction.oComm.GetFuncDataString("GetSystemTime", QueryCond);
if (sysCurrentDate == null)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD000", GlobalVariable.gcLanguage));
return(false);
}
UpdateValue = "";
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, GlobalVariable.gsCentralFactory);
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtUserId.Text.Trim());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtUserDesc.Text.Trim());
//UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtPassword.Text.Trim());
if (chkChangePassFlag.Checked == true)
{
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "Y");
}
else
{
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
}
//USER_GRP_?
// 2011-08-26-임종우 : 사용자 부서, 직급, 외부접속 허용 데이터를 업데이트 시 기존에 초기화 시키고 있음. -> 기존 데이터 저장하도록 변경.
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, rtDataTable.Rows[0][5].ToString());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, rtDataTable.Rows[0][6].ToString());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, cdvCustomer.Text.Trim());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
//USER_CMF_?
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, rtDataTable.Rows[0][24].ToString());
//SEC_GRP_ID
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, cdvSecGrpId.Text.Trim());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtPhoneOffice.Text.Trim());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtPhoneMobile.Text.Trim());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtPhoneHome.Text.Trim());
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtPhoneOther.Text.Trim());
tempValue = CmnFunction.ChangeDateTimeString(dtpEnterDate.Text, "yyyy-MM-dd", "yyyyMMdd");
if (tempValue != "")
{
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, tempValue);
}
else
{
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
}
tempValue = CmnFunction.ChangeDateTimeString(dtpRetireDate.Text, "yyyy-MM-dd", "yyyyMMdd");
if (tempValue != "")
{
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, tempValue);
}
else
{
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
}
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtEmail.Text.Trim());
tempValue = CmnFunction.ChangeDateTimeString(dtpBirthDate.Text, "yyyy-MM-dd", "yyyyMMdd");
if (tempValue != "")
{
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, tempValue);
}
else
{
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "");
}
//SEX_FLAG
if (rbnFemale.Checked == true)
{
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "F");
}
else if (rbnMale.Checked == true)
{
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, "M");
}
//CREATE_USER_ID
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtCreateUser.Text);
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, CmnFunction.ChangeDateTimeString(txtCreateTime.Text, "yyyy-MM-dd HH:mm:ss", "yyyyMMddHHmmss"));
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, GlobalVariable.gsUserID);
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, sysCurrentDate);
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, GlobalVariable.gsCentralFactory);
UpdateValue = FwxCmnFunction.PackCondition(UpdateValue, txtUserId.Text.Trim());
if (CmnFunction.oComm.UpdateData("RWEBUSRDEF", "1", UpdateValue) != true)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD000", GlobalVariable.gcLanguage));
return(false);
}
return(true);
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("SEC1101.Update_Security_User() : " + 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="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>
/// Select UserID detail.
/// </summary>
/// <param name="factoryId">FactoryID value</param>
/// <param name="userID">UserID value</param>
/// <returns>bool : True or False</returns>
private bool FindUserInfo(string factoryId, string userID)
{
string value = "";
try
{
DataTable rtDataTable = new DataTable();
string QueryCond = null;
QueryCond = FwxCmnFunction.PackCondition(QueryCond, factoryId);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, userID);
rtDataTable = CmnFunction.oComm.SelectData("RWEBUSRDEF", "1", QueryCond);
if (rtDataTable.Rows.Count > 0)
{
txtUserId.Text = rtDataTable.Rows[0]["USER_ID"].ToString().Trim();
txtUserDesc.Text = rtDataTable.Rows[0]["USER_DESC"].ToString().Trim();
txtPassword.Text = rtDataTable.Rows[0]["PASSWORD"].ToString().Trim();
cdvSecGrpId.Text = rtDataTable.Rows[0]["SEC_GRP_ID"].ToString().Trim();
txtEmail.Text = rtDataTable.Rows[0]["EMAIL_ID"].ToString().Trim();
txtPhoneOffice.Text = rtDataTable.Rows[0]["PHONE_OFFICE"].ToString().Trim();
txtPhoneMobile.Text = rtDataTable.Rows[0]["PHONE_MOBILE"].ToString().Trim();
txtPhoneHome.Text = rtDataTable.Rows[0]["PHONE_HOME"].ToString().Trim();
txtPhoneOther.Text = rtDataTable.Rows[0]["PHONE_OTHER"].ToString().Trim();
cdvCustomer.Text = rtDataTable.Rows[0]["USER_GRP_3"].ToString().Trim();
if (rtDataTable.Rows[0]["SEX_FLAG"].ToString().Trim() == "M")
{
rbnMale.Checked = true;
rbnFemale.Checked = false;
}
else
{
rbnMale.Checked = false;
rbnFemale.Checked = true;
}
value = rtDataTable.Rows[0]["CHG_PASS_FLAG"].ToString().Trim();
if (value == "Y")
{
chkChangePassFlag.Checked = true;
}
else
{
chkChangePassFlag.Checked = false;
}
dtpBirthDate.CustomFormat = " ";
value = rtDataTable.Rows[0]["BIRTHDAY"].ToString().Trim();
if (value != "")
{
DateTime dtTemp;
if (CmnFunction.StringToDateTime(value, "yyyyMMdd", out dtTemp))
{
dtpBirthDate.Text = dtTemp.ToString();
}
}
dtpEnterDate.CustomFormat = " ";
value = rtDataTable.Rows[0]["ENTER_DATE"].ToString().Trim();
if (value != "")
{
DateTime dtTemp;
if (CmnFunction.StringToDateTime(value, "yyyyMMdd", out dtTemp))
{
dtpEnterDate.Text = dtTemp.ToString();
}
}
dtpRetireDate.CustomFormat = " ";
value = rtDataTable.Rows[0]["RETIRE_DATE"].ToString().Trim();
if (value != "")
{
DateTime dtTemp;
if (CmnFunction.StringToDateTime(value, "yyyyMMdd", out dtTemp))
{
dtpRetireDate.Text = dtTemp.ToString();
}
}
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 = "";
}
}
else
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD013", GlobalVariable.gcLanguage));
}
if (rtDataTable.Rows.Count > 0)
{
rtDataTable.Dispose();
}
return(true);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("SEC1101.FindUserInfo() : " + ex.ToString());
return(false);
}
}
/// <summary>
/// Insert RWEBUSRDEF Table.
/// </summary>
/// <returns>bool : True or False</returns>
private bool Create_Security_User()
{
string sysCurrentDate, tempValue = "";
DataTable rtDataTable = new DataTable();
try
{
string QueryCond;
string InsertValue;
QueryCond = "";
QueryCond = FwxCmnFunction.PackCondition(QueryCond, GlobalVariable.gsCentralFactory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvSecGrpId.Text);
rtDataTable = CmnFunction.oComm.SelectData("RWEBGRPDEF", "1", QueryCond);
if (rtDataTable.Rows.Count <= 0)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD014", GlobalVariable.gcLanguage));
return(false);
}
QueryCond = "";
QueryCond = FwxCmnFunction.PackCondition(QueryCond, GlobalVariable.gsCentralFactory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, txtUserId.Text);
rtDataTable = CmnFunction.oComm.SelectData("RWEBUSRDEF", "1", QueryCond);
if (rtDataTable.Rows.Count > 0)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD015", GlobalVariable.gcLanguage));
return(false);
}
else
{
QueryCond = "";
sysCurrentDate = "";
sysCurrentDate = CmnFunction.oComm.GetFuncDataString("GetSysTime", QueryCond);
if (sysCurrentDate == null)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD000", GlobalVariable.gcLanguage));
return(false);
}
InsertValue = "";
InsertValue = FwxCmnFunction.PackCondition(InsertValue, GlobalVariable.gsCentralFactory);
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtUserId.Text.Trim());
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtUserDesc.Text.Trim());
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtPassword.Text.Trim());
if (chkChangePassFlag.Checked == true)
{
InsertValue = FwxCmnFunction.PackCondition(InsertValue, "Y");
}
else
{
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
}
//USER_GRP_?
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, cdvCustomer.Text.Trim());
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
//USER_CMF_?
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, " ");
//SEC_GRP_ID
InsertValue = FwxCmnFunction.PackCondition(InsertValue, cdvSecGrpId.Text.Trim());
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtPhoneOffice.Text.Trim());
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtPhoneMobile.Text.Trim());
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtPhoneHome.Text.Trim());
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtPhoneOther.Text.Trim());
tempValue = CmnFunction.ChangeDateTimeString(dtpEnterDate.Text, "yyyy-MM-dd", "yyyyMMdd");
if (tempValue != "")
{
InsertValue = FwxCmnFunction.PackCondition(InsertValue, tempValue);
}
else
{
InsertValue = FwxCmnFunction.PackCondition(InsertValue, "");
}
tempValue = CmnFunction.ChangeDateTimeString(dtpRetireDate.Text, "yyyy-MM-dd", "yyyyMMdd");
if (tempValue != "")
{
InsertValue = FwxCmnFunction.PackCondition(InsertValue, tempValue);
}
else
{
InsertValue = FwxCmnFunction.PackCondition(InsertValue, "");
}
InsertValue = FwxCmnFunction.PackCondition(InsertValue, txtEmail.Text.Trim());
tempValue = CmnFunction.ChangeDateTimeString(dtpBirthDate.Text, "yyyy-MM-dd", "yyyyMMdd");
if (tempValue != "")
{
InsertValue = FwxCmnFunction.PackCondition(InsertValue, tempValue);
}
else
{
InsertValue = FwxCmnFunction.PackCondition(InsertValue, "");
}
//SEX_FLAG
if (rbnFemale.Checked == true)
{
InsertValue = FwxCmnFunction.PackCondition(InsertValue, "F");
}
else if (rbnMale.Checked == true)
{
InsertValue = FwxCmnFunction.PackCondition(InsertValue, "M");
}
//CREATE_USER_ID
InsertValue = FwxCmnFunction.PackCondition(InsertValue, GlobalVariable.gsUserID);
InsertValue = FwxCmnFunction.PackCondition(InsertValue, sysCurrentDate);
InsertValue = FwxCmnFunction.PackCondition(InsertValue, "");
InsertValue = FwxCmnFunction.PackCondition(InsertValue, "");
if (CmnFunction.oComm.InsertData("RWEBUSRDEF", "1", InsertValue) != true)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD000", GlobalVariable.gcLanguage));
return(false);
}
return(true);
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("SEC1101.Create_Security_User() : " + ex.ToString());
return(false);
}
}
private Boolean UpdateProcOper(string sStep, string sOper, int iSeq, string sOperDesc)// 수정- Oper/OperGroup Function Item리스트
{
string QueryData = "";
string QueryCondUpdt = null;
string QueryCond = null;
try
{
QueryCondUpdt = FwxCmnFunction.PackCondition(QueryCondUpdt, GlobalVariable.gsUserID);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, cdvFactory.Text);
QueryCondUpdt = FwxCmnFunction.PackCondition(QueryCondUpdt, cdvFactory.Text);
QueryData = lisFunction.SelectedItems[0].SubItems[0].Text.Trim();
QueryCond = FwxCmnFunction.PackCondition(QueryCond, QueryData);
QueryCondUpdt = FwxCmnFunction.PackCondition(QueryCondUpdt, QueryData);
if (rbnOper.Checked)
{
QueryData = "OPR";
}
else
{
QueryData = "OPRGRP";
}
QueryCond = FwxCmnFunction.PackCondition(QueryCond, QueryData);
QueryCondUpdt = FwxCmnFunction.PackCondition(QueryCondUpdt, QueryData);
int seq = iSeq + 1;
QueryCond = FwxCmnFunction.PackCondition(QueryCond, seq.ToString());
QueryCondUpdt = FwxCmnFunction.PackCondition(QueryCondUpdt, seq.ToString());
QueryCond = FwxCmnFunction.PackCondition(QueryCond, sOper);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, sOperDesc);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, GlobalVariable.gsUserID);
if (sStep == "1")//insert
{
if (CmnFunction.oComm.UpdateData("RWEBFUNITM", "1", QueryCondUpdt))
{
if (!CmnFunction.oComm.InsertData("RWEBFUNITM", "1", QueryCond))
{
CmnFunction.ShowMsgBox("RPT-0004");
return(false);
}
else
{
CmnInitFunction.InitListView(lisProcOper);
CmnInitFunction.InitListView(lisOper);
return(true);
}
}
else
{
CmnInitFunction.InitListView(lisProcOper);
CmnInitFunction.InitListView(lisOper);
return(true);
}
}
else if (sStep == "2")//delete
{
if (CmnFunction.oComm.DeleteData("RWEBFUNITM", "1", QueryCond))
{
if (!CmnFunction.oComm.UpdateData("RWEBFUNITM", "2", QueryCondUpdt))
{
CmnFunction.ShowMsgBox("RPT-0004");
return(false);
}
else
{
CmnInitFunction.InitListView(lisProcOper);
CmnInitFunction.InitListView(lisOper);
return(true);
}
}
else
{
CmnInitFunction.InitListView(lisProcOper);
CmnInitFunction.InitListView(lisOper);
return(true);
}
}
else
{
CmnInitFunction.InitListView(lisProcOper);
CmnInitFunction.InitListView(lisOper);
return(true);
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
return(false);
}
}
