コード例 #1
0
ファイル: STM34.cs プロジェクト: ChiangHanLung/PIC_VDS
        /// <summary>
        /// 輸入處理
        /// </summary>
        /// <returns>回傳作業成功失敗</returns>
        public bool Input()
        {
            #region
            bool bResult = false;
            try
            {
                string strCurrentSeq = "", strNextSeq = "", strNextFileName = "";

                STMModel.VDS_STM34_BCO BCO = new STMModel.VDS_STM34_BCO(ConnnectionString);
                System.Data.Common.DbTransaction DBT = BCO.OpenAndGetConnection(ConnnectionString).BeginTransaction();
                
                try
                {
                    for (Int32 i = 1; i <= 99; i++)
                    {

                        bResult = ImportDocument(File_Path_Name.Replace(".ok", ""), DBT);

                        //檢查是否還有檔案
                        strCurrentSeq = (i).ToString().PadLeft(2, Char.Parse("0"));
                        strNextSeq = (i + 1).ToString().PadLeft(2, Char.Parse("0"));
                        strNextFileName = string.Format("{0}{1}.delivery.ok", File_Name, strNextSeq);

                        if (!File.Exists(string.Format("{0}\\{1}", File_Path_IN, strNextFileName)))
                        {
                            break;
                        }
                        else
                        {
                            File_Path_Name = File_Path_Name.Replace(strCurrentSeq + ".delivery", strNextSeq + ".delivery");
                        }
                    }

                    DBT.Commit();//交易成功

                }
                catch (Exception ex)
                {
                    DBT.Rollback();//交易失敗
                    throw ex;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return bResult;

            #endregion
        }