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; } }