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