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

        public static int s_SystemVersion = 71;

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle();

            this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column10 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column4 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column5 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column6 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column7 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column8 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column9 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;

            dataGridViewCellStyle1.BackColor = System.Drawing.SystemColors.Control;

            dataGridViewCellStyle1.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            dataGridViewCellStyle1.ForeColor = System.Drawing.SystemColors.WindowText;

            dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight;

            dataGridViewCellStyle1.SelectionForeColor = System.Drawing.SystemColors.HighlightText;

            dataGridViewCellStyle1.WrapMode = System.Windows.Forms.DataGridViewTriState.True;

            this.dgvMaster.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;

            this.comboBox1.Size = new System.Drawing.Size(100, 24);

            this.label5.Location = new System.Drawing.Point(876, 16);

            this.comboBox3.Location = new System.Drawing.Point(1004, 17);

            this.label4.Location = new System.Drawing.Point(538, 16);

            this.comboBox2.Location = new System.Drawing.Point(666, 17);

            // Column1

            // 

            dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;

            dataGridViewCellStyle2.Font = new System.Drawing.Font("Century", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.Column1.DefaultCellStyle = dataGridViewCellStyle2;

            this.Column1.Frozen = true;

            this.Column1.HeaderText = "№";

            this.Column1.Name = "Column1";

            this.Column1.ReadOnly = true;

            this.Column1.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            this.Column1.Width = 60;

            // 

            // Column10

            // 

            this.Column10.Frozen = true;

            this.Column10.HeaderText = "発注区分コード";

            this.Column10.Name = "Column10";

            this.Column10.ReadOnly = true;

            this.Column10.Visible = false;

            this.Column10.Width = 5;

            // 

            // Column2

            // 

            this.Column2.Frozen = true;

            this.Column2.HeaderText = "発注者コード";

            this.Column2.Name = "Column2";

            this.Column2.ReadOnly = true;

            this.Column2.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            this.Column2.Visible = false;

            this.Column2.Width = 5;

            // 

            // Column4

            // 

            dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;

            this.Column4.DefaultCellStyle = dataGridViewCellStyle3;

            this.Column4.Frozen = true;

            this.Column4.HeaderText = "発　注　区　分";

            this.Column4.Name = "Column4";

            this.Column4.ReadOnly = true;

            this.Column4.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            this.Column4.Width = 380;

            // 

            // Column3

            // 

            dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;

            this.Column3.DefaultCellStyle = dataGridViewCellStyle4;

            this.Column3.Frozen = true;

            this.Column3.HeaderText = "発　注　者　名";

            this.Column3.Name = "Column3";

            this.Column3.ReadOnly = true;

            this.Column3.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            this.Column3.Width = 400;

            // 

            // Column5

            // 

            dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;

            dataGridViewCellStyle5.Font = new System.Drawing.Font("Century", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.Column5.DefaultCellStyle = dataGridViewCellStyle5;

            this.Column5.Frozen = true;

            this.Column5.HeaderText = "請求金額";

            this.Column5.Name = "Column5";

            this.Column5.ReadOnly = true;

            this.Column5.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            this.Column5.Width = 200;

            // 

            // Column6

            // 

            this.Column6.Frozen = true;

            this.Column6.HeaderText = "部署コード";

            this.Column6.Name = "Column6";

            this.Column6.ReadOnly = true;

            this.Column6.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            this.Column6.Visible = false;

            this.Column6.Width = 5;

            // 

            // Column7

            // 

            dataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;

            this.Column7.DefaultCellStyle = dataGridViewCellStyle6;

            this.Column7.Frozen = true;

            this.Column7.HeaderText = "部　　署";

            this.Column7.Name = "Column7";

            this.Column7.ReadOnly = true;

            this.Column7.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            // 

            // Column8

            // 

            this.Column8.Frozen = true;

            this.Column8.HeaderText = "工事担当者コード";

            this.Column8.Name = "Column8";

            this.Column8.ReadOnly = true;

            this.Column8.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            this.Column8.Visible = false;

            this.Column8.Width = 5;

            // 

            // Column9

            // 

            dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;

            this.Column9.DefaultCellStyle = dataGridViewCellStyle7;

            this.Column9.Frozen = true;

            this.Column9.HeaderText = "工事担当者";

            this.Column9.Name = "Column9";

            this.Column9.ReadOnly = true;

            this.Column9.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            // 

            DisplayData();

            listMonth.Add(new KeyValuePair<int, String>(0, "?????"));

            DateTime stDate = DateTime.Now;

            switch (CommonMotions.SystemMasterData.ConstructionNoBase)

            {

                case (int)CommonDefine.SystemConstructionNoBase.BusinessPeriod:

                    // ?c???

                    int iYear = CommonMotions.BusinessPeriodToConstructionYears(CommonMotions.SystemMasterData.BusinessPeriod);

                    stDate = CommonMotions.cnvDate(string.Format("{0}/{1}",

                                                    iYear,

                                                    CommonMotions.SystemMasterData.BusinessBeginningDate));

                    break;

                case (int)CommonDefine.SystemConstructionNoBase.ConstructionYear:

                    // ?H???N?x

                    stDate = CommonMotions.cnvDate(string.Format("{0}/{1}",

                                                    CommonMotions.SystemMasterData.ConstructionYear,

                                                    CommonMotions.SystemMasterData.ConstructionBeginningDate));

                    break;

            int DataCnt = 1;

            DateTime WorkDate = stDate;

            DateTime EndDate = DateTime.Now;

            for (int i = stDate.Month; i < 13; i++, DataCnt++)

                EndDate = DateTimeUtil.EndOfMonth(WorkDate);

                listMonth.Add(new KeyValuePair<int, String>(CommonMotions.cnvInt(EndDate.ToString("yyyyMM")),

                                                            string.Format("{0, 4}??", i)));

                WorkDate = stDate.AddMonths(DataCnt);

            if (DataCnt < 12)

                for (int i = 1; i < stDate.Month; i++, DataCnt++)

                {

                    EndDate = DateTimeUtil.EndOfMonth(WorkDate);

                    listMonth.Add(new KeyValuePair<int, String>(CommonMotions.cnvInt(EndDate.ToString("yyyyMM")),

                                                                string.Format("{0, 4}??", i)));

                    WorkDate = stDate.AddMonths(DataCnt);

                }

            C2DetailString,

                    strConstrName=string.Empty;

                sql.Append(", A2.OrderersName1");

                sql.Append(", C2.DetailString");

                sql.AppendFormat(" LEFT JOIN constructionbaseinfodetail C2 ON C2.ConstructionCode = C1.ConstructionCode AND C2.DetailNo= {0}",

                                                                { (int)ClsExcute.MaintenanceExecuteNo.SaleSalesGraphData,

[assembly: AssemblyVersion("1.0.0.71")]

[assembly: AssemblyFileVersion("1.0.0.71")]