C# DBDataSource.SetValue方法代码示例

        public virtual void ET_AFDataMenu_Add(MenuEvent pVal)
        {
            oForm = B1Connections.theAppl.Forms.ActiveForm;
            // ADD YOUR ACTION CODE HERE ...
            FN.SetItemEnable(oForm, "btnTRAN,btnCANCTR", false);

            oButton = oForm.Items.Item("1").Specific;
            oButton.Caption = "생성";


            oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0400T_HRD");
            oDB_M.SetValue("U_PERSON", 0, B1Connections.diCompany.UserName);

            SetYyyyMm_NextValue(oForm);
        }

        public virtual void ET_cboJOB_AFComboSelect(ItemEvent pVal)
        {
            oForm = B1Connections.theAppl.Forms.Item(pVal.FormUID);
            oComboBox = ((SAPbouiCOM.ComboBox)(oForm.Items.Item("cboJOB").Specific));
            // ADD YOUR ACTION CODE HERE ...

            oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0030M_HRD");
            oDB_M.SetValue("U_JOBNM", 0, oComboBox.Selected.Description);
        }

        private void SetSystemDataTable(SAPbouiCOM.Form oForm)
        {
            try
            {     
                oDB1_O = (SAPbouiCOM.DBDataSource)oForm.DataSources.DBDataSources.Item("@KIS_SO00301_HRD");
                oDB2_O = (SAPbouiCOM.DBDataSource)oForm.DataSources.DBDataSources.Item("@KIS_SO00302_HRD");

                oDB1_Z = (SAPbouiCOM.DBDataSource)oForm.DataSources.DBDataSources.Item("@KIS_SO00301Z_HRD");
                oDB1_Z.Clear();
                             
                //if (gDs.Tables[oForm.UniqueID + "_Deliver"] != null)
                //    gDs.Tables[oForm.UniqueID + "_Deliver"].Clear();
                //else
                //    gDs.Tables[oForm.UniqueID + "_Deliver"] = SetParameterDataTableSchema(oForm.UniqueID+"Deliver");

                if (gDs.Tables.Contains(oForm.UniqueID + "_Deliver"))
                {
                    gDs.Tables[oForm.UniqueID + "_Deliver"].Rows.Clear();
                }
                else
                {
                    System.Data.DataTable dt = SetParameterDataTableSchema(oForm.UniqueID + "_Deliver");
                    gDs.Tables.Add(dt);
                }
                if (oDB1_O.Size > 0 && oDB1_O.GetValue("U_DELVCD", 0).ToString().Trim() != "")
                {

                    for (int i = 0; i < oDB1_O.Size; i++)
                    {
                        System.Data.DataRow dr;

                        // 데이터 필터를 위해 DataTable에 담는다.
                        dr = gDs.Tables[oForm.UniqueID + "_Deliver"].NewRow();

                        dr["IDX"] = i; // "DataTable 고유ID"
                        dr["LINEID"] = oDB1_O.GetValue("LineId", i);//"원본라인번호";
                        dr["DELVCD"] = oDB1_O.GetValue("U_DELVCD", i).Trim(); //"배달코드";
                        dr["RDEPT"] = oDB1_O.GetValue("U_RDEPT", i).Trim(); //"부서";
                        dr["PAPERTP"] = oDB1_O.GetValue("U_PAPERTP", i).Trim(); //"지종";
                        dr["PAYCD"] = oDB1_O.GetValue("U_PAYCD", i).Trim(); //"요금제코드";
                        dr["PAYNM"] = oDB1_O.GetValue("U_PAYNM", i).Trim(); //"요금제명";
                        dr["TEL"] = oDB1_O.GetValue("U_TEL", i).Trim(); //"연락처";
                        dr["MOBILE"] = oDB1_O.GetValue("U_MOBILE", i).Trim(); //"휴대폰";
                        dr["ADDR1"] = oDB1_O.GetValue("U_ADDR1", i).Trim(); //"주소1";
                        dr["ADDR2"] = oDB1_O.GetValue("U_ADDR2", i).Trim(); //"주소2";
                        dr["ADDR1_D"] = oDB1_O.GetValue("U_ADDR1_D", i).Trim(); //"주소1상세";
                        dr["ADDR2_D"] = oDB1_O.GetValue("U_ADDR2_D", i).Trim(); //"주소2상세";
                        dr["CENTCD"] = oDB1_O.GetValue("U_CENTCD", i).Trim(); //"지국";
                        dr["CENTNM"] = oDB1_O.GetValue("U_CENTNM", i).Trim(); //"지국명";
                        dr["DELVFR"] = oDB1_O.GetValue("U_DELVFR", i).Trim(); //"배달시작일";
                        dr["DELVTO"] = oDB1_O.GetValue("U_DELVTO", i).Trim(); //"배달종료일";
                        dr["DELVCNT"] = oDB1_O.GetValue("U_DELVCNT", i).Trim(); //"배달부수";
                        dr["METHOD"] = oDB1_O.GetValue("U_METHOD", i).Trim(); //"가입방법";
                        dr["SAILCD"] = oDB1_O.GetValue("U_SAILCD", i).Trim(); //"유치자";
                        dr["SAILNM"] = oDB1_O.GetValue("U_SAILNM", i).Trim(); //"유치자";
                        dr["STATUS"] = oDB1_O.GetValue("U_STATUS", i).Trim(); //"배달상태";
                        dr["SDEPT"] = oDB1_O.GetValue("U_SDEPT", i).Trim(); //"유치부서";
                        dr["NOTE"] = oDB1_O.GetValue("U_NOTE", i).Trim(); //"배달상세";

                        dr["JOINDT"] = oDB1_O.GetValue("U_JOINDT", i).Trim(); //"가입일자";
                        dr["CLOSEDT"] = oDB1_O.GetValue("U_CLOSEDT", i).Trim(); //"해지일자";
                        dr["USERSG1"] = oDB1_O.GetValue("U_USERSG1", i).Trim(); //"등록자";
                        dr["READTP"] = oDB1_O.GetValue("U_READTP", i).Trim(); //"독자구분";

                        dr["BTEL1"] = oDB1_O.GetValue("U_BTEL1", i).Trim(); //"분국전화1";
                        dr["BTEL2"] = oDB1_O.GetValue("U_BTEL2", i).Trim(); //"분국전화1";

                        dr["ROWSTATE"] = ""; // 기본: "", 수정: M, 신규: I, 삭제: D 
                        gDs.Tables[oForm.UniqueID + "_Deliver"].Rows.Add(dr);


                        oDB1_Z.InsertRecord(i);

                        oDB1_Z.SetValue("U_NO", i, (i + 1).ToString());//"번호";
                        oDB1_Z.SetValue("U_IDX", i, (i).ToString());//"DataTable 고유ID";
                        oDB1_Z.SetValue("LineId", i, oDB1_O.GetValue("LineId", i));//"원본라인번호";
                        oDB1_Z.SetValue("U_DELVCD", i, oDB1_O.GetValue("U_DELVCD", i).Trim()); //"배달코드";
                        oDB1_Z.SetValue("U_RDEPT", i, oDB1_O.GetValue("U_RDEPT", i).Trim()); //"부서";
                        oDB1_Z.SetValue("U_PAPERTP", i, oDB1_O.GetValue("U_PAPERTP", i).Trim()); //"지종";
                        oDB1_Z.SetValue("U_PAYCD", i, oDB1_O.GetValue("U_PAYCD", i).Trim()); //"요금제코드";
                        oDB1_Z.SetValue("U_PAYNM", i, oDB1_O.GetValue("U_PAYNM", i).Trim()); //"요금제명";
                        oDB1_Z.SetValue("U_TEL", i, oDB1_O.GetValue("U_TEL", i).Trim()); //"연락처";
                        oDB1_Z.SetValue("U_MOBILE", i, oDB1_O.GetValue("U_MOBILE", i).Trim()); //"휴대폰";
                        oDB1_Z.SetValue("U_ADDR1", i, oDB1_O.GetValue("U_ADDR1", i).Trim()); //"주소1";
                        oDB1_Z.SetValue("U_ADDR2", i, oDB1_O.GetValue("U_ADDR2", i).Trim()); //"주소2";
                        oDB1_Z.SetValue("U_ADDR1_D", i, oDB1_O.GetValue("U_ADDR1_D", i).Trim()); //"주소1";
                        oDB1_Z.SetValue("U_ADDR2_D", i, oDB1_O.GetValue("U_ADDR2_D", i).Trim()); //"주소2";
                        oDB1_Z.SetValue("U_CENTCD", i, oDB1_O.GetValue("U_CENTCD", i).Trim()); //"지국";
                        oDB1_Z.SetValue("U_CENTNM", i, oDB1_O.GetValue("U_CENTNM", i).Trim()); //"지국명";
                        oDB1_Z.SetValue("U_DELVFR", i, oDB1_O.GetValue("U_DELVFR", i).Trim()); //"배달시작일";
                        oDB1_Z.SetValue("U_DELVTO", i, oDB1_O.GetValue("U_DELVTO", i).Trim()); //"배달종료일";
                        oDB1_Z.SetValue("U_DELVCNT", i, oDB1_O.GetValue("U_DELVCNT", i).Trim()); //"배달부수";
                        oDB1_Z.SetValue("U_METHOD", i, oDB1_O.GetValue("U_METHOD", i).Trim()); //"가입방법";
                        oDB1_Z.SetValue("U_SAILCD", i, oDB1_O.GetValue("U_SAILCD", i).Trim()); //"유치자";
                        oDB1_Z.SetValue("U_SAILNM", i, oDB1_O.GetValue("U_SAILNM", i).Trim()); //"유치자";
                        oDB1_Z.SetValue("U_STATUS", i, oDB1_O.GetValue("U_STATUS", i).Trim()); //"배달상태";
                        oDB1_Z.SetValue("U_SDEPT", i, oDB1_O.GetValue("U_SDEPT", i).Trim()); //"유치부서";
                        oDB1_Z.SetValue("U_NOTE", i, oDB1_O.GetValue("U_NOTE", i).Trim()); //"배달상세";

                        oDB1_Z.SetValue("U_JOINDT", i, oDB1_O.GetValue("U_JOINDT", i).Trim()); //"가입일자";
//.........这里部分代码省略.........

        public virtual void ET_edtCALLPER_AFValidate(ItemEvent pVal)
        {
            oForm = B1Connections.theAppl.Forms.Item(pVal.FormUID);
            oEditText = ((SAPbouiCOM.EditText)(oForm.Items.Item("edtCALLPER").Specific));
            // ADD YOUR ACTION CODE HERE ....

            if (pVal.ItemChanged == true)
            {
                if (oEditText.Value == "")
                {
                    oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0030M_HRD");
                    oDB_M.SetValue("U_CALLNM", 0, "");
                }
            }
        }

        /// <summary>
        /// 독자코드가 존재하면 새로운 코드를 채번해서 화면상에 Bind하고 저장하도록 한다.
        /// </summary>
        /// <param name="oForm"></param>
        private void SeNewCodeApply(SAPbouiCOM.Form oForm)
        {
            string strNewCode = string.Empty;
            string strLineID = string.Empty;
            try
            {
                oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0030M_HRD");
                strNewCode = GetNewCode(oForm);

                oDB_M.SetValue("Code", 0, strNewCode);
                foreach (System.Data.DataRow dr in gDs.Tables[oForm.UniqueID + "_Deliver"].Rows)
                {
                    strLineID = dr["LINEID"].ToString().Trim().PadLeft(4, '0');
                    dr["DELVCD"] = strNewCode + "_" + strLineID;
                }
            }
            catch (Exception)
            {
                throw;
            }
        }

//.........这里部分代码省略.........
                                    vPAYNM = row.Field<string>("PAYNM")
                                    ,
                                    vTEL = row.Field<string>("TEL")
                                    ,
                                    vMOBILE = row.Field<string>("MOBILE")
                                    ,
                                    vADDR1 = row.Field<string>("ADDR1")
                                    ,
                                    vADDR2 = row.Field<string>("ADDR2")
                                    ,
                                    vADDR1_D = row.Field<string>("ADDR1_D")
                                    ,
                                    vADDR2_D = row.Field<string>("ADDR2_D")
                                    ,
                                    vCENTCD = row.Field<string>("CENTCD")
                                    ,
                                    vCENTNM = row.Field<string>("CENTNM")
                                    ,
                                    vDELVFR = row.Field<string>("DELVFR")
                                    ,
                                    vDELVTO = row.Field<string>("DELVTO")
                                    ,
                                    vDELVCNT = row.Field<Int32>("DELVCNT")
                                    ,
                                    vMETHOD = row.Field<string>("METHOD")
                                    ,
                                    vSAILCD = row.Field<string>("SAILCD")
                                    ,
                                    vSAILNM = row.Field<string>("SAILNM")
                                    ,
                                    vSDEPT = row.Field<string>("SDEPT")
                                    ,
                                    vSTATUS = row.Field<string>("STATUS")
                                    ,
                                    vNOTE = row.Field<string>("NOTE")
                                    ,
                                    vJOINDT = row.Field<string>("JOINDT")
                                    ,
                                    vCLOSEDT = row.Field<string>("CLOSEDT")
                                    ,
                                    vUSERSG1 = row.Field<string>("USERSG1")
                                    ,
                                    vREADTP = row.Field<string>("READTP")
                                    ,
                                    vBTEL1 = row.Field<string>("BTEL1")
                                    ,
                                    vBTEL2 = row.Field<string>("BTEL2")
                                    ,
                                    vROWSTATE = row.Field<string>("ROWSTATE")
                                };

                foreach (var itemSub in objModify)
                {
                    if (itemSub.vROWSTATE == "I")
                        SetDbDataSourceAddRow(ref oForm, ref oMatrix, ref oDB1_O, "U_DELVCD");

                    oDB1_O.SetValue("U_DELVCD", itemSub.vIDX, itemSub.vDELVCD);
                    oDB1_O.SetValue("U_RDEPT", itemSub.vIDX, itemSub.vRDEPT);
                    oDB1_O.SetValue("U_PAPERTP", itemSub.vIDX, itemSub.vPAPERTP);
                    oDB1_O.SetValue("U_READTP", itemSub.vIDX, itemSub.vREADTP);

                    oDB1_O.SetValue("U_PAYCD", itemSub.vIDX, itemSub.vPAYCD);
                    oDB1_O.SetValue("U_PAYNM", itemSub.vIDX, itemSub.vPAYNM);

                    oDB1_O.SetValue("U_TEL", itemSub.vIDX, itemSub.vTEL);
                    oDB1_O.SetValue("U_MOBILE", itemSub.vIDX, itemSub.vMOBILE);
                    oDB1_O.SetValue("U_ADDR1", itemSub.vIDX, itemSub.vADDR1);
                    oDB1_O.SetValue("U_ADDR2", itemSub.vIDX, itemSub.vADDR2);
                    oDB1_O.SetValue("U_ADDR1_D", itemSub.vIDX, itemSub.vADDR1_D);
                    oDB1_O.SetValue("U_ADDR2_D", itemSub.vIDX, itemSub.vADDR2_D);
                    oDB1_O.SetValue("U_CENTCD", itemSub.vIDX, itemSub.vCENTCD);
                    oDB1_O.SetValue("U_CENTNM", itemSub.vIDX, itemSub.vCENTNM);
                    oDB1_O.SetValue("U_DELVFR", itemSub.vIDX, itemSub.vDELVFR);
                    oDB1_O.SetValue("U_DELVTO", itemSub.vIDX, itemSub.vDELVTO);
                    oDB1_O.SetValue("U_DELVCNT", itemSub.vIDX, itemSub.vDELVCNT.ToString());
                    oDB1_O.SetValue("U_METHOD", itemSub.vIDX, itemSub.vMETHOD);
                    oDB1_O.SetValue("U_STATUS", itemSub.vIDX, itemSub.vSTATUS);
                    oDB1_O.SetValue("U_SAILCD", itemSub.vIDX, itemSub.vSAILCD);
                    oDB1_O.SetValue("U_SAILNM", itemSub.vIDX, itemSub.vSAILNM);
                    oDB1_O.SetValue("U_SDEPT", itemSub.vIDX, itemSub.vSDEPT);
                    oDB1_O.SetValue("U_NOTE", itemSub.vIDX, itemSub.vNOTE);
                    oDB1_O.SetValue("U_JOINDT", itemSub.vIDX, itemSub.vJOINDT);
                    oDB1_O.SetValue("U_CLOSEDT", itemSub.vIDX, itemSub.vCLOSEDT);
                    oDB1_O.SetValue("U_USERSG1", itemSub.vIDX, itemSub.vUSERSG1); //등록자

                    oDB1_O.SetValue("U_BTEL1", itemSub.vIDX, itemSub.vBTEL1); //분국전화1
                    oDB1_O.SetValue("U_BTEL2", itemSub.vIDX, itemSub.vBTEL2); //분국전화2

                }
                if (objModify.Count() > 0)
                    oMatrix.LoadFromDataSource();

                rtnValue = true;
            }
            catch (Exception)
            {
                throw;
            }
            return rtnValue;
        }

        /// <summary>
        /// 마스터의 구독부수를 갱신한다.
        /// </summary>
        /// <param name="oForm"></param>
        private void SetSumNumberOfCofies(SAPbouiCOM.Form oForm)
        {

            try
            {
                oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0030M_HRD");
                string strSum = gDs.Tables[oForm.UniqueID + "_Deliver"].Compute(" SUM(DELVCNT) ", " STATUS = 'UO'").ToString();

                if (string.IsNullOrEmpty(strSum))
                    strSum = "0";

                oDB_M.SetValue("U_SUMCNT", 0, strSum);
            }
            catch (Exception)
            {
                throw;
            }
        }

        private void SetComboBox_AcctCode(SAPbouiCOM.Form oForm)
        {
            try
            {
                oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0320T_HRD");
                string strTYPE = oDB_M.GetValue("U_TYPE", 0).Trim();
                string strMETHOD = oDB_M.GetValue("U_METHOD", 0).Trim();
                string strACCTYN = oDB_M.GetValue("U_ACCTYN", 0).Trim();
                string strLIST = string.Empty;

                if (strACCTYN == "Y")
                {

                    if (strMETHOD == "S04" || strMETHOD == "S05") // 현금,무통장
                    {
                        if (strTYPE == "I") // 수금(입금)
                        {
                            strLIST = "'U201','U204'"; // 선수금, 보증금
                        }
                        else
                        {
                            strLIST = "'U204'"; // 보증금
                        }
                    }

                    else if (strMETHOD == "S11") //보증금대체
                    {
                        strLIST = "'U204'";
                    }
                    else if (strMETHOD == "S12") // 미지급금대체
                    {
                        strLIST = "'U204'";
                    }
                }


                if (String.IsNullOrEmpty(strLIST))
                {
                    oComboBox = oForm.Items.Item("cboACCTCD").Specific;
                    FN.SetComboClear(ref oComboBox);
                    oDB_M.SetValue("U_ACCTCD", 0, "");
                }
                else
                {
                    oComboBox = oForm.Items.Item("cboACCTCD").Specific;
                    FN.SetComboClear(ref oComboBox);
                    oDB_M.SetValue("U_ACCTCD", 0, "");

                    FN.SetComboBoxValidValues(oForm, string.Format(" SELECT  U_RMK1, U_SMLNM FROM [@KIS_AD00201] WHERE Code = 'SO19' AND U_SMLCD IN ({0}) ", strLIST), "cboACCTCD", FN.Enum_WholeTp.m_Space, "");
                }

            }
            catch (Exception)
            {

                throw;
            }
        }

        public virtual void ET_edtBNKACCT_AFChooseFromList(ItemEvent pVal)
        {
            oForm = B1Connections.theAppl.Forms.Item(pVal.FormUID);
            oEditText = ((SAPbouiCOM.EditText)(oForm.Items.Item("edtBNKACCT").Specific));
            // ADD YOUR ACTION CODE HERE ...

            //데이터를 가져오기 위해 데이터테이블 추가
            SAPbouiCOM.DataTable oDataTable = FN.GetCFLSelectedObjects(pVal);

            try
            {
                if (oDataTable != null)
                {
                    oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0320T_HRD");
                    oDB_M.SetValue("U_BNKACCT", 0, oDataTable.GetValue("Account", 0).ToString()); //계좌
                    //oDB_M.SetValue("U_ACCTCD", 0, oDataTable.GetValue("GLAccount", 0).ToString());//계정콛,
                    oDB_M.SetValue("U_BNKBRCH", 0, oDataTable.GetValue("Branch", 0).ToString());//지점명
                }
            }
            catch (Exception ex)
            {
                B1Connections.theAppl.StatusBar.SetText("ET_edtBNKACCT_AFChooseFromList " + ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error);
            }
            finally
            {
                oDataTable = null;
            }
        }

        /// <summary>
        /// 폼(Form) 및 아이템들(Items)의 기본값으로 설정되야하는 항목들을 정의합니다.
        /// </summary>
        private void Act3_DefualtSetting(SAPbouiCOM.Form oForm)
        {
            try
            {
                //메트릭스 첫줄 선택시 팝업박스 뜨는것 막는다.
                oForm.Settings.EnableRowFormat = false;
                oMatrix = (SAPbouiCOM.Matrix)oForm.Items.Item("mtx").Specific;
                oMatrix.SelectionMode = BoMatrixSelect.ms_Auto;

                if (oForm.Mode != BoFormMode.fm_ADD_MODE)
                {
                    oForm.Mode = BoFormMode.fm_ADD_MODE;
                }
                oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0320T_HRD");
                oDB_M.SetValue("U_TYPE", 0, "I"); // 수금으로 선택

                //네비게이션 버튼 활성화 및 네비게션의 유일한 값
                oForm.DataBrowser.BrowseBy = "edtDOCNUM";

                // 입금.지급방법
                //FN.SetComboBoxValidValues(oForm, " SELECT  U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE Code = 'SO51' AND U_RMK2 = 'Y' ", "cboMETHOD", FN.Enum_WholeTp.m_Nothing, "");

                // 계정과목 콤보
                //FN.SetComboBoxValidValues(oForm, " SELECT  U_RMK1, U_SMLNM FROM [@KIS_AD00201] WHERE Code = 'SO19' AND U_SMLCD IN ('U201', 'U204') ", "cboACCTCD", FN.Enum_WholeTp.m_Space, "");

                // 지국코드
                FN.SetChooseFromListAdd(oForm, "KIS_SO0040_HRD", "edtCENTCD", "Code", BoFormItemTypes.it_EDIT);

                // 은행계좌
                FN.SetChooseFromListAdd(oForm, ((int)BoObjectTypes.oHouseBankAccounts).ToString(), "edtBNKACCT", "Account", BoFormItemTypes.it_EDIT);

                //SAPbouiCOM.Conditions oCons = new SAPbouiCOM.Conditions();
                //SAPbouiCOM.Condition oCon = oCons.Add();

                //oCon.Alias = "GroupMask";
                //oCon.Operation = BoConditionOperation.co_EQUAL;
                //oCon.CondVal = "2";

                // 계정과목
                //FN.SetChooseFromListAdd(oForm, ((int)BoObjectTypes.oChartOfAccounts).ToString(), "cboACCTCD", "AcctCode", BoFormItemTypes.it_EDIT, oCons);


                //계정과목으로 입금/지급체크 여부에 따라 아이뎀활성여부
                SetItemEnabled(oForm);

                //입금지급 유형에따른 콤보바인딩처리
                SetComboBox_Method(oForm);

                FN.SetSumField(ref oMatrix, "U_REQAMT,U_SAVAMT,U_REQUNP,U_SAVUNP,U_REQDEP,U_SAVDEP");

            }
            catch (Exception)
            {
                throw;
            }
        }

        private void SetComboBox_Method(SAPbouiCOM.Form oForm)
        {
            try
            {
                oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0320T_HRD");
                string strTYPE = oDB_M.GetValue("U_TYPE", 0).Trim();
                string strACCTYN = oDB_M.GetValue("U_ACCTYN", 0).Trim();
                string strLIST = string.Empty;
                if (strTYPE == "I")
                {
                    if (strACCTYN == "Y")
                    {
                        strLIST = "'S04','S05'";
                    }
                    else
                    {
                        strLIST = "'S04','S05','S11'";// 현금, 무통장, 보증금대체
                    }
                }
                else
                {
                    strLIST = "'S04','S05','S12'";// 현금, 무통장, 미지급금대체

                }

                if (String.IsNullOrEmpty(strLIST))
                {
                    oComboBox = oForm.Items.Item("cboMETHOD").Specific;
                    FN.SetComboClear(ref oComboBox);
                    oDB_M.SetValue("U_METHOD", 0, "");
                }
                else
                {
                    oComboBox = oForm.Items.Item("cboMETHOD").Specific;
                    FN.SetComboClear(ref oComboBox);
                    oDB_M.SetValue("U_METHOD", 0, "");
                    FN.SetComboBoxValidValues(oForm, string.Format(" SELECT  U_SMLCD, U_SMLNM FROM [@KIS_AD00201] WHERE Code = 'SO51' AND U_SMLCD IN ({0}) ", strLIST), "cboMETHOD", FN.Enum_WholeTp.m_Space, "");
                }



            }
            catch (Exception)
            {

                throw;
            }
        }

        public virtual void ET_chkACCTIN_AFItemPressed(ItemEvent pVal)
        {
            oForm = B1Connections.theAppl.Forms.Item(pVal.FormUID);
            oCheckBox = ((SAPbouiCOM.CheckBox)(oForm.Items.Item("chkACCTIN").Specific));
            // ADD YOUR ACTION CODE HERE ...
            SetItemEnabled(oForm);

            //if (pVal.ItemChanged)
            //{
            oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0320T_HRD");
            oDB_M.SetValue("U_METHOD", 0, "");
            oDB_M.SetValue("U_ACCTCD", 0, "");

            SetComboBox_Method(oForm);

            //}
        }

        /// <summary>
        /// 창 닫기전에 부모창에 값을 바인딩 한다.
        /// </summary>
        /// <param name="oForm"></param>
        private void SetDataToParentApply(SAPbouiCOM.Form oForm)
        {
            try
            {

                //oForm.Update();
                oUDS = oForm.DataSources.UserDataSources;
                string StrPFormUID = oUDS.Item("pFORMUID").Value;
                pForm = B1Connections.theAppl.Forms.Item(StrPFormUID);

                //oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0030M_HRD");
                pDB_M = pForm.DataSources.DBDataSources.Item("@KIS_SO0030M_HRD");

                //string strBANKNM = FN.GetItemValue(ref oForm, "cboBANKNM");
                //string strBNKACCT = FN.GetItemValue(ref oForm, "edtBNKACCT");
                //string strCREDTBP = FN.GetItemValue(ref oForm, "cboCREDTBP");
                //string strDEPNAME = FN.GetItemValue(ref oForm, "edtDEPNAME");
                //string strCREDTNO = FN.GetItemValue(ref oForm, "edtCREDTNO");
                //string strVALIDMY = FN.GetItemValue(ref oForm, "edtVALIDMY");
                //string strCREDTNM = FN.GetItemValue(ref oForm, "edtCREDTNM");
                //string strJMNO = FN.GetItemValue(ref oForm, "edtJMNO1");
                //string strJMNO2 = FN.GetItemValue(ref oForm, "edtJMNO2");

                string strBANKNM = oUDS.Item("cboBANKNM").Value;
                string strBNKACCT = oUDS.Item("edtBNKACCT").Value;
                string strCREDTBP = oUDS.Item("cboCREDTBP").Value;
                string strDEPNAME = oUDS.Item("edtDEPNAME").Value;
                string strCREDTNO = oUDS.Item("edtCREDTNO").Value;
                string strVALIDMY = oUDS.Item("edtVALIDMY").Value;
                string strCREDTNM = oUDS.Item("edtCREDTNM").Value;
                string strJMNO = oUDS.Item("edtJMNO").Value;
                string strJMNOYN = oUDS.Item("chkJMNOYN").Value;

                pDB_M.SetValue("U_BANKNM", 0, strBANKNM);
                pDB_M.SetValue("U_BNKACCT", 0, strBNKACCT);
                pDB_M.SetValue("U_CREDTBP", 0, strCREDTBP);
                pDB_M.SetValue("U_DEPNAME", 0, strDEPNAME);
                pDB_M.SetValue("U_CREDTNO", 0, strCREDTNO);
                pDB_M.SetValue("U_VALIDMY", 0, strVALIDMY);
                pDB_M.SetValue("U_CREDTNM", 0, strCREDTNM);
                pDB_M.SetValue("U_JMNO", 0, strJMNO);
                pDB_M.SetValue("U_JMNOYN", 0, strJMNOYN);

                if (pForm.Mode == BoFormMode.fm_OK_MODE)
                    pForm.Mode = BoFormMode.fm_UPDATE_MODE;
            }
            catch (Exception)
            {
                throw;
            }
        }

        /// <summary>
        /// 추가모드전환시 자동으로 생성가능한 년월을 가져온다.
        /// </summary>
        /// <param name="oForm"></param>
        /// <returns></returns>
        private bool SetYyyyMm_NextValue(SAPbouiCOM.Form oForm)
        {
            bool rtnValue = false;
            string strYyyyMm = string.Empty;
            string strDate = string.Empty;
            string strDesc = string.Empty;
            string strValue = string.Empty;
            string strPerson = string.Empty;

            StringBuilder sb;
            SAPbobsCOM.Recordset oRS = (SAPbobsCOM.Recordset)B1Connections.diCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);

            try
            {
                strYyyyMm = FN.GetItemValue(ref oForm, "edtYYYYMM");
                strPerson = B1Connections.diCompany.UserName;

                sb = new StringBuilder();
                sb.AppendLine(" SELECT ISNULL ( (SELECT CONVERT (NVARCHAR (6), DATEADD (MM, 1, CONVERT (DATE, U_YYYYMM + '01')), 112)  ");
                sb.AppendLine("                    FROM (SELECT U_YYYYMM, ROW_NUMBER () OVER (ORDER BY U_YYYYMM DESC) AS RegSeq        ");
                sb.AppendLine("                            FROM [@KIS_SO0400T_HRD]                                                     ");
                sb.AppendFormat("                           WHERE Status = 'O' AND U_PERSON = '{0}') AS x                   ", strPerson);
                sb.AppendLine("                   WHERE RegSeq = 1)                                                                    ");
                sb.AppendLine("              , CONVERT (NVARCHAR (6), GETDATE (), 112))                                                ");
                sb.AppendLine("           AS U_YYYYMM                                                                                  ");

                oRS.DoQuery(sb.ToString());
                if (!oRS.EoF)
                {
                    strValue = oRS.Fields.Item("U_YYYYMM").Value.ToString();
                    oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_SO0400T_HRD");
                    oDB_M.SetValue("U_YYYYMM", 0, strValue);
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                if (oRS != null) { Marshal.ReleaseComObject(oRS); } oRS = null;
            }
            return rtnValue;
        }

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