工事管理システム製品化対応

                            MessageBoardEntry(depositData);

        private bool MessageBoardEntry(DepositData deposit)

                // 工事番号・営業担当者・工事担当者取得

                IOConstructionBaseInfoDetail cbiDDB = new IOConstructionBaseInfoDetail();

                try

                {

                    cbiDDB.connect();;

                    string strSQL = "SELECT A.ConstructionCode, B.PERSONCODE SCODE, B.PERSONNAME SNAME, C.PERSONCODE CCODE, C.PERSONNAME CNAME";

                    strSQL += " FROM CONSTRUCTIONBASEINFO P";

                    strSQL += " INNER JOIN REQUESTHEAD H ON H.REQCONSTRUCTIONCODE = P.CONSTRUCTIONCODE";

                    strSQL += string.Format(" AND H.ORDERERSDIVISION = {0}", deposit.OrderersDivision);

                    strSQL += string.Format(" AND H.ORDERERSCODE = {0}", deposit.OrderersCode);

                    strSQL += string.Format(" AND H.REQUESTMONTH = {0}", deposit.TargetDate);

                    strSQL += " LEFT JOIN PERSONINCHARGEMASTER B ON B.PERSONCODE = P.SALESPERSONCODE";

                    strSQL += " LEFT JOIN PERSONINCHARGEMASTER C ON C.PERSONCODE = P.CONSTRUCTIONPERSONCODE";

                    strSQL += " , CONSTRUCTIONBASEINFODETAIL A";

                    strSQL += " WHERE P.CONSTRUCTIONCODE = H.REQCONSTRUCTIONCODE";

                    strSQL += string.Format(" AND A.CONSTRUCTIONCODE = P.CONSTRUCTIONCODE AND A.DETAILNO = {0}", (int)ConstructionBaseInfoDetail.DetailDataNo.ConstructionName);

                    ArrayList arList = new ArrayList();

                    if (!cbiDDB.ExecuteReader(strSQL, ref arList)) return false;

                    string ConstructionCode = string.Empty;

                    int SalesPersonCode = 0;

                    string SalesPersonName = string.Empty;

                    int ConstructionPersonCode = 0;

                    string ConstructionPersonName = string.Empty;

                    int icnt = 0; // 対象者書込み

                    MessageBoardTerget wrkTer = null;

                    foreach (object[] onjwrk in arList)

                    {

                        ConstructionCode = CommonMotions.cnvString(onjwrk[0]);

                        SalesPersonCode = CommonMotions.cnvInt(onjwrk[1]);

                        SalesPersonName = CommonMotions.cnvString(onjwrk[2]);

                        ConstructionPersonCode = CommonMotions.cnvInt(onjwrk[3]);

                        ConstructionPersonName = CommonMotions.cnvString(onjwrk[4]);

                        // 営業担当は掲示板データを作成しない

                        // キーコードセット

                        //wrkTer = new MessageBoardTerget();

                        //wrkTer.RecordNumber = data.RecordNumber;

                        //wrkTer.BranchNumber = data.BranchNumber;

                        //wrkTer.SeqNum = ++icnt;

                        //wrkTer.ToCode = SalesPersonCode;

                        //wrkTer.ToName = SalesPersonName;

                        //terList.Add(wrkTer);

                        // 工事担当

                        // キーコードセット

                        wrkTer = new MessageBoardTerget();

                        wrkTer.RecordNumber = data.RecordNumber;

                        wrkTer.BranchNumber = data.BranchNumber;

                        wrkTer.SeqNum = ++icnt;

                        wrkTer.ToCode = ConstructionPersonCode;

                        wrkTer.ToName = ConstructionPersonName;

                        terList.Add(wrkTer);

                    }

                }

                finally

                {

                   cbiDDB.close(); cbiDDB = null;

                }