リビジョン 334
IOクラス一括インサートバグ修正
経過給与計算・支払済み給与計算修正
| branches/src/ProcessManagement/ProcessManagement/Common/CommonMotions.cs | ||
|---|---|---|
| 2741 | 2741 |
strSQL.AppendFormat(" AND DATE(CONCAT(A1.years, '/', A2.month, '/', A3.days)) <= DATE('{0}'))", dtLast.ToShortDateString());
|
| 2742 | 2742 |
strSQL.Append(" ORDER BY d) A");
|
| 2743 | 2743 |
strSQL.Append(", PERSONSALARYMASTER AS B");
|
| 2744 |
strSQL.Append(" WHERE B.STARTDATE <= A.d");
|
|
| 2745 |
strSQL.AppendFormat(" AND B.PERSONCODE = {0}", PersonCode);
|
|
| 2744 |
strSQL.AppendFormat(" WHERE B.PERSONCODE = {0}", PersonCode);
|
|
| 2745 |
strSQL.Append(" AND B.STARTDATE <= A.d");
|
|
| 2746 | 2746 |
strSQL.Append(" ORDER BY A.d, B.STARTDATE DESC) AS AX");
|
| 2747 | 2747 |
strSQL.Append(" GROUP BY AX.hiduke");
|
| 2748 | 2748 |
strSQL.Append(" ORDER BY AX.hiduke");
|
| 2749 | 2749 |
strSQL.Append(" ) AS SAL");
|
| 2750 | 2750 |
|
| 2751 | 2751 |
ArrayList ArData = new ArrayList(); |
| 2752 |
SalDB.ExecuteReader(strSQL.ToString(), ref ArData);
|
|
| 2752 |
if(!SalDB.ExecuteReader(strSQL.ToString(), ref ArData)) return 0;
|
|
| 2753 | 2753 |
|
| 2754 | 2754 |
foreach (object[] objRec in ArData) |
| 2755 | 2755 |
{
|
| ... | ... | |
| 2771 | 2771 |
/// 期間より零れた経過給与を取得する |
| 2772 | 2772 |
/// </summary> |
| 2773 | 2773 |
/// <returns></returns> |
| 2774 |
public static int CalcSpilledSalary(IOMPersonInCharge SalDB, int TargetYear, DateTime dtStart, DateTime dtLast, int PersonCode) |
|
| 2774 |
public static void CalcSpilledSalary(IOMPersonInCharge SalDB |
|
| 2775 |
, int TargetYear, DateTime dtStart, DateTime dtLast |
|
| 2776 |
, int PersonCode |
|
| 2777 |
, ref int NextDiffDay |
|
| 2778 |
, ref int PrevDiffDay) |
|
| 2775 | 2779 |
{
|
| 2776 | 2780 |
try |
| 2777 | 2781 |
{
|
| 2778 |
int RetSalary = 0; |
|
| 2779 | 2782 |
|
| 2783 |
DateTime dtDefaultEnd = CommonMotions.GetOpeningEndDate(TargetYear, false); |
|
| 2784 |
|
|
| 2780 | 2785 |
StringBuilder strSQL = new StringBuilder(); |
| 2781 |
|
|
| 2782 | 2786 |
strSQL.Append("Select");
|
| 2783 | 2787 |
strSQL.Append(" Base.ConstructionCode");
|
| 2784 | 2788 |
strSQL.Append(", Ledger.ConstructionStart");
|
| ... | ... | |
| 2786 | 2790 |
strSQL.Append(", LDetail.GroupCount");
|
| 2787 | 2791 |
strSQL.Append(", LDetail.SalaryFlg");
|
| 2788 | 2792 |
strSQL.Append(", LDetail.SalaryDays");
|
| 2789 |
strSQL.Append(", Salary.SalaryPerson");
|
|
| 2790 |
strSQL.Append(", Salary.DaySalary");
|
|
| 2791 |
strSQL.Append(", (LDetail.SalaryDays * Salary.DaySalary) As SalVal");
|
|
| 2792 | 2793 |
strSQL.Append(" From");
|
| 2793 | 2794 |
strSQL.Append(" constructionbaseinfo As Base");
|
| 2794 | 2795 |
strSQL.Append(" Inner Join constructionledger As Ledger");
|
| ... | ... | |
| 2798 | 2799 |
strSQL.AppendFormat(" And LDetail.GroupCount = {0}", (int)FrmConstructionLedger.DataGroup.Payroll);
|
| 2799 | 2800 |
strSQL.AppendFormat(" And LDetail.CompanyCode = {0}", PersonCode);
|
| 2800 | 2801 |
strSQL.AppendFormat(" And LDetail.SalaryFlg = {0}", (int)CommonDefine.SalaryDevision.DaysInput);
|
| 2801 |
strSQL.Append(" Inner Join(");
|
|
| 2802 |
strSQL.Append(" Where");
|
|
| 2803 |
strSQL.AppendFormat(" Base.ConstructionPeriod = {0}", TargetYear);
|
|
| 2804 |
strSQL.AppendFormat(" And Base.ConstructionPersonCode = {0}", PersonCode);
|
|
| 2805 |
strSQL.Append(" And(");
|
|
| 2806 |
strSQL.AppendFormat("DATE('{0}') <= DATE(Ledger.ConstructionStart)", dtLast.ToShortDateString());
|
|
| 2807 |
strSQL.AppendFormat(" And DATE(Ledger.ConstructionEnd) <= DATE('{0}')", dtDefaultEnd.ToShortDateString());
|
|
| 2808 |
strSQL.Append(")");
|
|
| 2809 |
|
|
| 2810 |
ArrayList ArData = new ArrayList(); |
|
| 2811 |
if (!SalDB.ExecuteReader(strSQL.ToString(), ref ArData)) return; |
|
| 2812 |
|
|
| 2813 |
// 半端分の日数を取得する |
|
| 2814 |
NextDiffDay = ArData.Cast<object[]>().Sum(x => CommonMotions.cnvInt(x[5])); |
|
| 2815 |
|
|
| 2816 |
// 先期の半端分の日数を取得する |
|
| 2817 |
PrevDiffDay = CalcSpilledPreviusDay(SalDB, TargetYear, dtStart, PersonCode); |
|
| 2818 |
|
|
| 2819 |
} |
|
| 2820 |
catch (Exception ex) |
|
| 2821 |
{
|
|
| 2822 |
logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
|
|
| 2823 |
} |
|
| 2824 |
} |
|
| 2825 |
#endregion |
|
| 2826 |
|
|
| 2827 |
#region 先期の終了後零れた日数を取得する |
|
| 2828 |
/// <summary> |
|
| 2829 |
/// 先期の終了後零れた日数を取得する |
|
| 2830 |
/// </summary> |
|
| 2831 |
/// <returns></returns> |
|
| 2832 |
private static int CalcSpilledPreviusDay(IOMPersonInCharge SalDB |
|
| 2833 |
, int TargetYear, DateTime dtStart, int PersonCode) |
|
| 2834 |
{
|
|
| 2835 |
try |
|
| 2836 |
{
|
|
| 2837 |
int RetDay = 0; |
|
| 2838 |
|
|
| 2839 |
// 先期の期末を取得する |
|
| 2840 |
int PrevTargetYear = (TargetYear - 1); |
|
| 2841 |
if (PrevTargetYear < 1) return 0; |
|
| 2842 |
DateTime dtPrevEnd = CommonMotions.GetOpeningEndDate((TargetYear - 1), false); |
|
| 2843 |
|
|
| 2844 |
// 今期の最初が先期の最後より大きい場合は処理しない |
|
| 2845 |
if (dtPrevEnd< dtStart) return 0; |
|
| 2846 |
|
|
| 2847 |
StringBuilder strSQL = new StringBuilder(); |
|
| 2802 | 2848 |
strSQL.Append("Select");
|
| 2803 |
strSQL.Append(" B.PersonCode As SalaryPerson");
|
|
| 2804 |
strSQL.AppendFormat(", ROUND(B.MonthlySalary* {0} / 30) As DaySalary", CommonDefine.s_SalaryCorrection);
|
|
| 2849 |
strSQL.Append(" Base.ConstructionCode");
|
|
| 2850 |
strSQL.Append(", Ledger.ConstructionStart");
|
|
| 2851 |
strSQL.Append(", Ledger.ConstructionEnd");
|
|
| 2852 |
strSQL.Append(", LDetail.GroupCount");
|
|
| 2853 |
strSQL.Append(", LDetail.SalaryFlg");
|
|
| 2854 |
strSQL.Append(", LDetail.SalaryDays");
|
|
| 2805 | 2855 |
strSQL.Append(" From");
|
| 2806 |
strSQL.Append(" PERSONSALARYMASTER As B");
|
|
| 2856 |
strSQL.Append(" constructionbaseinfo As Base");
|
|
| 2857 |
strSQL.Append(" Inner Join constructionledger As Ledger");
|
|
| 2858 |
strSQL.Append(" On Ledger.ConstructionCode = Base.ConstructionCode");
|
|
| 2859 |
strSQL.Append(" Inner Join constructionledgerdetail As LDetail");
|
|
| 2860 |
strSQL.Append(" On LDetail.ConstructionCode = Base.ConstructionCode");
|
|
| 2861 |
strSQL.AppendFormat(" And LDetail.GroupCount = {0}", (int)FrmConstructionLedger.DataGroup.Payroll);
|
|
| 2862 |
strSQL.AppendFormat(" And LDetail.CompanyCode = {0}", PersonCode);
|
|
| 2863 |
strSQL.AppendFormat(" And LDetail.SalaryFlg = {0}", (int)CommonDefine.SalaryDevision.DaysInput);
|
|
| 2807 | 2864 |
strSQL.Append(" Where");
|
| 2808 |
strSQL.AppendFormat(" DATE(B.STARTDATE) <= DATE('{0}')", dtLast.ToShortDateString());
|
|
| 2809 |
strSQL.AppendFormat(" AND B.PERSONCODE = {0}", PersonCode);
|
|
| 2810 |
strSQL.Append(" Order By B.StartDate DESC limit 1");
|
|
| 2811 |
strSQL.Append(") AS Salary");
|
|
| 2812 |
strSQL.AppendFormat(" On Salary.SalaryPerson = {0}", PersonCode);
|
|
| 2813 |
strSQL.Append(" Where");
|
|
| 2814 |
strSQL.AppendFormat(" Base.ConstructionPeriod = {0}", TargetYear);
|
|
| 2865 |
strSQL.AppendFormat(" Base.ConstructionPeriod = {0}", PrevTargetYear);
|
|
| 2815 | 2866 |
strSQL.AppendFormat(" And Base.ConstructionPersonCode = {0}", PersonCode);
|
| 2816 | 2867 |
strSQL.Append(" And(");
|
| 2817 |
strSQL.AppendFormat("DATE('{0}') <= DATE(Ledger.ConstructionStart)", dtStart.ToShortDateString());
|
|
| 2818 |
strSQL.AppendFormat(" And DATE(Ledger.ConstructionEnd) <= DATE('{0}')", dtLast.ToShortDateString());
|
|
| 2868 |
strSQL.AppendFormat("DATE('{0}') <= DATE(Ledger.ConstructionStart)", (dtStart.AddDays(-1)).ToShortDateString());
|
|
| 2869 |
strSQL.AppendFormat(" And DATE(Ledger.ConstructionEnd) <= DATE('{0}')", dtPrevEnd.ToShortDateString());
|
|
| 2819 | 2870 |
strSQL.Append(")");
|
| 2820 | 2871 |
|
| 2821 | 2872 |
ArrayList ArData = new ArrayList(); |
| 2822 |
SalDB.ExecuteReader(strSQL.ToString(), ref ArData);
|
|
| 2873 |
if (!SalDB.ExecuteReader(strSQL.ToString(), ref ArData)) return 0;
|
|
| 2823 | 2874 |
|
| 2824 |
RetSalary = ArData.Cast<object[]>().Sum(x => CommonMotions.cnvInt(x[8])); |
|
| 2875 |
// 半端分の日数を取得する |
|
| 2876 |
RetDay = ArData.Cast<object[]>().Sum(x => CommonMotions.cnvInt(x[5])); |
|
| 2825 | 2877 |
|
| 2826 |
return RetSalary;
|
|
| 2878 |
return RetDay;
|
|
| 2827 | 2879 |
} |
| 2828 | 2880 |
catch (Exception ex) |
| 2829 | 2881 |
{
|
| 2830 | 2882 |
logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
|
| 2831 | 2883 |
return 0; |
| 2832 | 2884 |
} |
| 2833 |
|
|
| 2834 | 2885 |
} |
| 2835 | 2886 |
#endregion |
| 2836 | 2887 |
|
| ... | ... | |
| 2997 | 3048 |
{ // 今期は削除されていないもの
|
| 2998 | 3049 |
//strSQL.Append(" A.DELETEFLG = 0");
|
| 2999 | 3050 |
DateTime dtDefaultEnd = CommonMotions.GetOpeningEndDate(nTargetCount, false); |
| 3000 |
strSQL.AppendFormat(" DATE(A.StartDate) <= DATE('{0}')", dtDefaultEnd.ToShortDateString());
|
|
| 3051 |
|
|
| 3052 |
strSQL.AppendFormat(" C.ConstructionPeriod = {0}", nTargetCount);
|
|
| 3053 |
strSQL.AppendFormat(" And DATE(A.StartDate) <= DATE('{0}')", dtDefaultEnd.ToShortDateString());
|
|
| 3001 | 3054 |
// システム管理者以外は部署参照マスタよりデータ取得 |
| 3002 | 3055 |
if (CommonMotions.LoginUserData.PersonCode != CommonDefine.AdminCode) |
| 3003 | 3056 |
{
|
| branches/src/ProcessManagement/ProcessManagement/Common/CommonVersion.cs | ||
|---|---|---|
| 14 | 14 |
/// <summary> |
| 15 | 15 |
/// 本体バージョン |
| 16 | 16 |
/// </summary> |
| 17 |
public static int s_SystemVersion = 163;
|
|
| 17 |
public static int s_SystemVersion = 167;
|
|
| 18 | 18 |
|
| 19 | 19 |
/// <summary> |
| 20 | 20 |
/// コピー・環境バージョン |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOActionScheduleData.cs | ||
|---|---|---|
| 148 | 148 |
bDataFirst = false; |
| 149 | 149 |
} |
| 150 | 150 |
|
| 151 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 151 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 152 | 152 |
|
| 153 | 153 |
return true; |
| 154 | 154 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOAttendanceDailyData.cs | ||
|---|---|---|
| 282 | 282 |
bDataFirst = false; |
| 283 | 283 |
} |
| 284 | 284 |
|
| 285 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 285 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 286 | 286 |
|
| 287 | 287 |
return true; |
| 288 | 288 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOAttendanceData.cs | ||
|---|---|---|
| 265 | 265 |
bDataFirst = false; |
| 266 | 266 |
} |
| 267 | 267 |
|
| 268 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 268 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 269 | 269 |
|
| 270 | 270 |
return true; |
| 271 | 271 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBaseInfo.cs | ||
|---|---|---|
| 456 | 456 |
bDataFirst = false; |
| 457 | 457 |
} |
| 458 | 458 |
|
| 459 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 459 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 460 | 460 |
|
| 461 | 461 |
return true; |
| 462 | 462 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBaseInfoDetail.cs | ||
|---|---|---|
| 234 | 234 |
bDataFirst = false; |
| 235 | 235 |
} |
| 236 | 236 |
|
| 237 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 237 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 238 | 238 |
|
| 239 | 239 |
return true; |
| 240 | 240 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBudget.cs | ||
|---|---|---|
| 341 | 341 |
bDataFirst = false; |
| 342 | 342 |
} |
| 343 | 343 |
|
| 344 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 344 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 345 | 345 |
|
| 346 | 346 |
return true; |
| 347 | 347 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBudgetDetail.cs | ||
|---|---|---|
| 286 | 286 |
bDataFirst = false; |
| 287 | 287 |
} |
| 288 | 288 |
|
| 289 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 289 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 290 | 290 |
|
| 291 | 291 |
return true; |
| 292 | 292 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionLedger.cs | ||
|---|---|---|
| 315 | 315 |
bDataFirst = false; |
| 316 | 316 |
} |
| 317 | 317 |
|
| 318 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 318 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 319 | 319 |
|
| 320 | 320 |
return true; |
| 321 | 321 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionLedgerDetail.cs | ||
|---|---|---|
| 326 | 326 |
bDataFirst = false; |
| 327 | 327 |
} |
| 328 | 328 |
|
| 329 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 329 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 330 | 330 |
return true; |
| 331 | 331 |
} |
| 332 | 332 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionLedgerExcute.cs | ||
|---|---|---|
| 271 | 271 |
bDataFirst = false; |
| 272 | 272 |
} |
| 273 | 273 |
|
| 274 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 274 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 275 | 275 |
return true; |
| 276 | 276 |
} |
| 277 | 277 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionLink.cs | ||
|---|---|---|
| 202 | 202 |
/// </summary> |
| 203 | 203 |
/// <param name="data">工事増減情報データ</param> |
| 204 | 204 |
/// <returns>true：成功 false：失敗</returns> |
| 205 |
/// <summary> |
|
| 206 |
/// 工事増減情報追加 |
|
| 207 |
/// </summary> |
|
| 208 |
/// <param name="data">工事増減情報データ</param> |
|
| 209 |
/// <returns>true：成功 false：失敗</returns> |
|
| 210 | 205 |
public bool InsertAction(List<ConstructionLink> data, bool bConnect = true) |
| 211 | 206 |
{
|
| 212 | 207 |
StringBuilder strcmd = new StringBuilder(); |
| ... | ... | |
| 240 | 235 |
bDataFirst = false; |
| 241 | 236 |
} |
| 242 | 237 |
|
| 243 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false; return true;
|
|
| 238 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false; return true;
|
|
| 244 | 239 |
} |
| 245 | 240 |
catch (Exception ex) |
| 246 | 241 |
{
|
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionProgressDate.cs | ||
|---|---|---|
| 160 | 160 |
bDataFirst = false; |
| 161 | 161 |
} |
| 162 | 162 |
|
| 163 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 163 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 164 | 164 |
|
| 165 | 165 |
return true; |
| 166 | 166 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOCostDataOfPerson.cs | ||
|---|---|---|
| 273 | 273 |
bDataFirst = false; |
| 274 | 274 |
} |
| 275 | 275 |
|
| 276 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 276 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 277 | 277 |
return true; |
| 278 | 278 |
} |
| 279 | 279 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOCostomerRegist.cs | ||
|---|---|---|
| 337 | 337 |
bDataFirst = false; |
| 338 | 338 |
} |
| 339 | 339 |
|
| 340 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 340 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 341 | 341 |
|
| 342 | 342 |
return true; |
| 343 | 343 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataConstruction.cs | ||
|---|---|---|
| 241 | 241 |
bDataFirst = false; |
| 242 | 242 |
} |
| 243 | 243 |
|
| 244 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 244 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 245 | 245 |
|
| 246 | 246 |
return true; |
| 247 | 247 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataDetail.cs | ||
|---|---|---|
| 290 | 290 |
bDataFirst = false; |
| 291 | 291 |
} |
| 292 | 292 |
|
| 293 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 293 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 294 | 294 |
|
| 295 | 295 |
return true; |
| 296 | 296 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataField.cs | ||
|---|---|---|
| 262 | 262 |
bDataFirst = false; |
| 263 | 263 |
} |
| 264 | 264 |
|
| 265 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 265 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 266 | 266 |
|
| 267 | 267 |
return true; |
| 268 | 268 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataMaterials.cs | ||
|---|---|---|
| 278 | 278 |
bDataFirst = false; |
| 279 | 279 |
} |
| 280 | 280 |
|
| 281 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 281 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 282 | 282 |
|
| 283 | 283 |
return true; |
| 284 | 284 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataSubcontractors.cs | ||
|---|---|---|
| 259 | 259 |
bDataFirst = false; |
| 260 | 260 |
} |
| 261 | 261 |
|
| 262 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 262 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 263 | 263 |
|
| 264 | 264 |
return true; |
| 265 | 265 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataVehicles.cs | ||
|---|---|---|
| 289 | 289 |
bDataFirst = false; |
| 290 | 290 |
} |
| 291 | 291 |
|
| 292 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 292 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 293 | 293 |
|
| 294 | 294 |
return true; |
| 295 | 295 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOEstimateBudget.cs | ||
|---|---|---|
| 262 | 262 |
bDataFirst = false; |
| 263 | 263 |
} |
| 264 | 264 |
|
| 265 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 265 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 266 | 266 |
|
| 267 | 267 |
return true; |
| 268 | 268 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOEstimateBudgetDetail.cs | ||
|---|---|---|
| 266 | 266 |
bDataFirst = false; |
| 267 | 267 |
} |
| 268 | 268 |
|
| 269 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 269 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 270 | 270 |
|
| 271 | 271 |
return true; |
| 272 | 272 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOEstimateData.cs | ||
|---|---|---|
| 248 | 248 |
bDataFirst = false; |
| 249 | 249 |
} |
| 250 | 250 |
|
| 251 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 251 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 252 | 252 |
|
| 253 | 253 |
return true; |
| 254 | 254 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOEstimateDataBody.cs | ||
|---|---|---|
| 251 | 251 |
bDataFirst = false; |
| 252 | 252 |
} |
| 253 | 253 |
|
| 254 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 254 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 255 | 255 |
return true; |
| 256 | 256 |
} |
| 257 | 257 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOEstimateDataDetail.cs | ||
|---|---|---|
| 288 | 288 |
bDataFirst = false; |
| 289 | 289 |
} |
| 290 | 290 |
|
| 291 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 291 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 292 | 292 |
|
| 293 | 293 |
return true; |
| 294 | 294 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOInputSearchLogData.cs | ||
|---|---|---|
| 188 | 188 |
bDataFirst = false; |
| 189 | 189 |
} |
| 190 | 190 |
|
| 191 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 191 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 192 | 192 |
|
| 193 | 193 |
return true; |
| 194 | 194 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMApproval.cs | ||
|---|---|---|
| 148 | 148 |
bDataFirst = false; |
| 149 | 149 |
} |
| 150 | 150 |
|
| 151 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 151 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 152 | 152 |
|
| 153 | 153 |
return true; |
| 154 | 154 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMBizPeriodHistory.cs | ||
|---|---|---|
| 245 | 245 |
bDataFirst = false; |
| 246 | 246 |
} |
| 247 | 247 |
|
| 248 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 248 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 249 | 249 |
|
| 250 | 250 |
return true; |
| 251 | 251 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMBusinessType.cs | ||
|---|---|---|
| 138 | 138 |
bDataFirst = false; |
| 139 | 139 |
} |
| 140 | 140 |
|
| 141 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 141 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 142 | 142 |
|
| 143 | 143 |
return true; |
| 144 | 144 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostLarge.cs | ||
|---|---|---|
| 201 | 201 |
bDataFirst = false; |
| 202 | 202 |
} |
| 203 | 203 |
|
| 204 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 204 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 205 | 205 |
|
| 206 | 206 |
return true; |
| 207 | 207 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostLinkMS.cs | ||
|---|---|---|
| 242 | 242 |
bDataFirst = false; |
| 243 | 243 |
} |
| 244 | 244 |
|
| 245 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 245 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 246 | 246 |
|
| 247 | 247 |
return true; |
| 248 | 248 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostMiddle.cs | ||
|---|---|---|
| 206 | 206 |
bDataFirst = false; |
| 207 | 207 |
} |
| 208 | 208 |
|
| 209 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 209 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 210 | 210 |
|
| 211 | 211 |
return true; |
| 212 | 212 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostMiddleSearchWord.cs | ||
|---|---|---|
| 244 | 244 |
bDataFirst = false; |
| 245 | 245 |
} |
| 246 | 246 |
|
| 247 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 247 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 248 | 248 |
|
| 249 | 249 |
return true; |
| 250 | 250 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMComponent.cs | ||
|---|---|---|
| 256 | 256 |
bDataFirst = false; |
| 257 | 257 |
} |
| 258 | 258 |
|
| 259 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 259 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 260 | 260 |
|
| 261 | 261 |
return true; |
| 262 | 262 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMComponentLink.cs | ||
|---|---|---|
| 240 | 240 |
bDataFirst = false; |
| 241 | 241 |
} |
| 242 | 242 |
|
| 243 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 243 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 244 | 244 |
|
| 245 | 245 |
return true; |
| 246 | 246 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMConstructionItem.cs | ||
|---|---|---|
| 252 | 252 |
bDataFirst = false; |
| 253 | 253 |
} |
| 254 | 254 |
|
| 255 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 255 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 256 | 256 |
|
| 257 | 257 |
return true; |
| 258 | 258 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMConstructionSpec.cs | ||
|---|---|---|
| 258 | 258 |
bDataFirst = false; |
| 259 | 259 |
} |
| 260 | 260 |
|
| 261 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 261 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 262 | 262 |
|
| 263 | 263 |
return true; |
| 264 | 264 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMConstructionSpecUnitPrice.cs | ||
|---|---|---|
| 242 | 242 |
bDataFirst = false; |
| 243 | 243 |
} |
| 244 | 244 |
|
| 245 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 245 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 246 | 246 |
|
| 247 | 247 |
return true; |
| 248 | 248 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMConstructionTypeMaster.cs | ||
|---|---|---|
| 260 | 260 |
bDataFirst = false; |
| 261 | 261 |
} |
| 262 | 262 |
|
| 263 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 263 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 264 | 264 |
|
| 265 | 265 |
return true; |
| 266 | 266 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDepartment.cs | ||
|---|---|---|
| 210 | 210 |
bDataFirst = false; |
| 211 | 211 |
} |
| 212 | 212 |
|
| 213 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 213 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 214 | 214 |
|
| 215 | 215 |
return true; |
| 216 | 216 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDepartmentExpenses.cs | ||
|---|---|---|
| 277 | 277 |
bDataFirst = false; |
| 278 | 278 |
} |
| 279 | 279 |
|
| 280 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 280 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 281 | 281 |
|
| 282 | 282 |
return true; |
| 283 | 283 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDivision.cs | ||
|---|---|---|
| 204 | 204 |
bDataFirst = false; |
| 205 | 205 |
} |
| 206 | 206 |
|
| 207 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 207 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 208 | 208 |
|
| 209 | 209 |
return true; |
| 210 | 210 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMHolidayCalender.cs | ||
|---|---|---|
| 184 | 184 |
bDataFirst = false; |
| 185 | 185 |
} |
| 186 | 186 |
|
| 187 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 187 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 188 | 188 |
|
| 189 | 189 |
return true; |
| 190 | 190 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMOrderers.cs | ||
|---|---|---|
| 240 | 240 |
bDataFirst = false; |
| 241 | 241 |
} |
| 242 | 242 |
|
| 243 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 243 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 244 | 244 |
|
| 245 | 245 |
return true; |
| 246 | 246 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMPersonDepartment.cs | ||
|---|---|---|
| 239 | 239 |
bDataFirst = false; |
| 240 | 240 |
} |
| 241 | 241 |
|
| 242 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 242 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 243 | 243 |
|
| 244 | 244 |
return true; |
| 245 | 245 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMPersonSalary.cs | ||
|---|---|---|
| 246 | 246 |
bDataFirst = false; |
| 247 | 247 |
} |
| 248 | 248 |
|
| 249 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 249 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 250 | 250 |
|
| 251 | 251 |
return true; |
| 252 | 252 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMProcessExcute.cs | ||
|---|---|---|
| 241 | 241 |
bDataFirst = false; |
| 242 | 242 |
} |
| 243 | 243 |
|
| 244 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 244 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 245 | 245 |
|
| 246 | 246 |
return true; |
| 247 | 247 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSecurity.cs | ||
|---|---|---|
| 254 | 254 |
bDataFirst = false; |
| 255 | 255 |
} |
| 256 | 256 |
|
| 257 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 257 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 258 | 258 |
|
| 259 | 259 |
return true; |
| 260 | 260 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractor.cs | ||
|---|---|---|
| 313 | 313 |
bDataFirst = false; |
| 314 | 314 |
} |
| 315 | 315 |
|
| 316 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 316 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 317 | 317 |
|
| 318 | 318 |
return true; |
| 319 | 319 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorItem.cs | ||
|---|---|---|
| 203 | 203 |
bDataFirst = false; |
| 204 | 204 |
} |
| 205 | 205 |
|
| 206 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 206 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 207 | 207 |
|
| 208 | 208 |
return true; |
| 209 | 209 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorJobCategory.cs | ||
|---|---|---|
| 246 | 246 |
bDataFirst = false; |
| 247 | 247 |
} |
| 248 | 248 |
|
| 249 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 249 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 250 | 250 |
|
| 251 | 251 |
return true; |
| 252 | 252 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorJobItem.cs | ||
|---|---|---|
| 199 | 199 |
bDataFirst = false; |
| 200 | 200 |
} |
| 201 | 201 |
|
| 202 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 202 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 203 | 203 |
|
| 204 | 204 |
return true; |
| 205 | 205 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorJobLink.cs | ||
|---|---|---|
| 197 | 197 |
bDataFirst = false; |
| 198 | 198 |
} |
| 199 | 199 |
|
| 200 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 200 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 201 | 201 |
|
| 202 | 202 |
return true; |
| 203 | 203 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSuppliers.cs | ||
|---|---|---|
| 278 | 278 |
bDataFirst = false; |
| 279 | 279 |
} |
| 280 | 280 |
|
| 281 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 281 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 282 | 282 |
|
| 283 | 283 |
return true; |
| 284 | 284 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSystem.cs | ||
|---|---|---|
| 342 | 342 |
bDataFirst = false; |
| 343 | 343 |
} |
| 344 | 344 |
|
| 345 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 345 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 346 | 346 |
|
| 347 | 347 |
return true; |
| 348 | 348 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMTerm.cs | ||
|---|---|---|
| 210 | 210 |
bDataFirst = false; |
| 211 | 211 |
} |
| 212 | 212 |
|
| 213 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 213 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 214 | 214 |
return true; |
| 215 | 215 |
} |
| 216 | 216 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMTypeExpenses.cs | ||
|---|---|---|
| 251 | 251 |
bDataFirst = false; |
| 252 | 252 |
} |
| 253 | 253 |
|
| 254 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 254 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 255 | 255 |
|
| 256 | 256 |
return true; |
| 257 | 257 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMUnit.cs | ||
|---|---|---|
| 137 | 137 |
bDataFirst = false; |
| 138 | 138 |
} |
| 139 | 139 |
|
| 140 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 140 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 141 | 141 |
|
| 142 | 142 |
return true; |
| 143 | 143 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMVehicle.cs | ||
|---|---|---|
| 192 | 192 |
bDataFirst = false; |
| 193 | 193 |
} |
| 194 | 194 |
|
| 195 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 195 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 196 | 196 |
|
| 197 | 197 |
return true; |
| 198 | 198 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMVehicleRecordData.cs | ||
|---|---|---|
| 153 | 153 |
bDataFirst = false; |
| 154 | 154 |
} |
| 155 | 155 |
|
| 156 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 156 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 157 | 157 |
|
| 158 | 158 |
return true; |
| 159 | 159 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMessageBoardData.cs | ||
|---|---|---|
| 289 | 289 |
bDataFirst = false; |
| 290 | 290 |
} |
| 291 | 291 |
|
| 292 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 292 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 293 | 293 |
|
| 294 | 294 |
return true; |
| 295 | 295 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMessageBoardDataTerget.cs | ||
|---|---|---|
| 246 | 246 |
bDataFirst = false; |
| 247 | 247 |
} |
| 248 | 248 |
|
| 249 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 249 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 250 | 250 |
|
| 251 | 251 |
return true; |
| 252 | 252 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMessageBrowsingHistory.cs | ||
|---|---|---|
| 235 | 235 |
bDataFirst = false; |
| 236 | 236 |
} |
| 237 | 237 |
|
| 238 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 238 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 239 | 239 |
|
| 240 | 240 |
return true; |
| 241 | 241 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOOrdersPriceData.cs | ||
|---|---|---|
| 255 | 255 |
bDataFirst = false; |
| 256 | 256 |
} |
| 257 | 257 |
|
| 258 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 258 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 259 | 259 |
|
| 260 | 260 |
return true; |
| 261 | 261 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPeriodAvoidance.cs | ||
|---|---|---|
| 182 | 182 |
bDataFirst = false; |
| 183 | 183 |
} |
| 184 | 184 |
|
| 185 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 185 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 186 | 186 |
return true; |
| 187 | 187 |
} |
| 188 | 188 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPersonApproval.cs | ||
|---|---|---|
| 215 | 215 |
bDataFirst = false; |
| 216 | 216 |
} |
| 217 | 217 |
|
| 218 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 218 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 219 | 219 |
|
| 220 | 220 |
return true; |
| 221 | 221 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPersonApprovalCommnet.cs | ||
|---|---|---|
| 208 | 208 |
bDataFirst = false; |
| 209 | 209 |
} |
| 210 | 210 |
|
| 211 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 211 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 212 | 212 |
|
| 213 | 213 |
return true; |
| 214 | 214 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPersonApprovalDetail.cs | ||
|---|---|---|
| 213 | 213 |
bDataFirst = false; |
| 214 | 214 |
} |
| 215 | 215 |
|
| 216 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 216 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 217 | 217 |
|
| 218 | 218 |
return true; |
| 219 | 219 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsData.cs | ||
|---|---|---|
| 264 | 264 |
bDataFirst = false; |
| 265 | 265 |
} |
| 266 | 266 |
|
| 267 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 267 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 268 | 268 |
|
| 269 | 269 |
return true; |
| 270 | 270 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsDataAttend.cs | ||
|---|---|---|
| 262 | 262 |
bDataFirst = false; |
| 263 | 263 |
} |
| 264 | 264 |
|
| 265 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 265 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 266 | 266 |
|
| 267 | 267 |
return true; |
| 268 | 268 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsDataDetail.cs | ||
|---|---|---|
| 265 | 265 |
bDataFirst = false; |
| 266 | 266 |
} |
| 267 | 267 |
|
| 268 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 268 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 269 | 269 |
|
| 270 | 270 |
return true; |
| 271 | 271 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProcessApproval.cs | ||
|---|---|---|
| 215 | 215 |
bDataFirst = false; |
| 216 | 216 |
} |
| 217 | 217 |
|
| 218 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 218 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 219 | 219 |
|
| 220 | 220 |
return true; |
| 221 | 221 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProcessApprovalCommnet.cs | ||
|---|---|---|
| 205 | 205 |
bDataFirst = false; |
| 206 | 206 |
} |
| 207 | 207 |
|
| 208 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 208 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 209 | 209 |
|
| 210 | 210 |
return true; |
| 211 | 211 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProcessApprovalDetail.cs | ||
|---|---|---|
| 202 | 202 |
bDataFirst = false; |
| 203 | 203 |
} |
| 204 | 204 |
|
| 205 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 205 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 206 | 206 |
|
| 207 | 207 |
return true; |
| 208 | 208 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPurchaseOrder.cs | ||
|---|---|---|
| 351 | 351 |
bDataFirst = false; |
| 352 | 352 |
} |
| 353 | 353 |
|
| 354 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 354 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 355 | 355 |
|
| 356 | 356 |
return true; |
| 357 | 357 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPurchaseOrderDate.cs | ||
|---|---|---|
| 258 | 258 |
bDataFirst = false; |
| 259 | 259 |
} |
| 260 | 260 |
|
| 261 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 261 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 262 | 262 |
|
| 263 | 263 |
return true; |
| 264 | 264 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPurchaseOrderDetail.cs | ||
|---|---|---|
| 290 | 290 |
bDataFirst = false; |
| 291 | 291 |
} |
| 292 | 292 |
|
| 293 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 293 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 294 | 294 |
|
| 295 | 295 |
return true; |
| 296 | 296 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IORequestOrderDate.cs | ||
|---|---|---|
| 240 | 240 |
bDataFirst = false; |
| 241 | 241 |
} |
| 242 | 242 |
|
| 243 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 243 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 244 | 244 |
|
| 245 | 245 |
return true; |
| 246 | 246 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSFPData.cs | ||
|---|---|---|
| 211 | 211 |
bDataFirst = false; |
| 212 | 212 |
} |
| 213 | 213 |
|
| 214 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 214 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 215 | 215 |
|
| 216 | 216 |
return true; |
| 217 | 217 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSFPDataDetail.cs | ||
|---|---|---|
| 197 | 197 |
bDataFirst = false; |
| 198 | 198 |
} |
| 199 | 199 |
|
| 200 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 200 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 201 | 201 |
|
| 202 | 202 |
return true; |
| 203 | 203 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSalesGraphData.cs | ||
|---|---|---|
| 195 | 195 |
bDataFirst = false; |
| 196 | 196 |
} |
| 197 | 197 |
|
| 198 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 198 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 199 | 199 |
|
| 200 | 200 |
return true; |
| 201 | 201 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSubConstrJobItemRegist.cs | ||
|---|---|---|
| 251 | 251 |
bDataFirst = false; |
| 252 | 252 |
} |
| 253 | 253 |
|
| 254 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 254 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 255 | 255 |
|
| 256 | 256 |
return true; |
| 257 | 257 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSubConstrJobLinkRegist.cs | ||
|---|---|---|
| 249 | 249 |
bDataFirst = false; |
| 250 | 250 |
} |
| 251 | 251 |
|
| 252 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 252 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 253 | 253 |
|
| 254 | 254 |
return true; |
| 255 | 255 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSubConstrRegist.cs | ||
|---|---|---|
| 337 | 337 |
bDataFirst = false; |
| 338 | 338 |
} |
| 339 | 339 |
|
| 340 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 340 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 341 | 341 |
|
| 342 | 342 |
return true; |
| 343 | 343 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSystemExecute.cs | ||
|---|---|---|
| 203 | 203 |
bDataFirst = false; |
| 204 | 204 |
} |
| 205 | 205 |
|
| 206 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 206 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 207 | 207 |
|
| 208 | 208 |
return true; |
| 209 | 209 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOTranceportDailyData.cs | ||
|---|---|---|
| 286 | 286 |
bDataFirst = false; |
| 287 | 287 |
} |
| 288 | 288 |
|
| 289 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 289 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 290 | 290 |
|
| 291 | 291 |
return true; |
| 292 | 292 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOVehicleScheduleData.cs | ||
|---|---|---|
| 151 | 151 |
bDataFirst = false; |
| 152 | 152 |
} |
| 153 | 153 |
|
| 154 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 154 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 155 | 155 |
|
| 156 | 156 |
return true; |
| 157 | 157 |
} |
| branches/src/ProcessManagement/ProcessManagement/DataModel/DepartmentMaster.cs | ||
|---|---|---|
| 17 | 17 |
private int m_ActionScheduleFlg = 0; // 行動予定表示フラグ |
| 18 | 18 |
private int m_StaffAssignFlg = 0; // 人員配置表示フラグ |
| 19 | 19 |
private DateTime m_StartDate = DateTime.Now; // 開始日付 |
| 20 |
private DateTime m_CompDate = DateTime.MinValue; // 終了日付 |
|
| 20 |
private DateTime m_CompDate = DateTime.MinValue; // 終了日付 |
|
| 21 | 21 |
private int m_DeleteFlg = 0; // 削除フラグ |
| 22 | 22 |
private DateTime m_EntryDate = DateTime.Now; // 登録日付 |
| 23 | 23 |
private DateTime m_UpdateDate = DateTime.Now; // 更新日付 |
| ... | ... | |
| 90 | 90 |
{
|
| 91 | 91 |
get { return m_CompDate; }
|
| 92 | 92 |
set { m_CompDate = value; }
|
| 93 |
} |
|
| 93 |
} |
|
| 94 | 94 |
/// <summary> |
| 95 | 95 |
/// 登録日付 |
| 96 | 96 |
/// </summary> |
| branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ApprovalList/FrmApprovalList.cs | ||
|---|---|---|
| 284 | 284 |
{
|
| 285 | 285 |
if (m_bInitFlg) return; |
| 286 | 286 |
|
| 287 |
|
|
| 288 | 287 |
// ?????R???{?{?b?N?X??X
|
| 289 | 288 |
SetcmbDepartment(); |
| 290 | 289 |
// ?S????R???{?{?b?N?X??X
|
| 291 | 290 |
SetcmbPersons(); |
| 291 |
// ?S????R???{?{?b?N?X?Z?b?g?????????Z?b?g????
|
|
| 292 |
if (!SetPerosonToDepartment()) return; |
|
| 292 | 293 |
|
| 293 |
|
|
| 294 | 294 |
// ?f?[?^?\?? |
| 295 | 295 |
DataDisplay(); |
| 296 | 296 |
} |
| branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstractionList/FrmConstructionList.cs | ||
|---|---|---|
| 319 | 319 |
SetcmbDepartment(); |
| 320 | 320 |
// ?S????R???{?{?b?N?X??X
|
| 321 | 321 |
SetcmbPersons(); |
| 322 |
// ?S????R???{?{?b?N?X?Z?b?g?????????Z?b?g????
|
|
| 323 |
if (!SetPerosonToDepartment()) return; |
|
| 322 | 324 |
|
| 323 | 325 |
// ?f?[?^?\?? |
| 324 | 326 |
DataDisplay(); |
| branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBaseInfo/FrmConstructionBaseInfoAuxiliary.cs | ||
|---|---|---|
| 3447 | 3447 |
// ?f?[?^?o?^ |
| 3448 | 3448 |
if (!DataAllEntryProcess(MsgOn)) return false; |
| 3449 | 3449 |
|
| 3450 |
// ????????????????? |
|
| 3451 |
if (m_TransferMesageFlg) MessageBoardEntry(); |
|
| 3452 |
|
|
| 3453 |
// ???p?S??????????????????? |
|
| 3454 |
if (m_Transfer2MesageFlg) MessageBoardEntry2(); |
|
| 3455 |
|
|
| 3456 | 3450 |
m_bChengeAns = false; |
| 3457 | 3451 |
|
| 3458 | 3452 |
// ??X?t???O??ON |
| ... | ... | |
| 3500 | 3494 |
IOConstructionLedgerDetail LedgerDDB = new IOConstructionLedgerDetail(); // ?H??????????f?[?^ |
| 3501 | 3495 |
IOConstructionLedgerExcute LedgerEDB = new IOConstructionLedgerExcute(); // ?H???????x?????f?[?^ |
| 3502 | 3496 |
|
| 3497 |
IOMessageBoardData mbdDB = new IOMessageBoardData(); // ?f????f?[?^ |
|
| 3498 |
IOMessageBoardTerget mbtDB = new IOMessageBoardTerget(); // ?f??????e?[?u?? |
|
| 3499 |
|
|
| 3503 | 3500 |
FrmConstructionLedger frm = new FrmConstructionLedger(); // ?H?????????? |
| 3504 | 3501 |
try |
| 3505 | 3502 |
{
|
| ... | ... | |
| 3542 | 3539 |
TyingDataFlag = true; |
| 3543 | 3540 |
|
| 3544 | 3541 |
// ???????????????s?? |
| 3545 |
cbiDB.connect(); cbiDB.beginTran(); |
|
| 3546 |
cbidDB.connect(); cbidDB.beginTran(); |
|
| 3547 |
cpdDB.connect(); cpdDB.beginTran(); |
|
| 3548 |
cbLinkDB.connect(); cbLinkDB.beginTran(); |
|
| 3542 |
DBBeginTran(cbiDB, cbidDB, cpdDB, cbLinkDB, |
|
| 3543 |
ApprovalDB, PersonDB, |
|
| 3544 |
BudgetDB, BudgetDDB, |
|
| 3545 |
LedgerDB, LedgerDDB, LedgerEDB, |
|
| 3546 |
mbdDB, mbtDB); |
|
| 3549 | 3547 |
|
| 3550 |
ApprovalDB.connect(); ApprovalDB.beginTran(); |
|
| 3551 |
PersonDB.connect(); PersonDB.beginTran(); |
|
| 3552 |
|
|
| 3553 |
BudgetDB.connect(); BudgetDB.beginTran(); |
|
| 3554 |
BudgetDDB.connect(); BudgetDDB.beginTran(); |
|
| 3555 |
|
|
| 3556 |
LedgerDB.connect(); LedgerDB.beginTran(); |
|
| 3557 |
LedgerDDB.connect(); LedgerDDB.beginTran(); |
|
| 3558 |
LedgerEDB.connect(); LedgerEDB.beginTran(); |
|
| 3559 |
|
|
| 3560 | 3548 |
// ?f?[?^?o?^ |
| 3561 | 3549 |
if (!ConstructionBaseInfoDataEntry(cbiDB, cpdDB)) |
| 3562 | 3550 |
{
|
| ... | ... | |
| 3565 | 3553 |
cbiDB, cbidDB, cpdDB, cbLinkDB, |
| 3566 | 3554 |
ApprovalDB, PersonDB, |
| 3567 | 3555 |
BudgetDB, BudgetDDB, |
| 3568 |
LedgerDB, LedgerDDB, LedgerEDB); |
|
| 3556 |
LedgerDB, LedgerDDB, LedgerEDB, |
|
| 3557 |
mbdDB, mbtDB); |
|
| 3569 | 3558 |
|
| 3570 | 3559 |
return false; |
| 3571 | 3560 |
} |
| ... | ... | |
| 3576 | 3565 |
cbiDB, cbidDB, cpdDB, cbLinkDB, |
| 3577 | 3566 |
ApprovalDB, PersonDB, |
| 3578 | 3567 |
BudgetDB, BudgetDDB, |
| 3579 |
LedgerDB, LedgerDDB, LedgerEDB); |
|
| 3568 |
LedgerDB, LedgerDDB, LedgerEDB, |
|
| 3569 |
mbdDB, mbtDB); |
|
| 3580 | 3570 |
|
| 3581 | 3571 |
return false; |
| 3582 | 3572 |
} |
| ... | ... | |
| 3591 | 3581 |
cbiDB, cbidDB, cpdDB, cbLinkDB, |
| 3592 | 3582 |
ApprovalDB, PersonDB, |
| 3593 | 3583 |
BudgetDB, BudgetDDB, |
| 3594 |
LedgerDB, LedgerDDB, LedgerEDB); |
|
| 3584 |
LedgerDB, LedgerDDB, LedgerEDB, |
|
| 3585 |
mbdDB, mbtDB); |
|
| 3595 | 3586 |
|
| 3596 | 3587 |
return false; |
| 3597 | 3588 |
} |
| ... | ... | |
| 3608 | 3599 |
cbiDB, cbidDB, cpdDB, cbLinkDB, |
| 3609 | 3600 |
ApprovalDB, PersonDB, |
| 3610 | 3601 |
BudgetDB, BudgetDDB, |
| 3611 |
LedgerDB, LedgerDDB, LedgerEDB); |
|
| 3602 |
LedgerDB, LedgerDDB, LedgerEDB, |
|
| 3603 |
mbdDB, mbtDB); |
|
| 3612 | 3604 |
|
| 3613 | 3605 |
return false; |
| 3614 | 3606 |
} |
| ... | ... | |
| 3623 | 3615 |
cbiDB, cbidDB, cpdDB, cbLinkDB, |
| 3624 | 3616 |
ApprovalDB, PersonDB, |
| 3625 | 3617 |
BudgetDB, BudgetDDB, |
| 3626 |
LedgerDB, LedgerDDB, LedgerEDB); |
|
| 3618 |
LedgerDB, LedgerDDB, LedgerEDB, |
|
| 3619 |
mbdDB, mbtDB); |
|
| 3627 | 3620 |
|
| 3628 | 3621 |
return false; |
| 3629 | 3622 |
} |
| ... | ... | |
| 3638 | 3631 |
cbiDB, cbidDB, cpdDB, cbLinkDB, |
| 3639 | 3632 |
ApprovalDB, PersonDB, |
| 3640 | 3633 |
BudgetDB, BudgetDDB, |
| 3641 |
LedgerDB, LedgerDDB, LedgerEDB); |
|
| 3634 |
LedgerDB, LedgerDDB, LedgerEDB, |
|
| 3635 |
mbdDB, mbtDB); |
|
| 3642 | 3636 |
|
| 3643 | 3637 |
return false; |
| 3644 | 3638 |
} |
他の形式にエクスポート: Unified diff