リビジョン 192
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