Exemple #1
0
        public BO_OCF GetOCF()
        {
            BO_OCF boOCF = null;

            DataTable dt = GetData();

            if (dt.Rows.Count != 0)
            {
                boOCF               = new BO_OCF();
                boOCF.OCF_DATE      = Convert.ToDateTime(dt.Rows[0]["OCF_DATE"]);
                boOCF.OCF_NEXT_DATE = Convert.ToDateTime(dt.Rows[0]["OCF_NEXT_DATE"]);
                boOCF.OCF_PREV_DATE = Convert.ToDateTime(dt.Rows[0]["OCF_PREV_DATE"]);
            }

            return(boOCF);
        }
Exemple #2
0
        public List <BO_OCF> GetOCFList()
        {
            List <BO_OCF> list = new List <BO_OCF>();
            BO_OCF        boOCF;

            DataTable dt = GetDataList();

            if (dt.Rows.Count != 0)
            {
                foreach (DataRow row in dt.Constraints)
                {
                    boOCF               = new BO_OCF();
                    boOCF.OCF_DATE      = Convert.ToDateTime(row["OCF_DATE"]);
                    boOCF.OCF_NEXT_DATE = Convert.ToDateTime(row["OCF_NEXT_DATE"]);
                    boOCF.OCF_PREV_DATE = Convert.ToDateTime(row["OCF_PREV_DATE"]);
                    list.Add(boOCF);
                }
            }

            return(list);
        }
Exemple #3
0
        public bool setOCF(DateTime OCF_DATE, string DB_TYPE, string USER_ID)
        {
            OCF    ocf   = new OCF(DB_TYPE);
            BO_OCF boOCF = ocf.GetOCF();

            if (boOCF == null)
            {
                MessageDisplay.Error("交易日期檔(OCF)讀取錯誤!");
                return(false);
            }

            if (DB_TYPE == "futAH" || DB_TYPE == "optAH")
            {
                if (MessageDisplay.Choose($"請確定交易日期({boOCF.OCF_DATE.AsString("yyyy/MM/dd")}) 沒有例外而遞延日期?\r\n(eg.颱風,災害...)") == System.Windows.Forms.DialogResult.No)
                {
                    return(false);
                }
            }

            //清除異動紀錄檔
            daoFutAHOCFUPD.Delete();
            daoOptAHOCFUPD.Delete();

            if (DB_TYPE == "futAH")
            {
                daoFutAHOCFUPD.Insert(boOCF.OCF_PREV_DATE, boOCF.OCF_DATE, OCF_DATE, USER_ID);
                ConnectionInfo connectionInfo = SettingDragons.Instance.GetConnectionInfo(DB_TYPE);
                ResultData     resultData     = serviceCommon.ExecuteStoredProcedure(connectionInfo, "futAH.sp_FAH_chg_OCF_Hdata", null, false);
            }
            else if (DB_TYPE == "optAH")
            {
                daoOptAHOCFUPD.Insert(boOCF.OCF_PREV_DATE, boOCF.OCF_DATE, OCF_DATE, USER_ID);
                ConnectionInfo connectionInfo = SettingDragons.Instance.GetConnectionInfo(DB_TYPE);
                ResultData     resultData     = serviceCommon.ExecuteStoredProcedure(connectionInfo, "optAH.sp_OAH_chg_OCF_Hdata", null, false);
            }

            //更新OCF_DATE
            return(ocf.UpdateDate(OCF_DATE));
        }