プロジェクト

全般

プロフィール

リビジョン 192

堀内7年以上前に追加

FrmReqBillingStatus追加
メニュー起動チェック追加
IOクラスStringBuilder化途中

差分を表示:

branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsExcute.cs
472 472
                    int NowPoint = GetNowProcessPoint();
473 473

  
474 474
                    // 起動チェック
475
                    //int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference;
476
                    //if (!ClsSecurityPermission.GetExecutePermission(m_ProcControlPara[NowPoint].ProcNo, ref EditFlg))
477
                    //{
478
                    //    MessageBox.Show("選択された処理の起動権限が設定されていません。", "起動権限確認", MessageBoxButtons.OK, MessageBoxIcon.Stop);
479
                    //    BackProcess();
480
                    //}
475
                    int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference;
476
                    if (!ClsSecurityPermission.GetExecutePermission(m_ProcControlPara[NowPoint].ProcNo, ref EditFlg))
477
                    {
478
                        MessageBox.Show("選択された処理の起動権限が設定されていません。", "起動権限確認", MessageBoxButtons.OK, MessageBoxIcon.Stop);
479
                        BackProcess();
480
                    }
481 481

  
482 482
                    switch (m_ProcControlPara[NowPoint].ProcNo)
483 483
                    {
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialInfo.cs
63 63
        public bool SelectAction(string AddSQLString, ref List<MaterialInfo> data, bool bConnect = true)
64 64
        {
65 65
            // インターフェース
66
            string strcmd = "";
66
            StringBuilder strcmd = new StringBuilder();
67 67
            ArrayList arData = new ArrayList();
68 68

  
69 69
            try
70 70
            {
71 71
                // SQL作成(DateTime型が変換できないのでCharに変換しておく)
72
                strcmd = "SELECT";
73
                strcmd += " MaterialItemCode, MaterialCount, RentCount, DeleteFlg";
74
                strcmd += " ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')";
75
                strcmd += " ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')";
76
                strcmd += " FROM MaterialInfo";
77
                strcmd += AddSQLString;
72
                strcmd.Append("SELECT");
73
                strcmd.Append(" MaterialItemCode, MaterialCount, RentCount, DeleteFlg");
74
                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
75
                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
76
                strcmd.Append(" FROM MaterialInfo");
77
                strcmd.Append(AddSQLString);
78 78

  
79 79
                // SQL実行
80
                if (!ExecuteReader(strcmd, ref arData, bConnect)) return false;
80
                if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
81 81

  
82 82
                // データセット
83 83
                foreach (object[] objwrk in arData)
......
91 91
            }
92 92
            catch (Exception ex)
93 93
            {
94
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
94
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
95 95
                return false;
96 96
            }
97 97

  
......
104 104
        /// <returns>true:成功 false:失敗</returns>
105 105
        public bool InsertAction(List<MaterialInfo> data, bool bConnect = true)
106 106
        {
107
            string strcmd = "";
107
            StringBuilder strcmd = new StringBuilder();
108 108
            try
109 109
            {
110 110

  
111 111
                foreach (MaterialInfo work in data)
112 112
                {
113
                    strcmd = "INSERT INTO MaterialInfo";
113
                    strcmd.Append("INSERT INTO MaterialInfo");
114 114

  
115
                    strcmd += " VALUES (";
115
                    strcmd.Append(" VALUES (");
116 116

  
117
                    strcmd += string.Format("  {0}", work.MaterialItemCode .ToString());
118
                    strcmd += string.Format(", {0}", work.MaterialCount .ToString());
119
                    strcmd += string.Format(", {0}", work.RentCount.ToString());
120
                    strcmd += string.Format(", {0}", work.DeleteFlg.ToString());
117
                    strcmd.AppendFormat("  {0}", work.MaterialItemCode .ToString());
118
                    strcmd.AppendFormat(", {0}", work.MaterialCount .ToString());
119
                    strcmd.AppendFormat(", {0}", work.RentCount.ToString());
120
                    strcmd.AppendFormat(", {0}", work.DeleteFlg.ToString());
121 121

  
122
                    strcmd += ", NOW()";
123
                    strcmd += ", NOW()";
124
                    strcmd += ")";
122
                    strcmd.Append(", NOW()");
123
                    strcmd.Append(", NOW()");
124
                    strcmd.Append(")");
125 125

  
126
                    if (!ExecuteNonQuery(strcmd, bConnect)) return false;
126
                    if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
127 127
                }
128 128
                return true;
129 129
            }
130 130
            catch (Exception ex)
131 131
            {
132
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
132
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
133 133
                return false;
134 134
            }
135 135
        }
......
142 142
        /// <returns>true:成功 false:失敗</returns>
143 143
        public bool UpdateAction(string AddSQLString, MaterialInfo data, bool bConnect = true)
144 144
        {
145
            string strcmd = "";
145
            StringBuilder strcmd = new StringBuilder();
146 146
            try
147 147
            {
148 148

  
149
                strcmd = "UPDATE MaterialInfo";
150
                strcmd += " SET";
149
                strcmd.Append("UPDATE MaterialInfo");
150
                strcmd.Append(" SET");
151 151

  
152
                strcmd += string.Format(" MaterialCount = {0}", data.MaterialCount.ToString());
153
                strcmd += string.Format(",RentCount = {0}", data.RentCount.ToString());
154
                strcmd += string.Format(",DeleteFlg = {0}", data.DeleteFlg.ToString());
152
                strcmd.AppendFormat(" MaterialCount = {0}", data.MaterialCount.ToString());
153
                strcmd.AppendFormat(",RentCount = {0}", data.RentCount.ToString());
154
                strcmd.AppendFormat(",DeleteFlg = {0}", data.DeleteFlg.ToString());
155 155

  
156
                strcmd += ", UpdateDate = NOW()";
157
                strcmd += AddSQLString;
156
                strcmd.Append(", UpdateDate = NOW()");
157
                strcmd.Append(AddSQLString);
158 158

  
159
                if (!ExecuteNonQuery(strcmd, bConnect)) return false;
159
                if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
160 160

  
161 161
                return true;
162 162
            }
163 163
            catch (Exception ex)
164 164
            {
165
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
165
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
166 166
                return false;
167 167
            }
168 168
        }
......
175 175
        public bool DeleteAction(string AddSQLString, bool bConnect = true)
176 176
        {
177 177
            // インターフェース
178
            string strcmd = "";
178
            StringBuilder strcmd = new StringBuilder();
179 179
            try
180 180
            {
181
                strcmd = "Update MaterialInfo Set DeleteFlg = 1";
182
                strcmd += ", UpdateDate = NOW()";
183
                strcmd += AddSQLString;
181
                strcmd.Append("Update MaterialInfo Set DeleteFlg = 1");
182
                strcmd.Append(", UpdateDate = NOW()");
183
                strcmd.Append(AddSQLString);
184 184

  
185
                if (!ExecuteNonQuery(strcmd, bConnect)) return false;
185
                if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
186 186

  
187 187
                return true;
188 188
            }
189 189
            catch (Exception ex)
190 190
            {
191
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
191
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
192 192
                return false;
193 193
            }
194 194
        }
......
231 231
        /// <returns>Where文字列</returns>
232 232
        public string CreatePrimarykeyString(int MaterialItemCode)
233 233
        {
234
            string strWork = string.Empty;
234
            StringBuilder strWork = new StringBuilder();
235 235
            try
236 236
            {
237
                strWork = string.Format(" Where MaterialItemCode = {0}", MaterialItemCode);
237
                strWork.AppendFormat(" Where MaterialItemCode = {0}", MaterialItemCode);
238 238

  
239 239
            }
240 240
            catch (Exception ex)
241 241
            {
242
                logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strWork);
242
                logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strWork.ToString());
243 243
            }
244 244

  
245
            return strWork;
245
            return strWork.ToString();
246 246
        }
247 247

  
248 248

  
......
257 257
        {
258 258

  
259 259
            //インターフェース
260
            string strcmd = "";
260
            StringBuilder strcmd = new StringBuilder();
261 261
            ArrayList arData = new ArrayList();
262 262

  
263 263
            try
264 264
            {
265
                strcmd = string.Format("select * from MaterialInfo where MaterialItemCode = {0} for update;", MaterialItemCode);
265
                strcmd.AppendFormat("select * from MaterialInfo where MaterialItemCode = {0} for update;", MaterialItemCode);
266 266

  
267 267
                // SQL実行
268
                if (!ExecuteReader(strcmd, ref arData, bConnect)) return false;
268
                if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
269 269

  
270 270
                return true;
271 271
            }
272 272
            catch (Exception ex)
273 273
            {
274
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
274
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
275 275
                return false;
276 276
            }
277 277

  
......
288 288
        {
289 289

  
290 290
            //インターフェース
291
            string strcmd = "";
291
            StringBuilder strcmd = new StringBuilder();
292 292
            ArrayList arData = new ArrayList();
293 293

  
294 294
            try
295 295
            {
296
                strcmd = string.Format("select * from MaterialInfo where MaterialItemCode = {0} lock in share mode;", MaterialItemCode);
296
                strcmd.AppendFormat("select * from MaterialInfo where MaterialItemCode = {0} lock in share mode;", MaterialItemCode);
297 297

  
298 298
                // SQL実行
299
                if (!ExecuteReader(strcmd, ref arData, bConnect)) return false;
299
                if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
300 300

  
301 301
                return true;
302 302
            }
303 303
            catch (Exception ex)
304 304
            {
305
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
305
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
306 306
                return false;
307 307
            }
308 308

  
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialItem.cs
70 70
        public bool SelectAction(string AddSQLString, ref List<MaterialItemMaster> data, bool bConnect = true)
71 71
        {
72 72
            // インターフェース
73
            string strcmd = "";
73
            StringBuilder strcmd = new StringBuilder();
74 74
            ArrayList arData = new ArrayList();
75 75

  
76 76
            try
77 77
            {
78 78
                // SQL作成(DateTime型が変換できないのでCharに変換しておく)
79
                strcmd = "SELECT";
80
                strcmd += " MaterialItemCode, MaterialKindCode, MaterialItemName, DisplayOrder, DeleteFlg";
81
                strcmd += " ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')";
82
                strcmd += " ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')";
83
                strcmd += " ,VersionNo";
84
                strcmd += " FROM MaterialItemMaster";
85
                strcmd += AddSQLString;
79
                strcmd.Append("SELECT");
80
                strcmd.Append(" MaterialItemCode, MaterialKindCode, MaterialItemName, DisplayOrder, DeleteFlg");
81
                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
82
                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
83
                strcmd.Append(" ,VersionNo");
84
                strcmd.Append(" FROM MaterialItemMaster");
85
                strcmd.Append(AddSQLString);
86 86

  
87 87
                // SQL実行
88
                if (!ExecuteReader(strcmd, ref arData, bConnect)) return false;
88
                if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
89 89

  
90 90
                // データセット
91 91
                foreach (object[] objwrk in arData)
......
99 99
            }
100 100
            catch (Exception ex)
101 101
            {
102
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
102
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
103 103
                return false;
104 104
            }
105 105

  
......
112 112
        /// <returns>true:成功 false:失敗</returns>
113 113
        public bool InsertAction(List<MaterialItemMaster> data, bool bConnect = true)
114 114
        {
115
            string strcmd = "";
115
            StringBuilder strcmd = new StringBuilder();
116 116
            try
117 117
            {
118 118

  
119 119
                foreach (MaterialItemMaster work in data)
120 120
                {
121
                    strcmd = "INSERT INTO MaterialItemMaster";
121
                    strcmd.Append("INSERT INTO MaterialItemMaster");
122 122

  
123
                    strcmd += " VALUES (";
123
                    strcmd.Append(" VALUES (");
124 124

  
125
                    strcmd += string.Format("  {0}", work.MaterialItemCode.ToString());
126
                    strcmd += string.Format(", {0}", work.MaterialKindCode.ToString());
127
                    strcmd += string.Format(", '{0}'", work.MaterialItemName);
128
                    strcmd += string.Format(", {0}", work.DisplayOrder.ToString());
129
                    strcmd += string.Format(", {0}", work.DeleteFlg.ToString());
125
                    strcmd.AppendFormat("  {0}", work.MaterialItemCode.ToString());
126
                    strcmd.AppendFormat(", {0}", work.MaterialKindCode.ToString());
127
                    strcmd.AppendFormat(", '{0}'", work.MaterialItemName);
128
                    strcmd.AppendFormat(", {0}", work.DisplayOrder.ToString());
129
                    strcmd.AppendFormat(", {0}", work.DeleteFlg.ToString());
130 130

  
131
                    strcmd += ", NOW()";
132
                    strcmd += ", NOW()";
133
                    strcmd += ", 0";
134
                    strcmd += ")";
131
                    strcmd.Append(", NOW()");
132
                    strcmd.Append(", NOW()");
133
                    strcmd.Append(", 0");
134
                    strcmd.Append(")");
135 135

  
136
                    if (!ExecuteNonQuery(strcmd, bConnect)) return false;
136
                    if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
137 137
                }
138 138
                return true;
139 139
            }
140 140
            catch (Exception ex)
141 141
            {
142
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
142
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
143 143
                return false;
144 144
            }
145 145
        }
......
152 152
        /// <returns>true:成功 false:失敗</returns>
153 153
        public bool UpdateAction(string AddSQLString, MaterialItemMaster data, bool bConnect = true)
154 154
        {
155
            string strcmd = "";
155
            StringBuilder strcmd = new StringBuilder();
156 156
            try
157 157
            {
158 158

  
159
                strcmd = "UPDATE MaterialItemMaster";
159
                strcmd.Append("UPDATE MaterialItemMaster");
160 160

  
161
                strcmd += " SET";
161
                strcmd.Append(" SET");
162 162

  
163
                strcmd += string.Format(" MaterialItemCode = {0}", data.MaterialItemCode.ToString());
164
                strcmd += string.Format(",MaterialKindCode = {0}", data.MaterialKindCode.ToString());
165
                strcmd += string.Format(",MaterialItemName = '{0}'", data.MaterialItemName);
166
                strcmd += string.Format(",DisplayOrder = {0}", data.DisplayOrder.ToString());
167
                strcmd += string.Format(",DeleteFlg = {0}", data.DeleteFlg.ToString());
168
                strcmd += ", UpdateDate = NOW()";
169
                strcmd += string.Format(", VersionNo = if(VersionNo = {0}, 0, VersionNo + 1) ", IOMaterialItem.MAX_VERSION);
163
                strcmd.AppendFormat(" MaterialItemCode = {0}", data.MaterialItemCode.ToString());
164
                strcmd.AppendFormat(",MaterialKindCode = {0}", data.MaterialKindCode.ToString());
165
                strcmd.AppendFormat(",MaterialItemName = '{0}'", data.MaterialItemName);
166
                strcmd.AppendFormat(",DisplayOrder = {0}", data.DisplayOrder.ToString());
167
                strcmd.AppendFormat(",DeleteFlg = {0}", data.DeleteFlg.ToString());
168
                strcmd.Append(", UpdateDate = NOW()");
169
                strcmd.AppendFormat(", VersionNo = if(VersionNo = {0}, 0, VersionNo + 1) ", IOMaterialItem.MAX_VERSION);
170 170

  
171
                strcmd += AddSQLString;
171
                strcmd.Append(AddSQLString);
172 172

  
173
                if (!ExecuteNonQuery(strcmd, bConnect)) return false;
173
                if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
174 174

  
175 175
                return true;
176 176
            }
......
189 189
        /// <returns>true:成功 false:失敗</returns>
190 190
        public bool UpdateVersionAction(string AddSQLString, MaterialItemMaster data, bool bConnect = true)
191 191
        {
192
            string strcmd = "";
192
            StringBuilder strcmd = new StringBuilder();
193 193
            try
194 194
            {
195 195

  
196
                strcmd = "UPDATE MaterialItemMaster";
196
                strcmd.Append("UPDATE MaterialItemMaster");
197 197

  
198
                strcmd += " SET";
198
                strcmd.Append(" SET");
199 199

  
200
                strcmd += string.Format(" MaterialItemCode = {0}", data.MaterialItemCode.ToString());
201
                strcmd += string.Format(",MaterialKindCode = {0}", data.MaterialKindCode.ToString());
202
                strcmd += string.Format(",MaterialItemName = '{0}'", data.MaterialItemName);
203
                strcmd += string.Format(",DisplayOrder = {0}", data.DisplayOrder.ToString());
204
                strcmd += string.Format(",DeleteFlg = {0}", data.DeleteFlg.ToString());
205
                strcmd += ", UpdateDate = NOW()";
206
                strcmd += string.Format(", VersionNo = if(VersionNo = {0}, 0, VersionNo + 1) ", IOMaterialItem.MAX_VERSION);
200
                strcmd.AppendFormat(" MaterialItemCode = {0}", data.MaterialItemCode.ToString());
201
                strcmd.AppendFormat(",MaterialKindCode = {0}", data.MaterialKindCode.ToString());
202
                strcmd.AppendFormat(",MaterialItemName = '{0}'", data.MaterialItemName);
203
                strcmd.AppendFormat(",DisplayOrder = {0}", data.DisplayOrder.ToString());
204
                strcmd.AppendFormat(",DeleteFlg = {0}", data.DeleteFlg.ToString());
205
                strcmd.Append(", UpdateDate = NOW()");
206
                strcmd.AppendFormat(", VersionNo = if(VersionNo = {0}, 0, VersionNo + 1) ", IOMaterialItem.MAX_VERSION);
207 207

  
208
                strcmd += AddSQLString;
208
                strcmd.Append(AddSQLString);
209 209

  
210
                if (!ExecuteNonQuery(strcmd, bConnect)) return false;
210
                if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
211 211

  
212 212
                return true;
213 213
            }
214 214
            catch (Exception ex)
215 215
            {
216
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
216
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
217 217
                return false;
218 218
            }
219 219
        }
......
227 227
        public bool DeleteAction(string AddSQLString, bool bConnect = true)
228 228
        {
229 229
            // インターフェース
230
            string strcmd = "";
230
            StringBuilder strcmd = new StringBuilder();
231 231
            try
232 232
            {
233
                strcmd = "Update MaterialItemMaster Set DeleteFlg = 1, DisplayOrder = 999";
234
                strcmd += ", UpdateDate = NOW()";
235
                strcmd += string.Format(", VersionNo = if(VersionNo = {0}, 0, VersionNo + 1) ", IOMaterialItem.MAX_VERSION);
233
                strcmd.Append("Update MaterialItemMaster Set DeleteFlg = 1, DisplayOrder = 999");
234
                strcmd.Append(", UpdateDate = NOW()");
235
                strcmd.AppendFormat(", VersionNo = if(VersionNo = {0}, 0, VersionNo + 1) ", IOMaterialItem.MAX_VERSION);
236 236

  
237
                strcmd += AddSQLString;
237
                strcmd.Append(AddSQLString);
238 238

  
239
                if (!ExecuteNonQuery(strcmd, bConnect)) return false;
239
                if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
240 240

  
241 241
                return true;
242 242
            }
243 243
            catch (Exception ex)
244 244
            {
245
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
245
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
246 246
                return false;
247 247
            }
248 248
        }
......
289 289
        /// <returns>Where文字列</returns>
290 290
        public string CreatePrimarykeyString(int MaterialItemCode)
291 291
        {
292
            string strWork = string.Empty;
292
            StringBuilder strWork = new StringBuilder();
293 293
            try
294 294
            {
295
                strWork = string.Format(" Where MaterialItemCode = {0}", MaterialItemCode);
295
                strWork.AppendFormat(" Where MaterialItemCode = {0}", MaterialItemCode);
296 296

  
297 297
            }
298 298
            catch (Exception ex)
299 299
            {
300
                logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strWork);
300
                logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strWork.ToString());
301 301
            }
302 302

  
303
            return strWork;
303
            return strWork.ToString();
304 304
        }
305 305

  
306 306
        /// <summary>
......
312 312
        public int SelectMaxMaterialItemKeyCount(string AddSQLString, bool bConnect = true)
313 313
        {
314 314
            // インターフェース
315
            string strcmd = "";
315
            StringBuilder strcmd = new StringBuilder();
316 316
            ArrayList arData = new ArrayList();
317 317
            int iRet = 0;
318 318
            try
319 319
            {
320 320
                // SQL作成
321
                strcmd = "SELECT IFNULL(MAX(MaterialItemCode), 0) FROM MaterialItemMaster" + AddSQLString;
321
                strcmd.AppendFormat("SELECT IFNULL(MAX(MaterialItemCode), 0) FROM MaterialItemMaster{0}", AddSQLString);
322 322

  
323 323
                // SQL実行
324
                if (!ExecuteReader(strcmd, ref arData, bConnect)) return iRet;
324
                if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return iRet;
325 325

  
326 326
                // データセット
327 327
                foreach (object[] objwrk in arData)
......
334 334
            }
335 335
            catch (Exception ex)
336 336
            {
337
                logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
337
                logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
338 338
            }
339 339

  
340 340
            return iRet;
......
348 348
        /// <returns></returns>
349 349
        public int SelectkindItemCount(int MaterialKindCode, bool bConnect = true)
350 350
        {
351
            string strcmd = "";
351
            StringBuilder strcmd = new StringBuilder();
352 352
            ArrayList arData = new ArrayList();
353 353
            int iRet = 0;
354 354
            try
355 355
            {
356 356
                // SQL作成
357
                strcmd = string.Format("SELECT COUNT(*) FROM MaterialItemMaster where MaterialKindCode = {0} and Deleteflg = 0" , MaterialKindCode);
357
                strcmd.AppendFormat("SELECT COUNT(*) FROM MaterialItemMaster where MaterialKindCode = {0} and Deleteflg = 0" , MaterialKindCode);
358 358

  
359 359
                // SQL実行
360
                if (!ExecuteReader(strcmd, ref arData, bConnect)) return iRet;
360
                if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return iRet;
361 361

  
362 362
                // データセット
363 363
                iRet = int.Parse((((object[])arData[0])[0]).ToString());
......
365 365
            }
366 366
            catch (Exception ex)
367 367
            {
368
                logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
368
                logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
369 369
            }
370 370

  
371 371
            return iRet;
......
379 379
        public bool SetTimeOut(int time, bool bConnect = true)
380 380
        {
381 381
            //インターフェース
382
            string strcmd = "";
382
            StringBuilder strcmd = new StringBuilder();
383 383
            try
384 384
            {
385
                strcmd = string.Format("set innodb_lock_wait_timeout = {0};", time);
385
                strcmd.AppendFormat("set innodb_lock_wait_timeout = {0};", time);
386 386

  
387
                if (!ExecuteNonQuery(strcmd, bConnect)) return false;
387
                if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
388 388

  
389 389
                return true;
390 390
            }
391 391
            catch (Exception ex)
392 392
            {
393
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
393
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
394 394
                return false;
395 395
            }
396 396

  
......
406 406
        {
407 407

  
408 408
            //インターフェース
409
            string strcmd = "";
409
            StringBuilder strcmd = new StringBuilder();
410 410
            ArrayList arData = new ArrayList();
411 411

  
412 412
            try
413 413
            {
414
                strcmd = string.Format("select * from MaterialItemMaster  where MaterialItemCode = {0} for update;", MaterialItemCode);
414
                strcmd.AppendFormat("select * from MaterialItemMaster  where MaterialItemCode = {0} for update;", MaterialItemCode);
415 415

  
416 416
                // SQL実行
417
                if (!ExecuteReader(strcmd, ref arData, bConnect)) return false;
417
                if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
418 418

  
419 419
                return true;
420 420
            }
421 421
            catch (Exception ex)
422 422
            {
423
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
423
                logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
424 424
                return false;
425 425
            }
426 426

  
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedger/FrmConstructionLedgerAuxiliary.cs
2671 2671
        /// 工事詳細台帳よりデータを取得する
2672 2672
        /// </summary>
2673 2673
        /// <returns></returns>
2674
        private void CreateGetDataSQL(ref StringBuilder strcmd)
2675
        {
2676
            try
2677
            {
2678
                // 工事詳細台帳明細データを読み込む
2679
                strcmd.Append("SELECT");
2680
                strcmd.Append("  A.ConstructionCode");	        // 工事コード
2681
                strcmd.Append(", A.GroupCount");               // グループ番号
2682
                strcmd.Append(", A.LineCount");                // 行番号
2683
                strcmd.Append(", A.ComponentCode");            // 構成キー
2684
                strcmd.Append(", A.ItemCode");		            // 工種キー
2685
                strcmd.Append(", A.FirstString");              // 項目名称
2686
                strcmd.Append(", A.SecondString");             // 工事内容
2687
                strcmd.Append(", A.CompanyType");              // 協力会社コードタイプ
2688
                strcmd.Append(", A.CompanyCode");              // 協力会社コード
2689
                strcmd.Append(", A.CompanyName");              // 協力会社名称
2690
                strcmd.Append(", A.EstimatePrice");            // 予算(見積)金額
2691
                strcmd.Append(", A.ExecutionAmount");          // 実行金額
2692
                strcmd.Append(", A.AmountConfigRate");         // 金額構成率
2693
                strcmd.Append(", A.PaymentBurden");            // 支払補填額
2694
                strcmd.Append(", A.FixDataFlg");               // 固定データフラグ
2695
                strcmd.Append(", A.IndependentFlg");           // 独立データフラグ
2696
                strcmd.Append(", A.FluctuationFlg");           // 増減データフラグ
2697
                strcmd.Append(", A.SalaryFlg");                // 給与振分区分
2698
                strcmd.Append(", A.SalaryDays");               // 給与振分日数
2699
                strcmd.Append(", A.OperatingFlg");             // 担当中フラグ
2700
                strcmd.Append(", A.SourceCode");               // 元工事番号
2701
                strcmd.Append(", A.JoinTitleFlg");             // 工事名称タイトル
2702
                strcmd.Append(", A.SalaryOnRegist");           // 登録時月額給与
2703
                strcmd.Append(", A.PurchaseOrderFlg");         // 注文書発行フラグ
2704
                strcmd.Append(", DATE_FORMAT(A.EntryDate, '%Y/%m/%d %H:%i:%s')");
2705
                strcmd.Append(", DATE_FORMAT(A.UpdateDate, '%Y/%m/%d %H:%i:%s')");
2706

  
2707
                strcmd.Append(", B.TARGETMONTH, B.PAYMENTAMOUNT");
2708
                strcmd.Append(" FROM CONSTRUCTIONLEDGERDETAIL AS A");
2709
                strcmd.Append(" LEFT JOIN CONSTRUCTIONLEDGEREXCUTE AS B");
2710
                strcmd.Append(" ON B.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE");
2711
                strcmd.Append(" AND B.GROUPCOUNT = A.GROUPCOUNT");
2712
                strcmd.Append(" AND B.LINECOUNT = A.LINECOUNT");
2713
                strcmd.AppendFormat(" WHERE A.CONSTRUCTIONCODE = {0}", m_ConstructionCode);
2714
                strcmd.Append(" ORDER BY A.GROUPCOUNT ASC, A.LINECOUNT ASC, B.COLUMNCOUNT ASC");
2715

  
2716
            }
2717
            catch (Exception ex)
2718
            {
2719
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
2720
            }
2721
        }
2722

  
2723
        #endregion
2724
        #region 工事詳細台帳よりデータを取得する
2725
        /// <summary>
2726
        /// 工事詳細台帳よりデータを取得する
2727
        /// </summary>
2728
        /// <returns></returns>
2674 2729
        private bool InitDispData()
2675 2730
        {
2676 2731
            IOConstructionLedger LedgerDB = new IOConstructionLedger();
......
2679 2734
            try
2680 2735
            {
2681 2736
                // 工事詳細台帳データを読み込む
2682
                string strSQL = LedgerDB.CreatePrimarykeyString(m_ConstructionCode);
2737
                StringBuilder strSQL = new StringBuilder();
2738
                strSQL.Append(LedgerDB.CreatePrimarykeyString(m_ConstructionCode));
2683 2739
                ConstructionLedger LedgerRec = new ConstructionLedger();
2684
                if (!LedgerDB.SelectAction(strSQL, ref LedgerRec)) return false;
2740
                if (!LedgerDB.SelectAction(strSQL.ToString(), ref LedgerRec)) return false;
2685 2741

  
2686
                // 工事詳細台帳明細データを読み込む
2687
                strSQL = "SELECT";
2688
                strSQL += "  A.ConstructionCode";	        // 工事コード
2689
                strSQL += ", A.GroupCount";               // グループ番号
2690
                strSQL += ", A.LineCount";                // 行番号
2691
                strSQL += ", A.ComponentCode";            // 構成キー
2692
                strSQL += ", A.ItemCode";		            // 工種キー
2693
                strSQL += ", A.FirstString";              // 項目名称
2694
                strSQL += ", A.SecondString";             // 工事内容
2695
                strSQL += ", A.CompanyType";              // 協力会社コードタイプ
2696
                strSQL += ", A.CompanyCode";              // 協力会社コード
2697
                strSQL += ", A.CompanyName";              // 協力会社名称
2698
                strSQL += ", A.EstimatePrice";            // 予算(見積)金額
2699
                strSQL += ", A.ExecutionAmount";          // 実行金額
2700
                strSQL += ", A.AmountConfigRate";         // 金額構成率
2701
                strSQL += ", A.PaymentBurden";            // 支払補填額
2702
                strSQL += ", A.FixDataFlg";               // 固定データフラグ
2703
                strSQL += ", A.IndependentFlg";           // 独立データフラグ
2704
                strSQL += ", A.FluctuationFlg";           // 増減データフラグ
2705
                strSQL += ", A.SalaryFlg";                // 給与振分区分
2706
                strSQL += ", A.SalaryDays";               // 給与振分日数
2707
                strSQL += ", A.OperatingFlg";             // 担当中フラグ
2708
                strSQL += ", A.SourceCode";               // 元工事番号
2709
                strSQL += ", A.JoinTitleFlg";             // 工事名称タイトル
2710
                strSQL += ", A.SalaryOnRegist";           // 登録時月額給与
2711
                strSQL += ", A.PurchaseOrderFlg";         // 注文書発行フラグ
2712
                strSQL += ", DATE_FORMAT(A.EntryDate, '%Y/%m/%d %H:%i:%s')";
2713
                strSQL += ", DATE_FORMAT(A.UpdateDate, '%Y/%m/%d %H:%i:%s')";
2714

  
2715
                strSQL += ", B.TARGETMONTH, B.PAYMENTAMOUNT";
2716
                strSQL += " FROM CONSTRUCTIONLEDGERDETAIL AS A";
2717
                strSQL += " LEFT JOIN CONSTRUCTIONLEDGEREXCUTE AS B";
2718
                strSQL += " ON B.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE";
2719
                strSQL += " AND B.GROUPCOUNT = A.GROUPCOUNT";
2720
                strSQL += " AND B.LINECOUNT = A.LINECOUNT";
2721
                strSQL += string.Format(" WHERE A.CONSTRUCTIONCODE = {0}", m_ConstructionCode);
2722
                strSQL += " ORDER BY A.GROUPCOUNT ASC, A.LINECOUNT ASC, B.COLUMNCOUNT ASC";
2723

  
2742
                strSQL.Clear();
2743
                CreateGetDataSQL(ref strSQL);
2724 2744
                ArrayList DetailList = new ArrayList();
2725
                if (!DetailDB.ExecuteReader(strSQL, ref DetailList)) return false;
2745
                if (!DetailDB.ExecuteReader(strSQL.ToString(), ref DetailList)) return false;
2726 2746
                if (DetailList.Count == 0) return false;
2727 2747

  
2728 2748
                // 工事予算書の承認を確認する
......
2945 2965
                            // 一般ユーザーは行ロック
2946 2966
                            if (!CheckLeaderOrUser()) dgv.Rows[dgv.RowCount - 1].ReadOnly = true;
2947 2967
                            break;
2968
                        case (int)DataGroup.TransportationCosts:    // 3:交通費(通行料・電車代)
2969
                        case (int)DataGroup.PurchaseCosts:          // 4:購入品
2970
                        case (int)DataGroup.VehicleLeaseFee:        // 5:車両リース代
2971
                        case (int)DataGroup.ParkingCosts:           // 6:駐車場・資材置き場
2972
                        case (int)DataGroup.RoomChargeCosts:        // 7:宿泊費
2973
                        case (int)DataGroup.DisposeCosts:           // 8:処分費等
2974
                            dgv.Rows[dgv.RowCount - 1].ReadOnly = true;
2975
                            break;
2948 2976
                        default:
2949 2977
                            break;
2950 2978
                    }
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ReqbillingStatus/FrmReqBillingStatus.cs
1
using System;
2
using System.Collections.Generic;
3
using System.ComponentModel;
4
using System.Data;
5
using System.Drawing;
6
using System.Text;
7
using System.Windows.Forms;
8
using System.Collections;
9

  
10
using log4net;
11
using log4net.Appender;
12
using log4net.Repository.Hierarchy;
13

  
14
using ProcessManagement.Common;
15
using ProcessManagement.DB.IOAccess;
16
using ProcessManagement.DataModel;
17
using ProcessManagement.DB.Core;
18
using ProcessManagement.Forms.CustomControls;
19
using ProcessManagement.Forms.ControlsAction;
20
//*---------------------------- ???????? ----------------------------------*
21
//  2017/06/07  Ver1.0.0.0      Create Source           
22
//
23
//
24
//
25
//*----------------------------------------------------------------------------*
26
namespace ProcessManagement.Forms.DataEntry
27
{
28
    public partial class FrmReqBillingStatus : Form
29
    {
30
        #region ?g?p??`
31
        //log4net???O???g?p????
32
        private static readonly log4net.ILog logger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
33
        #endregion
34

  
35
        #region ??
36
        /// <summary>
37
        /// ?\???J????
38
        /// </summary>
39
        private enum DispColumn
40
        {
41
            No = 0,
42
            ConstructionDepartment,
43
            ConstructionPerson,
44
            ConstructionName,
45
            PrintOut,
46
            Status,
47
            ConstructionCode,
48
            PrintOutDate,
49
            MailingDate,
50
            ReturnDate,
51
            ReturnCheckDate,
52
            OrderNo,
53
        }
54

  
55
        #endregion
56

  
57
        #region ???
58
        /// <summary>
59
        /// ?t?B?[???h?l????t???O
60
        /// </summary>
61
        //private bool m_bChengeAns = false;
62

  
63
        /// <summary>
64
        /// ???????t???O
65
        /// </summary>
66
        private bool m_initDataLoad = true;
67

  
68
        /// <summary>
69
        /// ??????????f?[?^?J?E???g
70
        /// </summary>
71
        private int m_initDataCount = 0;
72

  
73
        /// <summary>
74
        /// ?N???t???O
75
        /// </summary>
76
        private int m_ExecuteFlg = 0;
77

  
78
        /// <summary>
79
        /// ?f?[?^????{?^???\???t???O
80
        /// </summary>
81
        private bool m_DataAddtionButton = false;
82
        /// <summary>
83
        /// ?I???{?^???????t???O
84
        /// </summary>
85
        private bool m_CloseingProcessOff = false;
86

  
87
        /// <summary>
88
        /// Cell???T?C?Y
89
        /// </summary>
90
        private int[] m_CellSize;
91

  
92
        #region ?t?H?[????
93
        /// <summary>
94
        /// ?t?H?[????
95
        /// </summary>
96
        private int m_FormWidthSize = 0;
97
        #endregion
98

  
99
        #region ?O???b?h???T?C?Y
100
        /// <summary>
101
        /// ?O???b?h???T?C?Y
102
        /// </summary>
103
        private int m_GridWidthSize = 0;
104
        #endregion
105
        #endregion
106

  
107
        #region ?v???p?e?B
108
        /// <summary>
109
        /// ?N???t???O
110
        /// </summary>
111
        public int ExecuteFlg
112
        {
113
            get { return m_ExecuteFlg; }
114
            set { m_ExecuteFlg = value; }
115
        }
116
        /// <summary>
117
        /// ?f?[?^????{?^???\??
118
        /// </summary>
119
        public bool DataAddtionButton
120
        {
121
            get { return m_DataAddtionButton; }
122
            set { m_DataAddtionButton = value; }
123
        }
124
        #endregion
125

  
126
        #region ?R???X?g???N?^
127
        public FrmReqBillingStatus()
128
        {
129
            InitializeComponent();
130
        }
131
        #endregion
132
        #region ?f?X?g???N?^
133
        ~FrmReqBillingStatus()
134
        {
135
            try
136
            {
137
                GC.Collect();
138
            }
139
            catch (Exception ex)
140
            {
141
                logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);
142
            }
143
        }
144
        #endregion
145

  
146
        #region ?~?{?^??
147
        /// <summary>
148
        /// ?~?{?^??????????
149
        /// </summary>
150
        /// <param name="sender"></param>
151
        /// <param name="e"></param>
152
        private void FrmReqPayStatus_FormClosing(object sender, FormClosingEventArgs e)
153
        {
154
            if (m_CloseingProcessOff) return;
155

  
156
            // ?O?v???Z?X????
157
            ClsExcute.BackProcess();
158
        }
159
        #endregion
160

  
161
        #region ?I???{?^??
162
        /// <summary>
163
        /// ?I???{?^???N???b?N
164
        /// </summary>
165
        /// <param name="sender"></param>
166
        /// <param name="e"></param>
167
        private void btnEnd_Click(object sender, EventArgs e)
168
        {
169
            m_CloseingProcessOff = false;
170
            
171
            this.Close();
172
        }
173
        #endregion
174

  
175
        #region ?X?V?{?^??
176
        /// <summary>
177
        /// ?f?[?^?X?V?{?^??????
178
        /// </summary>
179
        /// <param name="sender"></param>
180
        /// <param name="e"></param>
181
        private void btnDataUpDate_Click(object sender, EventArgs e)
182
        {
183
            if (m_initDataLoad) return;
184
            // ?\???f?[?^?X?V
185
            DataDisplay();
186
        }
187
        #endregion
188

  
189
        #region ?t?H?[?????[?h
190
        /// <summary>
191
        /// ?????t?H?[?????[?h
192
        /// </summary>
193
        /// <param name="sender"></param>
194
        /// <param name="e"></param>
195
        private void FrmConstructionBaseInfoList_Load(object sender, EventArgs e)
196
        {
197
            SetInitnumUDConstPro();
198
            // ?R???{?{?b?N?X?Z?b?g
199
            SetcmbDepartment();
200
            SetcmbPersons();
201

  
202
            // ?R???{?{?b?N?X?????\??
203
            InitCombBox();
204

  
205
            // ?\???X?^?C?????X
206
            InitDisplayStyle();
207

  
208
            // ???O?C?????Z?b?g
209
            InitDepPersonCode();
210

  
211
            // ?????\??
212
            InitDataLoad();
213

  
214
            m_initDataLoad = false;
215
        }
216
        #endregion
217

  
218
        #region ?Z???_?u???N???b?N
219
        /// <summary>
220
        /// ?Z???_?u???N???b?N
221
        /// </summary>
222
        /// <param name="sender"></param>
223
        /// <param name="e"></param>
224
        private void dgvMaster_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
225
        {
226
            if (e.RowIndex < 0) return;
227
            // ?f?[?^??????????????
228
            if (dgvMaster.RowCount == 0) return;
229
            if (CommonMotions.chkCellBlank(dgvMaster.CurrentRow.Cells[(int)DispColumn.ConstructionName].Value)) return;
230

  
231
            // ?e?????N??
232
            SubProcessExecute(CommonMotions.cnvIntFromStringCode(dgvMaster.CurrentRow.Cells[(int)DispColumn.ConstructionCode].Value.ToString(), "-"));
233
        }
234
        #endregion
235

  
236
        #region ?t?H?[??KeyDown
237
        /// <summary>
238
        /// Entry?L?[?????????
239
        /// </summary>
240
        /// <param name="sender"></param>
241
        /// <param name="e"></param>
242
        private void FrmConstructionBaseInfoList_KeyDown(object sender, KeyEventArgs e)
243
        {
244
            //Enter?L?[?????????????m?F
245
            //Alt??Ctrl?L?[?????????????????????
246
            if ((e.KeyCode == Keys.Enter) && !e.Alt && !e.Control)
247
            {
248
                //????????Tab?L?[??????????????????
249
                //Shift??????????????O??R???g???[????t?H?[?J?X?????
250
                this.ProcessTabKey(!e.Shift);
251

  
252
                e.Handled = true;
253
                //.NET Framework 2.0??~
254
                e.SuppressKeyPress = true;
255
            }
256
        }
257
        #endregion
258

  
259
        #region ?f?[?^?R?s?[
260
        /// <summary>
261
        /// ?f?[?^?R?s?[?@?\
262
        /// </summary>
263
        /// <param name="sender"></param>
264
        /// <param name="e"></param>
265
        private void btnDataCopy_Click(object sender, EventArgs e)
266
        {
267
            // ???N???v???Z?X?Z?b?g
268
            int NowPoint = ClsExcute.NextProcess((int)ClsExcute.ProcessExecuteNo.ConstructionCopyList);
269
            // ?????H????
270
            ClsExcute.ProcControlPara[NowPoint].IntExecParameter.Add(0);
271

  
272
            // ?N???[?Y??????OFF?????B
273
            m_CloseingProcessOff = true;
274
            // ???N???[?Y
275
            this.Close();
276
        }
277
        #endregion
278

  
279
        #region ?c????R???{?{?b?N?X??X
280
        /// <summary>
281
        /// ?c?????X
282
        /// </summary>
283
        /// <param name="sender"></param>
284
        /// <param name="e"></param>
285
        private void numUDConstPro_ValueChanged(object sender, EventArgs e)
286
        {
287
            if (m_initDataLoad) return;
288

  
289
            // ?R???{?{?b?N?X?Z?b?g
290
            int DepCode = CommonMotions.cnvInt(cmbDepartment.SelectedValue);
291
            int PerCode = CommonMotions.cnvInt(cmbConstructionPerson.SelectedValue);
292
            SetcmbDepartment();
293
            SetcmbPersons();
294
            cmbDepartment.SelectedValue = DepCode;
295
            cmbConstructionPerson.SelectedValue = PerCode;
296

  
297
            // ?f?[?^?\??
298
            DataDisplay();
299
        }
300
        #endregion
301

  
302
        #region ?????R???{?{?b?N?X??X
303
        /// <summary>
304
        /// ?????R???{?{?b?N?X??X
305
        /// </summary>
306
        /// <param name="sender"></param>
307
        /// <param name="e"></param>
308
        private void cmbDepartment_TextChanged(object sender, EventArgs e)
309
        {
310
            if (m_initDataLoad) return;
311

  
312
            // ?S????R???{?{?b?N?X??X
313
            SetcmbPersons();
314

  
315
            // ?f?[?^?\??
316
            DataDisplay();
317
        }
318
        #endregion
319

  
320
        #region ?S????R???{?{?b?N?X??X
321
        /// <summary>
322
        /// ?S?????X
323
        /// </summary>
324
        /// <param name="sender"></param>
325
        /// <param name="e"></param>
326
        private void cmbConstructionPerson_TextChanged(object sender, EventArgs e)
327
        {
328
            if (m_initDataLoad) return;
329

  
330
            // ?S????I?????????I????????
331
            SetPerosonToDepartment();
332

  
333
            // ?f?[?^?\??
334
            DataDisplay();
335
        }
336
        #endregion
337

  
338
        #region ?t?H?[???T?C?Y??X
339
        /// <summary>
340
        /// ?t?H?[???T?C?Y??X
341
        /// </summary>
342
        /// <param name="sender"></param>
343
        /// <param name="e"></param>
344
        private void FrmReqPayStatus_SizeChanged(object sender, EventArgs e)
345
        {
346
            if (this.WindowState == FormWindowState.Minimized)
347
            {
348
                // ?????
349
            }
350
            else if (this.WindowState == FormWindowState.Maximized)
351
            {
352
                // ???
353
                CellSizeChangesWhenChangingScreenSize(false);
354
            }
355
            else if (this.WindowState == FormWindowState.Normal)
356
            {
357
                // ?W????
358
                CellSizeChangesWhenChangingScreenSize(true);
359
            }
360
        }
361
        #endregion
362

  
363
        #region ?c??E?H???S????????
364
        /// <summary>
365
        /// ?c??E?H???S????????
366
        /// </summary>
367
        /// <param name="sender"></param>
368
        /// <param name="e"></param>
369
        private void radioButton_CheckedChanged(object sender, EventArgs e)
370
        {
371
            if (m_initDataLoad) return;
372

  
373
            // ?f?[?^?\??
374
            DataDisplay();
375
        }
376
        #endregion
377
    }
378
}
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ReqbillingStatus/FrmReqBillingStatus.designer.cs
1
namespace ProcessManagement.Forms.DataEntry
2
{
3
    partial class FrmReqBillingStatus
4
    {
5
        /// <summary>
6
        /// 必要なデザイナ変数です。
7
        /// </summary>
8
        private System.ComponentModel.IContainer components = null;
9

  
10
        /// <summary>
11
        /// 使用中のリソースをすべてクリーンアップします。
12
        /// </summary>
13
        /// <param name="disposing">マネージ リソースが破棄される場合 true、破棄されない場合は false です。</param>
14
        protected override void Dispose(bool disposing)
15
        {
16
            if (disposing && (components != null))
17
            {
18
                components.Dispose();
19
            }
20
            base.Dispose(disposing);
21
        }
22

  
23
        #region Windows フォーム デザイナで生成されたコード
24

  
25
        /// <summary>
26
        /// デザイナ サポートに必要なメソッドです。このメソッドの内容を
27
        /// コード エディタで変更しないでください。
28
        /// </summary>
29
        private void InitializeComponent()
30
        {
31
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
32
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle();
33
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle12 = new System.Windows.Forms.DataGridViewCellStyle();
34
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();
35
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle();
36
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle();
37
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle();
38
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle();
39
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle8 = new System.Windows.Forms.DataGridViewCellStyle();
40
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle9 = new System.Windows.Forms.DataGridViewCellStyle();
41
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle10 = new System.Windows.Forms.DataGridViewCellStyle();
42
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle11 = new System.Windows.Forms.DataGridViewCellStyle();
43
            this.btnEnd = new System.Windows.Forms.Button();
44
            this.label1 = new System.Windows.Forms.Label();
45
            this.groupBox1 = new System.Windows.Forms.GroupBox();
46
            this.label3 = new System.Windows.Forms.Label();
47
            this.radioButton2 = new System.Windows.Forms.RadioButton();
48
            this.radioButton1 = new System.Windows.Forms.RadioButton();
49
            this.label4 = new System.Windows.Forms.Label();
50
            this.numUDConstPro = new System.Windows.Forms.NumericUpDown();
51
            this.label5 = new System.Windows.Forms.Label();
52
            this.label7 = new System.Windows.Forms.Label();
53
            this.cmbConstructionPerson = new System.Windows.Forms.ComboBox();
54
            this.cmbDepartment = new System.Windows.Forms.ComboBox();
55
            this.label2 = new System.Windows.Forms.Label();
56
            this.btnDataUpDate = new System.Windows.Forms.Button();
57
            this.dgvMaster = new ProcessManagement.Forms.CustomControls.DataGridViewEX();
58
            this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
59
            this.Column10 = new System.Windows.Forms.DataGridViewTextBoxColumn();
60
            this.Column6 = new System.Windows.Forms.DataGridViewTextBoxColumn();
61
            this.Column4 = new System.Windows.Forms.DataGridViewTextBoxColumn();
62
            this.Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
63
            this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
64
            this.Column9 = new System.Windows.Forms.DataGridViewTextBoxColumn();
65
            this.Column8 = new System.Windows.Forms.DataGridViewTextBoxColumn();
66
            this.Column5 = new System.Windows.Forms.DataGridViewTextBoxColumn();
67
            this.Column13 = new System.Windows.Forms.DataGridViewTextBoxColumn();
68
            this.groupBox1.SuspendLayout();
69
            ((System.ComponentModel.ISupportInitialize)(this.numUDConstPro)).BeginInit();
70
            ((System.ComponentModel.ISupportInitialize)(this.dgvMaster)).BeginInit();
71
            this.SuspendLayout();
72
            // 
73
            // btnEnd
74
            // 
75
            this.btnEnd.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));
76
            this.btnEnd.BackColor = System.Drawing.Color.Blue;
77
            this.btnEnd.ForeColor = System.Drawing.Color.White;
78
            this.btnEnd.Location = new System.Drawing.Point(1150, 619);
79
            this.btnEnd.Name = "btnEnd";
80
            this.btnEnd.Size = new System.Drawing.Size(120, 30);
81
            this.btnEnd.TabIndex = 8;
82
            this.btnEnd.Text = "終 了";
83
            this.btnEnd.UseVisualStyleBackColor = false;
84
            this.btnEnd.Click += new System.EventHandler(this.btnEnd_Click);
85
            // 
86
            // label1
87
            // 
88
            this.label1.Anchor = System.Windows.Forms.AnchorStyles.Top;
89
            this.label1.BackColor = System.Drawing.Color.White;
90
            this.label1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
91
            this.label1.Font = new System.Drawing.Font("MS 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
92
            this.label1.ForeColor = System.Drawing.Color.Black;
93
            this.label1.Location = new System.Drawing.Point(440, 10);
94
            this.label1.Name = "label1";
95
            this.label1.Size = new System.Drawing.Size(400, 20);
96
            this.label1.TabIndex = 6;
97
            this.label1.Text = "請 求 状 況 確 認";
98
            this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
99
            // 
100
            // groupBox1
101
            // 
102
            this.groupBox1.Anchor = System.Windows.Forms.AnchorStyles.Top;
103
            this.groupBox1.BackColor = System.Drawing.Color.LightGoldenrodYellow;
104
            this.groupBox1.Controls.Add(this.label3);
105
            this.groupBox1.Controls.Add(this.radioButton2);
106
            this.groupBox1.Controls.Add(this.radioButton1);
107
            this.groupBox1.Controls.Add(this.label4);
108
            this.groupBox1.Controls.Add(this.numUDConstPro);
109
            this.groupBox1.Controls.Add(this.label5);
110
            this.groupBox1.Controls.Add(this.label7);
111
            this.groupBox1.Controls.Add(this.cmbConstructionPerson);
112
            this.groupBox1.Controls.Add(this.cmbDepartment);
113
            this.groupBox1.Controls.Add(this.label2);
114
            this.groupBox1.ForeColor = System.Drawing.Color.White;
115
            this.groupBox1.Location = new System.Drawing.Point(10, 40);
116
            this.groupBox1.Name = "groupBox1";
117
            this.groupBox1.Size = new System.Drawing.Size(1260, 55);
118
            this.groupBox1.TabIndex = 0;
119
            this.groupBox1.TabStop = false;
120
            // 
121
            // label3
122
            // 
123
            this.label3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
124
            this.label3.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
125
            this.label3.Font = new System.Drawing.Font("MS 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
126
            this.label3.ForeColor = System.Drawing.Color.Black;
127
            this.label3.Location = new System.Drawing.Point(747, 19);
128
            this.label3.Name = "label3";
129
            this.label3.Size = new System.Drawing.Size(120, 25);
130
            this.label3.TabIndex = 4;
131
            this.label3.Text = "担 当 者";
132
            this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
133
            // 
134
            // radioButton2
135
            // 
136
            this.radioButton2.AutoSize = true;
137
            this.radioButton2.BackColor = System.Drawing.Color.Transparent;
138
            this.radioButton2.Font = new System.Drawing.Font("MS 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
139
            this.radioButton2.ForeColor = System.Drawing.Color.Black;
140
            this.radioButton2.Location = new System.Drawing.Point(662, 32);
141
            this.radioButton2.Name = "radioButton2";
142
            this.radioButton2.Size = new System.Drawing.Size(77, 20);
143
            this.radioButton2.TabIndex = 44;
144
            this.radioButton2.Text = "工 事";
145
            this.radioButton2.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
146
            this.radioButton2.UseVisualStyleBackColor = false;
147
            this.radioButton2.CheckedChanged += new System.EventHandler(this.radioButton_CheckedChanged);
148
            // 
149
            // radioButton1
150
            // 
151
            this.radioButton1.AutoSize = true;
152
            this.radioButton1.BackColor = System.Drawing.Color.Transparent;
153
            this.radioButton1.Checked = true;
154
            this.radioButton1.Font = new System.Drawing.Font("MS 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
155
            this.radioButton1.ForeColor = System.Drawing.Color.Black;
156
            this.radioButton1.Location = new System.Drawing.Point(662, 12);
157
            this.radioButton1.Name = "radioButton1";
158
            this.radioButton1.Size = new System.Drawing.Size(77, 20);
159
            this.radioButton1.TabIndex = 43;
160
            this.radioButton1.TabStop = true;
161
            this.radioButton1.Text = "営 業";
162
            this.radioButton1.TextAlign = System.Drawing.ContentAlignment.TopCenter;
163
            this.radioButton1.UseVisualStyleBackColor = false;
164
            this.radioButton1.CheckedChanged += new System.EventHandler(this.radioButton_CheckedChanged);
165
            // 
166
            // label4
167
            // 
168
            this.label4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
169
            this.label4.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
170
            this.label4.Font = new System.Drawing.Font("MS 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
171
            this.label4.ForeColor = System.Drawing.Color.Black;
172
            this.label4.Location = new System.Drawing.Point(20, 19);
173
            this.label4.Name = "label4";
174
            this.label4.Size = new System.Drawing.Size(120, 25);
175
            this.label4.TabIndex = 42;
176
            this.label4.Text = "営業期";
177
            this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
178
            // 
179
            // numUDConstPro
180
            // 
181
            this.numUDConstPro.BackColor = System.Drawing.Color.White;
182
            this.numUDConstPro.Font = new System.Drawing.Font("MS 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
183
            this.numUDConstPro.ForeColor = System.Drawing.Color.Black;
184
            this.numUDConstPro.Location = new System.Drawing.Point(173, 20);
185
            this.numUDConstPro.Name = "numUDConstPro";
186
            this.numUDConstPro.ReadOnly = true;
187
            this.numUDConstPro.Size = new System.Drawing.Size(80, 23);
188
            this.numUDConstPro.TabIndex = 0;
189
            this.numUDConstPro.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
190
            this.numUDConstPro.ValueChanged += new System.EventHandler(this.numUDConstPro_ValueChanged);
191
            // 
192
            // label5
193
            // 
194
            this.label5.Font = new System.Drawing.Font("MS 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
195
            this.label5.ForeColor = System.Drawing.Color.Black;
196
            this.label5.Location = new System.Drawing.Point(253, 23);
197
            this.label5.Name = "label5";
198
            this.label5.Size = new System.Drawing.Size(25, 16);
199
            this.label5.TabIndex = 39;
200
            this.label5.Text = "期";
201
            this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
202
            // 
203
            // label7
204
            // 
205
            this.label7.Font = new System.Drawing.Font("MS 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
206
            this.label7.ForeColor = System.Drawing.Color.Black;
207
            this.label7.Location = new System.Drawing.Point(148, 23);
208
            this.label7.Name = "label7";
209
            this.label7.Size = new System.Drawing.Size(25, 16);
210
            this.label7.TabIndex = 40;
211
            this.label7.Text = "第";
212
            this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
213
            // 
214
            // cmbConstructionPerson
215
            // 
216
            this.cmbConstructionPerson.BackColor = System.Drawing.Color.White;
217
            this.cmbConstructionPerson.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
218
            this.cmbConstructionPerson.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
219
            this.cmbConstructionPerson.FormattingEnabled = true;
220
            this.cmbConstructionPerson.Location = new System.Drawing.Point(875, 20);
221
            this.cmbConstructionPerson.Name = "cmbConstructionPerson";
222
            this.cmbConstructionPerson.Size = new System.Drawing.Size(200, 23);
223
            this.cmbConstructionPerson.TabIndex = 2;
224
            this.cmbConstructionPerson.TextChanged += new System.EventHandler(this.cmbConstructionPerson_TextChanged);
225
            // 
226
            // cmbDepartment
227
            // 
228
            this.cmbDepartment.BackColor = System.Drawing.Color.White;
229
            this.cmbDepartment.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
230
            this.cmbDepartment.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
231
            this.cmbDepartment.FormattingEnabled = true;
232
            this.cmbDepartment.Location = new System.Drawing.Point(422, 20);
233
            this.cmbDepartment.Name = "cmbDepartment";
234
            this.cmbDepartment.Size = new System.Drawing.Size(200, 23);
235
            this.cmbDepartment.TabIndex = 1;
236
            this.cmbDepartment.TextChanged += new System.EventHandler(this.cmbDepartment_TextChanged);
237
            // 
238
            // label2
239
            // 
240
            this.label2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
241
            this.label2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
242
            this.label2.Font = new System.Drawing.Font("MS 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
243
            this.label2.ForeColor = System.Drawing.Color.Black;
244
            this.label2.Location = new System.Drawing.Point(294, 19);
245
            this.label2.Name = "label2";
246
            this.label2.Size = new System.Drawing.Size(120, 25);
247
            this.label2.TabIndex = 4;
248
            this.label2.Text = "部  署";
249
            this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
250
            // 
251
            // btnDataUpDate
252
            // 
253
            this.btnDataUpDate.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
254
            this.btnDataUpDate.BackColor = System.Drawing.Color.Aquamarine;
255
            this.btnDataUpDate.Font = new System.Drawing.Font("MS 明朝", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
256
            this.btnDataUpDate.ForeColor = System.Drawing.Color.Black;
257
            this.btnDataUpDate.Location = new System.Drawing.Point(1150, 4);
258
            this.btnDataUpDate.Name = "btnDataUpDate";
259
            this.btnDataUpDate.Size = new System.Drawing.Size(120, 30);
260
            this.btnDataUpDate.TabIndex = 7;
261
            this.btnDataUpDate.Text = "最新状態に更新";
262
            this.btnDataUpDate.UseVisualStyleBackColor = false;
263
            this.btnDataUpDate.Click += new System.EventHandler(this.btnDataUpDate_Click);
264
            // 
265
            // dgvMaster
266
            // 
267
            this.dgvMaster.AllowUserToAddRows = false;
268
            this.dgvMaster.AllowUserToDeleteRows = false;
269
            this.dgvMaster.AllowUserToResizeColumns = false;
270
            this.dgvMaster.AllowUserToResizeRows = false;
271
            dataGridViewCellStyle1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
272
            this.dgvMaster.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1;
273
            this.dgvMaster.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
274
            | System.Windows.Forms.AnchorStyles.Left) 
275
            | System.Windows.Forms.AnchorStyles.Right)));
276
            this.dgvMaster.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
277
            this.dgvMaster.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
278
            dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
279
            dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Control;
280
            dataGridViewCellStyle2.Font = new System.Drawing.Font("MS 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
281
            dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.WindowText;
282
            dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight;
283
            dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
284
            dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
285
            this.dgvMaster.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2;
286
            this.dgvMaster.ColumnHeadersHeight = 24;
287
            this.dgvMaster.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
288
            this.dgvMaster.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
289
            this.Column1,
290
            this.Column10,
291
            this.Column6,
292
            this.Column4,
293
            this.Column3,
294
            this.Column2,
295
            this.Column9,
296
            this.Column8,
297
            this.Column5,
298
            this.Column13});
299
            dataGridViewCellStyle12.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
300
            dataGridViewCellStyle12.BackColor = System.Drawing.SystemColors.Window;
301
            dataGridViewCellStyle12.Font = new System.Drawing.Font("MS 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
302
            dataGridViewCellStyle12.ForeColor = System.Drawing.SystemColors.ControlText;
303
            dataGridViewCellStyle12.SelectionBackColor = System.Drawing.Color.LightSeaGreen;
304
            dataGridViewCellStyle12.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
305
            dataGridViewCellStyle12.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
306
            this.dgvMaster.DefaultCellStyle = dataGridViewCellStyle12;
307
            this.dgvMaster.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter;
308
            this.dgvMaster.Location = new System.Drawing.Point(10, 103);
309
            this.dgvMaster.MultiSelect = false;
310
            this.dgvMaster.Name = "dgvMaster";
311
            this.dgvMaster.RowHeadersVisible = false;
312
            this.dgvMaster.RowHeadersWidth = 20;
313
            this.dgvMaster.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.DisableResizing;
314
            this.dgvMaster.RowTemplate.Height = 24;
315
            this.dgvMaster.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;
316
            this.dgvMaster.Size = new System.Drawing.Size(1260, 506);
317
            this.dgvMaster.TabIndex = 5;
318
            this.dgvMaster.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvMaster_CellDoubleClick);
319
            // 
320
            // Column1
321
            // 
322
            dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
323
            this.Column1.DefaultCellStyle = dataGridViewCellStyle3;
324
            this.Column1.Frozen = true;
325
            this.Column1.HeaderText = "№";
326
            this.Column1.Name = "Column1";
327
            this.Column1.ReadOnly = true;
328
            this.Column1.Resizable = System.Windows.Forms.DataGridViewTriState.False;
329
            this.Column1.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
330
            this.Column1.Width = 50;
331
            // 
332
            // Column10
333
            // 
334
            dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
335
            this.Column10.DefaultCellStyle = dataGridViewCellStyle4;
336
            this.Column10.Frozen = true;
337
            this.Column10.HeaderText = "部  署";
338
            this.Column10.Name = "Column10";
339
            this.Column10.ReadOnly = true;
340
            this.Column10.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
341
            this.Column10.Width = 120;
342
            // 
343
            // Column6
344
            // 
345
            dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
346
            this.Column6.DefaultCellStyle = dataGridViewCellStyle5;
347
            this.Column6.Frozen = true;
348
            this.Column6.HeaderText = "担 当 者";
349
            this.Column6.Name = "Column6";
350
            this.Column6.ReadOnly = true;
351
            this.Column6.Resizable = System.Windows.Forms.DataGridViewTriState.False;
352
            this.Column6.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
353
            this.Column6.Width = 120;
354
            // 
355
            // Column4
356
            // 
357
            dataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
358
            this.Column4.DefaultCellStyle = dataGridViewCellStyle6;
359
            this.Column4.Frozen = true;
360
            this.Column4.HeaderText = "請 求 名 称";
361
            this.Column4.Name = "Column4";
362
            this.Column4.ReadOnly = true;
363
            this.Column4.Resizable = System.Windows.Forms.DataGridViewTriState.False;
364
            this.Column4.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
365
            this.Column4.Width = 420;
366
            // 
367
            // Column3
368
            // 
369
            dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
370
            dataGridViewCellStyle7.Font = new System.Drawing.Font("Century", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
371
            this.Column3.DefaultCellStyle = dataGridViewCellStyle7;
372
            this.Column3.Frozen = true;
373
            this.Column3.HeaderText = "請 求 金 額";
374
            this.Column3.Name = "Column3";
375
            this.Column3.ReadOnly = true;
376
            this.Column3.Resizable = System.Windows.Forms.DataGridViewTriState.False;
377
            this.Column3.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
378
            this.Column3.Width = 170;
379
            // 
380
            // Column2
381
            // 
382
            dataGridViewCellStyle8.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
383
            this.Column2.DefaultCellStyle = dataGridViewCellStyle8;
384
            this.Column2.Frozen = true;
385
            this.Column2.HeaderText = "工事コード";
386
            this.Column2.Name = "Column2";
... 差分の行数が表示可能な上限を超えました。超過分は表示しません。

他の形式にエクスポート: Unified diff