/ - Diff - 工事管理システム製品化対応 - Redmine

             /// <summary>
             /// パスを定数で定義する
             /// </summary>
             public const string s_UPDATE_FILE_PATH = @"D:\Work\Test";
             //public const string s_UPDATE_FILE_PATH = @"Z:\52GenbaKantokuHisyo";
             public const string s_UPDATE_FILE_PATH = @"Z:\52GenbaKantokuHisyo";
             //public const string s_UPDATE_FILE_PATH = @"Z:\5-2現場監督秘書";
             //private const string s_UPDATE_FILE_PATH = @"Z:\⑤ＩＴ事業部用\Debug";
             public const string s_UPDATECOPY_NAME = "UpDateCopy.exe";
-...
                 /// 作成中
                 /// </summary>
                 Making = 1,
                 /// <summary>
                 /// 作成しない
                 /// </summary>
                 NoMakeData = 9,
+            }
             #endregion

trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsChangeBaseInfoData.cs
178	178	DB27.DeleteAction(strRemove, false);
179	179	}
180	180
181		// 結合工事リンク情報更新（1件目は削除済み）
	181	// 結合工事リンク情報更新
182	182	if (ProcSuccess)
183	183	{
184	184	// 増減工事親確認
185	185	if (BaseRec.TyingFlg == (int)CommonDefine.BaseInfoTyingFlg.Parent)
186	186	{
187		for (int i = 1; i < RemoveList.Count; i++)
	187	for (int i = 0; i < RemoveList.Count; i++)
188	188	{
189	189	if (!DB01.UpdateFeild(RemoveList[i]
190	190	, (int)IOConstructionBaseInfo.TableColumn.TyingFlg
...	...
199	199	// 結合工事親確認
200	200	if (BaseRec.JoinFlg == (int)CommonDefine.BaseInfoJoinFlg.JoinParent)
201	201	{
202		for (int i = 1; i < UpdateLinkList.Count; i++)
	202	string strSQL = string.Empty;
	203	for (int i = 0; i < UpdateLinkList.Count; i++)
203	204	{
204	205	if (!DB01.UpdateFeild(UpdateLinkList[i]
205	206	, (int)IOConstructionBaseInfo.TableColumn.JoinFlg
...	...
209	210	ProcSuccess = false;
210	211	break;
211	212	}
	213	strSQL = string.Format("UPDATE CONSTRUCTIONBASEINFO A SET A.JOINFLG = {0}", (int)CommonDefine.BaseInfoJoinFlg.Standard);
	214	strSQL += " WHERE A.CONSTRUCTIONCODE IN (SELECT AA.FLUCTUATIONCODE FROM CONSTRUCTIONLINK AA";
	215	strSQL += string.Format(" WHERE AA.CONSTRUCTIONCODE = {0}",UpdateLinkList[i]);
	216	strSQL += string.Format(" AND AA.LINKTYPE = {0})", (int)CommonDefine.LinkDataType.FluctuationType);
	217	DB01.ExecuteNonQuery(strSQL, false);
212	218	}
213	219	}
214	220	}

trunk/src/ProcessManagement/ProcessManagement/DataModel/SystemMaster.cs
26	26	private double m_OfficeExpenses = 0; // 事務所経費
27	27	private double m_OperatingExpenses = 0; // 営業経費
28	28	private double m_ConsumptionTax = 0; // 消費税
	29
29	30	private string m_ExcelSavePath = string.Empty; // Excel保存パス
30	31
31	32	private int m_BusinessPeriod = 0; // 営業期数

trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionJoin/FrmConstructionJoinAuxiliary.cs
1440	1440	List<ConstructionLink> LinkList = new List<ConstructionLink>();
1441	1441	if (!LinkDB.SelectAction(strLinkSQL, ref LinkList, false)) return false;
1442	1442
	1443	string strSelSQL = "SELECT COUNT(*) FROM DAILYDATACONSTRUCTION WHERE CONSTRUCTIONCODE IN (";
1443	1444	string strDelSQL = string.Format("UPDATE DAILYDATACONSTRUCTION SET CONSTRUCTIONCODE = {0} WHERE CONSTRUCTIONCODE IN (", m_ConstructionCode);
1444	1445	// 検索キー追加
1445	1446	for (int i = 0; i < LinkList.Count; i++)
1446	1447	{
1447	1448	if (i != 0) strDelSQL += " ,";
	1449	if (i != 0) strSelSQL += " ,";
1448	1450	strDelSQL += string.Format("{0}", LinkList[i].FluctuationCode);
	1451	strSelSQL += string.Format("{0}", LinkList[i].FluctuationCode);
1449	1452
1450	1453	}
1451	1454	strDelSQL += ")";
	1455	strSelSQL += ")";
1452	1456
1453		string strSelSQL = string.Format("SELECT COUNT(*) FROM DAILYDATACONSTRUCTION WHERE CONSTRUCTIONCODE = {0}", m_ConstructionCode);
1454	1457	int DataCount = GetDailyDataCount(DailyData1, strSelSQL);
1455	1458	if (DataCount > 0)
1456	1459	{
...	...
1462	1465	}
1463	1466
1464	1467	strSelSQL = strSelSQL.Replace("DAILYDATACONSTRUCTION", "DAILYDATADETAIL");
1465		DataCount = 0;
	1468	strDelSQL = strDelSQL.Replace("DAILYDATACONSTRUCTION", "DAILYDATADETAIL");
	1469	DataCount = GetDailyDataCount(DailyData1, strSelSQL);
1466	1470	if (DataCount > 0)
1467	1471	{
1468		strDelSQL = strDelSQL.Replace("DAILYDATACONSTRUCTION", "DAILYDATADETAIL");
1469	1472	if (!DailyData2.ExecuteNonQuery(strDelSQL, false))
1470	1473	{
1471	1474	DailyData1.rollback(); DailyData2.rollback(); DailyData3.rollback(); DailyData4.rollback(); DailyData5.rollback(); DailyData6.rollback();
...	...
1474	1477	}
1475	1478
1476	1479	strSelSQL = strSelSQL.Replace("DAILYDATADETAIL", "DAILYDATAVEHICLES");
1477		DataCount = 0;
	1480	strDelSQL = strDelSQL.Replace("DAILYDATADETAIL", "DAILYDATAVEHICLES");
	1481	DataCount = GetDailyDataCount(DailyData1, strSelSQL);
1478	1482	if (DataCount > 0)
1479	1483	{
1480		strDelSQL = strDelSQL.Replace("DAILYDATADETAIL", "DAILYDATAVEHICLES");
1481	1484	if (!DailyData3.ExecuteNonQuery(strDelSQL, false))
1482	1485	{
1483	1486	DailyData1.rollback(); DailyData2.rollback(); DailyData3.rollback(); DailyData4.rollback(); DailyData5.rollback(); DailyData6.rollback();
...	...
1486	1489	}
1487	1490
1488	1491	strSelSQL = strSelSQL.Replace("DAILYDATAVEHICLES", "DAILYDATAMATERIALS");
1489		DataCount = 0;
	1492	strDelSQL = strDelSQL.Replace("DAILYDATAVEHICLES", "DAILYDATAMATERIALS");
	1493	DataCount = GetDailyDataCount(DailyData1, strSelSQL);
1490	1494	if (DataCount > 0)
1491	1495	{
1492		strDelSQL = strDelSQL.Replace("DAILYDATAVEHICLES", "DAILYDATAMATERIALS");
1493	1496	if (!DailyData4.ExecuteNonQuery(strDelSQL, false))
1494	1497	{
1495	1498	DailyData1.rollback(); DailyData2.rollback(); DailyData3.rollback(); DailyData4.rollback(); DailyData5.rollback(); DailyData6.rollback();
...	...
1498	1501	}
1499	1502
1500	1503	strSelSQL = strSelSQL.Replace("DAILYDATAMATERIALS", "DAILYDATASUBCONTRACTORS");
1501		DataCount = 0;
	1504	strDelSQL = strDelSQL.Replace("DAILYDATAMATERIALS", "DAILYDATASUBCONTRACTORS");
	1505	DataCount = GetDailyDataCount(DailyData1, strSelSQL);
1502	1506	if (DataCount > 0)
1503	1507	{
1504		strDelSQL = strDelSQL.Replace("DAILYDATAMATERIALS", "DAILYDATASUBCONTRACTORS");
1505	1508	if (!DailyData5.ExecuteNonQuery(strDelSQL, false))
1506	1509	{
1507	1510	DailyData1.rollback(); DailyData2.rollback(); DailyData3.rollback(); DailyData4.rollback(); DailyData5.rollback(); DailyData6.rollback();
...	...
1510	1513	}
1511	1514
1512	1515	strSelSQL = strSelSQL.Replace("DAILYDATASUBCONTRACTORS", "DAILYDATAFIELD");
1513		DataCount = 0;
	1516	strDelSQL = strDelSQL.Replace("DAILYDATASUBCONTRACTORS", "DAILYDATAFIELD");
	1517	DataCount = GetDailyDataCount(DailyData1, strSelSQL);
1514	1518	if (DataCount > 0)
1515	1519	{
1516		strDelSQL = strDelSQL.Replace("DAILYDATASUBCONTRACTORS", "DAILYDATAFIELD");
1517	1520	if (!DailyData6.ExecuteNonQuery(strDelSQL, false))
1518	1521	{
1519	1522	DailyData1.rollback(); DailyData2.rollback(); DailyData3.rollback(); DailyData4.rollback(); DailyData5.rollback(); DailyData6.rollback();

trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PurchaseOrderEntry/FrmOrderEntryList.cs
797	797	OrderNo = CommonMotions.cnvInt(CurRow.Cells[(int)GridColumn.OrderNo].Value);
798	798	}
799	799
800
801	800	// データカウント取得
802	801	SelectCnt++;
803	802	}
804	803
805	804	if (bNoCreateData && bMakeingData && bApprovalData)
806	805	{
807		MessageBox.Show("注文書：作成・編集・閲覧は同時にできません。", "選択エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
	806	MessageBox.Show("注文書：新規作成・編集・閲覧は同時にできません。", "選択エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
808	807	return false;
809	808	}
810	809	if (bNoCreateData && bMakeingData)
811	810	{
812		MessageBox.Show("注文書：作成・編集は同時にできません。", "選択エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
	811	MessageBox.Show("注文書：新規作成・編集は同時にできません。", "選択エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
813	812	return false;
814	813	}
815	814	if (bMakeingData && bApprovalData)
...	...
819	818	}
820	819	if (bNoCreateData && bApprovalData)
821	820	{
822		MessageBox.Show("注文書：作成・閲覧は同時にできません。", "選択エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
	821	MessageBox.Show("注文書：新規作成・閲覧は同時にできません。", "選択エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
823	822	return false;
824	823	}
825	824

             /// </summary>
             private List<KeyValuePair<int, int>> m_ChangeCompany = new List<KeyValuePair<int, int>>();
             /// <summary>
             /// 新規プロセスフラグ
             /// </summary>
             private bool m_bNewProcess = false;
             #endregion
             #region プロパティ

+            }
             #endregion
             #region 旧作成データと新作成データの判別処理
             /// <summary>
             /// 旧作成データと新作成データの判別処理
             /// </summary>
             /// <returns></returns>
             private bool DisplayTypeCheck()
+            {
                 IOConstructionLedgerDetail LDetailDB = new IOConstructionLedgerDetail();
                 try
+                {
                     int ConstrSearchCode = ClsProcessExist.GetParentConstrCode(m_ConstructionCode);
                     string strSQL = LDetailDB.CreatePrimarykeyString(ConstrSearchCode, (int)FrmConstructionLedger.DataGroup.ConstructionCosts);
                     if (ConstrSearchCode != m_ConstructionCode) strSQL += string.Format(" AND SOURCECODE = {0}", m_ConstructionCode);
                     strSQL += " AND COMPANYCODE > 0";
                     ConstructionLedgerDetail LDetailRec = new ConstructionLedgerDetail();
                     if (!LDetailDB.SelectAction(strSQL, ref LDetailRec)) return false;
                     if (LDetailRec.PurchaseOrderFlg < (int)CommonDefine.PurchaseOrderFlg.NoCreate)
+                    {
                         m_OrderNo = 1;
                         m_bNewProcess = false;
                         return true;
+                    }
                     m_bNewProcess = true;
                     return true;
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
                     return false;
+                }
                 finally
+                {
                     LDetailDB.close(); LDetailDB = null;
+                }
+            }
             #endregion
             #region 注文書明細選択画面表示
             /// <summary>
             /// 注文書明細選択画面表示
-...
                     // ヘッダー情報表示
                     DispHeader();
                     if (m_bNewProcess)
                     object[] objRec = (object[])m_DetailList[0];
                     if (CommonMotions.cnvInt(objRec[(int)FrmOrderEntryList.ReadDBColumn.OrderNo]) < 0)
                     {   // 旧方式のデータ表示
                         OldType_SetPurchaseOrderData();
+                    }
                     else
+                    {
                         // 注文書データを読み込む
                         if (m_CreateData)
-...
                         // 承認データ受付番号セット
                         SetApprovalOrderNo();
+                    }
                     else
                     {   // 旧方式のデータ表示
                         OldType_SetPurchaseOrderData();
+                    }
                     // 申請・承認表示処理
                     InitApprovalDisplay();
-...
                             binit = false;
                             continue;
+                        }
                         // 会社コードが変わればでデータセットへ行く
                         // 会社コードが変わればデータセットへ行く
                         if (Break_CompanyCode != DetailRec.CompanyCode)
+                        {
                             // 協力業者発注合計が30万以上に注文書を発行する

プロジェクト

全般

プロフィール

工事管理システム製品化対応

リビジョン 43