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

        public static int s_SystemVersion = 26;

            IOProceedingsDataAttend DB20 = new IOProceedingsDataAttend();           // 発注者打ち合わせ議事録データ（出席者）

                //DetailRec.ExecutionAmount = ExecutionAmount;                                // ???s???z

                //DetailRec.AmountConfigRate = AmountConfigRate;                              // ???z?\????

                // ???????????????E?????f?[?^???????\??????

                if (DispType== (int)DispDataTypeCode.Department)

                {

                    GetType2DeleteData(LedgerDB, ref arData);

                }

                //strSQL += " AND C.DELETEFLG = 0";

                //strSQL += string.Format(" AND C.EMPLOYEECLASSFLG = {0}", (int)CommonDefine.EmployeeClassFlg.Regular);

        #region ???????????f?[?^??S?????f?[?^???????????

        /// <summary>

        /// ???????????f?[?^??S?????f?[?^???????????

        /// </summary>

        private void GetType2DeleteData(IOConstructionLedger LedgerDB, ref ArrayList arData)

        {

            string strSQL = string.Empty;

            try

            {

                // SQL??A?N?Z?X????????????

                string strSecurity = string.Empty;

                CreateSecuritySQL(ref strSecurity);

                int NotOrder = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("?? ?? ??")).Key;

                int DepCode = CommonMotions.cnvInt(cmbDepartment.SelectedValue);

                // ----- ?r?p?k??

                // ????????f?[?^????

                strSQL = "SELECT";

                strSQL += " C.PERSONCODE";

                strSQL += " ,C.PERSONNAME";

                strSQL += " ,C.DISPLAYORDER";

                strSQL += " ,SUM(A.ORDERSDECISIONPRICE)";

                strSQL += " ,SUM(A.COMPANYEXPENSES)";

                strSQL += " ,SUM(A.DEPARTMENTEXPENSES)";

                strSQL += " ,SUM(A.SALESEXPENSES)";

                strSQL += " ,SUM(A.TOTALPAYMENT)";

                strSQL += " ,SUM(A.GROSSPROFIT)";

                strSQL += " ,SUM(A.NETPROFIT)";

                strSQL += " ,C.EMPLOYEECLASSFLG";

                strSQL += " FROM PERSONINCHARGEMASTER C";

                strSQL += " LEFT JOIN CONSTRUCTIONBASEINFO B ON B.CONSTRUCTIONPERSONCODE = C.PERSONCODE";

                strSQL += string.Format(" AND B.CONSTRUCTIONPERIOD = {0}", numUDConstPro.Value);

                strSQL += string.Format(" AND B.CONSTRUCTIONSTATUSFLG != {0}", NotOrder);

                strSQL += string.Format(" AND B.TyingFlg != {0}", (int)CommonDefine.BaseInfoTyingFlg.Tying);

                strSQL += ", CONSTRUCTIONLEDGER A";

                //strSQL += " LEFT JOIN CONSTRUCTIONLEDGER A ON A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE";

                strSQL += string.Format(" WHERE C.DEPARTMENTCODE = {0}", DepCode);

                strSQL += " AND A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE";

                strSQL += " AND C.DELETEFLG != 0";

                //strSQL += string.Format(" AND C.EMPLOYEECLASSFLG = {0}", (int)CommonDefine.EmployeeClassFlg.Regular);

                strSQL += " GROUP BY C.DISPLAYORDER, C.PERSONCODE, C.PERSONNAME, C.EMPLOYEECLASSFLG";

                strSQL += " ORDER BY 11, 3 ASC";

                if (!LedgerDB.ExecuteReader(strSQL, ref arData)) return;

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", ex.Message, strSQL);

            }

        }

        #endregion

                    // Debug.WriteLine(string.Format("Code={0} Val={1} Start={2} End={3}", PersonCDArray[i], workSalary.ToString("0,0"), dtStart, dtMax));

[assembly: AssemblyFileVersion("0.9.9.26")]