リビジョン 257
請求まとめ（業者追加、現場追加されたデータが取得できなかった不具合の対応）
| branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestSummaryList/FrmRequestSummaryListAuxiliary.cs | ||
|---|---|---|
| 2203 | 2203 |
} |
| 2204 | 2204 |
#endregion |
| 2205 | 2205 |
|
| 2206 |
#region ?f?[?^??SQL???i?x?????F????j
|
|
| 2206 |
#region ?S??????F???????J???SQL??
|
|
| 2207 | 2207 |
/// <summary> |
| 2208 | 2208 |
/// ?f?[?^??SQL???i?x?????F????j |
| 2209 | 2209 |
/// </summary> |
| ... | ... | |
| 2357 | 2357 |
} |
| 2358 | 2358 |
#endregion |
| 2359 | 2359 |
|
| 2360 |
#region ?f?[?^??SQL???i?x?????F????j
|
|
| 2360 |
#region ???j???[???????J???SQL??
|
|
| 2361 | 2361 |
/// <summary> |
| 2362 | 2362 |
/// ?f?[?^??SQL???i?x?????F????j |
| 2363 | 2363 |
/// </summary> |
| ... | ... | |
| 2367 | 2367 |
{
|
| 2368 | 2368 |
try |
| 2369 | 2369 |
{
|
| 2370 |
sql.Append("select * from ( ");
|
|
| 2370 | 2371 |
sql.Append("select ");
|
| 2371 | 2372 |
sql.Append(" ifnull(Bd.SeqNo, 1) as SeqNo ");
|
| 2372 | 2373 |
sql.Append(" , ifnull(Bdd.LineCount, 0) as LineCount ");
|
| ... | ... | |
| 2575 | 2576 |
sql.Append(" and Bd.TargetDate = Bdd.TargetDate ");
|
| 2576 | 2577 |
sql.Append(" and Bd.SeqNo = Bdd.SeqNo ");
|
| 2577 | 2578 |
sql.AppendFormat(" and Bd.TargetDate = {0} ", m_Select_TargetDate);
|
| 2578 |
sql.Append(" and Bdd.CONSTRUCTIONCODE = 0 ");
|
|
| 2579 |
// TODO sql.Append(" and Bdd.CONSTRUCTIONCODE = 0 ");
|
|
| 2579 | 2580 |
sql.Append(" left join ( ");
|
| 2580 | 2581 |
sql.Append(" PurchaseOrderDate as Pod ");
|
| 2581 | 2582 |
sql.Append(" ) on Bd.CompanyCode = Pod.CompanyCode ");
|
| 2582 | 2583 |
sql.Append(" and Bdd.ConstructionCode = Pod.ConstructionCode ");
|
| 2583 | 2584 |
|
| 2584 |
sql.Append(" ");
|
|
| 2585 |
sql.Append(") AS T ");
|
|
| 2585 | 2586 |
|
| 2586 | 2587 |
sql.Append("group by ");
|
| 2587 |
sql.Append(" SeqNo ");
|
|
| 2588 |
sql.Append(" , LineCount ");
|
|
| 2589 |
sql.Append(" , CompanyCode ");
|
|
| 2590 |
sql.Append(" , CompanyName ");
|
|
| 2591 |
sql.Append(" , DisplayOrder ");
|
|
| 2592 |
sql.Append(" , ConstructionCode ");
|
|
| 2593 |
sql.Append(" , FieldName ");
|
|
| 2594 |
sql.Append(" , BillPrice ");
|
|
| 2595 |
sql.Append(" , HighwPrice ");
|
|
| 2596 |
sql.Append(" , Hardwprice ");
|
|
| 2597 |
sql.Append(" , IndswasteTax ");
|
|
| 2598 |
sql.Append(" , UpdateDate ");
|
|
| 2599 |
sql.Append(" , Bikou ");
|
|
| 2600 |
sql.Append(" , KojiSeikyu ");
|
|
| 2601 |
sql.Append(" , KojiNebiki ");
|
|
| 2602 |
sql.Append(" , KojiSousai ");
|
|
| 2603 |
sql.Append(" , JikaiKurikosi ");
|
|
| 2604 |
sql.Append(" , KojiKousoku ");
|
|
| 2605 |
sql.Append(" , KojiKanamono ");
|
|
| 2606 |
sql.Append(" , KojiSannhaiZei ");
|
|
| 2607 |
sql.Append(" , CnstrPrice ");
|
|
| 2608 |
sql.Append(" , CnstrpriceExist ");
|
|
| 2609 |
sql.Append(" , ApprovalPersonCode ");
|
|
| 2610 |
sql.Append(" , TantoNM ");
|
|
| 2611 |
sql.Append(" , ApprovalDate ");
|
|
| 2612 |
sql.Append(" , ApprovalEndFlg ");
|
|
| 2613 |
sql.Append(" , SalesPersonCode ");
|
|
| 2614 |
sql.Append(" , ConstructionPersonCode ");
|
|
| 2615 |
sql.Append(" , ConstrSubPersonCode ");
|
|
| 2616 |
sql.Append(" , ConstructionInstructor ");
|
|
| 2617 |
sql.Append(" , DepartmentCode ");
|
|
| 2618 |
sql.Append(" , PurchaseOrderMailingDate ");
|
|
| 2619 |
sql.Append(" , PurchaseOrderReturnDate ");
|
|
| 2620 |
sql.Append(" , PaData ");
|
|
| 2621 |
sql.Append(" , LinePoint ");
|
|
| 2622 |
sql.Append(" , ColPoint ");
|
|
| 2588 |
sql.Append(" T.SeqNo ");
|
|
| 2589 |
sql.Append(" , T.LineCount ");
|
|
| 2590 |
sql.Append(" , T.CompanyCode ");
|
|
| 2591 |
sql.Append(" , T.CompanyName ");
|
|
| 2592 |
sql.Append(" , T.DisplayOrder ");
|
|
| 2593 |
sql.Append(" , T.ConstructionCode ");
|
|
| 2594 |
sql.Append(" , T.FieldName ");
|
|
| 2595 |
sql.Append(" , T.BillPrice ");
|
|
| 2596 |
sql.Append(" , T.HighwPrice ");
|
|
| 2597 |
sql.Append(" , T.Hardwprice ");
|
|
| 2598 |
sql.Append(" , T.IndswasteTax ");
|
|
| 2599 |
sql.Append(" , T.UpdateDate ");
|
|
| 2600 |
sql.Append(" , T.Bikou ");
|
|
| 2601 |
sql.Append(" , T.KojiSeikyu ");
|
|
| 2602 |
sql.Append(" , T.KojiNebiki ");
|
|
| 2603 |
sql.Append(" , T.KojiSousai ");
|
|
| 2604 |
sql.Append(" , T.JikaiKurikosi ");
|
|
| 2605 |
sql.Append(" , T.KojiKousoku ");
|
|
| 2606 |
sql.Append(" , T.KojiKanamono ");
|
|
| 2607 |
sql.Append(" , T.KojiSannhaiZei ");
|
|
| 2608 |
sql.Append(" , T.CnstrPrice ");
|
|
| 2609 |
sql.Append(" , T.CnstrpriceExist ");
|
|
| 2610 |
sql.Append(" , T.ApprovalPersonCode ");
|
|
| 2611 |
sql.Append(" , T.TantoNM ");
|
|
| 2612 |
sql.Append(" , T.ApprovalDate ");
|
|
| 2613 |
sql.Append(" , T.ApprovalEndFlg ");
|
|
| 2614 |
sql.Append(" , T.SalesPersonCode ");
|
|
| 2615 |
sql.Append(" , T.ConstructionPersonCode ");
|
|
| 2616 |
sql.Append(" , T.ConstrSubPersonCode ");
|
|
| 2617 |
sql.Append(" , T.ConstructionInstructor ");
|
|
| 2618 |
sql.Append(" , T.DepartmentCode ");
|
|
| 2619 |
sql.Append(" , T.PurchaseOrderMailingDate ");
|
|
| 2620 |
sql.Append(" , T.PurchaseOrderReturnDate ");
|
|
| 2621 |
sql.Append(" , T.PaData ");
|
|
| 2623 | 2622 |
} |
| 2624 | 2623 |
catch (Exception ex) |
| 2625 | 2624 |
{
|
他の形式にエクスポート: Unified diff