リビジョン 88
資材管理、請求管理をマージ、セキュリティ区分登録(FrmSecurityのConfigurationArrayにデータ表示定義を追加)
branches/src/ProcessManagement/ProcessManagement/Common/CommonVersion.cs | ||
---|---|---|
14 | 14 |
/// <summary> |
15 | 15 |
/// 本体バージョン |
16 | 16 |
/// </summary> |
17 |
public static int s_SystemVersion = 1; |
|
17 |
public static int s_SystemVersion = 18;
|
|
18 | 18 |
|
19 | 19 |
/// <summary> |
20 | 20 |
/// コピー・環境バージョン |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBankBusinessDayMaster.cs | ||
---|---|---|
70 | 70 |
|
71 | 71 |
try |
72 | 72 |
{ |
73 |
// SQL作成(DateTime型が変換できないのでCharに変換しておく) |
|
73 |
// SQL作成(oracleのDateTime型が変換できないのでCharに変換しておく)
|
|
74 | 74 |
strcmd = "SELECT"; |
75 | 75 |
strcmd += " YearMonth, BankBusinessDay, Note, DeleteFlg"; |
76 | 76 |
strcmd += " ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')"; |
... | ... | |
122 | 122 |
strcmd += string.Format(", '{0}'", work.Note.ToString()); |
123 | 123 |
strcmd += string.Format(", {0}", work.DeleteFlg.ToString()); |
124 | 124 |
|
125 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
126 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
125 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
126 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
127 | 127 |
strcmd = strcmd + ")"; |
128 | 128 |
|
129 | 129 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
159 | 159 |
strcmd += string.Format(",Note = '{0}'", data.Note); |
160 | 160 |
strcmd += string.Format(",DeleteFlg = {0}", data.DeleteFlg.ToString()); |
161 | 161 |
|
162 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
162 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
163 | 163 |
strcmd += AddSQLString; |
164 | 164 |
|
165 | 165 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
186 | 186 |
try |
187 | 187 |
{ |
188 | 188 |
strcmd = "Update BankBusinessDayMaster Set DeleteFlg = 1"; |
189 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
189 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
190 | 190 |
strcmd += AddSQLString; |
191 | 191 |
|
192 | 192 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingData.cs | ||
---|---|---|
123 | 123 |
strcmd += string.Format(", {0}", work.SeqNo.ToString()); |
124 | 124 |
strcmd += string.Format(", {0}", work.BillPrice.ToString()); |
125 | 125 |
|
126 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
127 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
126 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
127 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
128 | 128 |
strcmd = strcmd + ")"; |
129 | 129 |
|
130 | 130 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
157 | 157 |
|
158 | 158 |
strcmd += string.Format(" BillPrice = {0}", data.BillPrice.ToString()); |
159 | 159 |
|
160 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
160 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
161 | 161 |
strcmd += AddSQLString; |
162 | 162 |
|
163 | 163 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingDataDetail.cs | ||
---|---|---|
136 | 136 |
strcmd += string.Format(", {0}", work.IndsWasteTax.ToString()); |
137 | 137 |
strcmd += string.Format(", '{0}'", work.Note.ToString()); |
138 | 138 |
|
139 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
140 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
139 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
140 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
141 | 141 |
strcmd = strcmd + ")"; |
142 | 142 |
|
143 | 143 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
176 | 176 |
strcmd += string.Format(",IndsWasteTax = {0}", data.IndsWasteTax.ToString()); |
177 | 177 |
strcmd += string.Format(",Note = '{0}'", data.Note); |
178 | 178 |
|
179 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
179 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
180 | 180 |
strcmd += AddSQLString; |
181 | 181 |
|
182 | 182 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingPaymentSummary.cs | ||
---|---|---|
129 | 129 |
strcmd += string.Format(" {0}", work.CompanyCode.ToString()); |
130 | 130 |
strcmd += string.Format(", {0}", work.TargetDate.ToString()); |
131 | 131 |
strcmd += string.Format(", {0}", work.ChargePaymentKind.ToString()); |
132 |
strcmd += string.Format(", DATE_FORMAT(DATE_FORMAT('{0}','%Y/%m/%d'),'%Y/%m/%d')", work.Payday.ToString());
|
|
132 |
strcmd += string.Format(", STR_TO_DATE(DATE_FORMAT('{0}','%Y/%m/%d'),'%Y/%m/%d')", work.Payday.ToString());
|
|
133 | 133 |
strcmd += string.Format(", {0}", work.BillPriceStotal.ToString()); |
134 | 134 |
strcmd += string.Format(", {0}", work.ConsumptionTaxRate.ToString()); |
135 | 135 |
strcmd += string.Format(", {0}", work.ConsumptionTaxPrice.ToString()); |
... | ... | |
140 | 140 |
strcmd += string.Format(", {0}", work.CnstrPriceStotal.ToString()); |
141 | 141 |
strcmd += string.Format(", {0}", work.BillingPriceTotal.ToString()); |
142 | 142 |
|
143 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
144 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
143 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
144 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
145 | 145 |
strcmd = strcmd + ")"; |
146 | 146 |
|
147 | 147 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
172 | 172 |
|
173 | 173 |
strcmd += " SET"; |
174 | 174 |
|
175 |
strcmd += string.Format(" Payday = DATE_FORMAT(DATE_FORMAT('{0}','%Y/%m/%d'),'%Y/%m/%d')", data.Payday.ToString());
|
|
175 |
strcmd += string.Format(" Payday = STR_TO_DATE(DATE_FORMAT('{0}','%Y/%m/%d'),'%Y/%m/%d')", data.Payday.ToString());
|
|
176 | 176 |
strcmd += string.Format(",BillPriceStotal = {0}", data.BillPriceStotal.ToString()); |
177 | 177 |
|
178 | 178 |
strcmd += string.Format(",ConsumptionTaxRate = {0}", data.ConsumptionTaxRate.ToString()); |
... | ... | |
185 | 185 |
strcmd += string.Format(",CnstrPriceStotal = {0}", data.CnstrPriceStotal.ToString()); |
186 | 186 |
strcmd += string.Format(",BillingPriceTotal = {0}", data.BillingPriceTotal.ToString()); |
187 | 187 |
|
188 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
188 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
189 | 189 |
strcmd += AddSQLString; |
190 | 190 |
|
191 | 191 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODeadLineMaster.cs | ||
---|---|---|
125 | 125 |
strcmd += string.Format(", '{0}'", work.Note.ToString()); |
126 | 126 |
strcmd += string.Format(", {0}", work.DeleteFlg.ToString()); |
127 | 127 |
|
128 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
129 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
128 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
129 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
130 | 130 |
strcmd = strcmd + ")"; |
131 | 131 |
|
132 | 132 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
162 | 162 |
strcmd += string.Format(",PayDay = {0}", data.PayDay.ToString()); |
163 | 163 |
strcmd += string.Format(",Note = '{0}'", data.Note); |
164 | 164 |
strcmd += string.Format(",DeleteFlg = {0}", data.DeleteFlg.ToString()); |
165 |
|
|
166 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
165 |
|
|
166 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
167 | 167 |
strcmd += AddSQLString; |
168 | 168 |
|
169 | 169 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
190 | 190 |
try |
191 | 191 |
{ |
192 | 192 |
strcmd = "Update DeadLineMaster Set DeleteFlg = 1"; |
193 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
193 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
194 | 194 |
strcmd += AddSQLString; |
195 | 195 |
|
196 | 196 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODepositApprovalInfo.cs | ||
---|---|---|
221 | 221 |
strcmd += string.Format(", '{0}'", data.ApprovalPersonName.ToString()); |
222 | 222 |
strcmd += string.Format(", {0}", data.ApprovalAuthority.ToString()); |
223 | 223 |
strcmd += string.Format(", DATE_FORMAT('{0}','%Y%m%d')", data.ApprovalDate.ToString()); |
224 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
225 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
224 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
225 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
226 | 226 |
strcmd = strcmd + ")"; |
227 | 227 |
|
228 | 228 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
264 | 264 |
strcmd += string.Format(",ApprovalPersonName = '{0}'", data.ApprovalPersonName.ToString()); |
265 | 265 |
strcmd += string.Format(",ApprovalAuthority = {0}", data.ApprovalAuthority.ToString()); |
266 | 266 |
strcmd += string.Format(",ApprovalDate = DATE_FORMAT('{0}','%Y%m%d')", data.ApprovalDate.ToString()); |
267 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
267 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
268 | 268 |
strcmd += AddSQLString; |
269 | 269 |
|
270 | 270 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODepositData.cs | ||
---|---|---|
218 | 218 |
strcmd += string.Format(", {0}", data.DepositAmount.ToString()); |
219 | 219 |
strcmd += string.Format(", {0}", data.DepositAmountCash.ToString()); |
220 | 220 |
strcmd += string.Format(", {0}", data.DepositAmountBill.ToString()); |
221 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
222 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
221 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
222 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
223 | 223 |
strcmd = strcmd + ")"; |
224 | 224 |
|
225 | 225 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
260 | 260 |
strcmd += string.Format(",DepositAmount = {0}", data.DepositAmount.ToString()); |
261 | 261 |
strcmd += string.Format(",DepositAmountCash = {0}", data.DepositAmountCash.ToString()); |
262 | 262 |
strcmd += string.Format(",DepositAmountBill = {0}", data.DepositAmountBill.ToString()); |
263 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
263 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
264 | 264 |
strcmd += AddSQLString; |
265 | 265 |
|
266 | 266 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
319 | 319 |
wrk.SeqNo = int.Parse(objwrk[(int)ColumnName.SeqNo].ToString()); |
320 | 320 |
wrk.BusinessPeriod = int.Parse(objwrk[(int)ColumnName.BusinessPeriod].ToString()); |
321 | 321 |
wrk.DepositDate = DateTime.Parse(objwrk[(int)ColumnName.DepositDate].ToString()); |
322 |
wrk.DepositAmount = int.Parse(objwrk[(int)ColumnName.DepositAmount].ToString());
|
|
323 |
wrk.DepositAmountCash = int.Parse(objwrk[(int)ColumnName.DepositAmountCash].ToString());
|
|
324 |
wrk.DepositAmountBill = int.Parse(objwrk[(int)ColumnName.DepositAmountBill].ToString());
|
|
322 |
wrk.DepositAmount = long.Parse(objwrk[(int)ColumnName.DepositAmount].ToString());
|
|
323 |
wrk.DepositAmountCash = long.Parse(objwrk[(int)ColumnName.DepositAmountCash].ToString());
|
|
324 |
wrk.DepositAmountBill = long.Parse(objwrk[(int)ColumnName.DepositAmountBill].ToString());
|
|
325 | 325 |
|
326 | 326 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)ColumnName.EntryDate].ToString()); |
327 | 327 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)ColumnName.UpdateDate].ToString()); |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODepositDataDetail.cs | ||
---|---|---|
187 | 187 |
strcmd += string.Format(", DATE_FORMAT('{0}','%Y/%m/%d')", data.ApprovalDate.ToShortDateString()); |
188 | 188 |
strcmd += string.Format(", {0}", data.ApprovalEndFlg ? 1 : 0); |
189 | 189 |
|
190 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
191 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
190 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
191 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
192 | 192 |
strcmd = strcmd + ")"; |
193 | 193 |
|
194 | 194 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
237 | 237 |
strcmd += string.Format(",ApprovalDate = DATE_FORMAT('{0}','%Y/%m/%d')", data.ApprovalDate.ToShortDateString()); |
238 | 238 |
strcmd += string.Format(",ApprovalEndFlg = {0}", data.ApprovalEndFlg ? 1 : 0); |
239 | 239 |
|
240 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
240 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
241 | 241 |
strcmd += string.Format(" where OrderersDivision = {0} and OrderersCode = {1} and TargetDate = {2} and SeqNo = {3} and LineCount = {4} ", |
242 | 242 |
data.OrderersDivision, data.OrderersCode, data.TargetDate, data.SeqNo, data.LineCount); |
243 | 243 |
strcmd += AddSQLString; |
... | ... | |
299 | 299 |
wrk.LineCount = int.Parse(objwrk[(int)NameColumn.LineCount].ToString()); |
300 | 300 |
wrk.RequestNo = int.Parse(objwrk[(int)NameColumn.RequestNo].ToString()); |
301 | 301 |
wrk.OrderNo = int.Parse(objwrk[(int)NameColumn.OrderNo].ToString()); |
302 |
wrk.DepositAmount = int.Parse(objwrk[(int)NameColumn.DepositAmount].ToString());
|
|
303 |
wrk.DiscountAmount = int.Parse(objwrk[(int)NameColumn.DiscountAmount].ToString());
|
|
304 |
wrk.CnstrPrice = int.Parse(objwrk[(int)NameColumn.CnstrPrice].ToString());
|
|
305 |
wrk.Fees = int.Parse(objwrk[(int)NameColumn.Fees].ToString());
|
|
306 |
wrk.OtherAdjustments = int.Parse(objwrk[(int)NameColumn.OtherAdjustments].ToString());
|
|
307 |
wrk.CarryAmount = int.Parse(objwrk[(int)NameColumn.CarryAmount].ToString());
|
|
302 |
wrk.DepositAmount = long.Parse(objwrk[(int)NameColumn.DepositAmount].ToString());
|
|
303 |
wrk.DiscountAmount = long.Parse(objwrk[(int)NameColumn.DiscountAmount].ToString());
|
|
304 |
wrk.CnstrPrice = long.Parse(objwrk[(int)NameColumn.CnstrPrice].ToString());
|
|
305 |
wrk.Fees = long.Parse(objwrk[(int)NameColumn.Fees].ToString());
|
|
306 |
wrk.OtherAdjustments = long.Parse(objwrk[(int)NameColumn.OtherAdjustments].ToString());
|
|
307 |
wrk.CarryAmount = long.Parse(objwrk[(int)NameColumn.CarryAmount].ToString());
|
|
308 | 308 |
wrk.ApprovalPersonCode = int.Parse(objwrk[(int)NameColumn.ApprovalPersonCode].ToString()); |
309 | 309 |
wrk.ApprovalDate = DateTime.Parse(objwrk[(int)NameColumn.ApprovalDate].ToString()); |
310 | 310 |
wrk.ApprovalEndFlg = (int.Parse(objwrk[(int)NameColumn.ApprovalEndFlg].ToString()) != 0); |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOInvoiceData.cs | ||
---|---|---|
206 | 206 |
strcmd += string.Format(", '{0}'", data.Comment4.ToString()); |
207 | 207 |
strcmd += string.Format(", '{0}'", data.Comment5.ToString()); |
208 | 208 |
strcmd += string.Format(", {0}", data.CompleteFlg.ToString()); |
209 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
210 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
209 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
210 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
211 | 211 |
strcmd = strcmd + ")"; |
212 | 212 |
|
213 | 213 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
254 | 254 |
strcmd += string.Format(", Comment4 = '{0}'", data.Comment4.ToString()); |
255 | 255 |
strcmd += string.Format(", Comment5 = '{0}'", data.Comment5.ToString()); |
256 | 256 |
strcmd += string.Format(", CompleteFlg = {0}", data.CompleteFlg.ToString()); |
257 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
257 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
258 | 258 |
|
259 | 259 |
strcmd += AddSQLString; |
260 | 260 |
|
... | ... | |
320 | 320 |
|
321 | 321 |
wrk.RequestName = objwrk[(int)NameColumn.RequestName].ToString(); |
322 | 322 |
|
323 |
wrk.TotalAmount = int.Parse(objwrk[(int)NameColumn.TotalAmount].ToString());
|
|
324 |
wrk.TaxAmount = int.Parse(objwrk[(int)NameColumn.TaxAmount].ToString());
|
|
323 |
wrk.TotalAmount = long.Parse(objwrk[(int)NameColumn.TotalAmount].ToString());
|
|
324 |
wrk.TaxAmount = long.Parse(objwrk[(int)NameColumn.TaxAmount].ToString());
|
|
325 | 325 |
|
326 | 326 |
wrk.Comment1 = objwrk[(int)NameColumn.Comment1].ToString(); |
327 | 327 |
wrk.Comment2 = objwrk[(int)NameColumn.Comment2].ToString(); |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialInfo.cs | ||
---|---|---|
119 | 119 |
strcmd += string.Format(", {0}", work.RentCount.ToString()); |
120 | 120 |
strcmd += string.Format(", {0}", work.DeleteFlg.ToString()); |
121 | 121 |
|
122 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
123 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
122 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
123 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
124 | 124 |
strcmd = strcmd + ")"; |
125 | 125 |
|
126 | 126 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
153 | 153 |
strcmd += string.Format(",RentCount = {0}", data.RentCount.ToString()); |
154 | 154 |
strcmd += string.Format(",DeleteFlg = {0}", data.DeleteFlg.ToString()); |
155 | 155 |
|
156 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
156 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
157 | 157 |
strcmd += AddSQLString; |
158 | 158 |
|
159 | 159 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
179 | 179 |
try |
180 | 180 |
{ |
181 | 181 |
strcmd = "Update MaterialInfo Set DeleteFlg = 1"; |
182 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
182 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
183 | 183 |
strcmd += AddSQLString; |
184 | 184 |
|
185 | 185 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialItem.cs | ||
---|---|---|
25 | 25 |
/// log4netログを使用する |
26 | 26 |
/// </summary> |
27 | 27 |
private static readonly ILog logger = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); |
28 |
/// <summary> |
|
29 |
/// バージョンNoの最大値 |
|
30 |
/// </summary> |
|
31 |
private static readonly int MAX_VERSION = 99999999; |
|
28 | 32 |
#endregion |
29 | 33 |
|
30 | 34 |
#region 定数 |
... | ... | |
39 | 43 |
DisplayOrder, |
40 | 44 |
DeleteFlg, |
41 | 45 |
ENTRYDATE, |
42 |
UPDATEDATE |
|
46 |
UPDATEDATE, |
|
47 |
VERSIONNO |
|
43 | 48 |
} |
44 | 49 |
#endregion |
45 | 50 |
|
... | ... | |
122 | 127 |
strcmd += string.Format(", {0}", work.DisplayOrder.ToString()); |
123 | 128 |
strcmd += string.Format(", {0}", work.DeleteFlg.ToString()); |
124 | 129 |
|
125 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
126 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
130 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
131 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
127 | 132 |
strcmd = strcmd + ")"; |
128 | 133 |
|
129 | 134 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
159 | 164 |
strcmd += string.Format(",DisplayOrder = {0}", data.DisplayOrder.ToString()); |
160 | 165 |
strcmd += string.Format(",DeleteFlg = {0}", data.DeleteFlg.ToString()); |
161 | 166 |
|
162 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
167 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
163 | 168 |
strcmd += AddSQLString; |
164 | 169 |
|
165 | 170 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
173 | 178 |
} |
174 | 179 |
} |
175 | 180 |
|
181 |
/// <summary> |
|
182 |
/// 資材品目マスタ更新 |
|
183 |
/// </summary> |
|
184 |
/// <param name="AddSQLString">更新条件SQL文字列</param> |
|
185 |
/// <param name="data">資材品目マスタデータ</param> |
|
186 |
/// <returns>true:成功 false:失敗</returns> |
|
187 |
public bool UpdateVersionAction(string AddSQLString, MaterialItemMaster data, bool bConnect = true) |
|
188 |
{ |
|
189 |
string strcmd = ""; |
|
190 |
int nVersionNo = 0; |
|
191 |
try |
|
192 |
{ |
|
176 | 193 |
|
194 |
strcmd = "UPDATE MaterialItemMaster"; |
|
195 |
|
|
196 |
strcmd += " SET"; |
|
197 |
|
|
198 |
strcmd += string.Format(" MaterialItemCode = {0}", data.MaterialItemCode.ToString()); |
|
199 |
strcmd += string.Format(",MaterialKindCode = {0}", data.MaterialKindCode.ToString()); |
|
200 |
strcmd += string.Format(",MaterialItemName = '{0}'", data.MaterialItemName); |
|
201 |
strcmd += string.Format(",DisplayOrder = {0}", data.DisplayOrder.ToString()); |
|
202 |
strcmd += string.Format(",DeleteFlg = {0}", data.DeleteFlg.ToString()); |
|
203 |
if (data.VersionNo >= MAX_VERSION) |
|
204 |
{ |
|
205 |
nVersionNo = 1; |
|
206 |
} |
|
207 |
else |
|
208 |
{ |
|
209 |
nVersionNo = data.VersionNo + 1; |
|
210 |
} |
|
211 |
strcmd += string.Format(",VersionNo = {0}", nVersionNo.ToString()); |
|
212 |
|
|
213 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
|
214 |
strcmd += AddSQLString; |
|
215 |
|
|
216 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
|
217 |
|
|
218 |
return true; |
|
219 |
} |
|
220 |
catch (Exception ex) |
|
221 |
{ |
|
222 |
logger.ErrorFormat("システムエラー::{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd); |
|
223 |
return false; |
|
224 |
} |
|
225 |
} |
|
226 |
|
|
177 | 227 |
/// <summary> |
178 | 228 |
/// 資材品目マスタ削除 |
179 | 229 |
/// </summary> |
... | ... | |
187 | 237 |
try |
188 | 238 |
{ |
189 | 239 |
strcmd = "Update MaterialItemMaster Set DeleteFlg = 1,DisplayOrder = 999"; |
190 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
240 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
191 | 241 |
strcmd += AddSQLString; |
192 | 242 |
|
193 | 243 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
219 | 269 |
|
220 | 270 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)NameColumn.ENTRYDATE].ToString()); |
221 | 271 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)NameColumn.UPDATEDATE].ToString()); |
272 |
|
|
273 |
wrk.VersionNo = int.Parse(objwrk[(int)NameColumn.VERSIONNO].ToString()); |
|
222 | 274 |
} |
223 | 275 |
catch (MySqlException oraex) |
224 | 276 |
{ |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialRecordInfo.cs | ||
---|---|---|
127 | 127 |
strcmd += string.Format(", DATE_FORMAT('{0}','%Y/%m/%d')", work.RepayPlanDate.ToString()); |
128 | 128 |
strcmd += string.Format(", '{0}'", work.CommentText.ToString()); |
129 | 129 |
|
130 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
131 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
130 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
131 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
132 | 132 |
strcmd = strcmd + ")"; |
133 | 133 |
|
134 | 134 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
164 | 164 |
strcmd += string.Format(",RepayPlanDate = DATE_FORMAT('{0}','%Y/%m/%d')", data.RepayPlanDate.ToString()); |
165 | 165 |
strcmd += string.Format(",CommentText = '{0}'", data.CommentText.ToString()); |
166 | 166 |
|
167 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
167 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
168 | 168 |
strcmd += AddSQLString; |
169 | 169 |
|
170 | 170 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialTypes.cs | ||
---|---|---|
120 | 120 |
strcmd += string.Format(", {0}", work.DisplayOrder.ToString()); |
121 | 121 |
strcmd += string.Format(", {0}", work.DeleteFlg.ToString()); |
122 | 122 |
|
123 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
124 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
123 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
124 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
125 | 125 |
strcmd = strcmd + ")"; |
126 | 126 |
|
127 | 127 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
156 | 156 |
strcmd += string.Format(",DisplayOrder = {0}", data.DisplayOrder.ToString()); |
157 | 157 |
strcmd += string.Format(",DeleteFlg = {0}", data.DeleteFlg.ToString()); |
158 | 158 |
|
159 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
159 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
160 | 160 |
strcmd += AddSQLString; |
161 | 161 |
|
162 | 162 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
184 | 184 |
try |
185 | 185 |
{ |
186 | 186 |
strcmd = "Update MaterialKindMaster Set DeleteFlg = 1,DisplayOrder = 999"; |
187 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
187 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
188 | 188 |
strcmd += AddSQLString; |
189 | 189 |
|
190 | 190 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IORequestData.cs | ||
---|---|---|
189 | 189 |
strcmd += string.Format(", {0}", data.TaxAmount.ToString()); |
190 | 190 |
strcmd += string.Format(", '{0}'", data.Note.ToString()); |
191 | 191 |
|
192 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
193 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
192 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
193 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
194 | 194 |
strcmd = strcmd + ")"; |
195 | 195 |
|
196 | 196 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
239 | 239 |
strcmd += string.Format(",TaxAmount = {0}", data.TaxAmount.ToString()); |
240 | 240 |
strcmd += string.Format(",Note = '{0}'", data.Note.ToString()); |
241 | 241 |
|
242 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
242 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
243 | 243 |
|
244 | 244 |
strcmd += string.Format(" Where RequestNo = {0} And MainConstructionCode = {1}", data.RequestNo.ToString(), data.MainConstructionCode.ToString()); |
245 | 245 |
strcmd += AddSQLString; |
... | ... | |
321 | 321 |
wrk.MainConstructionCode = int.Parse(objwrk[(int)NameColumn.MainConstructionCode].ToString()); |
322 | 322 |
|
323 | 323 |
wrk.ConstructionName = objwrk[(int)NameColumn.ConstructionName].ToString(); |
324 |
wrk.ContractAmount = int.Parse(objwrk[(int)NameColumn.ContractAmount].ToString());
|
|
325 |
wrk.PaidAmount = int.Parse(objwrk[(int)NameColumn.PaidAmount].ToString());
|
|
326 |
wrk.RequestAmount0 = int.Parse(objwrk[(int)NameColumn.RequestAmount0].ToString());
|
|
327 |
wrk.RequestAmount1 = int.Parse(objwrk[(int)NameColumn.RequestAmount1].ToString());
|
|
328 |
wrk.RequestAmount2 = int.Parse(objwrk[(int)NameColumn.RequestAmount2].ToString());
|
|
329 |
wrk.RequestAmount3 = int.Parse(objwrk[(int)NameColumn.RequestAmount3].ToString());
|
|
330 |
wrk.RequestAmount4 = int.Parse(objwrk[(int)NameColumn.RequestAmount4].ToString());
|
|
331 |
wrk.RequestAmount5 = int.Parse(objwrk[(int)NameColumn.RequestAmount5].ToString());
|
|
332 |
wrk.RequestAmount6 = int.Parse(objwrk[(int)NameColumn.RequestAmount6].ToString());
|
|
333 |
wrk.UnclaimedAmount = int.Parse(objwrk[(int)NameColumn.UnclaimedAmount].ToString());
|
|
334 |
wrk.UnpaidAmount = int.Parse(objwrk[(int)NameColumn.UnpaidAmount].ToString());
|
|
335 |
wrk.TaxAmount = int.Parse(objwrk[(int)NameColumn.TaxAmount].ToString());
|
|
324 |
wrk.ContractAmount = long.Parse(objwrk[(int)NameColumn.ContractAmount].ToString());
|
|
325 |
wrk.PaidAmount = long.Parse(objwrk[(int)NameColumn.PaidAmount].ToString());
|
|
326 |
wrk.RequestAmount0 = long.Parse(objwrk[(int)NameColumn.RequestAmount0].ToString());
|
|
327 |
wrk.RequestAmount1 = long.Parse(objwrk[(int)NameColumn.RequestAmount1].ToString());
|
|
328 |
wrk.RequestAmount2 = long.Parse(objwrk[(int)NameColumn.RequestAmount2].ToString());
|
|
329 |
wrk.RequestAmount3 = long.Parse(objwrk[(int)NameColumn.RequestAmount3].ToString());
|
|
330 |
wrk.RequestAmount4 = long.Parse(objwrk[(int)NameColumn.RequestAmount4].ToString());
|
|
331 |
wrk.RequestAmount5 = long.Parse(objwrk[(int)NameColumn.RequestAmount5].ToString());
|
|
332 |
wrk.RequestAmount6 = long.Parse(objwrk[(int)NameColumn.RequestAmount6].ToString());
|
|
333 |
wrk.UnclaimedAmount = long.Parse(objwrk[(int)NameColumn.UnclaimedAmount].ToString());
|
|
334 |
wrk.UnpaidAmount = long.Parse(objwrk[(int)NameColumn.UnpaidAmount].ToString());
|
|
335 |
wrk.TaxAmount = long.Parse(objwrk[(int)NameColumn.TaxAmount].ToString());
|
|
336 | 336 |
wrk.Note = objwrk[(int)NameColumn.Note].ToString(); |
337 | 337 |
|
338 | 338 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)NameColumn.ENTRYDATE].ToString()); |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IORequestDataDetail.cs | ||
---|---|---|
158 | 158 |
strcmd += string.Format(", {0}", data.RequestAmount.ToString()); |
159 | 159 |
strcmd += string.Format(", {0}", data.TaxAmount.ToString()); |
160 | 160 |
|
161 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
162 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
161 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
162 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
163 | 163 |
strcmd = strcmd + ")"; |
164 | 164 |
|
165 | 165 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
195 | 195 |
strcmd += string.Format(",RequestAmount = {0}", data.RequestAmount.ToString()); |
196 | 196 |
strcmd += string.Format(",TaxAmount = {0}", data.TaxAmount.ToString()); |
197 | 197 |
|
198 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
198 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
199 | 199 |
|
200 | 200 |
strcmd += string.Format(" Where RequestNo = {0}", data.RequestNo.ToString()); |
201 | 201 |
strcmd += string.Format(" And MainConstructionCode = {0}", data.MainConstructionCode.ToString()); |
... | ... | |
281 | 281 |
wrk.ConstructionCode = int.Parse(objwrk[(int)NameColumn.ConstructionCode].ToString()); |
282 | 282 |
|
283 | 283 |
wrk.ConstructionKind = int.Parse(objwrk[(int)NameColumn.ConstructionKind].ToString()); |
284 |
wrk.RequestAmount = int.Parse(objwrk[(int)NameColumn.RequestAmount].ToString());
|
|
285 |
wrk.TaxAmount = int.Parse(objwrk[(int)NameColumn.TaxAmount].ToString());
|
|
284 |
wrk.RequestAmount = long.Parse(objwrk[(int)NameColumn.RequestAmount].ToString());
|
|
285 |
wrk.TaxAmount = long.Parse(objwrk[(int)NameColumn.TaxAmount].ToString());
|
|
286 | 286 |
|
287 | 287 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)NameColumn.ENTRYDATE].ToString()); |
288 | 288 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)NameColumn.UPDATEDATE].ToString()); |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IORequestHead.cs | ||
---|---|---|
184 | 184 |
strcmd += string.Format(", {0}", data.AssignedFlg.ToString()); |
185 | 185 |
strcmd += string.Format(", {0}", data.InvoiceNo.ToString()); |
186 | 186 |
|
187 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
188 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
187 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
188 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
189 | 189 |
strcmd = strcmd + ")"; |
190 | 190 |
|
191 | 191 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
... | ... | |
262 | 262 |
strcmd += string.Format(",AssignedFlg = {0}", data.AssignedFlg.ToString()); |
263 | 263 |
strcmd += string.Format(",InvoiceNo = {0}", data.InvoiceNo.ToString()); |
264 | 264 |
|
265 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
265 |
strcmd += ", UpdateDate = STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
266 | 266 |
|
267 | 267 |
//strcmd += string.Format(" Where RequestNo = {0}", data.RequestNo.ToString()); |
268 | 268 |
strcmd += AddSQLString; |
... | ... | |
329 | 329 |
|
330 | 330 |
wrk.ReqConstructionName = objwrk[(int)NameColumn.ReqConstructionName].ToString(); |
331 | 331 |
|
332 |
wrk.RequestTotalAmount = int.Parse(objwrk[(int)NameColumn.RequestTotalAmount].ToString());
|
|
333 |
wrk.RequestAmount = int.Parse(objwrk[(int)NameColumn.RequestAmount].ToString());
|
|
334 |
wrk.TaxAmount = int.Parse(objwrk[(int)NameColumn.TaxAmount].ToString());
|
|
335 |
wrk.UnpaidAmount = int.Parse(objwrk[(int)NameColumn.UnpaidAmount].ToString());
|
|
332 |
wrk.RequestTotalAmount = long.Parse(objwrk[(int)NameColumn.RequestTotalAmount].ToString());
|
|
333 |
wrk.RequestAmount = long.Parse(objwrk[(int)NameColumn.RequestAmount].ToString());
|
|
334 |
wrk.TaxAmount = long.Parse(objwrk[(int)NameColumn.TaxAmount].ToString());
|
|
335 |
wrk.UnpaidAmount = long.Parse(objwrk[(int)NameColumn.UnpaidAmount].ToString());
|
|
336 | 336 |
|
337 | 337 |
wrk.Note = objwrk[(int)NameColumn.Note].ToString(); |
338 | 338 |
|
branches/src/ProcessManagement/ProcessManagement/DataModel/DepositData.cs | ||
---|---|---|
18 | 18 |
private int m_SeqNo = 0; // 連番 |
19 | 19 |
private int m_BusinessPeriod = 0; // 営業期 |
20 | 20 |
private DateTime m_DepositDate = DateTime.MinValue; // 入金日 |
21 |
private int m_DepositAmount = 0; // 入金金額
|
|
22 |
private int m_DepositAmountCash = 0; // 入金金額(現金)
|
|
23 |
private int m_DepositAmountBill = 0; // 入金金額(手形)
|
|
21 |
private long m_DepositAmount = 0; // 入金金額
|
|
22 |
private long m_DepositAmountCash = 0; // 入金金額(現金)
|
|
23 |
private long m_DepositAmountBill = 0; // 入金金額(手形)
|
|
24 | 24 |
private DateTime m_EntryDate = DateTime.Now; // 登録年月日 |
25 | 25 |
private DateTime m_UpdateDate = DateTime.Now; // 更新年月日 |
26 | 26 |
#endregion |
... | ... | |
86 | 86 |
/// <summary> |
87 | 87 |
/// 入金金額 |
88 | 88 |
/// </summary> |
89 |
public int DepositAmount
|
|
89 |
public long DepositAmount
|
|
90 | 90 |
{ |
91 | 91 |
get { return m_DepositAmount; } |
92 | 92 |
set { m_DepositAmount = value; } |
... | ... | |
95 | 95 |
/// <summary> |
96 | 96 |
/// 入金金額(現金) |
97 | 97 |
/// </summary> |
98 |
public int DepositAmountCash
|
|
98 |
public long DepositAmountCash
|
|
99 | 99 |
{ |
100 | 100 |
get { return m_DepositAmountCash; } |
101 | 101 |
set { m_DepositAmountCash = value; } |
... | ... | |
104 | 104 |
/// <summary> |
105 | 105 |
/// 入金金額(手形) |
106 | 106 |
/// </summary> |
107 |
public int DepositAmountBill
|
|
107 |
public long DepositAmountBill
|
|
108 | 108 |
{ |
109 | 109 |
get { return m_DepositAmountBill; } |
110 | 110 |
set { m_DepositAmountBill = value; } |
branches/src/ProcessManagement/ProcessManagement/DataModel/DepositDataDetail.cs | ||
---|---|---|
19 | 19 |
private int m_LineCount = 0; // 行番号 |
20 | 20 |
private int m_RequestNo = 0; // 請求No |
21 | 21 |
private int m_OrderNo = 0; // 受付番号 |
22 |
private int m_DepositAmount = 0; // 入金金額
|
|
23 |
private int m_DiscountAmount = 0; // 値引き金額
|
|
24 |
private int m_CnstrPrice = 0; // 協力金
|
|
25 |
private int m_Fees = 0; // 手数料
|
|
26 |
private int m_OtherAdjustments = 0; // その他調整
|
|
27 |
private int m_CarryAmount = 0; // 繰越金額
|
|
22 |
private long m_DepositAmount = 0; // 入金金額
|
|
23 |
private long m_DiscountAmount = 0; // 値引き金額
|
|
24 |
private long m_CnstrPrice = 0; // 協力金
|
|
25 |
private long m_Fees = 0; // 手数料
|
|
26 |
private long m_OtherAdjustments = 0; // その他調整
|
|
27 |
private long m_CarryAmount = 0; // 繰越金額
|
|
28 | 28 |
private int m_ApprovalPersonCode = 0; // 承認担当者コード |
29 | 29 |
private DateTime m_ApprovalDate = DateTime.MinValue; // 担当者承認日付 |
30 | 30 |
private bool m_ApprovalEndFlg = false; // 承認完了フラグ |
... | ... | |
102 | 102 |
/// <summary> |
103 | 103 |
/// 入金金額 |
104 | 104 |
/// </summary> |
105 |
public int DepositAmount
|
|
105 |
public long DepositAmount
|
|
106 | 106 |
{ |
107 | 107 |
get { return m_DepositAmount; } |
108 | 108 |
set { m_DepositAmount = value; } |
... | ... | |
111 | 111 |
/// <summary> |
112 | 112 |
/// 値引き金額 |
113 | 113 |
/// </summary> |
114 |
public int DiscountAmount
|
|
114 |
public long DiscountAmount
|
|
115 | 115 |
{ |
116 | 116 |
get { return m_DiscountAmount; } |
117 | 117 |
set { m_DiscountAmount = value; } |
... | ... | |
120 | 120 |
/// <summary> |
121 | 121 |
/// 協力金 |
122 | 122 |
/// </summary> |
123 |
public int CnstrPrice
|
|
123 |
public long CnstrPrice
|
|
124 | 124 |
{ |
125 | 125 |
get { return m_CnstrPrice; } |
126 | 126 |
set { m_CnstrPrice = value; } |
... | ... | |
129 | 129 |
/// <summary> |
130 | 130 |
/// 手数料 |
131 | 131 |
/// </summary> |
132 |
public int Fees
|
|
132 |
public long Fees
|
|
133 | 133 |
{ |
134 | 134 |
get { return m_Fees; } |
135 | 135 |
set { m_Fees = value; } |
... | ... | |
138 | 138 |
/// <summary> |
139 | 139 |
/// その他調整 |
140 | 140 |
/// </summary> |
141 |
public int OtherAdjustments
|
|
141 |
public long OtherAdjustments
|
|
142 | 142 |
{ |
143 | 143 |
get { return m_OtherAdjustments; } |
144 | 144 |
set { m_OtherAdjustments = value; } |
... | ... | |
147 | 147 |
/// <summary> |
148 | 148 |
/// 繰越金額 |
149 | 149 |
/// </summary> |
150 |
public int CarryAmount
|
|
150 |
public long CarryAmount
|
|
151 | 151 |
{ |
152 | 152 |
get { return m_CarryAmount; } |
153 | 153 |
set { m_CarryAmount = value; } |
branches/src/ProcessManagement/ProcessManagement/DataModel/InvoiceData.cs | ||
---|---|---|
20 | 20 |
private DateTime m_CretateDate = DateTime.MinValue; // 作成日 |
21 | 21 |
private DateTime m_RequestDate = DateTime.MinValue; // 請求日 |
22 | 22 |
private string m_RequestName = ""; // 請求先名 |
23 |
private int m_TotalAmount = 0; // 税込み合計金額
|
|
24 |
private int m_TaxAmount = 0; // 消費税金額
|
|
23 |
private long m_TotalAmount = 0; // 税込み合計金額
|
|
24 |
private long m_TaxAmount = 0; // 消費税金額
|
|
25 | 25 |
private string m_Comment1 = ""; // コメント1 |
26 | 26 |
private string m_Comment2 = ""; // コメント2 |
27 | 27 |
private string m_Comment3 = ""; // コメント3 |
... | ... | |
111 | 111 |
/// <summary> |
112 | 112 |
/// 税込み合計金額 |
113 | 113 |
/// </summary> |
114 |
public int TotalAmount
|
|
114 |
public long TotalAmount
|
|
115 | 115 |
{ |
116 | 116 |
get { return m_TotalAmount; } |
117 | 117 |
set { m_TotalAmount = value; } |
... | ... | |
120 | 120 |
/// <summary> |
121 | 121 |
/// 消費税金額 |
122 | 122 |
/// </summary> |
123 |
public int TaxAmount
|
|
123 |
public long TaxAmount
|
|
124 | 124 |
{ |
125 | 125 |
get { return m_TaxAmount; } |
126 | 126 |
set { m_TaxAmount = value; } |
branches/src/ProcessManagement/ProcessManagement/DataModel/MaterialItemMaster.cs | ||
---|---|---|
9 | 9 |
public class MaterialItemMaster |
10 | 10 |
{ |
11 | 11 |
#region メンバ変数 |
12 |
private int m_MaterialItemCode = 0; // キー項目 |
|
13 |
private int m_MaterialKindCode = 0; // 資材種類コード |
|
12 |
private int m_MaterialItemCode = 0; // キー項目
|
|
13 |
private int m_MaterialKindCode = 0; // 資材種類コード
|
|
14 | 14 |
private string m_MaterialItemName = string.Empty; // 名称 |
15 |
private int m_DisplayOrder = 0; // 表示順 |
|
16 |
private int m_DeleteFlg = 0; // 削除フラグ |
|
17 |
private DateTime m_EntryDate = DateTime.Now; // 登録日付 |
|
18 |
private DateTime m_UpdateDate = DateTime.Now; // 更新日付 |
|
15 |
private int m_DisplayOrder = 0; // 表示順 |
|
16 |
private int m_DeleteFlg = 0; // 削除フラグ |
|
17 |
private DateTime m_EntryDate = DateTime.Now; // 登録日付 |
|
18 |
private DateTime m_UpdateDate = DateTime.Now; // 更新日付 |
|
19 |
private int m_VersionNo = 0; // バージョンNo(排他制御用) |
|
19 | 20 |
#endregion |
20 | 21 |
|
21 | 22 |
|
... | ... | |
47 | 48 |
get { return m_MaterialItemName; } |
48 | 49 |
set { m_MaterialItemName = value; } |
49 | 50 |
} |
50 |
|
|
51 | 51 |
/// <summary> |
52 | 52 |
/// 表示順 |
53 | 53 |
/// </summary> |
... | ... | |
64 | 64 |
get { return m_DeleteFlg; } |
65 | 65 |
set { m_DeleteFlg = value; } |
66 | 66 |
} |
67 |
|
|
68 | 67 |
/// <summary> |
69 | 68 |
/// 登録日付 |
70 | 69 |
/// </summary> |
... | ... | |
81 | 80 |
set { m_UpdateDate = value; } |
82 | 81 |
get { return m_UpdateDate; } |
83 | 82 |
} |
83 |
/// <summary> |
|
84 |
/// バージョンNo |
|
85 |
/// </summary> |
|
86 |
public int VersionNo |
|
87 |
{ |
|
88 |
get { return m_VersionNo; } |
|
89 |
set { m_VersionNo = value; } |
|
90 |
} |
|
84 | 91 |
#endregion |
85 | 92 |
|
86 | 93 |
} |
branches/src/ProcessManagement/ProcessManagement/DataModel/RequestData.cs | ||
---|---|---|
15 | 15 |
private int m_RequestNo = 0; // 請求No |
16 | 16 |
private int m_MainConstructionCode = 0; // 本工事番号 |
17 | 17 |
private string m_ConstructionName = ""; // 工事件名 |
18 |
private int m_ContractAmount = 0; // 請負金額
|
|
19 |
private int m_PaidAmount = 0; // 請求済金額
|
|
20 |
private int m_RequestAmount0 = 0; // 請求金額0
|
|
21 |
private int m_RequestAmount1 = 0; // 請求金額1
|
|
22 |
private int m_RequestAmount2 = 0; // 請求金額2
|
|
23 |
private int m_RequestAmount3 = 0; // 請求金額3
|
|
24 |
private int m_RequestAmount4 = 0; // 請求金額4
|
|
25 |
private int m_RequestAmount5 = 0; // 請求金額5
|
|
26 |
private int m_RequestAmount6 = 0; // 請求金額6
|
|
27 |
private int m_UnclaimedAmount = 0; // 請求残金額
|
|
28 |
private int m_UnpaidAmount = 0; // 未入金金額
|
|
29 |
private int m_TaxAmount = 0; // 消費税
|
|
18 |
private long m_ContractAmount = 0; // 請負金額
|
|
19 |
private long m_PaidAmount = 0; // 請求済金額
|
|
20 |
private long m_RequestAmount0 = 0; // 請求金額0
|
|
21 |
private long m_RequestAmount1 = 0; // 請求金額1
|
|
22 |
private long m_RequestAmount2 = 0; // 請求金額2
|
|
23 |
private long m_RequestAmount3 = 0; // 請求金額3
|
|
24 |
private long m_RequestAmount4 = 0; // 請求金額4
|
|
25 |
private long m_RequestAmount5 = 0; // 請求金額5
|
|
26 |
private long m_RequestAmount6 = 0; // 請求金額6
|
|
27 |
private long m_UnclaimedAmount = 0; // 請求残金額
|
|
28 |
private long m_UnpaidAmount = 0; // 未入金金額
|
|
29 |
private long m_TaxAmount = 0; // 消費税
|
|
30 | 30 |
private string m_Note = ""; // 備考 |
31 | 31 |
private DateTime m_EntryDate = DateTime.Now; // 登録日付 |
32 | 32 |
private DateTime m_UpdateDate = DateTime.Now; // 更新日付 |
... | ... | |
66 | 66 |
/// <summary> |
67 | 67 |
/// 請負金額 |
68 | 68 |
/// </summary> |
69 |
public int ContractAmount
|
|
69 |
public long ContractAmount
|
|
70 | 70 |
{ |
71 | 71 |
get { return m_ContractAmount; } |
72 | 72 |
set { m_ContractAmount = value; } |
... | ... | |
75 | 75 |
/// <summary> |
76 | 76 |
/// 請求済金額 |
77 | 77 |
/// </summary> |
78 |
public int PaidAmount
|
|
78 |
public long PaidAmount
|
|
79 | 79 |
{ |
80 | 80 |
get { return m_PaidAmount; } |
81 | 81 |
set { m_PaidAmount = value; } |
... | ... | |
84 | 84 |
/// <summary> |
85 | 85 |
/// 請求金額0 |
86 | 86 |
/// </summary> |
87 |
public int RequestAmount0
|
|
87 |
public long RequestAmount0
|
|
88 | 88 |
{ |
89 | 89 |
get { return m_RequestAmount0; } |
90 | 90 |
set { m_RequestAmount0 = value; } |
... | ... | |
93 | 93 |
/// <summary> |
94 | 94 |
/// 請求金額1 |
95 | 95 |
/// </summary> |
96 |
public int RequestAmount1
|
|
96 |
public long RequestAmount1
|
|
97 | 97 |
{ |
98 | 98 |
get { return m_RequestAmount1; } |
99 | 99 |
set { m_RequestAmount1 = value; } |
... | ... | |
102 | 102 |
/// <summary> |
103 | 103 |
/// 請求金額2 |
104 | 104 |
/// </summary> |
105 |
public int RequestAmount2
|
|
105 |
public long RequestAmount2
|
|
106 | 106 |
{ |
107 | 107 |
get { return m_RequestAmount2; } |
108 | 108 |
set { m_RequestAmount2 = value; } |
... | ... | |
111 | 111 |
/// <summary> |
112 | 112 |
/// 請求金額3 |
113 | 113 |
/// </summary> |
114 |
public int RequestAmount3
|
|
114 |
public long RequestAmount3
|
|
115 | 115 |
{ |
116 | 116 |
get { return m_RequestAmount3; } |
117 | 117 |
set { m_RequestAmount3 = value; } |
... | ... | |
120 | 120 |
/// <summary> |
121 | 121 |
/// 請求金額4 |
122 | 122 |
/// </summary> |
123 |
public int RequestAmount4
|
|
123 |
public long RequestAmount4
|
|
124 | 124 |
{ |
125 | 125 |
get { return m_RequestAmount4; } |
126 | 126 |
set { m_RequestAmount4 = value; } |
... | ... | |
129 | 129 |
/// <summary> |
130 | 130 |
/// 請求金額5 |
131 | 131 |
/// </summary> |
132 |
public int RequestAmount5
|
|
132 |
public long RequestAmount5
|
|
133 | 133 |
{ |
134 | 134 |
get { return m_RequestAmount5; } |
135 | 135 |
set { m_RequestAmount5 = value; } |
... | ... | |
138 | 138 |
/// <summary> |
139 | 139 |
/// 請求金額6 |
140 | 140 |
/// </summary> |
141 |
public int RequestAmount6
|
|
141 |
public long RequestAmount6
|
|
142 | 142 |
{ |
143 | 143 |
get { return m_RequestAmount6; } |
144 | 144 |
set { m_RequestAmount6 = value; } |
... | ... | |
147 | 147 |
/// <summary> |
148 | 148 |
/// 請求残金額 |
149 | 149 |
/// </summary> |
150 |
public int UnclaimedAmount
|
|
150 |
public long UnclaimedAmount
|
|
151 | 151 |
{ |
152 | 152 |
get { return m_UnclaimedAmount; } |
153 | 153 |
set { m_UnclaimedAmount = value; } |
... | ... | |
156 | 156 |
/// <summary> |
157 | 157 |
/// 未入金金額 |
158 | 158 |
/// </summary> |
159 |
public int UnpaidAmount
|
|
159 |
public long UnpaidAmount
|
|
160 | 160 |
{ |
161 | 161 |
get { return m_UnpaidAmount; } |
162 | 162 |
set { m_UnpaidAmount = value; } |
... | ... | |
165 | 165 |
/// <summary> |
166 | 166 |
/// 消費税 |
167 | 167 |
/// </summary> |
168 |
public int TaxAmount
|
|
168 |
public long TaxAmount
|
|
169 | 169 |
{ |
170 | 170 |
get { return m_TaxAmount; } |
171 | 171 |
set { m_TaxAmount = value; } |
branches/src/ProcessManagement/ProcessManagement/DataModel/RequestDataDetail.cs | ||
---|---|---|
16 | 16 |
private int m_MainConstructionCode = 0; // 本工事番号 |
17 | 17 |
private int m_ConstructionCode = 0; // 工事番号 |
18 | 18 |
private int m_ConstructionKind = 0; // 工事区分 |
19 |
private int m_RequestAmount = 0; // 請求金額
|
|
20 |
private int m_TaxAmount = 0; // 消費税
|
|
19 |
private long m_RequestAmount = 0; // 請求金額
|
|
20 |
private long m_TaxAmount = 0; // 消費税
|
|
21 | 21 |
private DateTime m_EntryDate = DateTime.Now; // 登録日付 |
22 | 22 |
private DateTime m_UpdateDate = DateTime.Now; // 更新日付 |
23 | 23 |
#endregion |
... | ... | |
66 | 66 |
/// <summary> |
67 | 67 |
/// 請求金額 |
68 | 68 |
/// </summary> |
69 |
public int RequestAmount
|
|
69 |
public long RequestAmount
|
|
70 | 70 |
{ |
71 | 71 |
get { return m_RequestAmount; } |
72 | 72 |
set { m_RequestAmount = value; } |
... | ... | |
75 | 75 |
/// <summary> |
76 | 76 |
/// 消費税 |
77 | 77 |
/// </summary> |
78 |
public int TaxAmount
|
|
78 |
public long TaxAmount
|
|
79 | 79 |
{ |
80 | 80 |
get { return m_TaxAmount; } |
81 | 81 |
set { m_TaxAmount = value; } |
branches/src/ProcessManagement/ProcessManagement/DataModel/RequestHead.cs | ||
---|---|---|
20 | 20 |
private int m_OrderersCode = 0; // 発注者コード |
21 | 21 |
private string m_OrderersName = ""; // 発注者名 |
22 | 22 |
private string m_ReqConstructionName = ""; // 請求工事件名 |
23 |
private int m_RequestTotalAmount = 0; // 請求金額合計
|
|
24 |
private int m_RequestAmount = 0; // 請求金額
|
|
25 |
private int m_TaxAmount = 0; // 消費税
|
|
26 |
private int m_UnpaidAmount = 0; // 未入金
|
|
23 |
private long m_RequestTotalAmount = 0; // 請求金額合計
|
|
24 |
private long m_RequestAmount = 0; // 請求金額
|
|
25 |
private long m_TaxAmount = 0; // 消費税
|
|
26 |
private long m_UnpaidAmount = 0; // 未入金
|
|
27 | 27 |
private string m_Note =""; // 備考 |
28 | 28 |
private int m_AssignedFlg = 0; // 割当済フラグ |
29 | 29 |
private int m_InvoiceNo = 0; // 請求書No |
... | ... | |
110 | 110 |
/// <summary> |
111 | 111 |
/// 請求金額合計 |
112 | 112 |
/// </summary> |
113 |
public int RequestTotalAmount
|
|
113 |
public long RequestTotalAmount
|
|
114 | 114 |
{ |
115 | 115 |
get { return m_RequestTotalAmount; } |
116 | 116 |
set { m_RequestTotalAmount = value; } |
... | ... | |
119 | 119 |
/// <summary> |
120 | 120 |
/// 請求金額 |
121 | 121 |
/// </summary> |
122 |
public int RequestAmount
|
|
122 |
public long RequestAmount
|
|
123 | 123 |
{ |
124 | 124 |
get { return m_RequestAmount; } |
125 | 125 |
set { m_RequestAmount = value; } |
... | ... | |
128 | 128 |
/// <summary> |
129 | 129 |
/// 消費税 |
130 | 130 |
/// </summary> |
131 |
public int TaxAmount
|
|
131 |
public long TaxAmount
|
|
132 | 132 |
{ |
133 | 133 |
get { return m_TaxAmount; } |
134 | 134 |
set { m_TaxAmount = value; } |
... | ... | |
137 | 137 |
/// <summary> |
138 | 138 |
/// 未入金 |
139 | 139 |
/// </summary> |
140 |
public int UnpaidAmount
|
|
140 |
public long UnpaidAmount
|
|
141 | 141 |
{ |
142 | 142 |
get { return m_UnpaidAmount; } |
143 | 143 |
set { m_UnpaidAmount = value; } |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/FrmRegField.Designer.cs | ||
---|---|---|
48 | 48 |
this.dataGridViewTextBoxColumn3 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
49 | 49 |
this.col99 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
50 | 50 |
this.dgv1 = new System.Windows.Forms.DataGridView(); |
51 |
this.btnAccept = new System.Windows.Forms.Button(); |
|
51 | 52 |
this.ConstructionCode = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
52 | 53 |
this.col000 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
53 | 54 |
this.col001 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
54 | 55 |
this.col002 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
55 | 56 |
this.ReadOnly = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
56 |
this.btnAccept = new System.Windows.Forms.Button();
|
|
57 |
this.KeyNo = new System.Windows.Forms.DataGridViewTextBoxColumn();
|
|
57 | 58 |
((System.ComponentModel.ISupportInitialize)(this.dgv2)).BeginInit(); |
58 | 59 |
((System.ComponentModel.ISupportInitialize)(this.dgv1)).BeginInit(); |
59 | 60 |
this.SuspendLayout(); |
... | ... | |
219 | 220 |
this.col000, |
220 | 221 |
this.col001, |
221 | 222 |
this.col002, |
222 |
this.ReadOnly}); |
|
223 |
this.ReadOnly, |
|
224 |
this.KeyNo}); |
|
223 | 225 |
this.dgv1.Location = new System.Drawing.Point(12, 51); |
224 | 226 |
this.dgv1.Name = "dgv1"; |
225 | 227 |
dataGridViewCellStyle8.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; |
... | ... | |
240 | 242 |
this.dgv1.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgv1_CellValueChanged); |
241 | 243 |
this.dgv1.SelectionChanged += new System.EventHandler(this.dgv1_SelectionChanged); |
242 | 244 |
// |
245 |
// btnAccept |
|
246 |
// |
|
247 |
this.btnAccept.BackColor = System.Drawing.Color.Lime; |
|
248 |
this.btnAccept.ForeColor = System.Drawing.Color.Black; |
|
249 |
this.btnAccept.Location = new System.Drawing.Point(376, 270); |
|
250 |
this.btnAccept.Name = "btnAccept"; |
|
251 |
this.btnAccept.Size = new System.Drawing.Size(120, 32); |
|
252 |
this.btnAccept.TabIndex = 10; |
|
253 |
this.btnAccept.Text = "登 録"; |
|
254 |
this.btnAccept.UseVisualStyleBackColor = false; |
|
255 |
this.btnAccept.Click += new System.EventHandler(this.btnAccept_Click); |
|
256 |
// |
|
243 | 257 |
// ConstructionCode |
244 | 258 |
// |
245 | 259 |
this.ConstructionCode.HeaderText = "ConstructionCode"; |
... | ... | |
286 | 300 |
this.ReadOnly.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
287 | 301 |
this.ReadOnly.Visible = false; |
288 | 302 |
// |
289 |
// btnAccept
|
|
303 |
// KeyNo
|
|
290 | 304 |
// |
291 |
this.btnAccept.BackColor = System.Drawing.Color.Lime; |
|
292 |
this.btnAccept.ForeColor = System.Drawing.Color.Black; |
|
293 |
this.btnAccept.Location = new System.Drawing.Point(376, 270); |
|
294 |
this.btnAccept.Name = "btnAccept"; |
|
295 |
this.btnAccept.Size = new System.Drawing.Size(120, 32); |
|
296 |
this.btnAccept.TabIndex = 10; |
|
297 |
this.btnAccept.Text = "登 録"; |
|
298 |
this.btnAccept.UseVisualStyleBackColor = false; |
|
299 |
this.btnAccept.Click += new System.EventHandler(this.btnAccept_Click); |
|
305 |
this.KeyNo.HeaderText = "KeyNo"; |
|
306 |
this.KeyNo.Name = "KeyNo"; |
|
307 |
this.KeyNo.ReadOnly = true; |
|
308 |
this.KeyNo.Resizable = System.Windows.Forms.DataGridViewTriState.False; |
|
309 |
this.KeyNo.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
|
310 |
this.KeyNo.Visible = false; |
|
300 | 311 |
// |
301 | 312 |
// FrmRegField |
302 | 313 |
// |
... | ... | |
346 | 357 |
private System.Windows.Forms.DataGridViewTextBoxColumn col001; |
347 | 358 |
private System.Windows.Forms.DataGridViewTextBoxColumn col002; |
348 | 359 |
private System.Windows.Forms.DataGridViewTextBoxColumn ReadOnly; |
360 |
private System.Windows.Forms.DataGridViewTextBoxColumn KeyNo; |
|
349 | 361 |
} |
350 | 362 |
} |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/FrmRegField.cs | ||
---|---|---|
31 | 31 |
No, // 行番号 |
32 | 32 |
ConstructionName, // 現場名 |
33 | 33 |
BillPrice, // 金額 |
34 |
ReadOnly, |
|
34 |
ReadOnly, // 読み取り専用フラグ |
|
35 |
LineCount, // 行番号 |
|
35 | 36 |
} |
36 | 37 |
#endregion |
37 | 38 |
|
... | ... | |
106 | 107 |
} |
107 | 108 |
#endregion |
108 | 109 |
|
110 |
#region キーを作成する |
|
111 |
/// <summary> |
|
112 |
/// キーを作成する |
|
113 |
/// </summary> |
|
114 |
/// <param name="nSeqNo"></param> |
|
115 |
/// <param name="nLineCount"></param> |
|
116 |
/// <returns></returns> |
|
117 |
private int getKeyNo(int nSeqNo, int nLineCount) |
|
118 |
{ |
|
119 |
int nKeyNo = nSeqNo * 100 + nLineCount; |
|
120 |
|
|
121 |
return nKeyNo; |
|
122 |
} |
|
123 |
#endregion |
|
124 |
|
|
125 |
#region 該当工事既存判定 |
|
126 |
/// <summary> |
|
127 |
/// 該当工事既存判定 |
|
128 |
/// </summary> |
|
129 |
/// <param name="nConstructionCode"></param> |
|
130 |
/// <returns></returns> |
|
131 |
private bool isExistConstructionRow(int nConstructionCode) |
|
132 |
{ |
|
133 |
foreach (DataGridViewRow r in m_HtGridRowConstructionCode.Values) |
|
134 |
{ |
|
135 |
if (int.Parse(r.Cells[(int)ColumnIndex.ConstructionCode].Value.ToString()) == nConstructionCode) |
|
136 |
{ |
|
137 |
return true; |
|
138 |
} |
|
139 |
} |
|
140 |
|
|
141 |
return false; |
|
142 |
} |
|
143 |
#endregion |
|
144 |
|
|
145 |
#region 行を取得 |
|
146 |
/// <summary> |
|
147 |
/// 行を取得 |
|
148 |
/// </summary> |
|
149 |
/// <param name="nKeyNo"></param> |
|
150 |
/// <returns></returns> |
|
151 |
private DataGridViewRow GetConstructionRow(int nKeyNo) |
|
152 |
{ |
|
153 |
|
|
154 |
foreach (DataGridViewRow r in m_HtGridRowConstructionCode.Values) |
|
155 |
{ |
|
156 |
int wrk = int.Parse(r.Cells[(int)ColumnIndex.LineCount].Value.ToString()); |
|
157 |
|
|
158 |
if( wrk == -1 ){ |
|
159 |
continue; |
|
160 |
} |
|
161 |
|
|
162 |
if ( wrk == nKeyNo) |
|
163 |
{ |
|
164 |
return r; |
|
165 |
} |
|
166 |
} |
|
167 |
|
|
168 |
return null; |
|
169 |
} |
|
170 |
#endregion |
|
171 |
|
|
109 | 172 |
#region 現場追加ボタン押下 |
110 | 173 |
/// <summary> |
111 | 174 |
/// 現場追加ボタン押下 |
... | ... | |
133 | 196 |
// 選択結果判定 OKなら以下の処理を実行する |
134 | 197 |
if (frmConstructionDiag.EndButton == DialogResult.OK) |
135 | 198 |
{ |
136 |
// 同じ現場コードの行を探す |
|
137 |
if (!m_HtGridRowConstructionCode.ContainsKey(frmConstructionDiag.ConstructionCode)) |
|
199 |
if (isExistConstructionRow(frmConstructionDiag.ConstructionCode) == true) |
|
138 | 200 |
{ |
139 |
// 見つからなかった場合は現場を追加 |
|
201 |
if (MessageBox.Show("既に同一工事が存在しますが追加してよろしいですか?", "現場追加", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) |
|
202 |
{ |
|
203 |
return; |
|
204 |
} |
|
205 |
} |
|
140 | 206 |
|
141 |
// 行番号付番
|
|
142 |
int rowCount = dgv1.RowCount - 1;
|
|
207 |
// 行番号付番 |
|
208 |
int rowCount = dgv1.RowCount - 1; |
|
143 | 209 |
|
144 |
// 現場の追加
|
|
145 |
dgv1.Rows.Add(frmConstructionDiag.ConstructionCode, rowCount, frmConstructionDiag.ConstructionName, 0, false);
|
|
146 |
dgv1.Rows[dgv1.RowCount - 1].Resizable = DataGridViewTriState.False;
|
|
147 |
dgv1[(int)ColumnIndex.BillPrice, dgv1.RowCount - 1].ReadOnly = false;
|
|
148 |
//dgv1[(int)ColumnIndex.BillPrice, dgv1.RowCount - 1].Style.Format = "#,0";
|
|
210 |
// 現場の追加 |
|
211 |
dgv1.Rows.Add(frmConstructionDiag.ConstructionCode, rowCount, frmConstructionDiag.ConstructionName, 0, false, -1);
|
|
212 |
dgv1.Rows[dgv1.RowCount - 1].Resizable = DataGridViewTriState.False; |
|
213 |
dgv1[(int)ColumnIndex.BillPrice, dgv1.RowCount - 1].ReadOnly = false; |
|
214 |
//dgv1[(int)ColumnIndex.BillPrice, dgv1.RowCount - 1].Style.Format = "#,0"; |
|
149 | 215 |
|
150 |
// ハッシュテーブルに追加 |
|
151 |
m_HtGridRowConstructionCode.Add(frmConstructionDiag.ConstructionCode, dgv1.Rows[dgv1.RowCount - 1]); |
|
152 |
} |
|
216 |
// ハッシュテーブルに追加 |
|
217 |
m_HtGridRowConstructionCode.Add(rowCount, dgv1.Rows[dgv1.RowCount - 1]); |
|
153 | 218 |
|
154 | 219 |
} |
155 | 220 |
|
... | ... | |
182 | 247 |
foreach (DataGridViewRow gridRow in dgv1.SelectedRows) |
183 | 248 |
{ |
184 | 249 |
// ハッシュテーブルから選択行を削除する |
185 |
m_HtGridRowConstructionCode.Remove((int)gridRow.Cells[(int)ColumnIndex.ConstructionCode].Value);
|
|
250 |
m_HtGridRowConstructionCode.Remove((int)gridRow.Cells[(int)ColumnIndex.No].Value);
|
|
186 | 251 |
|
187 | 252 |
// Gridから選択行を削除する |
188 | 253 |
dgv1.Rows.Remove(gridRow); |
... | ... | |
243 | 308 |
continue; |
244 | 309 |
} |
245 | 310 |
|
246 |
if (m_HtGridRowConstructionCode.ContainsKey(detail.ConstructionCode)) |
|
311 |
int keyNo = getKeyNo(m_ConstructionFieldNameHeader.SeqNo, detail.LineCount); |
|
312 |
|
|
313 |
DataGridViewRow gridRow = GetConstructionRow(keyNo); |
|
314 |
|
|
315 |
if (gridRow != null) |
|
247 | 316 |
{ |
248 |
var gridRow = m_HtGridRowConstructionCode[detail.ConstructionCode] as DataGridViewRow; |
|
249 |
|
|
250 | 317 |
// 見つかったら 金額を取得、行を削除する |
251 | 318 |
detail.BillPrice = CommonMotions.cnvInt(gridRow.Cells[(int)ColumnIndex.BillPrice].Value); |
252 | 319 |
if (detail.BillPrice == 0) |
... | ... | |
504 | 571 |
dgv2.Rows.Add(0, "", "不明", 0); |
505 | 572 |
|
506 | 573 |
// 各現場の行を追加 |
507 |
int rowCount = 0;
|
|
574 |
int rowCount = 1;
|
|
508 | 575 |
foreach (var detail in m_ConstructionFieldNameHeader.ConstructionFieldNameDetails) |
509 | 576 |
{ |
510 |
if(detail.ConstructionCode != 0 )
|
|
577 |
if (detail.ConstructionCode != 0)
|
|
511 | 578 |
{ |
512 | 579 |
// 各個現場の行を追加 |
513 |
dgv1.Rows.Add(detail.ConstructionCode, ++rowCount, detail.FieldName, detail.BillPrice, detail.ReadOnly);
|
|
580 |
dgv1.Rows.Add(detail.ConstructionCode, rowCount, detail.FieldName, detail.BillPrice, detail.ReadOnly, getKeyNo(m_ConstructionFieldNameHeader.SeqNo, detail.LineCount));
|
|
514 | 581 |
dgv1.Rows[dgv1.RowCount - 1].Resizable = DataGridViewTriState.False; |
515 | 582 |
dgv1.Rows[dgv1.RowCount - 1].Cells[(int)ColumnIndex.BillPrice].ReadOnly = detail.ReadOnly; // ReadOnlyフラグがtrueなら金額のセルを編集不可にする |
583 |
|
|
584 |
// m_HtDetailLineCount.Add(rowCount, detail); |
|
585 |
m_HtGridRowConstructionCode.Add(rowCount, dgv1.Rows[dgv1.RowCount - 1]); |
|
586 |
rowCount++; |
|
516 | 587 |
} |
517 |
|
|
518 |
// ハッシュテーブルの追加 |
|
519 |
//m_HtDetailLineCount.Add(detail.LineCount, detail); //Update Mjurakami |
|
520 |
m_HtDetailLineCount.Add(detail.ConstructionCode, detail); |
|
521 |
m_HtGridRowConstructionCode.Add(detail.ConstructionCode, dgv1.Rows[dgv1.RowCount - 1]); |
|
588 |
else |
|
589 |
{ |
|
590 |
m_HtDetailLineCount.Add(0, detail); |
|
591 |
} |
|
522 | 592 |
} |
523 | 593 |
|
524 | 594 |
// 不明行を再計算して表示 |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/FrmRegField.resx | ||
---|---|---|
147 | 147 |
<metadata name="ReadOnly.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
148 | 148 |
<value>True</value> |
149 | 149 |
</metadata> |
150 |
<metadata name="KeyNo.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
|
151 |
<value>True</value> |
|
152 |
</metadata> |
|
150 | 153 |
</root> |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/FrmSelectRegField.Designer.cs | ||
---|---|---|
31 | 31 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle(); |
32 | 32 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle(); |
33 | 33 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle(); |
34 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); |
|
34 | 35 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle(); |
35 | 36 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle8 = new System.Windows.Forms.DataGridViewCellStyle(); |
36 | 37 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle(); |
37 | 38 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle(); |
38 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); |
|
39 | 39 |
this.label1 = new System.Windows.Forms.Label(); |
40 | 40 |
this.tboxCompany = new System.Windows.Forms.TextBox(); |
41 | 41 |
this.btnAdd = new System.Windows.Forms.Button(); |
42 | 42 |
this.btnDelete = new System.Windows.Forms.Button(); |
43 | 43 |
this.btnEnd = new System.Windows.Forms.Button(); |
44 | 44 |
this.dgv2 = new System.Windows.Forms.DataGridView(); |
45 |
this.ConstructionCode2 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
46 |
this.OrderNo2 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
47 |
this.dataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
48 |
this.dataGridViewTextBoxColumn2 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
49 |
this.dataGridViewTextBoxColumn3 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
50 |
this.col99 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
45 | 51 |
this.dgv1 = new System.Windows.Forms.DataGridView(); |
46 | 52 |
this.btnAccept = new System.Windows.Forms.Button(); |
47 | 53 |
this.ConstructionCode = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
... | ... | |
50 | 56 |
this.col001 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
51 | 57 |
this.col002 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
52 | 58 |
this.ReadOnly = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
53 |
this.ConstructionCode2 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
54 |
this.OrderNo2 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
55 |
this.dataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
56 |
this.dataGridViewTextBoxColumn2 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
57 |
this.dataGridViewTextBoxColumn3 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
58 |
this.col99 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
59 | 59 |
((System.ComponentModel.ISupportInitialize)(this.dgv2)).BeginInit(); |
60 | 60 |
((System.ComponentModel.ISupportInitialize)(this.dgv1)).BeginInit(); |
61 | 61 |
this.SuspendLayout(); |
... | ... | |
158 | 158 |
this.dgv2.Size = new System.Drawing.Size(610, 24); |
159 | 159 |
this.dgv2.TabIndex = 9; |
160 | 160 |
// |
161 |
// ConstructionCode2 |
|
162 |
// |
|
163 |
this.ConstructionCode2.Frozen = true; |
|
164 |
this.ConstructionCode2.HeaderText = "■工事番号"; |
|
165 |
this.ConstructionCode2.Name = "ConstructionCode2"; |
|
166 |
this.ConstructionCode2.Visible = false; |
|
167 |
// |
|
168 |
// OrderNo2 |
|
169 |
// |
|
170 |
this.OrderNo2.Frozen = true; |
|
171 |
this.OrderNo2.HeaderText = "■連番"; |
|
172 |
this.OrderNo2.Name = "OrderNo2"; |
|
173 |
this.OrderNo2.Visible = false; |
|
174 |
// |
|
175 |
// dataGridViewTextBoxColumn1 |
|
176 |
// |
|
177 |
this.dataGridViewTextBoxColumn1.Frozen = true; |
|
178 |
this.dataGridViewTextBoxColumn1.HeaderText = "No"; |
|
179 |
this.dataGridViewTextBoxColumn1.Name = "dataGridViewTextBoxColumn1"; |
|
180 |
this.dataGridViewTextBoxColumn1.ReadOnly = true; |
|
181 |
this.dataGridViewTextBoxColumn1.Resizable = System.Windows.Forms.DataGridViewTriState.False; |
|
182 |
this.dataGridViewTextBoxColumn1.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
|
183 |
this.dataGridViewTextBoxColumn1.Width = 40; |
|
184 |
// |
|
185 |
// dataGridViewTextBoxColumn2 |
|
186 |
// |
|
187 |
this.dataGridViewTextBoxColumn2.Frozen = true; |
|
188 |
this.dataGridViewTextBoxColumn2.HeaderText = "現 場 名"; |
|
189 |
this.dataGridViewTextBoxColumn2.Name = "dataGridViewTextBoxColumn2"; |
|
190 |
this.dataGridViewTextBoxColumn2.ReadOnly = true; |
|
191 |
this.dataGridViewTextBoxColumn2.Resizable = System.Windows.Forms.DataGridViewTriState.False; |
|
192 |
this.dataGridViewTextBoxColumn2.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
|
193 |
this.dataGridViewTextBoxColumn2.Width = 400; |
|
194 |
// |
|
195 |
// dataGridViewTextBoxColumn3 |
|
196 |
// |
|
197 |
dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; |
|
198 |
this.dataGridViewTextBoxColumn3.DefaultCellStyle = dataGridViewCellStyle2; |
|
199 |
this.dataGridViewTextBoxColumn3.Frozen = true; |
|
200 |
this.dataGridViewTextBoxColumn3.HeaderText = "金 額"; |
|
201 |
this.dataGridViewTextBoxColumn3.Name = "dataGridViewTextBoxColumn3"; |
|
202 |
this.dataGridViewTextBoxColumn3.ReadOnly = true; |
|
203 |
this.dataGridViewTextBoxColumn3.Resizable = System.Windows.Forms.DataGridViewTriState.False; |
|
204 |
this.dataGridViewTextBoxColumn3.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
|
205 |
this.dataGridViewTextBoxColumn3.Width = 150; |
|
206 |
// |
|
207 |
// col99 |
|
208 |
// |
|
209 |
this.col99.Frozen = true; |
|
210 |
this.col99.HeaderText = "col99"; |
|
211 |
this.col99.Name = "col99"; |
|
212 |
this.col99.ReadOnly = true; |
|
213 |
this.col99.Width = 24; |
|
214 |
// |
|
161 | 215 |
// dgv1 |
162 | 216 |
// |
163 | 217 |
this.dgv1.AllowUserToAddRows = false; |
... | ... | |
260 | 314 |
this.ReadOnly.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
261 | 315 |
this.ReadOnly.Visible = false; |
262 | 316 |
// |
263 |
// ConstructionCode2 |
|
264 |
// |
|
265 |
this.ConstructionCode2.Frozen = true; |
|
266 |
this.ConstructionCode2.HeaderText = "■工事番号"; |
|
267 |
this.ConstructionCode2.Name = "ConstructionCode2"; |
|
268 |
this.ConstructionCode2.Visible = false; |
|
269 |
// |
|
270 |
// OrderNo2 |
|
271 |
// |
|
272 |
this.OrderNo2.Frozen = true; |
|
273 |
this.OrderNo2.HeaderText = "■連番"; |
|
274 |
this.OrderNo2.Name = "OrderNo2"; |
|
275 |
this.OrderNo2.Visible = false; |
|
276 |
// |
|
277 |
// dataGridViewTextBoxColumn1 |
|
278 |
// |
|
279 |
this.dataGridViewTextBoxColumn1.Frozen = true; |
|
280 |
this.dataGridViewTextBoxColumn1.HeaderText = "No"; |
|
281 |
this.dataGridViewTextBoxColumn1.Name = "dataGridViewTextBoxColumn1"; |
|
282 |
this.dataGridViewTextBoxColumn1.ReadOnly = true; |
|
283 |
this.dataGridViewTextBoxColumn1.Resizable = System.Windows.Forms.DataGridViewTriState.False; |
|
284 |
this.dataGridViewTextBoxColumn1.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
|
285 |
this.dataGridViewTextBoxColumn1.Width = 40; |
|
286 |
// |
他の形式にエクスポート: Unified diff