private void Act1_FormInit(SAPbouiCOM.Form oForm)
{
oForm.Freeze(true);
Act2_DataSourcesBinding(oForm);
//Call LabelInit(oForm)
Act3_DefualtSetting(oForm, "", "");
Act4_FormMenuSetting(oForm);
//FindData(false)
oForm.Freeze(false);
}
private static void FindData(SAPbouiCOM.Form oForm)
{
SAPbouiCOM.Grid oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
string edtDATE = oForm.DataSources.UserDataSources.Item("edtDATE").Value;
string cboGROUP = oForm.DataSources.UserDataSources.Item("cboGROUP").Value;
string GrdTitle = string.Empty;
int BDATE = Convert.ToInt16(edtDATE) -1;
StringBuilder pQuery = new StringBuilder();
string query = string.Empty;
pQuery.AppendLine(" EXEC [KIS_SP_SD0180F1_HRD] ");
pQuery.AppendLine(" @DATE = '{0}' ");
pQuery.AppendLine(" ,@GROUP = '{1}' ");
string sQry = string.Format(pQuery.ToString(), edtDATE, cboGROUP);
try
{
GrdTitle = string.Format("{0}년1월,{1}년1월,{0}년2월,{1}년2월,{0}년3월,{1}년3월,{0}년4월,{1}년4월,{0}년5월,{1}년5월,{0}년6월,{1}년6월,{0}년7월,{1}년7월,{0}년8월,{1}년8월,{0}년9월,{1}년9월,{0}년10월,{1}년10월,{0}년11월,{1}년11월,{0}년12월,{1}년12월,{0}년합계,{1}년합계,ROWSID", BDATE, edtDATE);
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oGrid.SelectionMode = BoMatrixSelect.ms_Single;
string cv_ColumnsUID_s = "LINENUM,GROUP1,CARDNM,BMON1,MON1,BMON2,MON2,BMON3,MON3,BMON4,MON4,BMON5,MON5,BMON6,MON6,BMON7,MON7,BMON8,MON8,BMON9,MON9,BMON10,MON10,BMON11,MON11,BMON12,MON12,BAMTSUM,AMTSUM,ROWSID";
string cv_NoEditable_s = "LINENUM,GROUP1,CARDNM,BMON1,MON1,BMON2,MON2,BMON3,MON3,BMON4,MON4,BMON5,MON5,BMON6,MON6,BMON7,MON7,BMON8,MON8,BMON9,MON9,BMON10,MON10,BMON11,MON11,BMON12,MON12,BAMTSUM,AMTSUM,ROWSID";
string cv_ColumnsNAM_s = string.Format("#,고객그룹-기업,BP명,{0}",GrdTitle);
string cv_Right_Just_s = "BMON1,MON1,BMON2,MON2,BMON3,MON3,BMON4,MON4,BMON5,MON5,BMON6,MON6,BMON7,MON7,BMON8,MON8,BMON9,MON9,BMON10,MON10,BMON11,MON11,BMON12,MON12,BAMTSUM,AMTSUM";
string cv_No_Visible_s = "LINENUM,ROWSID";
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oForm.Freeze(true);
oForm.DataSources.DataTables.Item("grd").ExecuteQuery(sQry);
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd"); //데이터 그리드에 Display
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid.DataTable.Rows.Count == 1 && oGrid.DataTable.GetValue("GROUP1", 0).ToString() == "")
{
FN.SetGridTitle(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_No_Visible_s);
B1Connections.theAppl.StatusBar.SetText("데이터가 없습니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터가 없습니다.
}
else
{
FN.BindGrid(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
//FN.SetGridSumField(ref oGrid, cv_Right_Just_s);
B1Connections.theAppl.StatusBar.SetText("조회완료", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success); //조회완료
oGrid.RowHeaders.Width = 0;
#region Color Setting
Color newRGBColor = Color.FromArgb(100, 100, 200);
//int rowForeColor = newRGBColor.R | (newRGBColor.G << 8) | (newRGBColor.B << 16);
string DefultFontColor = "#000000";
Color systemBackColor = Color.FromArgb(217, 229, 242);
int rowBackColor1 = Color.LightYellow.R | Color.LightYellow.G << 8 | Color.LightYellow.B << 16;
int rowBackColor2 = Color.LightCyan.R | Color.LightCyan.G << 8 | Color.LightCyan.B << 16;
int blueForeColor = Color.Blue.R | (Color.Blue.G << 8) | (Color.Blue.B << 16);
int redForeColor = Color.Red.R | Color.Red.G << 8 | Color.Red.B << 16;
//int iDefultFontColor = setting.GetCellFontColor(-1, 1);
int iDefultFontColor = Convert.ToInt32(System.Drawing.ColorTranslator.FromHtml(DefultFontColor).ToArgb());
int iDefultBackColor = systemBackColor.R | (systemBackColor.G << 8) | (systemBackColor.B << 16);
#endregion
#region GridColorSet
FN.SetColumnProperty(oForm, "grd", "BackColor=#DCDCDC");
XDocument root = XDocument.Parse(oGrid.DataTable.SerializeAsXML(BoDataTableXmlSelect.dxs_DataOnly));
//필터링 : 선택된 행의 컬랙션을 조회합니다.
var rows = from c in root.Descendants("Row")
where c.Elements("Cells").Elements("Cell").Any(o => o.Element("ColumnUid").Value == "ROWSID" && o.Element("Value").Value != "0")
select c;
string Row = string.Empty;
foreach (XElement r in rows)
{
foreach (XElement c in r.Descendants("Cell"))
{
string ColumnUid = c.Element("ColumnUid").Value;
string Value = c.Element("Value").Value;
if (ColumnUid == "LINENUM")
{
Row = c.Element("Value").Value;
}
else if (ColumnUid == "CARDNM")
{
if (Value == "소계")
oGrid.CommonSetting.SetRowBackColor(Convert.ToInt32(Row), rowBackColor1);
else
oGrid.CommonSetting.SetRowBackColor(Convert.ToInt32(Row), rowBackColor2);
}
}
}
#endregion
//for (int i = 0; i < oGrid.Rows.Count; i++)
//{
// if (oGrid.DataTable.GetValue("CARDNM", i) == "소계")
// {
// oGrid.CommonSetting.SetRowBackColor(i + 1, rowBackColor1);
// }
// else if(oGrid.DataTable.GetValue("CARDNM", i) == "합계")
// {
// oGrid.CommonSetting.SetRowBackColor(i + 1, rowBackColor2);
// }
// else
// {
// oGrid.CommonSetting.SetRowBackColor(i + 1, iDefultBackColor);
// }
//}
oGrid.CommonSetting.FixedColumnsCount = 3;
oGrid.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("btnFIND_OnAfterItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oGrid = null;
}
}
private void GetAdvanceAmt(SAPbouiCOM.Form oForm)
{
string strREADCD = string.Empty;
try
{
oForm.Freeze(true);
oUDS = oForm.DataSources.UserDataSources;
oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0030M_HRD");
strREADCD = oDB_M.GetValue("Code", 0).Trim();
string strRtnValue = FN.GetRecordsetValue(string.Format( " SELECT ISNULL(U_AMT,0) FROM KIS_VW_SO02401_HRD WHERE U_READCD = '{0}' " , strREADCD));
oUDS.Item("edtADVANCE").Value = strRtnValue;
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("GetAdvanceAmt " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oForm.Refresh();
}
}
public void SetGridTitle(SAPbouiCOM.Form oForm)
{
//ADD YOUR ACTION CODE HERE ...
try
{
oForm.Freeze(true);
//* 미발행 그리드 초기화 */
oForm.DataSources.DataTables.Add("grd");
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd");
FN.SetGridTitle(oGrid
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnUid)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnName)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotVisible)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotEditable));
oGrid.RowHeaders.Width = 0;
oGrid.AutoResizeColumns();
oGrid.SelectionMode = BoMatrixSelect.ms_NotSupported;
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("SetGridTitle " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oForm.Refresh();
}
}
private void FindData(SAPbouiCOM.Form oForm)
{
string cv_ColumnsUID_s;
string cv_NoEditable_s;
string cv_ColumnsNAM_s;
string cv_Right_Just_s;
string cv_No_Visible_s;
StringBuilder sb = new StringBuilder();
string cboTAKEYM = string.Empty;
string edtTAKEDT = string.Empty;
try
{
oForm.Freeze(true);
oUDS = oForm.DataSources.UserDataSources;
cboTAKEYM = oUDS.Item("cboTAKEYM").ValueEx.Trim();
edtTAKEDT = oUDS.Item("edtTAKEDT").ValueEx;
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oGrid.SelectionMode = BoMatrixSelect.ms_Single;
cv_ColumnsUID_s = " DocEntry, U_TAKEYM, U_TAKEDT, U_SFILE, U_EFILE, U_TOTCNT, U_NEWCNT, U_MODCNT, U_CLOCNT, U_RCLCNT, CreateDate, CreateTime, USER_CODE ";
cv_NoEditable_s = " DocEntry, U_TAKEYM, U_TAKEDT, U_SFILE, U_EFILE, U_TOTCNT, U_NEWCNT, U_MODCNT, U_CLOCNT, U_RCLCNT, CreateDate, CreateTime, USER_CODE ";
cv_ColumnsNAM_s = " 문서번호, 신청접수년월, 신청접수일자, 신청파일이름, 결과파일이름, 총건수, 신규등록건수, 변경등록건수, 해지등록건수, 임의해지건수, 실행일자, 실행시간, 실행자 ";
cv_Right_Just_s = " DocEntry, U_TOTCNT, U_NEWCNT, U_MODCNT, U_CLOCNT, U_RCLCNT ";
cv_No_Visible_s = " ";
sb.AppendLine(" SELECT T0.DocEntry ");
sb.AppendLine(" , T0.U_TAKEYM ");
sb.AppendLine(" , T0.U_TAKEDT ");
//sb.AppendLine(" , T0.U_DESC ");
sb.AppendLine(" , T0.U_SFILE ");
sb.AppendLine(" , T0.U_EFILE ");
sb.AppendLine(" , T0.U_TOTCNT ");
sb.AppendLine(" , T0.U_NEWCNT ");
sb.AppendLine(" , T0.U_MODCNT ");
sb.AppendLine(" , T0.U_CLOCNT ");
sb.AppendLine(" , T0.U_RCLCNT ");
sb.AppendLine(" , T0.CreateDate ");
sb.AppendLine(" , T0.CreateTime ");
sb.AppendLine(" , (SELECT F.USER_CODE FROM OUSR F WHERE F.USERID = T0.UserSign) AS USER_CODE ");
sb.AppendLine(" FROM [@KIS_SO0390T_HRD] T0 ");
sb.AppendLine(" WHERE (ISNULL('{0}','') = '' OR (T0.U_TAKEYM = '{0}')) ");
sb.AppendLine(" AND (ISNULL('{1}','') = '' OR (T0.U_TAKEDT = '{1}')) ");
sb.AppendLine(" ORDER BY T0.U_TAKEYM, T0.U_TAKEDT ");
oForm.DataSources.DataTables.Item("grd").ExecuteQuery(string.Format(sb.ToString(), cboTAKEYM, edtTAKEDT));
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd"); //데이터 그리드에 Display
if (oGrid.DataTable.Rows.Count == 1)
{
if (oGrid.DataTable.Columns.Item("DocEntry").Cells.Item(0).Value.ToString().Trim() == "0")
{
oGrid.DataTable.Rows.Clear();
}
}
FN.SetGirdColumnLinkedObjec(ref oGrid, "DocEntry", BoLinkedObject.lf_ProfitCenter);
FN.BindGrid(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
oGrid.RowHeaders.Width = 0;
oGrid.AutoResizeColumns();
}
catch (Exception)
{
//oForm.Freeze(false);
throw;
}
finally
{
oForm.Freeze(false);
oGrid = null;
}
}
private SAPbouiCOM.DataTable FindData(SAPbouiCOM.Form oForm)
{
//ADD YOUR ACTION CODE HERE ...
SAPbouiCOM.Grid oGrid;
StringBuilder sb;
string strCALLPER = string.Empty;
string strColYyyyMm = string.Empty;
string strCENTCE_FR = string.Empty;
string strCENTCE_TO = string.Empty;
try
{
oForm.Freeze(true);
oUDS = oForm.DataSources.UserDataSources;
strCALLPER = oUDS.Item("edtCALLPER").ValueEx;
strCENTCE_FR = oUDS.Item("edtCENTCD1").ValueEx;
strCENTCE_TO = oUDS.Item("edtCENTCD2").ValueEx;
sb = new StringBuilder();
//조회
sb.AppendLine(" EXEC KIS_SP_SO0260F1_HRD @pQUERY_TYPE = '{0}' ");
sb.AppendLine(" , @pPERSON = '{1}' ");
sb.AppendLine(" , @pCENTCD_FR = '{2}' ");
sb.AppendLine(" , @pCENTCD_TO = '{3}' ");
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oForm.DataSources.DataTables.Item("grd").ExecuteQuery(string.Format(sb.ToString(), "Q", strCALLPER, strCENTCE_FR, strCENTCE_TO));
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd");
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid.DataTable.Rows.Count == 1 && (oGrid.DataTable.GetValue("U_READCD", 0).ToString() == null || oGrid.DataTable.GetValue("U_READCD", 0).ToString() == ""))
{
FN.SetGridTitle(oGrid
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnUid)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnName)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotVisible)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotEditable));
}
else
{
strColYyyyMm = FN.GetRecordsetValue(string.Format(sb.ToString(), "C", "", "", "", "")).Replace("[", "").Replace("]", "");
FN.SetGrdColumnNumber(ref oGrid, "", GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.AlignRight) + "," + strColYyyyMm, "", "");
// 독자 링크버튼추가
FN.SetGirdColumnLinkedObjec(ref oGrid, "U_READCD", BoLinkedObject.lf_BusinessPartner);
// 지국 링크버튼추가
FN.SetGirdColumnLinkedObjec(ref oGrid, "U_CENTCD", BoLinkedObject.lf_BusinessPartner);
FN.BindGrid(oGrid
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnUid) + "," + strColYyyyMm
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnName) + "," + strColYyyyMm
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotEditable) + "," + strColYyyyMm
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotVisible)
, ""
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.AlignRight) + "," + strColYyyyMm);
//FN.SetColoumnColor(oForm, "grd3", "#E0ECF8", "ETAX_YN,DTINO,DTSTAT"); //그리드 BG 기본색(#E6E6FA)
//oGrid.RowHeaders.Width = 0;
oGrid.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("ET_btnFind_AFItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oForm.Refresh();
}
SAPbouiCOM.DataTable dt = oForm.DataSources.DataTables.Item("grd");
return dt;
}
private void DBDataSourcesBindingData(SAPbouiCOM.Form oForm, System.Data.DataTable dt, int sIndex)
{
try
{
System.Collections.Hashtable hashTable = new System.Collections.Hashtable();
SetHashTable_Seq(ref hashTable, dt);
oMatrix = oForm.Items.Item("mtx").Specific;
oForm.Freeze(true);
oMatrix.Clear();
string U_RDCD = string.Empty;
string U_DELVCD = string.Empty;
int seq;
for (int i = sIndex; i < dt.Rows.Count; i++)
{
oMatrix.AddRow();
U_RDCD = dt.Rows[i]["U_RDCD"].ToString();
seq = GetHashTable_NextSeq(ref hashTable, U_RDCD);
U_DELVCD = U_RDCD + "_" + seq.ToString().PadLeft(4, '0');
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_RDCD", U_RDCD);
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_RDNM", dt.Rows[i]["U_RDNM"].ToString());
//oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_DELVCD", dt.Rows[i]["U_DELVCD"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_DELVCD", U_DELVCD);
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_RDEPT", dt.Rows[i]["U_RDEPT"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_PAPERTP", dt.Rows[i]["U_PAPERTP"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_TYPE", dt.Rows[i]["U_TYPE"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_PAYCD", dt.Rows[i]["U_PAYCD"].ToString());
//oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_PAYNM", dt.Rows[i][6].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_TEL", dt.Rows[i]["U_TEL"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_ADDR1", dt.Rows[i]["U_ADDR1"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_ADDR1_D", dt.Rows[i]["U_ADDR1_D"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_ADDR2", dt.Rows[i]["U_ADDR2"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_ADDR2_D", dt.Rows[i]["U_ADDR2_D"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_CENTCD", dt.Rows[i]["U_CENTCD"].ToString());
//oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_CENTNM", dt.Rows[i][11].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_DELVFR", dt.Rows[i]["U_DELVFR"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_DELVCNT", dt.Rows[i]["U_DELVCNT"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_METHOD", dt.Rows[i]["U_METHOD"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_SDEPT", dt.Rows[i]["U_SDEPT"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_SAILCD", dt.Rows[i]["U_SAILCD"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_SAILNM", dt.Rows[i]["U_SAILNM"].ToString());
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_STATUS", "UO");
oMatrix.SetCellWithoutValidation(oMatrix.RowCount, "U_NOTE", "");
}
oMatrix.FlushToDataSource();
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText(ex.Message, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error);
//throw;
}
finally
{
oForm.Freeze(false);
}
}
private void FindData2(SAPbouiCOM.Form oForm)
{
string cv_ColumnsUID_s;
string cv_NoEditable_s;
string cv_ColumnsNAM_s;
string cv_Right_Just_s;
string cv_No_Visible_s;
oGrid1 = (SAPbouiCOM.Grid)oForm.Items.Item("grd1").Specific;
oGrid2 = (SAPbouiCOM.Grid)oForm.Items.Item("grd2").Specific;
oGrid2.SelectionMode = BoMatrixSelect.ms_None;
StringBuilder pQuery = new StringBuilder();
string sQry = string.Empty;
if (iROW != -1)
{
oForm.Items.Item("edtEMPNO2").Specific.value = oGrid1.DataTable.GetValue("U_EMPNO", iROW);
oForm.Items.Item("edtDEPTNM").Specific.value = oGrid1.DataTable.GetValue("U_DEPTNM", iROW);
oForm.Items.Item("edtJIKGBNM").Specific.value = oGrid1.DataTable.GetValue("U_JIKGBNM", iROW);
oForm.Items.Item("edtJIKCHNM").Specific.value = oGrid1.DataTable.GetValue("U_JIKCHNM", iROW);
}
//고과항목 그리드호출
try
{
cv_ColumnsUID_s = "U_CHEKER, U_EMPNM, U_DEPTCD, U_JIKGBCD, U_JIKCHKCD, U_PASSYN, Code";
cv_NoEditable_s = "U_CHEKER, U_EMPNM, U_DEPTCD, U_JIKGBCD, U_JIKCHKCD, Code";
cv_ColumnsNAM_s = "고과,사원,부서,직급,직책,상태,코드";
cv_Right_Just_s = " ";
cv_No_Visible_s = "Code";
#region 조회Query
pQuery.Clear();
pQuery.AppendLine(" SELECT ");
pQuery.AppendLine(" U_CHEKER ");
pQuery.AppendLine(" ,U_EMPNM ");
pQuery.AppendLine(" ,U_DEPTCD ");
pQuery.AppendLine(" ,U_JIKGBCD ");
pQuery.AppendLine(" ,U_JIKCHKCD ");
pQuery.AppendLine(" ,U_PASSYN ");
pQuery.AppendLine(" ,Code ");
pQuery.AppendLine(" FROM [@KIS_HR00203_HRD] ");
pQuery.AppendLine(" WHERE Code = '{0}' ");
sQry = string.Format(pQuery.ToString(), GRIDCODE);
#endregion
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oForm.Freeze(true);
oForm.DataSources.DataTables.Item("grd2").ExecuteQuery(sQry);
oGrid2.DataTable = oForm.DataSources.DataTables.Item("grd2"); //데이터 그리드에 Display
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid2.DataTable.Rows.Count == 1 && oGrid2.DataTable.GetValue("U_CHEKER", 0).ToString() == "")
{
FN.SetGridTitle(oGrid2, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_No_Visible_s);
B1Connections.theAppl.StatusBar.SetText("데이터가 없습니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터가 없습니다.
}
else
{
FN.BindGrid(oGrid2, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
FN.SetGridCombo(ref oGrid2, "U_CHEKER", "", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE CODE = 'HR12' AND U_USEYN = 'Y'", "");
FN.SetGridCombo(ref oGrid2, "U_DEPTCD", "", " SELECT U_DEPTCD,U_DEPTNM FROM [@KIS_HR00401] WHERE U_USEYN = 'Y'", "");
FN.SetGridCombo(ref oGrid2, "U_JIKGBCD", "", " SELECT U_SMLCD,U_SMLNM FROM [@KIS_AD00101] WHERE CODE = 'HR11' AND U_USEYN = 'Y'", "");
FN.SetGridCombo(ref oGrid2, "U_JIKCHKCD", "", " SELECT U_SMLCD,U_SMLNM FROM [@KIS_AD00101] WHERE CODE = 'HR14' AND U_USEYN = 'Y'", "");
FN.SetGridCombo(ref oGrid2, "U_PASSYN", "", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE CODE = 'HR11' AND U_USEYN = 'Y'", "");
B1Connections.theAppl.StatusBar.SetText("조회완료", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success); //조회완료
oGrid2.RowHeaders.Width = 0;
//FN.SetGirdSort(ref oGrid1);
oGrid2.AutoResizeColumns();
}
}
catch (Exception ex)
{
oForm.Freeze(false);
B1Connections.theAppl.StatusBar.SetText("btnFIND_OnAfterItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
iROW = -1;
GRIDCODE = "SAVE";
oGrid2 = null;
}
}
private void FindData2(SAPbouiCOM.Form oForm)
{
string cv_ColumnsUID_s;
string cv_NoEditable_s;
string cv_ColumnsNAM_s;
string cv_Right_Just_s;
string cv_No_Visible_s;
oGrid2 = (SAPbouiCOM.Grid)oForm.Items.Item("grd2").Specific;
oGrid2.SelectionMode = BoMatrixSelect.ms_None;
oForm.Freeze(true);
//고과항목 그리드호출
try
{
cv_ColumnsUID_s = "Code,U_DTCD, U_ABILCD, U_COMPOCD, U_BASESC, U_CONTENTS,U_GRADE4,U_GRADE1,U_GRADE2,U_GRADE3,U_LASTGAF";
cv_NoEditable_s = "Code,U_DTCD, U_ABILCD, U_COMPOCD, U_BASESC, U_CONTENTS,U_GRADE4,U_GRADE1,U_GRADE2,U_GRADE3,U_LASTGAF";
cv_ColumnsNAM_s = "코드,구분,역량,구성요소,배점,구성요소내용,평가등급,1차고과등급,2차고과등급,3차고과등급,최종등급";
cv_Right_Just_s = "U_BASESC";
cv_No_Visible_s = "Code";
string sQry = "";
sQry = " EXEC KIS_SP_HR0100F1_HRD '" + EXAMCD + "','" + GRIDCODE + "'";
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oForm.DataSources.DataTables.Item("grd2").ExecuteQuery(sQry);
oGrid2.DataTable = oForm.DataSources.DataTables.Item("grd2"); //데이터 그리드에 Display
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid2.DataTable.Rows.Count == 1 && oGrid2.DataTable.GetValue("U_DTCD", 0).ToString() == "")
{
FN.SetGridTitle(oGrid2, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_No_Visible_s);
B1Connections.theAppl.StatusBar.SetText("데이터가 없습니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터가 없습니다.
}
else
{
FN.BindGrid(oGrid2, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
FN.SetGridCombo(ref oGrid2, "U_DTCD", "", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE CODE = 'HR02' AND U_USEYN = 'Y'", "");
FN.SetGridCombo(ref oGrid2, "U_ABILCD", "", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE CODE = 'HR03' AND U_USEYN = 'Y'", "");
FN.SetGridCombo(ref oGrid2, "U_COMPOCD", "", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE CODE = 'HR04' AND U_USEYN = 'Y'", "");
FN.SetGridCombo(ref oGrid2, "U_GRADE4", "", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE CODE = 'HR15' AND U_USEYN = 'Y'", "");
FN.SetGridCombo(ref oGrid2, "U_GRADE1", "", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE CODE = 'HR15' AND U_USEYN = 'Y'", "");
FN.SetGridCombo(ref oGrid2, "U_GRADE2", "", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE CODE = 'HR15' AND U_USEYN = 'Y'", "");
FN.SetGridCombo(ref oGrid2, "U_GRADE3", "", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE CODE = 'HR15' AND U_USEYN = 'Y'", "");
B1Connections.theAppl.StatusBar.SetText("조회완료", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success); //조회완료
oGrid2.RowHeaders.Width = 0;
//FN.SetGirdSort(ref oGrid1);
oGrid2.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("btnFIND_OnAfterItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oGrid2 = null;
}
oForm.Freeze(false);
}
private void FindData1(SAPbouiCOM.Form oForm)
{
string cv_ColumnsUID_s;
string cv_NoEditable_s;
string cv_ColumnsNAM_s;
string cv_Right_Just_s;
string cv_No_Visible_s;
EXAMCD = oForm.Items.Item("cboYEAR").Specific.Value;
string EMPNO = oForm.Items.Item("edtEMPNO").Specific.Value;
string DEPT = oForm.Items.Item("cboDEPT").Specific.Value;
try
{
oGrid1 = (SAPbouiCOM.Grid)oForm.Items.Item("grd1").Specific;
oGrid1.SelectionMode = BoMatrixSelect.ms_Single;
cv_ColumnsUID_s = "U_EMPNO, U_EMPNM, U_DEPTCD, U_SCORE4, U_GRADE4, U_SCORE1, U_GRADE1, U_SCORE2, U_GRADE2, U_SCORE3, U_GRADE3,U_LASTSAF,U_LASTGAF,Code";
cv_NoEditable_s = "U_EMPNO, U_EMPNM, U_DEPTCD, U_SCORE4, U_GRADE4, U_SCORE1, U_GRADE1, U_SCORE2, U_GRADE2, U_SCORE3, U_GRADE3,U_LASTSAF,U_LASTGAF,Code";
cv_ColumnsNAM_s = "사원코드,사원명,부서,본인점수,본인등급,1차고과점수,1차고과등급,2차고과점수,2차고과등급,3차고과점수,3차고과등급,최종점수,최종등급,코드";
cv_Right_Just_s = " ";
cv_No_Visible_s = "Code";
string sQry = "";
sQry = " EXEC KIS_SP_HR0100F0_HRD '" + EXAMCD + "','" + EMPNO + "','" + DEPT + "'";
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oForm.Freeze(true);
oForm.DataSources.DataTables.Item("grd1").ExecuteQuery(sQry);
oGrid1.DataTable = oForm.DataSources.DataTables.Item("grd1"); //데이터 그리드에 Display
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid1.DataTable.Rows.Count == 1 && oGrid1.DataTable.GetValue("U_EMPNO", 0).ToString() == "")
{
FN.SetGridTitle(oGrid1, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_No_Visible_s);
B1Connections.theAppl.StatusBar.SetText("데이터가 없습니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터가 없습니다.
}
else
{
FN.BindGrid(oGrid1, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
FN.SetGridCombo(ref oGrid1, "U_DEPTCD", "", " SELECT U_DEPTCD,U_DEPTNM FROM [@KIS_HR00401] WHERE U_USEYN = 'Y'", "");
B1Connections.theAppl.StatusBar.SetText("조회완료", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success); //조회완료
oGrid1.RowHeaders.Width = 0;
//FN.SetGirdSort(ref oGrid1);
oGrid1.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("btnFIND_OnAfterItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
GRIDCODE = "";
oGrid1 = null;
}
}
private void SetGridValidate(SAPbouiCOM.Form oForm, SAPbouiCOM.Grid oGrid, ItemEvent pVal)
{
try
{
if (pVal.Row < 0)
{
if (pVal.ColUID == "CHK")
{
oForm.Freeze(true);
SAPbouiCOM.UserDataSources oUserData;
oUserData = oForm.DataSources.UserDataSources;
for (int i = 0; i <= oGrid.DataTable.Rows.Count - 1; i++)
{
if (!Chk_b)
{
oGrid.DataTable.Columns.Item("CHK").Cells.Item(i).Value = CFL.YES_MARK;
}
else
{
oGrid.DataTable.Columns.Item("CHK").Cells.Item(i).Value = CFL.NO_MARK;
}
}
Chk_b = !Chk_b;
//RecalAMT(oForm, oGrid);
}
}
else
{
oGrid.Rows.SelectedRows.Clear();
oGrid.Rows.SelectedRows.Add(pVal.Row);
}
}
catch (Exception)
{
throw;
}
finally
{
oForm.Freeze(false);
}
}
private void FindData(SAPbouiCOM.Form oForm)
{
//ADD YOUR ACTION CODE HERE ...
SAPbouiCOM.Grid oGrid;
StringBuilder sb;
string strQueryTp = string.Empty;
string strYyyyMm_F = string.Empty;
string strYyyyMm_T = string.Empty;
string strReadCd_F = string.Empty;
string strReadCd_T = string.Empty;
string strCentCd_F = string.Empty;
string strCentCd_T = string.Empty;
string strBillTp = string.Empty;
string strISSUEDT_F = string.Empty;
string strISSUEDT_T = string.Empty;
try
{
oForm.Freeze(true);
oUDS = oForm.DataSources.UserDataSources;
strQueryTp = oUDS.Item("optALL").ValueEx;
strYyyyMm_F = oUDS.Item("cboREQYM_F").ValueEx;
strYyyyMm_T = oUDS.Item("cboREQYM_T").ValueEx;
strReadCd_F = oUDS.Item("edtREAD_F").ValueEx;
strReadCd_T = oUDS.Item("edtREAD_T").ValueEx;
strCentCd_F = oUDS.Item("edtCENT_F").ValueEx;
strCentCd_T = oUDS.Item("edtCENT_T").ValueEx;
strBillTp = oUDS.Item("cboBILLTP").ValueEx;
strISSUEDT_F = oUDS.Item("edtISSUDT1").ValueEx;
strISSUEDT_T = oUDS.Item("edtISSUDT2").ValueEx;
sb = new StringBuilder();
//조회
sb.AppendFormat(" EXEC KIS_SP_SO0230F1_HRD @pFOLDLEV = '{0}' ", oForm.PaneLevel.ToString());
sb.AppendFormat(" , @pQUERYTP = '{0}' ", strQueryTp);
sb.AppendFormat(" , @pDATE_FR = '{0}' ", strYyyyMm_F);
sb.AppendFormat(" , @pDATE_TO = '{0}' ", strYyyyMm_T);
sb.AppendFormat(" , @pREAD_FR = '{0}' ", strReadCd_F);
sb.AppendFormat(" , @pREAD_TO = '{0}' ", strReadCd_T);
sb.AppendFormat(" , @pCENT_FR = '{0}' ", strCentCd_F);
sb.AppendFormat(" , @pCENT_TO = '{0}' ", strCentCd_T);
sb.AppendFormat(" , @pBILLTP = '{0}' ", strBillTp);
sb.AppendFormat(" , @pISSUDT1 = '{0}' ", strISSUEDT_F);
sb.AppendFormat(" , @pISSUDT2 = '{0}' ", strISSUEDT_T);
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
switch (oForm.PaneLevel)
{
case 1:
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd1").Specific;
oForm.DataSources.DataTables.Item("grd1").ExecuteQuery(sb.ToString());
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd1"); //데이터 그리드에 Display
FN.SetGirdSort(ref oGrid);
FN.SetSumField(ref oGrid, "SUPPAMT");
break;
case 2:
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd2").Specific;
oForm.DataSources.DataTables.Item("grd2").ExecuteQuery(sb.ToString());
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd2"); //데이터 그리드에 Display
FN.SetGirdSort(ref oGrid);
FN.SetSumField(ref oGrid, "SUPPAMT");
break;
case 3:
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd3").Specific;
oForm.DataSources.DataTables.Item("grd3").ExecuteQuery(sb.ToString());
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd3"); //데이터 그리드에 Display
FN.SetSumField(ref oGrid, "PRICE,QTY,SUPPAMT");
break;
default:
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd1").Specific;
break;
}
//그리드 컬럼셋팅
FN.SetGridCheckBox(ref oGrid, "CHK", true);
//그리드 컬럼셋팅
FN.SetGridComboDataBind(ref oGrid, "DOCTP", "R:독자,C:지국", BoComboDisplayType.cdt_Description);
//2. 세금그룹
FN.SetComboBoxValidValues(oGrid, "VATGRUP", "SELECT Code, Name FROM OVTG WHERE Code = 'A0' ", FN.Enum_WholeTp.m_Nothing);
//3. 계산서발행구분
FN.SetComboBoxValidValues(oGrid, "BILLGBN", "SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE Code ='SO15' ", FN.Enum_WholeTp.m_Nothing);
//링크컬럼셋팅
FN.SetGirdColumnLinkedObjec(ref oGrid, "CODE", BoLinkedObject.lf_BusinessPartner); // 독자/지국링크
FN.SetGirdColumnLinkedObjec(ref oGrid, "CARDCODE", BoLinkedObject.lf_BusinessPartner);
//FN.SetGirdColumnLinkedObjec(ref oGrid, "VATGRUP", BoLinkedObject.lf_VatGroup);
if (oForm.PaneLevel == 3)
{
FN.SetGridCheckBox(ref oGrid, "ETAX_YN", true);
FN.SetGridComboDataBind(ref oGrid, "INPUTP", "A:자동,M:수기", BoComboDisplayType.cdt_Description);
FN.SetComboBoxValidValues(oGrid, "DTSTAT", " SELECT U_CD, U_SMLNM FROM [@KIS_AD00101] WHERE Code ='VT14' ", FN.Enum_WholeTp.m_Nothing);
}
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid.DataTable.Rows.Count == 1 && (oGrid.DataTable.GetValue("CODE", 0).ToString() == null || oGrid.DataTable.GetValue("CODE", 0).ToString() == ""))
{
FN.SetGridTitle(oGrid
, GetGridFieldInfo(oForm, oForm.PaneLevel, SO.SO_COMMON_HRD.GridTitleType.ColumnUid)
, GetGridFieldInfo(oForm, oForm.PaneLevel, SO.SO_COMMON_HRD.GridTitleType.ColumnName)
, GetGridFieldInfo(oForm, oForm.PaneLevel, SO.SO_COMMON_HRD.GridTitleType.NotVisible)
, GetGridFieldInfo(oForm, oForm.PaneLevel, SO.SO_COMMON_HRD.GridTitleType.NotEditable));
}
else
{
FN.BindGrid(oGrid
, GetGridFieldInfo(oForm, oForm.PaneLevel, SO.SO_COMMON_HRD.GridTitleType.ColumnUid)
, GetGridFieldInfo(oForm, oForm.PaneLevel, SO.SO_COMMON_HRD.GridTitleType.ColumnName)
, GetGridFieldInfo(oForm, oForm.PaneLevel, SO.SO_COMMON_HRD.GridTitleType.NotEditable)
, GetGridFieldInfo(oForm, oForm.PaneLevel, SO.SO_COMMON_HRD.GridTitleType.NotVisible)
, ""
, GetGridFieldInfo(oForm, oForm.PaneLevel, SO.SO_COMMON_HRD.GridTitleType.AlignRight));
FN.SetColoumnColor(oForm, "grd3", "#E0ECF8", "ETAX_YN,DTINO,DTSTAT"); //그리드 BG 기본색(#E6E6FA)
oGrid.RowHeaders.Width = 0;
oGrid.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("ET_btnFind_AFItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oForm.Refresh();
}
}
private static void FindData(SAPbouiCOM.Form oForm)
{
SAPbouiCOM.Grid oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
string edtDOCDTF = oForm.DataSources.UserDataSources.Item("edtDOCDTF").Value;
string edtDOCDTT = oForm.DataSources.UserDataSources.Item("edtDOCDTT").Value;
string cboPRCCD = oForm.DataSources.UserDataSources.Item("cboPRCCD").Value;
string cboSLPCD = oForm.DataSources.UserDataSources.Item("cboSLPCD").Value;
string edtCARDCDF = oForm.DataSources.UserDataSources.Item("edtCARDCDF").Value;
string edtBPCDF = oForm.DataSources.UserDataSources.Item("edtBPCDF").Value;
string cboPUBLICA = oForm.DataSources.UserDataSources.Item("cboPUBLICA").Value;
StringBuilder pQuery = new StringBuilder();
string query = string.Empty;
pQuery.AppendLine(" EXEC [KIS_SP_SD0150F_HRD] ");
pQuery.AppendLine(" @edtDOCDTF = '{0}' ");
pQuery.AppendLine(" ,@edtDOCDTT = '{1}' ");
pQuery.AppendLine(" ,@cboPRCCD = '{2}' ");
pQuery.AppendLine(" ,@cboSLPCD = '{3}' ");
pQuery.AppendLine(" ,@edtCARDCDF = '{4}' ");
pQuery.AppendLine(" ,@edtBPCDF = '{5}' ");
pQuery.AppendLine(" ,@cboPUBLICA = '{6}' ");
string sQry = string.Format(pQuery.ToString(), edtDOCDTF, edtDOCDTT, cboPRCCD, cboSLPCD, edtCARDCDF, edtBPCDF, cboPUBLICA);
try
{
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oGrid.SelectionMode = BoMatrixSelect.ms_Single;
string cv_ColumnsUID_s = "U_DOCDT,U_PUBLICA,U_CARDCD,U_CARDNM,U_AMTSUM,U_VATSUM,U_DOCTOT,DPMSUM,U_SLPNM,U_BPCD,U_BPNM";
string cv_NoEditable_s = "U_DOCDT,U_PUBLICA,U_CARDCD,U_CARDNM,U_AMTSUM,U_VATSUM,U_DOCTOT,DPMSUM,U_SLPNM,U_BPCD,U_BPNM";
string cv_ColumnsNAM_s = "전기일,간행물,매출처,매출처명,매출액,매출부가세,매출합계,미수금,영업사원,대행사,대행사명";
string cv_Right_Just_s = "U_AMTSUM,U_VATSUM,U_DOCTOT,DPMSUM";
string cv_No_Visible_s = " ";
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oForm.Freeze(true);
oForm.DataSources.DataTables.Item("grd").ExecuteQuery(sQry);
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd"); //데이터 그리드에 Display
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid.DataTable.Rows.Count == 1 && oGrid.DataTable.GetValue(1, 0).ToString() == "")
{
FN.SetGridTitle(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_No_Visible_s);
B1Connections.theAppl.StatusBar.SetText("데이터가 없습니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터가 없습니다.
}
else
{
FN.BindGrid(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
FN.SetGridSumField(ref oGrid, cv_Right_Just_s);
FN.SetGirdColumnLinkedObjec(ref oGrid, "U_CARDCD", BoLinkedObject.lf_BusinessPartner);
FN.SetGirdColumnLinkedObjec(ref oGrid, "U_BPCD", BoLinkedObject.lf_BusinessPartner);
B1Connections.theAppl.StatusBar.SetText("조회완료", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success); //조회완료
oGrid.RowHeaders.Width = 0;
FN.SetGirdSort(ref oGrid);
oGrid.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("btnFIND_OnAfterItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oGrid = null;
}
}
private SAPbouiCOM.DataTable FindData(SAPbouiCOM.Form oForm)
{
//ADD YOUR ACTION CODE HERE ...
SAPbouiCOM.Grid oGrid;
StringBuilder sb;
string strREQDT_FR = string.Empty;
string strREQDT_TO = string.Empty;
string strREADCD_FR = string.Empty;
string strREADCD_TO = string.Empty;
string strPAPERTP = string.Empty;
string strBRANCHCD = string.Empty;
string strSALECD = string.Empty;
string strSTATUS = string.Empty;
try
{
oForm.Freeze(true);
oUDS = oForm.DataSources.UserDataSources;
strREQDT_FR = oUDS.Item("edtREQDT1").ValueEx;
strREQDT_TO = oUDS.Item("edtREQDT2").ValueEx;
strREADCD_FR = oUDS.Item("edtREADCD1").ValueEx;
strREADCD_TO = oUDS.Item("edtREADCD2").ValueEx;
strPAPERTP = oUDS.Item("cboPAPERTP").ValueEx;
strBRANCHCD = oUDS.Item("edtBRCHCD").ValueEx;
strSALECD = oUDS.Item("edtSALECD").ValueEx;
strSTATUS = oUDS.Item("cboSTATUS").ValueEx;
sb = new StringBuilder();
//조회
sb.AppendFormat(" EXEC KIS_SP_SO0130F1_HRD @pREQDT_FR = '{0}' ", strREQDT_FR);
sb.AppendFormat(" , @pREQDT_TO = '{0}' ", strREQDT_TO);
sb.AppendFormat(" , @pREADCD_FR = '{0}' ", strREADCD_FR);
sb.AppendFormat(" , @pREADCD_TO = '{0}' ", strREADCD_TO);
sb.AppendFormat(" , @pPAPERTP = '{0}' ", strPAPERTP);
sb.AppendFormat(" , @pBRANCHCD = '{0}' ", strBRANCHCD);
sb.AppendFormat(" , @pSALECD = '{0}' ", strSALECD);
sb.AppendFormat(" , @pSTATUS = '{0}' ", strSTATUS);
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oForm.DataSources.DataTables.Item("grd").ExecuteQuery(sb.ToString());
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd"); //데이터 그리드에 Display
//1. 지종
//FN.SetComboBoxValidValues(oGrid, "U_PAPERTP", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE Code ='SO01' ", FN.Enum_WholeTp.m_Nothing);
//2. 상태
//FN.SetComboBoxValidValues(oGrid, "U_STATUS", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE Code ='SO13' ", FN.Enum_WholeTp.m_Nothing);
// 독자 링크버튼추가
FN.SetGirdColumnLinkedObjec(ref oGrid, "READCD", BoLinkedObject.lf_BusinessPartner);
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid.DataTable.Rows.Count == 1 && (oGrid.DataTable.GetValue("READCD", 0).ToString() == null || oGrid.DataTable.GetValue("READCD", 0).ToString() == ""))
{
FN.SetGridTitle(oGrid
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnUid)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnName)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotVisible)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotEditable));
}
else
{
FN.BindGrid(oGrid
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnUid)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnName)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotEditable)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotVisible)
, ""
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.AlignRight));
//FN.SetColoumnColor(oForm, "grd3", "#E0ECF8", "ETAX_YN,DTINO,DTSTAT"); //그리드 BG 기본색(#E6E6FA)
oGrid.RowHeaders.Width = 0;
oGrid.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("ET_btnFind_AFItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oForm.Refresh();
}
SAPbouiCOM.DataTable dt = oForm.DataSources.DataTables.Item("grd");
return dt;
}
public void SetGridTitle(SAPbouiCOM.Form oForm)
{
oForm.Freeze(true);
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oForm.DataSources.DataTables.Item("grd").Clear();
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd");
string cv_ColumnsUID_s = "GROUP1,CARDNM,BMON1,MON1,BMON2,MON2,BMON3,MON3,BMON4,MON4,BMON5,MON5,BMON6,MON6,BMON7,MON7,BMON8,MON8,BMON9,MON9,BMON10,MON10,BMON11,MON11,BMON12,MON12,BAMTSUM,AMTSUM";
string cv_ColumnsNAM_s = "고객그룹-기업,BP명,전년도1월,조회년도1월,전년도2월,조회년도2월,전년도3월,조회년도3월,전년도4월,조회년도4월,전년도5월,조회년도5월,전년도6월,조회년도6월,전년도7월,조회년도7월,전년도8월,조회년도8월,전년도9월,조회년도9월,전년도10월,조회년도10월,전년도11월,조회년도11월,전년도12월,조회년도12월,전년도합계,조회년도합계";
string cv_No_Visible_s = " ";
FN.SetGridTitle(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_No_Visible_s);
oGrid.RowHeaders.Width = 0;
oGrid.AutoResizeColumns();
oForm.Freeze(false);
}
private static void FindData(SAPbouiCOM.Form oForm)
{
SAPbouiCOM.Grid oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
string FRRDCD = oForm.DataSources.UserDataSources.Item("edtFRRDCD").ValueEx;
string TORDCD = oForm.DataSources.UserDataSources.Item("edtTORDCD").ValueEx;
string FRRECDT = oForm.DataSources.UserDataSources.Item("edtFRRECDT").ValueEx;
string TORECDT = oForm.DataSources.UserDataSources.Item("edtTORECDT").ValueEx;
string FRDELCD = oForm.DataSources.UserDataSources.Item("edtFRDELCD").ValueEx;
string TODELCD = oForm.DataSources.UserDataSources.Item("edtTODELCD").ValueEx;
string CALLTP = oForm.DataSources.UserDataSources.Item("cboCALLTP").ValueEx;
string RECVID = oForm.DataSources.UserDataSources.Item("edtRECVID").ValueEx;
string PROSTAT = oForm.DataSources.UserDataSources.Item("cboPROSTAT").ValueEx;
string SPROCNM = B1Connections.theAppl.Company.UserName;
StringBuilder pQuery = new StringBuilder();
string query = string.Empty;
pQuery.AppendLine(" EXEC [KIS_SP_SO0080A_HRD] ");
pQuery.AppendLine(" @TYPE='FIND' ");
pQuery.AppendLine(" , @FRRDCD='{0}' ");
pQuery.AppendLine(" , @TORDCD='{1}' ");
pQuery.AppendLine(" , @FRRECVDT='{2}' ");
pQuery.AppendLine(" , @TORECVDT='{3}' ");
pQuery.AppendLine(" , @FRDELVCD='{4}' ");
pQuery.AppendLine(" , @TODELVCD='{5}' ");
pQuery.AppendLine(" , @CALLTP='{6}' ");
pQuery.AppendLine(" , @RECVID='{7}' ");
pQuery.AppendLine(" , @PROSTAT='{8}' ");
pQuery.AppendLine(" , @SDELVCD='' ");
pQuery.AppendLine(" , @SLINEID='' ");
pQuery.AppendLine(" , @SPROCOMM='' ");
pQuery.AppendLine(" , @SPROCNM='{9}' ");
pQuery.AppendLine(" , @SPROCDT='' ");
string sQry = string.Format(pQuery.ToString(), FRRDCD, TORDCD, FRRECDT, TORECDT, FRDELCD, TODELCD, CALLTP, RECVID, PROSTAT, SPROCNM);
try
{
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oGrid.SelectionMode = BoMatrixSelect.ms_Single;
string cv_ColumnsUID_s = "CHK,LINEID,U_RECVDT,CODE,NAME,U_DELVCD,U_RDEPT,U_CALLTP,U_TEL,U_PAYNM,U_CENTNM,U_COMMENT,U_PROCOMM,U_RECVNM,U_PROCDT,U_PROCNM,U_MEMO";
string cv_NoEditable_s = "LINEID,U_RECVDT,CODE,NAME,U_DELVCD,U_RDEPT,U_CALLTP,U_TEL,U_PAYNM,U_CENTNM,U_COMMENT,U_RECVNM,U_PROCDT,U_PROCNM,U_MEMO";
string cv_ColumnsNAM_s = "체크,라인번호,상담일,독자코드,독자이름,배달코드,구독부서,콜유형,전화번호,요금제,분국,접수내용,처리결과,작업자,처리일자,처리자,U_MEMO";
string cv_Right_Just_s = " ";
string cv_No_Visible_s = "U_MEMO ";
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oForm.Freeze(true);
oForm.DataSources.DataTables.Item("grd").ExecuteQuery(sQry);
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd"); //데이터 그리드에 Display
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid.DataTable.Rows.Count == 1 && oGrid.DataTable.GetValue("LINEID", 0).ToString() == "")
{
FN.SetGridTitle(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_No_Visible_s);
B1Connections.theAppl.StatusBar.SetText("데이터가 없습니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터가 없습니다.
}
else
{
FN.BindGrid(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
oGrid.Columns.Item(0).Type = BoGridColumnType.gct_CheckBox;
B1Connections.theAppl.StatusBar.SetText("조회완료", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success); //조회완료
oGrid.RowHeaders.Width = 0;
//FN.SetGirdSort(ref oGrid1);
oGrid.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("btnFIND_OnAfterItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oGrid = null;
}
}
private void FindData1(SAPbouiCOM.Form oForm)
{
string cv_ColumnsUID_s;
string cv_NoEditable_s;
string cv_ColumnsNAM_s;
string cv_Right_Just_s;
string cv_No_Visible_s;
EXAMCD = oForm.Items.Item("cboYEAR").Specific.Value;
string EMPNO = oForm.Items.Item("edtEMPNO").Specific.Value;
string DEPT = oForm.Items.Item("cboDEPT").Specific.Value;
StringBuilder pQuery = new StringBuilder();
string sQry = string.Empty;
try
{
oGrid1 = (SAPbouiCOM.Grid)oForm.Items.Item("grd1").Specific;
oGrid1.SelectionMode = BoMatrixSelect.ms_Single;
cv_ColumnsUID_s = "U_EMPNM, U_DEPTNM, U_EMPNO, U_JIKCHNM, U_JIKGBNM, Code";
cv_NoEditable_s = "U_EMPNM, U_DEPTNM, U_EMPNO, U_JIKCHNM, U_JIKGBNM, Code";
cv_ColumnsNAM_s = "사원명,부서명,사원코드,직책,직급,코드";
cv_Right_Just_s = " ";
cv_No_Visible_s = "U_EMPNO,U_JIKCHNM,U_JIKGBNM,Code";
#region 조회Query
pQuery.Clear();
pQuery.Append(" EXEC KIS_SP_HR0060B0_HRD '{0}','{1}','{2}'");
//pQuery.AppendLine(" SELECT ");
//pQuery.AppendLine(" A.U_EMPNM AS U_EMPNM ");
//pQuery.AppendLine(" ,C.U_DEPTNM AS U_DEPTNM ");
//pQuery.AppendLine(" ,A.U_EMPNO AS U_EMPNO ");
//pQuery.AppendLine(" ,B.U_JIKCHNM AS U_JIKCHNM ");
//pQuery.AppendLine(" ,B.U_JIKGBNM AS U_JIKGBNM ");
//pQuery.AppendLine(" ,A.Code AS Code ");
//pQuery.AppendLine(" FROM [@KIS_HR0020M_HRD] A ");
//pQuery.AppendLine(" INNER JOIN [@KIS_HR0120M] B ON A.U_EMPNO = B.U_EMPNO ");
//pQuery.AppendLine(" INNER JOIN [@KIS_HR01202] C ON B.Code = C.Code ");
//pQuery.AppendLine(" INNER JOIN [@KIS_AD00201] D ON A.U_EXAMCD = D.U_SMLCD AND D.Code = 'HR01' AND D.U_RMK2 = 'U03' ");
//pQuery.AppendLine(" WHERE A.U_EXAMCD = '{0}' ");
//pQuery.AppendLine(" AND (A.U_STATUS = 'Y') ");
//pQuery.AppendLine(" AND (A.U_DEPTCD = '{1}' OR '{1}' = '') ");
//pQuery.AppendLine(" AND (A.U_EMPNO = '{2}' OR '{2}' = '') ");
sQry = string.Format(pQuery.ToString(), EXAMCD, DEPT, EMPNO);
#endregion
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oForm.Freeze(true);
oForm.DataSources.DataTables.Item("grd1").ExecuteQuery(sQry);
oGrid1.DataTable = oForm.DataSources.DataTables.Item("grd1"); //데이터 그리드에 Display
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid1.DataTable.Rows.Count == 1 && oGrid1.DataTable.GetValue("U_EMPNM", 0).ToString() == "")
{
FN.SetGridTitle(oGrid1, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_No_Visible_s);
B1Connections.theAppl.StatusBar.SetText("데이터가 없습니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터가 없습니다.
}
else
{
FN.BindGrid(oGrid1, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
B1Connections.theAppl.StatusBar.SetText("조회완료", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success); //조회완료
oGrid1.RowHeaders.Width = 0;
//FN.SetGirdSort(ref oGrid1);
oGrid1.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("btnFIND_OnAfterItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oGrid1 = null;
}
}
private void FindData3(SAPbouiCOM.Form oForm)
{
string cv_ColumnsUID_s;
string cv_NoEditable_s;
string cv_ColumnsNAM_s;
string cv_Right_Just_s;
string cv_No_Visible_s;
oGrid3 = (SAPbouiCOM.Grid)oForm.Items.Item("grd3").Specific;
oGrid3.SelectionMode = BoMatrixSelect.ms_None;
StringBuilder pQuery = new StringBuilder();
string sQry = string.Empty;
oForm.Freeze(true);
//고과항목 그리드호출
try
{
string MTCHO = oForm.Items.Item("cboMTCHO").Specific.value;
sQry = " SELECT U_COMPOCD,U_COMPONM FROM [@KIS_HR00202_HRD] WHERE Code = '" + GRIDCODE + "' AND U_ABILCD = '" + MTCHO + "'";
oRS.DoQuery(sQry);
cv_ColumnsUID_s = "";
cv_NoEditable_s = "";
cv_ColumnsNAM_s = "";
cv_Right_Just_s = " ";
cv_No_Visible_s = " ";
for (int i = 0; i < oRS.RecordCount; i++)
{
cv_ColumnsUID_s = cv_ColumnsUID_s + oRS.Fields.Item("U_COMPONM").Value + ",";
cv_NoEditable_s = cv_NoEditable_s + oRS.Fields.Item("U_COMPONM").Value + ",";
cv_ColumnsNAM_s = cv_ColumnsNAM_s + oRS.Fields.Item("U_COMPONM").Value + ",";
oRS.MoveNext();
}
cv_ColumnsUID_s = FN.Left(cv_ColumnsUID_s, cv_ColumnsUID_s.Length - 1);
cv_NoEditable_s = FN.Left(cv_NoEditable_s, cv_NoEditable_s.Length - 1);
cv_ColumnsNAM_s = FN.Left(cv_ColumnsNAM_s, cv_ColumnsNAM_s.Length - 1);
#region 조회Query
pQuery.Clear();
pQuery.AppendLine(" EXEC [KIS_SP_PIVOT] @SQL = N' ");
pQuery.AppendLine(" SELECT U_COMPONM,U_SELVALNM FROM [@KIS_HR00202_HRD] ");
pQuery.AppendLine(" WHERE Code = ''{0}'' AND U_ABILCD = ''{1}''' ");
pQuery.AppendLine(" , @Pivot = N'U_COMPONM' ");
pQuery.AppendLine(" , @Value = N'MAX(U_SELVALNM)' ");
pQuery.AppendLine(" , @defaultPivot = NULL ");
sQry = string.Format(pQuery.ToString(), GRIDCODE, MTCHO);
#endregion
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oForm.DataSources.DataTables.Item("grd3").ExecuteQuery(sQry);
oGrid3.DataTable = oForm.DataSources.DataTables.Item("grd3"); //데이터 그리드에 Display
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid3.DataTable.Rows.Count == 1 && oGrid3.DataTable.GetValue(0, 0).ToString() == "")
{
FN.SetGridTitle(oGrid3, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_No_Visible_s);
B1Connections.theAppl.StatusBar.SetText("데이터가 없습니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터가 없습니다.
}
else
{
FN.BindGrid(oGrid3, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
B1Connections.theAppl.StatusBar.SetText("조회완료", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success); //조회완료
oGrid3.RowHeaders.Width = 0;
//FN.SetGirdSort(ref oGrid1);
oGrid3.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("btnFIND_OnAfterItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oGrid3 = null;
}
oForm.Freeze(false);
}
/// <summary>
/// 대분류 테이블에 저장되어있는 정보를 그리드에 출력합니다.
/// </summary>
/// <param name="oForm"></param>
/// <param name="oGrid"></param>
internal static void Veiw_Grid1_DataTable(SAPbouiCOM.Form oForm, int SelectedRow = -1,string Col = "", string FRCol = "" , string TOCol = "")
{
#region 그리드 조회
SAPbouiCOM.Grid oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oForm.Freeze(true);
try
{
string pformuid = oForm.DataSources.UserDataSources.Item("pformuid").ValueEx;
SAPbouiCOM.Form pForm = (SAPbouiCOM.Form)B1Connections.theAppl.Forms.Item(pformuid);
SAPbouiCOM.UserDataSources UDSs = pForm.DataSources.UserDataSources;
string Find = Col;
pformuid = null;
pForm = null;
UDSs = null;
System.Text.StringBuilder isb = new System.Text.StringBuilder();
isb.Append(" DECLARE @FRCODE NVARCHAR(20) = '{0}' ");
isb.Append(" DECLARE @TOCODE NVARCHAR(20) = '{1}' ");
isb.Append(" SELECT {2} AS Code FROM [@KIS_SO00301_HRD] ");
isb.Append(" WHERE (Code >= @FRCODE OR @FRCODE = '') ");
isb.Append(" AND (Code <= @TOCODE OR @TOCODE = '') ");
isb.Append(" GROUP BY U_DELVCD ");
string sQry = string.Format(isb.ToString(), FRCol, TOCol, Col);
oForm.DataSources.DataTables.Item("DT").ExecuteQuery(sQry);
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid.DataTable.Rows.Count == 1)
{
if (oGrid.DataTable.Columns.Item("Code").Cells.Item(0).Value.ToString().Trim() == "")
{
oGrid.DataTable.Rows.Clear();
}
}
string cv_ColumnsUID_s = "Code";
string cv_NoEditable_s = "Code";
string cv_ColumnsNAM_s = "Code";
string cv_Right_Just_s = "";
string cv_No_Visible_s = "";
oGrid.RowHeaders.Width = 0;
FN.BindGrid(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
FN.SetGirdSort(ref oGrid);
oGrid.AutoResizeColumns();
//string expr = "BackColor(CHK=#DBE4F6) & Editable(CHK=true)";
//FN.SetColumnProperty(oForm, "grd", expr);
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText(ex.Message, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
}
#endregion
}
private void FindData4(SAPbouiCOM.Form oForm)
{
string cv_ColumnsUID_s;
string cv_NoEditable_s;
string cv_ColumnsNAM_s;
string cv_Right_Just_s;
string cv_No_Visible_s;
oGrid4 = (SAPbouiCOM.Grid)oForm.Items.Item("grd4").Specific;
oGrid4.SelectionMode = BoMatrixSelect.ms_None;
oForm.Freeze(true);
//고과항목 그리드호출
try
{
StringBuilder pQuery = new StringBuilder();
string query = string.Empty;
pQuery.AppendLine(" SELECT 1 AS ROWSID, U_COMPOCD,U_COMPONM ");
pQuery.AppendLine(" FROM [@KIS_HR00202_HRD] A ");
pQuery.AppendLine(" WHERE U_ABILCD = 'U03' AND A.Code = '{0}' ");
pQuery.AppendLine(" UNION ALL ");
pQuery.AppendLine(" SELECT 2, U_COMPOCD,U_RMK1 ");
pQuery.AppendLine(" FROM [@KIS_HR00202_HRD] A ");
pQuery.AppendLine(" INNER JOIN [@KIS_AD00201] B ON A.U_COMPOCD = B.U_SMLCD AND B.Code = 'HR14' AND U_USEYN = 'Y' ");
pQuery.AppendLine(" WHERE U_ABILCD = 'U03' AND A.Code = '{0}' ");
pQuery.AppendLine(" UNION ALL ");
pQuery.AppendLine(" SELECT 3, U_COMPOCD,U_CONTENT1 ");
pQuery.AppendLine(" FROM [@KIS_HR00202_HRD] A ");
pQuery.AppendLine(" WHERE U_ABILCD = 'U03' AND A.Code = '{0}' ");
pQuery.AppendLine(" UNION ALL ");
pQuery.AppendLine(" SELECT 4, U_COMPOCD,U_CONTENT2 ");
pQuery.AppendLine(" FROM [@KIS_HR00202_HRD] A ");
pQuery.AppendLine(" WHERE U_ABILCD = 'U03' AND A.Code = '{0}' ");
pQuery.AppendLine(" ORDER BY U_COMPOCD, ROWSID ");
string sQry = string.Format(pQuery.ToString(), GRIDCODE);
cv_ColumnsUID_s = "ROWSID,U_COMPOCD,U_COMPONM";
cv_NoEditable_s = "ROWSID,U_COMPOCD,U_COMPONM";
cv_ColumnsNAM_s = "ROWSID,구분코드,내용";
cv_Right_Just_s = " ";
cv_No_Visible_s = "ROWSID,U_COMPOCD";
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oForm.DataSources.DataTables.Item("grd4").ExecuteQuery(sQry);
oGrid4.DataTable = oForm.DataSources.DataTables.Item("grd4"); //데이터 그리드에 Display
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid4.DataTable.Rows.Count == 1 && oGrid4.DataTable.GetValue(0, 0).ToString() == "")
{
FN.SetGridTitle(oGrid4, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_No_Visible_s);
B1Connections.theAppl.StatusBar.SetText("데이터가 없습니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터가 없습니다.
}
else
{
FN.BindGrid(oGrid4, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
B1Connections.theAppl.StatusBar.SetText("조회완료", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success); //조회완료
oGrid4.RowHeaders.Width = 0;
//FN.SetGirdSort(ref oGrid1);
for (int i = 0; i < oGrid4.DataTable.Rows.Count; i++)
{
if (oGrid4.DataTable.GetValue("ROWSID", i) == 1)
{
oGrid4.CommonSetting.SetRowBackColor(i + 1, 8684676);
}
}
oGrid4.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("btnFIND_OnAfterItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oGrid4 = null;
}
oForm.Freeze(false);
}
/// <summary>
/// 대분류 테이블에 저장되어있는 정보를 그리드에 출력합니다.
/// </summary>
/// <param name="oForm"></param>
/// <param name="oGrid"></param>
internal static void Veiw_Grid1_DataTable(SAPbouiCOM.Form oForm, int SelectedRow = -1)
{
#region 그리드 조회
SAPbouiCOM.Grid oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd1").Specific;
oForm.Freeze(true);
try
{
string pformuid = oForm.DataSources.UserDataSources.Item("pformuid").ValueEx;
SAPbouiCOM.Form pForm = (SAPbouiCOM.Form)B1Connections.theAppl.Forms.Item(pformuid);
SAPbouiCOM.UserDataSources UDSs = pForm.DataSources.UserDataSources;
string cboBPLID = UDSs.Item("cboBPLID").Value;//사업장
string edtSHORTCD = UDSs.Item("edtSHORTCD").Value;//관리계정
string edtDOCDTF = UDSs.Item("edtDOCDTF").Value;//전기일 시작
string edtDOCDTT = UDSs.Item("edtDOCDTT").Value;//전기일 종료
string edtDUEDTF = UDSs.Item("edtDUEDTF").Value;//만기일 시작
string edtDUEDTT = UDSs.Item("edtDUEDTT").Value;//만기일 종료
string edtBPCDF = UDSs.Item("edtBPCDF").Value;//BP코드 시작
string edtBPCDT = UDSs.Item("edtBPCDT").Value;//BP코드 종료
//대량이체 대상 리포트 헤더 조회조건값기준으로 데이터 채우기
oForm.DataSources.UserDataSources.Item("cboBPLID").Value = cboBPLID;
oForm.DataSources.UserDataSources.Item("edtVATRNUM").Value = FN.GetRecordsetValue(string.Format("SELECT VATRegNum FROM dbo.[OBPL] WHERE BPLId = '{0}'", cboBPLID));
//공통코드의 기본값 불러오기
//출금계좌 정보
oForm.DataSources.UserDataSources.Item("edtACCOUNT").Value = FN.GetRecordsetValue("SELECT Account FROM dbo.DSC1 WHERE Account = (SELECT TOP 1 U_RMK1 FROM [dbo].[@KIS_AD00201] WHERE Code = 'TR03' AND U_SMLCD = 'UACCOUNT')");
oForm.DataSources.UserDataSources.Item("edtACCTCD").Value = FN.GetRecordsetValue("SELECT GLAccount FROM dbo.DSC1 WHERE Account = (SELECT TOP 1 U_RMK1 FROM [dbo].[@KIS_AD00201] WHERE Code = 'TR03' AND U_SMLCD = 'UACCOUNT')");
oForm.DataSources.UserDataSources.Item("edtACCTNM").Value = FN.GetRecordsetValue(string.Format("SELECT AcctName FROM dbo.OACT WHERE AcctCode = '{0}'", oForm.DataSources.UserDataSources.Item("edtACCTCD").Value));
//코스트센터 정보
oForm.DataSources.UserDataSources.Item("edtPRCCD").Value = FN.GetRecordsetValue("SELECT PrcCode FROM dbo.OPRC WHERE PrcCode = (SELECT TOP 1 U_RMK1 FROM [dbo].[@KIS_AD00201] WHERE Code = 'TR03' AND U_SMLCD = 'UPRCCD')"); ;
oForm.DataSources.UserDataSources.Item("edtPRCNM").Value = FN.GetRecordsetValue("SELECT PrcName FROM dbo.OPRC WHERE PrcCode = (SELECT TOP 1 U_RMK1 FROM [dbo].[@KIS_AD00201] WHERE Code = 'TR03' AND U_SMLCD = 'UPRCCD')"); ;
#region 그리드 DataTable 실행문
System.Text.StringBuilder isb = new System.Text.StringBuilder();
isb.AppendLine("EXEC [KIS_SP_TR0021F1_HRD] ");
isb.AppendLine(" @cboBPLID = '{0}' ");
isb.AppendLine(" ,@edtSHORTCD = '{1}' ");
isb.AppendLine(" ,@edtDOCDTF = '{2}' ");
isb.AppendLine(" ,@edtDOCDTT = '{3}' ");
isb.AppendLine(" ,@edtDUEDTF = '{4}' ");
isb.AppendLine(" ,@edtDUEDTT = '{5}' ");
isb.AppendLine(" ,@edtBPCDF = '{6}' ");
isb.AppendLine(" ,@edtBPCDT = '{7}' ");
string sQry = string.Format(isb.ToString(), cboBPLID, edtSHORTCD, edtDOCDTF, edtDOCDTT, edtDUEDTF, edtDUEDTT, edtBPCDF, edtBPCDT);
oGrid.DataTable.ExecuteQuery(sQry);
//oForm.DataSources.DataTables.Item("DT_1").ExecuteQuery(sQry);
isb = null;
#endregion
#region 컬럼 설정
FN.SetGridColumnTypeToNumber(ref oGrid, "", "U_OPENAMT,U_TRANSAMT", "", "");
System.Text.StringBuilder isb_ColCode = new System.Text.StringBuilder();
isb_ColCode.Append("U_CHK,U_DOCDT,U_DUEDT,U_CARDCD,U_CARDNM,U_ACCTCD,U_OBJTP,U_OBJENTRY,U_TRANSID,U_PRCCD,U_OPENAMT,U_TRANSAMT,U_MEMO,U_OWNER,U_BANKCD,U_BANKNM,U_ACCOUNT");
System.Text.StringBuilder isb_ColName = new System.Text.StringBuilder();
isb_ColName.Append("선택,전기일,만기일,거래처,거래처명,G/L계정,원천유형,원천번호,분개번호,코스트센터,미지급잔액,이체금액,분개비고,예금주,은행코드,은행,거래처 계좌번호");
System.Text.StringBuilder isb_Editable = new System.Text.StringBuilder();
isb_Editable.Append("U_DOCDT,U_DUEDT,U_CARDCD,U_CARDNM,U_ACCTCD,U_OBJTP,U_OBJENTRY,U_TRANSID,U_PRCCD,U_OPENAMT,U_MEMO,U_OWNER,U_BANKCD,U_BANKNM,U_ACCOUNT");
System.Text.StringBuilder isb_Visible = new System.Text.StringBuilder();
isb_Visible.Append("U_BANKCD");
System.Text.StringBuilder isb_RightAlign = new System.Text.StringBuilder();
isb_RightAlign.Append("U_OPENAMT,U_TRANSAMT");
FN.BindGrid(oGrid, isb_ColCode.ToString(), isb_ColName.ToString(), isb_Editable.ToString(), isb_Visible.ToString(), "", isb_RightAlign.ToString(), false);
((SAPbouiCOM.EditTextColumn)oGrid.Columns.Item("U_CHK")).Type = BoGridColumnType.gct_CheckBox;
oGrid.CommonSetting.FixedColumnsCount = 2;
//* 링크버튼 조작 */
FN.SetGirdColumnLinkedObjec(ref oGrid, "U_CARDCD", BoLinkedObject.lf_BusinessPartner);//비즈니스 파트너 마스터
FN.SetGirdColumnLinkedObjec(ref oGrid, "U_ACCTCD", BoLinkedObject.lf_GLAccounts);//계정과목
FN.SetGirdColumnLinkedObjec(ref oGrid, "U_TRANSID", BoLinkedObject.lf_JournalPosting);//분개
/*그리드 정결 조작*/
FN.SetGirdSort(ref oGrid);
/*그리드 합계컬럼 조작*/
((SAPbouiCOM.EditTextColumn)oGrid.Columns.Item("U_OPENAMT")).AffectsFormMode = false;
TR_COMMON_HRD.SetGridSumField(ref oGrid, "U_OPENAMT,U_TRANSAMT", BoColumnSumType.bst_Manual);
///*컬럼 합계*/
((SAPbouiCOM.EditTextColumn)oGrid.Columns.Item("U_OPENAMT")).ColumnSetting.SumValue = TR_COMMON_HRD.GetGridCalc_SumValue(ref oForm, "U_OPENAMT").ToString();
((SAPbouiCOM.EditTextColumn)oGrid.Columns.Item("U_TRANSAMT")).ColumnSetting.SumValue = TR_COMMON_HRD.GetGridCalc_SumValue(ref oForm, "U_TRANSAMT").ToString();
/* 콤보박스 컬럼 조작*/
FN.SetComboBoxValidValues(oGrid, "U_OBJTP", "SELECT U_RMK1,U_RMK2 FROM [@KIS_AD00101] WHERE Code = 'AD03' AND U_RMK1 IN('18','30')", FN.Enum_WholeTp.m_Nothing); //원천문서 18,30 콤보설정
isb_ColCode = null;
isb_ColName = null;
isb_Editable = null;
isb_Visible = null;
#endregion
if (oGrid.DataTable.Rows.Count == 1)
{
if (oGrid.DataTable.Columns.Item("U_CARDCD").Cells.Item(0).Value.ToString().Trim() == "")
{
oGrid.DataTable.Rows.Clear();
}
}
//메시지 좀 뿌리지 말자..화면깜빡였는데 안나오면 데이터 없는거임.
//B1Connections.theAppl.StatusBar.SetText("데이터 조회가 완료 되었습니다.", BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Success);
oGrid.AutoResizeColumns();
/*컬럼 길이 조작*/
oGrid.RowHeaders.Width = 0;
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText(ex.Message, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
}
#endregion
}
private void SetChildDataToMatrix(SAPbouiCOM.Form oForm)
{
SAPbouiCOM.Form cForm = B1Connections.theAppl.Forms.Item(oForm.DataSources.UserDataSources.Item("cFORMUID").ValueEx);
oMatrix = oForm.Items.Item("mtx").Specific;
string strREADCD = string.Empty;
string strCENTCD = string.Empty;
string strADVRECV = string.Empty;
string strUpLineId = string.Empty;
bool bModify = false;
try
{
oForm.Freeze(true);
SAPbouiCOM.Grid cGrid = cForm.Items.Item("grd").Specific;
for (int i = 0; i < cGrid.DataTable.Rows.Count; i++)
{
if (FN.GetGridCellValue(ref cGrid, "CHK", i) == "Y")
{
strREADCD = FN.GetGridCellValue(ref cGrid, "U_READCD", i);
strCENTCD = FN.GetGridCellValue(ref cGrid, "U_CENTCD", i);
strADVRECV = FN.GetGridCellValue(ref cGrid, "U_ADVRECV", i);
strUpLineId = oForm.DataSources.UserDataSources.Item("U_BLINEID").ValueEx;
oDB_1 = oForm.DataSources.DBDataSources.Item("@KIS_SO04201_HRD");
if (string.IsNullOrEmpty(strCENTCD) == false)
{
SetMatrixAddRow(ref oForm, ref oMatrix, ref oDB_1, "U_READCD");
oMatrix.SetCellWithoutValidation(oMatrix.VisualRowCount, "U_READCD", FN.GetGridCellValue(ref cGrid, "U_READCD", i));
oMatrix.SetCellWithoutValidation(oMatrix.VisualRowCount, "U_READNM", FN.GetGridCellValue(ref cGrid, "U_READNM", i));
oMatrix.SetCellWithoutValidation(oMatrix.VisualRowCount, "U_ADVAMT", FN.GetGridCellValue(ref cGrid, "U_ADVRECV", i));
oMatrix.SetCellWithoutValidation(oMatrix.VisualRowCount, "U_ADVSUBT", FN.GetGridCellValue(ref cGrid, "U_ADVRECV", i));
bModify = true;
}
}
}
if (bModify)
{
oMatrix.FlushToDataSource();
if (oForm.Mode == BoFormMode.fm_OK_MODE)
oForm.Mode = BoFormMode.fm_UPDATE_MODE;
}
}
catch (Exception)
{
throw;
}
finally
{
oForm.Freeze(false);
if (oMatrix != null) { Marshal.ReleaseComObject(oMatrix); } oMatrix = null;
if (cForm != null) { Marshal.ReleaseComObject(cForm); } cForm = null;
}
}
internal static void FindData(SAPbouiCOM.Form oForm)
{
string pFORMUID = oForm.DataSources.UserDataSources.Item("pFORMUID").ValueEx;
SAPbouiCOM.Form pForm = (SAPbouiCOM.Form)B1Connections.theAppl.Forms.Item(pFORMUID);
SAPbouiCOM.Grid oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
string cboBPLID = string.Empty;
string edtFRDT = string.Empty;
string edtTODT = string.Empty;
string edtFRPRCCD = string.Empty;
string edtTOPRCCD = string.Empty;
string cboTRANSTY = string.Empty;
string strReportFiles = string.Empty;
StringBuilder pQuery = new StringBuilder();
string query = string.Empty;
try
{
oForm.Items.Item("grd").Enabled = false;
cboBPLID = pForm.DataSources.UserDataSources.Item("cboBPLID").Value;
edtFRDT = pForm.DataSources.UserDataSources.Item("edtFRDT").Value;
edtTODT = pForm.DataSources.UserDataSources.Item("edtTODT").Value;
edtFRPRCCD = pForm.DataSources.UserDataSources.Item("edtFRPRCCD").Value;
edtTOPRCCD = pForm.DataSources.UserDataSources.Item("edtTOPRCCD").Value;
cboTRANSTY = pForm.DataSources.UserDataSources.Item("cboTRANSTY").Value;
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oGrid.SelectionMode = BoMatrixSelect.ms_Single;
pQuery.Append(" EXEC KIS_SP_FI0050F1_HRD @cboBPLID = '{0}' ");
pQuery.Append(" , @edtFRDT = '{1}' ");
pQuery.Append(" , @edtTODT = '{2}' ");
pQuery.Append(" , @edtFRPRCCD = '{3}' ");
pQuery.Append(" , @edtTOPRCCD = '{4}' ");
pQuery.Append(" , @cboTRANSTY = '{5}' ");
string cv_ColumnsUID_s = "ROWSID,U_BPLID,RefDate,TransId,U_PRCNM,Debit,Credit,JEDT,U_PRCCD,BatchNum,TransType,TransNM,CreateDate";
string cv_NoEditable_s = "ROWSID,U_BPLID,RefDate,TransId,U_PRCNM,Debit,Credit,JEDT,U_PRCCD,BatchNum,TransType,TransNM,CreateDate";
string cv_ColumnsNAM_s = "#,사업장,전기일자,분개번호,코스트센터명,차변,대변,분개장 전기일,코스트센터,분개장 번호,입력경로코드,입력경로,분개 생성일";
string cv_Right_Just_s = "Debit,Credit";
string cv_No_Visible_s = "TransType";
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oForm.Freeze(true);
string sQry = (string.Format(pQuery.ToString()
, cboBPLID
, edtFRDT
, edtTODT
, edtFRPRCCD
, edtTOPRCCD
, cboTRANSTY
));
oForm.DataSources.DataTables.Item("grd").ExecuteQuery(sQry);
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid.DataTable.Rows.Count == 0)
{
FN.SetGridTitle(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_No_Visible_s);
B1Connections.theAppl.StatusBar.SetText("데이터가 없습니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터가 없습니다.
}
else
{
FN.BindGrid(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
/* 링크버튼 조작 */
FN.SetGirdColumnLinkedObjec(ref oGrid, "TransId", BoLinkedObject.lf_JournalPosting);//분개
FN.SetGirdColumnLinkedObjec(ref oGrid, "BatchNum", BoLinkedObject.lf_JournalVoucher);//분개장
/* 자동정렬 */
oGrid.AutoResizeColumns();
/*컬럼 길이 조작*/
oGrid.RowHeaders.Width = 0;
B1Connections.theAppl.StatusBar.SetText("조회완료", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success); //조회완료
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("btnFIND_OnAfterItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oGrid = null;
}
}
internal static void Veiw_Grid1_DataTable(SAPbouiCOM.Form oForm, int SelectedRow = -1)
{
#region 그리드 조회
SAPbouiCOM.Grid oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oForm.Freeze(true);
try
{
SAPbouiCOM.UserDataSources UDSs = oForm.DataSources.UserDataSources;
string SITE_CD = TR_COMMON_HRD.GetSITE_CD();
string edtCARDNO = UDSs.Item("edtCARDNO").Value;//카드번호
string edtFDATE = UDSs.Item("edtFDATE").Value;//승인일자 : 시작
string edtTDATE = UDSs.Item("edtTDATE").Value;//승인일자 : 종료
//대량이체 대상 리포트 헤더 조회조건값기준으로 데이터 채우기
#region 그리드 DataTable 실행문
System.Text.StringBuilder isb = new System.Text.StringBuilder();
isb.Append("EXEC [KIS_SP_TR0100F1_HRD] ");
isb.AppendFormat(" @SITE_CD = '{0}' ", SITE_CD);
isb.AppendFormat(",@edtCARDNO = '{0}' ", edtCARDNO);
isb.AppendFormat(",@edtFDATE = '{0}' ", edtFDATE);
isb.AppendFormat(",@edtTDATE = '{0}' ", edtTDATE);
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oForm.DataSources.DataTables.Item("grd").ExecuteQuery(isb.ToString());
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd"); //데이터 그리드에 Display
isb = null;
#endregion
#region 컬럼 설정
FN.SetGridColumnTypeToNumber(ref oGrid, "", "APPR_AMT,SUPPLY_AMT", "", "");
System.Text.StringBuilder isb_ColCode = new System.Text.StringBuilder();
isb_ColCode.Append("SITE_CD,CARD_NO,APPR_DATE,APPR_SEQ,APPR_TIME,APPR_NO,CANCEL_YN,USE_GB,CHAIN_NM,CHAIN_ID,CHAIN_CD,APPR_AMT,SUPPLY_AMT,APPR_TAX,HALBU,RECO_HALBU_NO,CHAIN_TYPE,WS_STATUS");
System.Text.StringBuilder isb_ColName = new System.Text.StringBuilder();
isb_ColName.Append("금융기관코드,카드번호,승인월,승인일별 일련번호,승인시간,승인번호,승인취소여부,사용구분,가맹점명,가맹점사업자번호,가맹점번호,승인금액,공급가액,부가가치세,할부기간,청구내역할부회차,과세정보가맹점유형코드,WEB 처리상태");
System.Text.StringBuilder isb_Editable = new System.Text.StringBuilder();
isb_Editable.Append("SITE_CD,CARD_NO,APPR_DATE,APPR_SEQ,APPR_TIME,APPR_NO,CANCEL_YN,USE_GB,CHAIN_NM,CHAIN_ID,CHAIN_CD,APPR_AMT,SUPPLY_AMT,APPR_TAX,HALBU,RECO_HALBU_NO,CHAIN_TYPE,WS_STATUS");
System.Text.StringBuilder isb_Visible = new System.Text.StringBuilder();
isb_Visible.Append("");
System.Text.StringBuilder isb_RightAlign = new System.Text.StringBuilder();
isb_RightAlign.Append("APPR_AMT,SUPPLY_AMT");
FN.BindGrid(oGrid, isb_ColCode.ToString(), isb_ColName.ToString(), isb_Editable.ToString(), isb_Visible.ToString(), "", isb_RightAlign.ToString(), false);
oGrid.CommonSetting.FixedColumnsCount = 2;
//* 링크버튼 조작 */
//FN.SetGirdColumnLinkedObjec(ref oGrid, "U_CARDCD", BoLinkedObject.lf_BusinessPartner);//비즈니스 파트너 마스터
/*그리드 정결 조작*/
FN.SetGirdSort(ref oGrid);
/*그리드 합계컬럼 조작*/
TR_COMMON_HRD.SetGridSumField(ref oGrid, "APPR_AMT,SUPPLY_AMT", BoColumnSumType.bst_Auto);
/* 콤보박스 컬럼 조작*/
FN.SetComboBoxValidValues(oGrid, "CHAIN_TYPE", "SELECT U_RMK1,U_SMLNM FROM [@KIS_AD00201] WHERE Code = 'TR08' AND U_USEYN = 'Y'", FN.Enum_WholeTp.m_Nothing); //대량이체 파일유형
isb_ColCode = null;
isb_ColName = null;
isb_Editable = null;
isb_Visible = null;
#endregion
if (oGrid.DataTable.Rows.Count == 1)
{
if (oGrid.DataTable.Columns.Item("CARD_NO").Cells.Item(0).Value.ToString().Trim() == "")
{
oGrid.DataTable.Rows.Clear();
}
}
oGrid.AutoResizeColumns();
/*컬럼 길이 조작*/
oGrid.RowHeaders.Width = 0;
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText(ex.Message, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
}
#endregion
}
private void FindSubData(SAPbouiCOM.Form oForm, int pRowIdx, string Type = "")
{
string strDeliveryCode = string.Empty;
string strExpr = string.Empty;
string strSort = string.Empty;
System.Data.DataRow[] findRows = null;
StringBuilder sb = new StringBuilder();
int i = 0;
try
{
oForm.Freeze(true);
oMatrix = ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx1_DUMY").Specific));
oDB2_Z = (SAPbouiCOM.DBDataSource)oForm.DataSources.DBDataSources.Item("@KIS_SO00302Z_HRD");
oDB2_Z.Clear();
if (oMatrix.VisualRowCount > 0)
{
strDeliveryCode = FN.GetMatirxCellValue(ref oMatrix, "U_DELVCD", pRowIdx);
sb.Append(" 1 = 1 ");
if (!string.IsNullOrEmpty(strDeliveryCode))
{
sb.AppendFormat(" AND DELVCD = '{0}' ", strDeliveryCode);
}
if (Type == "")
{
sb.AppendFormat(" AND DELVCD = '{0}' ", strDeliveryCode);
sFindTY = "F";
}
else
{
sFindTY = "";
}
findRows = gDs.Tables[oForm.UniqueID + "_Call"].Select(sb.ToString(), "IDX DESC");
oMatrix = (SAPbouiCOM.Matrix)oForm.Items.Item("mtx2_DUMY").Specific;
foreach (System.Data.DataRow dr in findRows)
{
oDB2_Z.InsertRecord(i);
oDB2_Z.SetValue("U_NO", i, (i + 1).ToString());
oDB2_Z.SetValue("U_IDX", i, dr["IDX"].ToString());//"데이터테이블 고유번호 IDX";
oDB2_Z.SetValue("LineId", i, dr["LINEID"].ToString());//"원본라인번호";
oDB2_Z.SetValue("U_DELVCD", i, dr["DELVCD"].ToString());//"배달코드"
oDB2_Z.SetValue("U_CALLTP", i, dr["CALLTP"].ToString());//"콜유형"
oDB2_Z.SetValue("U_MEMO", i, dr["MEMO"].ToString());//"접수내용"
oDB2_Z.SetValue("U_RECVID", i, dr["RECVID"].ToString());//"접수자ID"
oDB2_Z.SetValue("U_RECVNM", i, dr["RECVNM"].ToString());//"접수자명"
oDB2_Z.SetValue("U_RECVDT", i, dr["RECVDT"].ToString());//"접수일자"
oDB2_Z.SetValue("U_RECVTI", i, dr["RECVTI"].ToString());//"접수시간"
oDB2_Z.SetValue("U_PROCID", i, dr["PROCID"].ToString());//"처리자ID"
oDB2_Z.SetValue("U_PROCNM", i, dr["PROCNM"].ToString());//"처리자명"
oDB2_Z.SetValue("U_PROCDT", i, dr["PROCDT"].ToString());//"처리일자"
oDB2_Z.SetValue("U_PROSTAT", i, dr["PROSTAT"].ToString());//"처리상태"
i += 1;
}
oMatrix = (SAPbouiCOM.Matrix)oForm.Items.Item("mtx2_DUMY").Specific;
oMatrix.LoadFromDataSource();
//접수자 ID와 로그인 아이디가 다를경우 수정불가
for (int j = 0; j < oMatrix.VisualRowCount; j++)
{
if ((oMatrix.GetCellSpecific("U_RECVID", j + 1).Value.Trim() == B1Connections.diCompany.UserName.ToString()) && (sFindTY == "F"))
{
oMatrix.CommonSetting.SetCellEditable(j + 1, gCallTp_IDX, true);
oMatrix.CommonSetting.SetCellEditable(j + 1, gComment_IDX, true);
}
else
{
oMatrix.CommonSetting.SetCellEditable(j + 1, gCallTp_IDX, false);
oMatrix.CommonSetting.SetCellEditable(j + 1, gComment_IDX, false);
}
}
}
}
catch (Exception)
{
oForm.Freeze(false);
throw;
}
finally
{
oForm.Freeze(false);
findRows = null;
}
}
private void FindData(SAPbouiCOM.Form oForm)
{
//ADD YOUR ACTION CODE HERE ...
SAPbouiCOM.Grid oGrid;
StringBuilder sb;
string strYYYYMM_FR = string.Empty;
string strYYYYMM_TO = string.Empty;
string strCENTCD_FR = string.Empty;
string strCENTCD_TO = string.Empty;
string strPERSON = string.Empty;
try
{
oForm.Freeze(true);
oUDS = oForm.DataSources.UserDataSources;
strYYYYMM_FR = oUDS.Item("cboYYYYMM1").ValueEx;
strYYYYMM_TO = oUDS.Item("cboYYYYMM2").ValueEx;
sb = new StringBuilder();
//조회
sb.AppendLine(" SELECT CONVERT (VARCHAR (10), ROW_NUMBER () OVER (ORDER BY T0.Code)) AS ROWSEQ ");
sb.AppendLine(" , T0.Code AS READCD ");
sb.AppendLine(" , T0.[Name] AS READNM ");
sb.AppendLine(" , ISNULL(T0.U_SUMCNT, 0) AS READCNT ");
sb.AppendLine(" , T1.U_SAILCD ");
sb.AppendLine(" , T1.U_SAILNM ");
sb.AppendLine(" , T1.U_METHOD ");
sb.AppendLine(" , T1.U_PAPERTP ");
sb.AppendLine(" , U_EXPRYM ");
sb.AppendLine(" FROM [@KIS_SO0030M_HRD] T0 ");
sb.AppendLine(" INNER JOIN (SELECT ROW_NUMBER () OVER (PARTITION BY Code ORDER BY LineId) AS SEQ ");
sb.AppendLine(" , Code ");
sb.AppendLine(" , U_PAPERTP ");
sb.AppendLine(" , U_SAILCD ");
sb.AppendLine(" , U_SAILNM ");
sb.AppendLine(" , U_METHOD ");
sb.AppendLine(" FROM [@KIS_SO00301_HRD]) T1 ");
sb.AppendLine(" ON T0.Code = T1.Code AND T1.Seq = 1 ");
sb.AppendLine(" WHERE CONVERT(NVARCHAR(6), ISNULL(U_EXPRYM,''), 112) BETWEEN '{0}' AND '{1}' ");
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oForm.DataSources.DataTables.Item("grd").ExecuteQuery(string.Format( sb.ToString(), strYYYYMM_FR, strYYYYMM_TO) );
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd"); //데이터 그리드에 Display
//1. 지종
FN.SetComboBoxValidValues(oGrid, "U_PAPERTP", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE Code ='SO01' ", FN.Enum_WholeTp.m_Nothing);
//2. 가입방법
FN.SetComboBoxValidValues(oGrid, "U_METHOD", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE Code ='SO14' ", FN.Enum_WholeTp.m_Nothing);
// 지국 링크버튼추가
FN.SetGirdColumnLinkedObjec(ref oGrid, "READCD", BoLinkedObject.lf_BusinessPartner);
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid.DataTable.Rows.Count == 1 && (oGrid.DataTable.GetValue("READCD", 0).ToString() == null || oGrid.DataTable.GetValue("READCD", 0).ToString() == ""))
{
FN.SetGridTitle(oGrid
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnUid)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnName)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotVisible)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotEditable));
}
else
{
FN.BindGrid(oGrid
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnUid)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnName)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotEditable)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotVisible)
, ""
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.AlignRight));
//FN.SetColoumnColor(oForm, "grd3", "#E0ECF8", "ETAX_YN,DTINO,DTSTAT"); //그리드 BG 기본색(#E6E6FA)
oGrid.RowHeaders.Width = 0;
oGrid.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("ET_btnFind_AFItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oForm.Refresh();
}
}
private void FindRequestData(SAPbouiCOM.Form oForm)
{
//ADD YOUR ACTION CODE HERE ...
SAPbouiCOM.Grid oGrid;
StringBuilder sb;
string strREADCD = string.Empty;
try
{
oForm.Freeze(true);
oUDS = oForm.DataSources.UserDataSources;
oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0030M_HRD");
strREADCD = oDB_M.GetValue("Code", 0).Trim();
sb = new StringBuilder();
//조회
/*
sb.AppendLine(" SELECT M.U_REQYM AS U_YYYYMM ");
sb.AppendLine(" , M.U_AMT AS REQAMT ");
sb.AppendLine(" , M.U_DATE AS DEPO_DATE ");
sb.AppendLine(" , M.U_INAMT AS DEPO_AMT ");
sb.AppendLine(" , M.U_SMLNM + ' ' + M.U_SMLNM2 AS U_PMETHOD ");
sb.AppendLine(" , M.U_STATUS AS U_STATUS ");
sb.AppendLine(" FROM ( ");
sb.AppendLine(" SELECT A.U_READCD ");
sb.AppendLine(" , A.U_REQYM ");
sb.AppendLine(" , (SELECT SUM(CASE ISNULL(F.U_TYPE, '') WHEN '110' THEN ISNULL(F.U_DEBIT, 0) ");
sb.AppendLine(" WHEN '120' THEN (-1) * ISNULL(F.U_CREDIT, 0) ");
sb.AppendLine(" ELSE 0 END) ");
sb.AppendLine(" FROM [@KIS_SO01403_HRD] F ");
sb.AppendLine(" WHERE A.DocEntry = F.DocEntry ");
sb.AppendLine(" AND A.LineId = F.U_UPLINEID ");
sb.AppendLine(" AND F.U_TYPE IN ('110', '120') ) AS U_AMT ");
sb.AppendLine(" , CASE WHEN ISNULL(B.U_TYPE, '') NOT IN ('110', '120','150') THEN ISNULL(B.U_CREDIT, 0) ELSE 0 END AS U_INAMT ");
sb.AppendLine(" , B.U_DATE ");
sb.AppendLine(" , ISNULL(B.U_DEBIT,0) AS U_DEBIT ");
sb.AppendLine(" , ISNULL(B.U_CREDIT,0) AS U_CREDIT ");
sb.AppendLine(" , B.U_TYPE ");
sb.AppendLine(" , (SELECT F.U_SMLNM FROM [@KIS_AD00201] F WHERE F.Code = 'SO54' AND F.U_CD = B.U_TYPE) AS U_SMLNM ");
sb.AppendLine(" , (SELECT F.U_SMLNM FROM [@KIS_AD00201] F WHERE F.Code = 'SO51' AND F.U_SMLCD = B.U_SUBTYPE) AS U_SMLNM2 ");
sb.AppendLine(" , A.U_STATUS ");
sb.AppendLine(" FROM [@KIS_SO01401_HRD] A ");
sb.AppendLine(" LEFT OUTER JOIN [@KIS_SO01403_HRD] B ON A.DocEntry = B.DocEntry ");
sb.AppendLine(" AND A.LineId = B.U_UPLINEID ");
sb.AppendLine(" AND B.U_TYPE NOT IN ('110', '120', '150') ");
sb.AppendLine(" ) M ");
sb.AppendLine(" WHERE M.U_AMT <> 0 AND M.U_READCD = '{0}' ");
sb.AppendLine(" ORDER BY M.U_READCD, M.U_REQYM ");
*/
sb.AppendLine(" SELECT CASE WHEN ROW_NUMBER() OVER (PARTITION BY M.U_READCD, M.U_REQYM ORDER BY M.U_READCD, M.U_REQYM, M.U_AMT, M.DocEntry, M.LineId, M.U_DATE) = 1 THEN M.U_REQYM ELSE NULL END AS U_YYYYMM ");
sb.AppendLine(" , CASE WHEN ROW_NUMBER() OVER (PARTITION BY M.U_READCD, M.U_REQYM ORDER BY M.U_READCD, M.U_REQYM, M.U_AMT, M.DocEntry, M.LineId, M.U_DATE) = 1 THEN M.U_AMT ELSE NULL END AS REQAMT ");
sb.AppendLine(" , M.U_DATE AS DEPO_DATE ");
sb.AppendLine(" , M.U_INAMT AS DEPO_AMT ");
sb.AppendLine(" , M.U_SMLNM + (CASE ISNULL(M.U_SMLNM2,'') WHEN '' THEN '' ELSE ' ' + M.U_SMLNM2 END) AS U_PMETHOD ");
sb.AppendLine(" , M.U_STATUS AS U_STATUS ");
sb.AppendLine(" FROM ( ");
sb.AppendLine(" SELECT A.U_READCD ");
sb.AppendLine(" , A.U_REQYM ");
sb.AppendLine(" , A.DocEntry ");
sb.AppendLine(" , A.LineId ");
sb.AppendLine(" , ISNULL((SELECT SUM(ISNULL(F.U_DEBIT, 0)) ");
sb.AppendLine(" FROM [@KIS_SO01403_HRD] F ");
sb.AppendLine(" WHERE A.DocEntry = F.DocEntry ");
sb.AppendLine(" AND A.LineId = F.U_UPLINEID ");
sb.AppendLine(" AND F.U_TYPE IN ('110') ), 0) AS U_AMT ");
sb.AppendLine(" , CASE WHEN ISNULL(B.U_TYPE, '') NOT IN ('110','150','910','920','000') THEN ISNULL(B.U_CREDIT, 0) ELSE 0 END AS U_INAMT ");
sb.AppendLine(" , B.U_DATE ");
sb.AppendLine(" , ISNULL(B.U_DEBIT,0) AS U_DEBIT ");
sb.AppendLine(" , ISNULL(B.U_CREDIT,0) AS U_CREDIT ");
sb.AppendLine(" , B.U_TYPE ");
sb.AppendLine(" , (SELECT F.U_SMLNM FROM [@KIS_AD00201] F WHERE F.Code = 'SO54' AND F.U_CD = B.U_TYPE) AS U_SMLNM ");
sb.AppendLine(" , (SELECT F.U_SMLNM FROM [@KIS_AD00201] F WHERE F.Code = 'SO51' AND F.U_SMLCD = B.U_SUBTYPE) AS U_SMLNM2 ");
sb.AppendLine(" , A.U_STATUS ");
sb.AppendLine(" FROM [@KIS_SO01401_HRD] A ");
sb.AppendLine(" LEFT OUTER JOIN [@KIS_SO01403_HRD] B ON A.DocEntry = B.DocEntry ");
sb.AppendLine(" AND A.LineId = B.U_UPLINEID ");
sb.AppendLine(" AND B.U_TYPE NOT IN ('110','150','910','920','000') ");
sb.AppendLine(" ) M ");
sb.AppendLine(" WHERE M.U_AMT <> 0 AND M.U_READCD = '{0}' ");
sb.AppendLine(" ORDER BY M.U_READCD, M.U_REQYM ");
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
oForm.DataSources.DataTables.Item("grd").ExecuteQuery(string.Format(sb.ToString(), strREADCD));
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd"); //데이터 그리드에 Display
//1. 납부방법
//FN.SetComboBoxValidValues(oGrid, "U_PMETHOD", " SELECT U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE Code ='SO09' ", FN.Enum_WholeTp.m_Nothing);
//2. 상태
FN.SetComboBoxValidValues(oGrid, "U_STATUS", " SELECT 'O' [Code], '미납' AS [Name] UNION ALL SELECT 'C' [Code], '완납' AS [Name] ", FN.Enum_WholeTp.m_Nothing);
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid.DataTable.Rows.Count == 1 && (oGrid.DataTable.GetValue("U_YYYYMM", 0).ToString() == null || oGrid.DataTable.GetValue("U_YYYYMM", 0).ToString() == ""))
{
FN.SetGridTitle(oGrid
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnUid)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnName)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotVisible)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotEditable));
}
else
{
FN.BindGrid(oGrid
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnUid)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.ColumnName)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotEditable)
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.NotVisible)
, ""
, GetGridFieldInfo(oForm, SO.SO_COMMON_HRD.GridTitleType.AlignRight));
//FN.SetColoumnColor(oForm, "grd3", "#E0ECF8", "ETAX_YN,DTINO,DTSTAT"); //그리드 BG 기본색(#E6E6FA)
oGrid.RowHeaders.Width = 0;
oGrid.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("FindRequestData " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oForm.Refresh();
}
}
/// <summary>
/// 대분류 테이블에 저장되어있는 정보를 그리드에 출력합니다.
/// </summary>
/// <param name="oForm"></param>
/// <param name="oGrid"></param>
internal static void Veiw_Grid1_DataTable(SAPbouiCOM.Form oForm, int SelectedRow = -1)
{
#region 그리드 조회
SAPbouiCOM.Grid oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd1").Specific;
oForm.Freeze(true);
try
{
string pformuid = oForm.DataSources.UserDataSources.Item("pformuid").ValueEx;
SAPbouiCOM.Form pForm = (SAPbouiCOM.Form)B1Connections.theAppl.Forms.Item(pformuid);
SAPbouiCOM.UserDataSources UDSs = pForm.DataSources.UserDataSources;
string SITE_CD = TR_COMMON_HRD.GetSITE_CD();
string cboBPLID = UDSs.Item("cboBPLID").Value;//사업장
string edtDOCDTF = UDSs.Item("edtDOCDTF").Value;//거래일 시작
string edtDOCDTT = UDSs.Item("edtDOCDTT").Value;//거래일 종료
string edtACCOUNT = UDSs.Item("edtACCOUNT").Value;//은행계좌
string edtBANKCD = UDSs.Item("edtBANKCD").Value;//은행코드
string edtPRCCD = UDSs.Item("edtPRCCD").Value;//코스트센터
string cboINOUT = UDSs.Item("cboINOUT").Value;//입출금 유형
string cboSTATUS = UDSs.Item("cboSTATUS").Value;//지급처리상태
//대량이체 대상 리포트 헤더 조회조건값기준으로 데이터 채우기
oForm.DataSources.UserDataSources.Item("edtMEMO").Value = "[%MONTH]월 입출금내역([%DATE])";
//oForm.DataSources.UserDataSources.Item("cboBPLID").Value = cboBPLID;
//oForm.DataSources.UserDataSources.Item("edtVATRNUM").Value = FN.GetRecordsetValue(string.Format("SELECT VATRegNum FROM dbo.[OBPL] WHERE BPLId = '{0}'", cboBPLID));
//공통코드의 기본값 불러오기
////은행계좌 정보
//oForm.DataSources.UserDataSources.Item("edtACCOUNT").Value = FN.GetRecordsetValue("SELECT Account FROM dbo.DSC1 WHERE Account = (SELECT TOP 1 U_RMK1 FROM [dbo].[@KIS_AD00201] WHERE Code = 'TR03' AND U_SMLCD = 'UACCOUNT')");
//oForm.DataSources.UserDataSources.Item("edtACCTCD").Value = FN.GetRecordsetValue("SELECT GLAccount FROM dbo.DSC1 WHERE Account = (SELECT TOP 1 U_RMK1 FROM [dbo].[@KIS_AD00201] WHERE Code = 'TR03' AND U_SMLCD = 'UACCOUNT')");
//oForm.DataSources.UserDataSources.Item("edtACCTNM").Value = FN.GetRecordsetValue(string.Format("SELECT AcctName FROM dbo.OACT WHERE AcctCode = '{0}'", oForm.DataSources.UserDataSources.Item("edtACCTCD").Value));
////코스트센터 정보
//oForm.DataSources.UserDataSources.Item("edtPRCCD").Value = FN.GetRecordsetValue("SELECT PrcCode FROM dbo.OPRC WHERE PrcCode = (SELECT TOP 1 U_RMK1 FROM [dbo].[@KIS_AD00201] WHERE Code = 'TR03' AND U_SMLCD = 'UPRCCD')"); ;
//oForm.DataSources.UserDataSources.Item("edtPRCNM").Value = FN.GetRecordsetValue("SELECT PrcName FROM dbo.OPRC WHERE PrcCode = (SELECT TOP 1 U_RMK1 FROM [dbo].[@KIS_AD00201] WHERE Code = 'TR03' AND U_SMLCD = 'UPRCCD')"); ;
#region 그리드 DataTable 실행문
System.Text.StringBuilder isb = new System.Text.StringBuilder();
isb.Append("EXEC [KIS_SP_TR0071F1_HRD] ");
isb.AppendFormat(" @SITE_CD = '{0}' ", SITE_CD);
isb.AppendFormat(",@cboBPLID = '{0}' ", cboBPLID);
isb.AppendFormat(",@edtDOCDTF = '{0}' ", edtDOCDTF);
isb.AppendFormat(",@edtDOCDTT = '{0}' ", edtDOCDTT);
isb.AppendFormat(",@edtACCOUNT = '{0}' ", edtACCOUNT);
isb.AppendFormat(",@cboINOUT = '{0}' ", cboINOUT);
isb.AppendFormat(",@cboSTATUS = '{0}' ", cboSTATUS);
isb.AppendFormat(",@edtBANKCD = '{0}' ", edtBANKCD);
isb.AppendFormat(",@edtPRCCD = '{0}' ", edtPRCCD);
oForm.DataSources.DataTables.Item("DT_1").ExecuteQuery(isb.ToString());
isb = null;
#endregion
#region 컬럼 설정
FN.SetGridColumnTypeToNumber(ref oGrid, "", "INAMT,OUTAMT,TX_CUR_BAL", "", "");
System.Text.StringBuilder isb_ColCode = new System.Text.StringBuilder();
isb_ColCode.Append("U_CHK,DOCENTRY,TRANSID,U_TRANSID,U_PRCCD2,U_BPLID,U_BPLNM,U_SITECD,U_VATRNUM,U_BANKCD,U_ACCOUNT,U_GLACTCD,U_DOCDT,U_SEQ,JEOKYO,INAMT,OUTAMT,TX_CUR_BAL,U_SHORTNM,U_ACCTCD,U_PRCCD,U_LINEMEMO");
System.Text.StringBuilder isb_ColName = new System.Text.StringBuilder();
isb_ColName.Append("선택,문서번호,TRANSID,분개,문서:코스트센터,사업장ID,사업장,회사코드,사업자등록번호,은행코드,은행계좌,은행계정,거래일,순번,적요,입금,출금,잔액,GL계정/BP코드,관리계정,행:코스트센터,라인적요");
System.Text.StringBuilder isb_Editable = new System.Text.StringBuilder();
isb_Editable.Append("U_TRANSID,U_PRCCD2,U_BPLID,U_BPLNM,U_SITECD,U_VATRNUM,U_BANKCD,U_ACCOUNT,U_GLACTCD,U_DOCDT,U_SEQ,JEOKYO,INAMT,OUTAMT,TX_CUR_BAL");
System.Text.StringBuilder isb_Visible = new System.Text.StringBuilder();
isb_Visible.Append("DOCENTRY,TRANSID,U_BPLID,U_SITECD,U_VATRNUM,U_SEQ");
System.Text.StringBuilder isb_RightAlign = new System.Text.StringBuilder();
isb_RightAlign.Append("INAMT,OUTAMT,TX_CUR_BAL");
FN.BindGrid(oGrid, isb_ColCode.ToString(), isb_ColName.ToString(), isb_Editable.ToString(), isb_Visible.ToString(), "", isb_RightAlign.ToString(), false);
((SAPbouiCOM.EditTextColumn)oGrid.Columns.Item("U_CHK")).Type = BoGridColumnType.gct_CheckBox;
oGrid.CommonSetting.FixedColumnsCount = 2;
//* 링크버튼 조작 */
FN.SetGirdColumnLinkedObjec(ref oGrid, "U_SHORTNM", BoLinkedObject.lf_BusinessPartner);//BP/GL계정
FN.SetGirdColumnLinkedObjec(ref oGrid, "U_GLACTCD", BoLinkedObject.lf_GLAccounts);//계정과목
FN.SetGirdColumnLinkedObjec(ref oGrid, "U_ACCTCD", BoLinkedObject.lf_GLAccounts);//계정과목
FN.SetGirdColumnLinkedObjec(ref oGrid, "U_TRANSID", BoLinkedObject.lf_JournalPosting);//분개
///*그리드 정결 조작*/
//FN.SetGirdSort(ref oGrid);
/*그리드 합계컬럼 조작*/
TR_COMMON_HRD.SetGridSumField(ref oGrid, "INAMT,OUTAMT,TX_CUR_BAL", BoColumnSumType.bst_Auto);
/* 콤보박스 컬럼 조작*/
//FN.SetComboBoxValidValues(oGrid, "U_BPLID", "SELECT BPLID,BPLName FROM [OBPL] ORDER BY 1 ASC", FN.Enum_WholeTp.m_Nothing);//사업장
int U_SHORTNM_INDEX = FN.GetColumnIndex(oGrid, "U_SHORTNM")+1;
int U_ACCTCD_INDEX = FN.GetColumnIndex(oGrid, "U_ACCTCD") + 1;
int U_PRCCD_INDEX = FN.GetColumnIndex(oGrid, "U_PRCCD") + 1;
int U_LINEMEMO_INDEX = FN.GetColumnIndex(oGrid, "U_LINEMEMO") + 1;
for (int ilooper = 0; ilooper < oGrid.Rows.Count; ilooper++)
{
int iRowIndex = oGrid.GetDataTableRowIndex(ilooper);
bool TransId = oGrid.DataTable.GetValue("TRANSID", iRowIndex) == "";
if (TransId)
{
oGrid.CommonSetting.SetCellEditable(ilooper + 1, U_SHORTNM_INDEX, TransId);
oGrid.CommonSetting.SetCellEditable(ilooper + 1, U_ACCTCD_INDEX, TransId);
oGrid.CommonSetting.SetCellEditable(ilooper + 1, U_PRCCD_INDEX, TransId);
oGrid.CommonSetting.SetCellEditable(ilooper + 1, U_LINEMEMO_INDEX, TransId);
if (oGrid.CommonSetting.GetCellEditable(ilooper + 1, U_ACCTCD_INDEX))
{
oGrid.CommonSetting.SetCellEditable(ilooper + 1, U_ACCTCD_INDEX, false);
}
}
else
{
oGrid.CommonSetting.SetCellEditable(ilooper + 1, U_SHORTNM_INDEX, TransId);
oGrid.CommonSetting.SetCellEditable(ilooper + 1, U_ACCTCD_INDEX, TransId);
oGrid.CommonSetting.SetCellEditable(ilooper + 1, U_PRCCD_INDEX, TransId);
oGrid.CommonSetting.SetCellEditable(ilooper + 1, U_LINEMEMO_INDEX, TransId);
}
}
/* ChooseFromList 컬럼 조작*/
//관리계정
#region BP/GL계정 ChooseFromList 설정
if (GetIsChooseFromItem(oForm,"grd1.U_SHORTNM") == false)
{
FN.SetChooseFromListAdd(oForm, ((int)BoObjectTypes.oChartOfAccounts).ToString(), "grd1", "AcctCode", BoFormItemTypes.it_GRID, null, "U_SHORTNM");
}
else
{
SAPbouiCOM.EditTextColumn oColumn = (SAPbouiCOM.EditTextColumn)oGrid.Columns.Item("U_SHORTNM");
oColumn.ChooseFromListUID = "grd1.U_SHORTNM";
oColumn.ChooseFromListAlias = "AcctCode";
}
#endregion
#region 관리계정 ChooseFromList 설정
if (GetIsChooseFromItem(oForm,"grd1.U_ACCTCD") == false)
{
FN.SetChooseFromListAdd(oForm, ((int)BoObjectTypes.oChartOfAccounts).ToString(), "grd1", "AcctCode", BoFormItemTypes.it_GRID, null, "U_ACCTCD");
}
else
{
SAPbouiCOM.EditTextColumn oColumn = (SAPbouiCOM.EditTextColumn)oGrid.Columns.Item("U_ACCTCD");
oColumn.ChooseFromListUID = "grd1.U_ACCTCD";
oColumn.ChooseFromListAlias = "AcctCode";
}
#endregion
#region 코스트센터 ChooseFromList 설정
if (GetIsChooseFromItem(oForm, "grd1.U_PRCCD") == false)
{
FN.SetChooseFromListAdd(oForm, ((int)BoLinkedObject.lf_ProfitCenter).ToString(), "grd1", "PrcCode", BoFormItemTypes.it_GRID, null, "U_PRCCD");
}
else
{
SAPbouiCOM.EditTextColumn oColumn = (SAPbouiCOM.EditTextColumn)oGrid.Columns.Item("U_PRCCD");
oColumn.ChooseFromListUID = "grd1.U_PRCCD";
oColumn.ChooseFromListAlias = "PrcCode";
}
#endregion
isb_ColCode = null;
isb_ColName = null;
isb_Editable = null;
isb_Visible = null;
#endregion
if (oGrid.DataTable.Rows.Count == 1)
{
if (oGrid.DataTable.Columns.Item("U_SITECD").Cells.Item(0).Value.ToString().Trim() == "")
{
oGrid.DataTable.Rows.Clear();
}
}
oGrid.AutoResizeColumns();
/*컬럼 길이 조작*/
oGrid.RowHeaders.Width = 0;
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText(ex.Message, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
}
#endregion
}
/// <summary>
/// Grid 조회
/// </summary>
/// <param name="oForm">폼</param>
internal static void FindData(SAPbouiCOM.Form oForm)
{
string pFORMUID = oForm.DataSources.UserDataSources.Item("pFORMUID").ValueEx;
SAPbouiCOM.Form pForm = (SAPbouiCOM.Form)B1Connections.theAppl.Forms.Item(pFORMUID);
SAPbouiCOM.Grid oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd").Specific;
string edtDOCDTF = pForm.DataSources.UserDataSources.Item("edtDOCDTF").Value;
string edtDOCDTT = pForm.DataSources.UserDataSources.Item("edtDOCDTT").Value;
string cboSLPCD = pForm.DataSources.UserDataSources.Item("cboSLPCD").Value;
string cboBILLTP = pForm.DataSources.UserDataSources.Item("cboBILLTP").Value;
string edtCARDCDF = pForm.DataSources.UserDataSources.Item("edtCARDCDF").Value;
string cboPRCCD2 = pForm.DataSources.UserDataSources.Item("cboPRCCD2").Value;
string edtBPCDF = pForm.DataSources.UserDataSources.Item("edtBPCDF").Value;
string cboPRCCD = pForm.DataSources.UserDataSources.Item("cboPRCCD").Value;
string edtDOCDTF2 = pForm.DataSources.UserDataSources.Item("edtDOCDTF2").Value;
string edtDOCDTT2 = pForm.DataSources.UserDataSources.Item("edtDOCDTT2").Value;
string cboPUBLICA = pForm.DataSources.UserDataSources.Item("cboPUBLICA").Value;
string cboPAYTP = pForm.DataSources.UserDataSources.Item("cboPAYTP").Value;
string edtPAYMTH = pForm.DataSources.UserDataSources.Item("edtPAYMTH").Value;
StringBuilder pQuery = new StringBuilder();
string query = string.Empty;
pQuery.AppendLine(" EXEC [KIS_SP_SD0140F_HRD] ");
pQuery.AppendLine(" @edtDOCDTF = '{0}' ");
pQuery.AppendLine(" ,@edtDOCDTT = '{1}' ");
pQuery.AppendLine(" ,@cboSLPCD = '{2}' ");
pQuery.AppendLine(" ,@cboBILLTP = '{3}' ");
pQuery.AppendLine(" ,@edtCARDCDF = '{4}' ");
pQuery.AppendLine(" ,@cboPRCCD2 = '{5}' ");
pQuery.AppendLine(" ,@edtBPCDF = '{6}' ");
pQuery.AppendLine(" ,@cboPRCCD = '{7}' ");
pQuery.AppendLine(" ,@edtDOCDTF2 = '{8}' ");
pQuery.AppendLine(" ,@edtDOCDTT2 = '{9}' ");
pQuery.AppendLine(" ,@cboPUBLICA = '{10}' ");
pQuery.AppendLine(" ,@cboPAYTP = '{11}' ");
pQuery.AppendLine(" ,@edtPAYMTH = '{12}' ");
string sQry = string.Format(pQuery.ToString(), edtDOCDTF, edtDOCDTT, cboSLPCD, cboBILLTP, edtCARDCDF, cboPRCCD2, edtBPCDF, cboPRCCD, edtDOCDTF2, edtDOCDTT2, cboPUBLICA, cboPAYTP, edtPAYMTH);
try
{
oGrid.SelectionMode = BoMatrixSelect.ms_Single;
string cv_ColumnsUID_s = "ORDERBY,U_DOCDT,U_DOCDT2,DocEntry,U_PUBLICA,U_CARDCD,U_CARDNM,U_BILLTP,U_PAYTP,U_PAYMNM,U_DEPAMT,U_DEDUTION,AMTSUM,U_BPCD,U_BPNM,U_DOCTOT,U_PRCNM,U_SLPNM,IDX";
string cv_NoEditable_s = "ORDERBY,U_DOCDT,U_DOCDT2,DocEntry,U_PUBLICA,U_CARDCD,U_CARDNM,U_BILLTP,U_PAYTP,U_PAYMNM,U_DEPAMT,U_DEDUTION,AMTSUM,U_BPCD,U_BPNM,U_DOCTOT,U_PRCNM,U_SLPNM,IDX";
string cv_ColumnsNAM_s = "ORDERBY,수금전기일,매출전기일,문서번호,간행물,매출처,매출처명,수금유형,지급유형,지급방법,입금합계,공제금액,총수금액,대행사,대행사명,매출합계,수금부서,영업사원,IDX";
string cv_Right_Just_s = "U_DEPAMT,U_DEDUTION,AMTSUM,U_DOCTOT";
string cv_No_Visible_s = "ORDERBY,IDX";
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oForm.Freeze(true);
oForm.DataSources.DataTables.Item("grd").ExecuteQuery(sQry);
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd"); //데이터 그리드에 Display
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid.DataTable.Rows.Count == 1 && oGrid.DataTable.GetValue(2, 0).ToString() == "")
{
FN.SetGridTitle(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_No_Visible_s);
B1Connections.theAppl.StatusBar.SetText("데이터가 없습니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터가 없습니다.
}
else
{
FN.BindGrid(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
//FN.SetGridSumField(ref oGrid, cv_Right_Just_s);
FN.SetGirdColumnLinkedObjec(ref oGrid, "DocEntry", BoLinkedObject.lf_BusinessPartner);
FN.SetGirdColumnLinkedObjec(ref oGrid, "U_CARDCD", BoLinkedObject.lf_BusinessPartner);
FN.SetGirdColumnLinkedObjec(ref oGrid, "U_BPCD", BoLinkedObject.lf_BusinessPartner);
//지급유형
SAPbouiCOM.EditTextColumn oEditCol = (SAPbouiCOM.EditTextColumn)oGrid.Columns.Item("U_PAYTP");
oEditCol.Type = BoGridColumnType.gct_ComboBox;
SAPbouiCOM.ComboBoxColumn oComboCol = (SAPbouiCOM.ComboBoxColumn)oGrid.Columns.Item("U_PAYTP");
oComboCol.ValidValues.Add("1", "현금");
oComboCol.ValidValues.Add("2", "은행이체");
oComboCol.ValidValues.Add("3", "어음");
oComboCol.ValidValues.Add("4", "대체");
oComboCol.DisplayType = BoComboDisplayType.cdt_Description;
//수금유형
oEditCol = (SAPbouiCOM.EditTextColumn)oGrid.Columns.Item("U_BILLTP");
oEditCol.Type = BoGridColumnType.gct_ComboBox;
oComboCol = (SAPbouiCOM.ComboBoxColumn)oGrid.Columns.Item("U_BILLTP");
oComboCol.ValidValues.Add("1", "입금");
oComboCol.ValidValues.Add("2", "선수입금");
oComboCol.ValidValues.Add("3", "대행료 대체입금");
oComboCol.ValidValues.Add("4", "지급");
oComboCol.ValidValues.Add("5", "기타 대체");
oComboCol.DisplayType = BoComboDisplayType.cdt_Description;
B1Connections.theAppl.StatusBar.SetText("조회완료", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success); //조회완료
oGrid.RowHeaders.Width = 0;
//FN.SetGirdSort(ref oGrid1);
oGrid.AutoResizeColumns();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("btnFIND_OnAfterItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oGrid = null;
}
}
private void FindData(SAPbouiCOM.Form oForm)
{
string cv_ColumnsUID_s;
string cv_NoEditable_s;
string cv_ColumnsNAM_s;
string cv_Right_Just_s;
string cv_No_Visible_s;
oRS = (SAPbobsCOM.Recordset)B1Connections.diCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
EXAMCD = oForm.Items.Item("cboYEAR").Specific.Value;
try
{
oGrid = (SAPbouiCOM.Grid)oForm.Items.Item("grd1").Specific;
oGrid.SelectionMode = BoMatrixSelect.ms_Single;
cv_ColumnsUID_s = "U_LINENUM, U_EMPNO, U_EMPNM, U_DEPTCD, U_DEPTNM, U_PASSYNL, U_PASSYNT, U_HEADER, U_LINE,RANK,LASTG";
cv_NoEditable_s = "U_LINENUM, U_EMPNO, U_EMPNM, U_DEPTCD, U_DEPTNM, U_PASSYNL, U_PASSYNT, U_HEADER, U_LINE,RANK,LASTG";
cv_ColumnsNAM_s = "#,사번,사원명,부서코드,부서명,본인고과,고과자,헤더정보,라인정보,순위,최종등급";
cv_Right_Just_s = " ";
cv_No_Visible_s = "U_HEADER, U_LINE,RANK,LASTG";
string sQry = "";
sQry = string.Format(" EXEC [KIS_SP_HR0010B2_HRD] '1','{0}'",EXAMCD);
B1Connections.theAppl.StatusBar.SetText("데이터 조회중입니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터 조회중입니다
oForm.Freeze(true);
oForm.DataSources.DataTables.Item("grd1").ExecuteQuery(sQry);
oGrid.DataTable = oForm.DataSources.DataTables.Item("grd1"); //데이터 그리드에 Display
//조회된 내역이 없어도 1줄이 추가되므로 키값을 체크하여 조회안된 경우 1줄 삭제
if (oGrid.DataTable.Rows.Count == 1 && oGrid.DataTable.GetValue("U_EMPNO", 0).ToString() == "")
{
FN.SetGridTitle(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_No_Visible_s);
oForm.Items.Item("edtCREATE").Specific.Value = oGrid.DataTable.Rows.Count;
oForm.Items.Item("edtCOMPL").Specific.Value = 0;
oForm.Items.Item("edtINCOMPL").Specific.value = oForm.Items.Item("edtPERSON").Specific.Value;
B1Connections.theAppl.StatusBar.SetText("데이터가 없습니다.", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning); //데이터가 없습니다.
}
else
{
FN.BindGrid(oGrid, cv_ColumnsUID_s, cv_ColumnsNAM_s, cv_NoEditable_s, cv_No_Visible_s, "", cv_Right_Just_s);
FN.SetGridCombo(ref oGrid, "U_PASSYNL", "", " SELECT U_SMLCD,U_SMLNM FROM [@KIS_AD00201] WHERE CODE = 'HR11' AND U_USEYN = 'Y'", "");
FN.SetGridCombo(ref oGrid, "U_PASSYNT", "", " SELECT U_SMLCD,U_SMLNM FROM [@KIS_AD00201] WHERE CODE = 'HR11' AND U_USEYN = 'Y'", "");
B1Connections.theAppl.StatusBar.SetText("조회완료", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success); //조회완료
oGrid.RowHeaders.Width = 0;
oGrid.AutoResizeColumns();
sQry = string.Format(" EXEC [KIS_SP_HR0010B2_HRD] '2','{0}'",EXAMCD);
oRS.DoQuery(sQry);
oForm.Items.Item("edtCREATE").Specific.Value = oGrid.DataTable.Rows.Count;
oForm.Items.Item("edtCOMPL").Specific.Value = oRS.Fields.Item(0).Value;
oForm.Items.Item("edtINCOMPL").Specific.value = Convert.ToInt16(oForm.Items.Item("edtCREATE").Specific.Value) - Convert.ToInt16(oForm.Items.Item("edtCOMPL").Specific.Value);
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText("btnFIND_OnAfterItemPressed " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
oForm.Items.Item("btnSAVE").Enabled = true;
STATE = true;
oGrid = null;
}
}
