private DataTable dtOLevel; //選擇權級距 public W40073(string programID, string programName) : base(programID, programName) { InitializeComponent(); this.Text = _ProgramID + "─" + _ProgramName; dao40071 = new D40071(); dao40072 = new D40072(); daoMGD2 = new MGD2(); daoMGD2L = new MGD2L(); daoMGRT1 = new MGRT1(); daoMOCF = new MOCF(); dtFLevel = new DataTable(); dtFLevel = daoMGRT1.dddw_mgrt1("F"); //先讀,後面在不同的地方會用到 dtOLevel = new DataTable(); dtOLevel = daoMGRT1.dddw_mgrt1("O"); //先讀,後面在不同的地方會用到 GridHelper.SetCommonGrid(gvMain); GridHelper.SetCommonGrid(gvDetail); gvDetail.AppearancePrint.BandPanel.Font = new Font("Microsoft YaHei", 10); gvDetail.AppearancePrint.BandPanel.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; }
public override ReturnMessageClass Export() { ReturnMessageClass msg = new ReturnMessageClass(); msg.Status = ResultStatus.Fail; try { FilePath = PbFunc.wf_copy_file(ProgramId, $"{ProgramId}_{AdjType}"); base.OpenFileAndSetYear(); //說明文 string prepoStr = Dt.AsEnumerable().Any(d => d.Field <string>("prod_type") == "F") ? "期貨契約保證金及" : ""; foreach (DataRow dr in Dt.Rows) { string abbrName_Desc = dr["KIND_ABBR_NAME"].AsString(); GenKindNameList(dr, prepoStr, "", abbrName_Desc); } string implBeginDate = Dt.Rows[0]["impl_begin_ymd"].AsString(); string implEndDate = Dt.Rows[0]["impl_end_ymd"].AsString(); string mocfDate = new MOCF().GetMaxOcfDate(implBeginDate, implEndDate); implBeginDate = implBeginDate.AsDateTime("yyyyMMdd").AsTaiwanDateTime("{0}年{1}月{2}日", 3); implEndDate = implEndDate.AsDateTime("yyyyMMdd").AsTaiwanDateTime("{0}年{1}月{2}日", 3); mocfDate = mocfDate.AsDateTime("yyyyMMdd").AsTaiwanDateTime("{0}年{1}月{2}日", 3); ReplaceElementWord(implBeginDate, implEndDate, GenArrayTxt(KindNameList_Desc), mocfDate, implEndDate); Doc.Save(FilePath); msg.Status = ResultStatus.Success; return(msg); } catch (Exception ex) { base.ErrorHandle(ex, msg); return(msg); } }
private bool SaveFlag; //用於delete row後, 是曾經執行save function. #endregion public W40074(string programID, string programName) : base(programID, programName) { InitializeComponent(); this.Text = _ProgramID + "─" + _ProgramName; dao40071 = new D40071(); dao40072 = new D40072(); dao40074 = new D40074(); daoMGD2 = new MGD2(); daoMGD2L = new MGD2L(); daoMGRT1 = new MGRT1(); daoMOCF = new MOCF(); daoOCFG = new OCFG(); dtFLevel = daoMGRT1.dddw_mgrt1("F"); //先讀,後面在不同的地方會用到 dtOLevel = daoMGRT1.dddw_mgrt1("O"); //先讀,後面在不同的地方會用到 dtProdType = dao40071.d_40071_prod_type_ddl(); //先讀,後面在不同的地方會用到 dtDel = new DataTable(); kindIDLookUpEdit = new RepositoryItemLookUpEdit(); GridHelper.SetCommonGrid(gvMain); gvMain.AppearancePrint.BandPanel.Font = new Font("Microsoft YaHei", 10); gvMain.AppearancePrint.BandPanel.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; SaveFlag = true; }