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; }
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; }
protected override ResultStatus Save(PokeBall pokeBall) { string ShowMsg = "儲存錯誤"; try { if (gvMain.RowCount == 0) { MessageDisplay.Info("沒有變更資料,不需要存檔!"); return(ResultStatus.Fail); } dao40071 = new D40071(); daoMGD2 = new MGD2(); daoMGD2L = new MGD2L(); #region ue_save_before gvMain.CloseEditor(); gvMain.UpdateCurrentRow(); string ymd, issueBeginYmd, kindID, adjTypeName, tradeYmd, adjRsn, adjType; decimal cm = 0, curCm; int count; /*************************** * 調整類型: * 0一般 * 1長假 * 2處置股票 * 3股票 ****************************/ adjType = "0"; ymd = txtSDate.DateTimeValue.ToString("yyyyMMdd"); DataTable dtGrid = (DataTable)gcMain.DataSource; DataView dv = dtGrid.AsDataView(); dv.RowFilter = " ab_type in ('-','A')"; DataTable dtFiltered = dv.ToTable(); //dw_1 cbxCodeY.Checked = true; cbxCodeN.Checked = true; cbxCode.Checked = true; foreach (DataRow dr in dtFiltered.Rows) { if (dr.RowState == DataRowState.Deleted) { continue; } kindID = dr["KIND_ID"].AsString(); issueBeginYmd = dr["ISSUE_BEGIN_YMD"].AsString(); adjRsn = dr["ADJ_RSN"].AsString(); curCm = dr["CUR_CM"].AsDecimal(); if (adjRsn == "S") { cm = dr["SMA_CM"].AsDecimal(); } if (adjRsn == "E") { cm = dr["EWMA_CM"].AsDecimal(); } if (adjRsn == "M") { cm = dr["MAXV_CM"].AsDecimal(); } if (adjRsn == "s") { cm = dr["FUT_SMA_CM"].AsDecimal(); } if (adjRsn == "e") { cm = dr["FUT_EWMA_CM"].AsDecimal(); } if (adjRsn == "m") { cm = dr["FUT_MAXV_CM"].AsDecimal(); } if (adjRsn == "U") { cm = dr["USER_CM"].AsDecimal(); } if (dr["ADJ_CODE"].AsString() == "Y") { /****************************************** * 確認商品是否在同一交易日不同情境下設定過 ******************************************/ DataTable dtCheck = daoMGD2.IsProdSetOnSameDay(kindID, ymd, adjType); count = dtCheck.Rows[0]["LI_COUNT"].AsInt(); adjTypeName = dtCheck.Rows[0]["LS_ADJ_TYPE_NAME"].AsString(); if (count > 0) { MessageDisplay.Error(kindID + ",交易日(" + ymd + ")在" + adjTypeName + "已有資料"); return(ResultStatus.FailButNext); } /********************************* * 確認商品是否在同一生效日區間設定過 * 生效起日若與生效迄日相同,不重疊 * ex: 10/11的至10/31一般交易時段結束止,10/30的從10/31一般交易時段結束後始>>應不重疊 *************************************/ dtCheck = daoMGD2.IsProdSetInSameInterval(kindID, ymd, issueBeginYmd); count = dtCheck.Rows[0]["LI_COUNT"].AsInt(); adjTypeName = dtCheck.Rows[0]["LS_ADJ_TYPE_NAME"].AsString(); tradeYmd = dtCheck.Rows[0]["LS_TRADE_YMD"].AsString(); if (count > 0) { MessageDisplay.Error(kindID + "," + adjTypeName + ",交易日(" + tradeYmd + ")在同一生效日區間內已有資料"); return(ResultStatus.FailButNext); } if (cm == curCm) { MessageDisplay.Error(kindID + ",調整前後保證金一致,請重新輸入"); return(ResultStatus.FailButNext); } }//if (dr["ADJ_CODE"].AsString() == "Y") /************************************** * 判斷調整前後值不同,相同則警示且無法存檔 **************************************/ if (adjRsn == "U") { if (cm == 0) { MessageDisplay.Error(kindID + ",請輸入保證金金額"); return(ResultStatus.FailButNext); } } if (cm == 0) { MessageDisplay.Error(kindID + ",保證金計算值為空,請選擇其他模型"); return(ResultStatus.FailButNext); } } #endregion DateTime wTime, date; date = txtSDate.DateTimeValue; int found, colIndex, found2, currRow; string dbname; decimal curMM = 0, curIM = 0, MM = 0, IM = 0, rate = 0; wTime = DateTime.Now; DataTable dtMGD2 = dao40071.d_40071(ymd, adjType); //ids_mgd2 DataTable dtMGD2Log = dao40071.d_40071_log(); //ids_old dtMGD2Log.Clear(); //只取schema //再產生一張空的 d_40071 table DataTable dtEmpty = dao40071.d_40071(ymd, adjType); //dw_3 dtEmpty.Clear(); dtEmpty.Columns.Remove(dtEmpty.Columns["CPSORT"]); //刪除排序用的運算欄位 foreach (DataRow dr in dtFiltered.Rows) { if (dr.RowState == DataRowState.Deleted) { continue; } kindID = dr["KIND_ID"].ToString(); issueBeginYmd = dr["ISSUE_BEGIN_YMD"].AsString(); adjRsn = dr["ADJ_RSN"].AsString(); dv = dtMGD2.AsDataView(); dv.RowFilter = "MGD2_KIND_ID = '" + kindID + "'"; DataTable dtMGD2Filtered = dv.ToTable(); if (dtMGD2Filtered.Rows.Count > 0) { foreach (DataRow drMGD2 in dtMGD2Filtered.Rows) { currRow = dtMGD2Log.Rows.Count; dtMGD2Log.Rows.Add(); for (colIndex = 0; colIndex < dtMGD2.Columns.Count; colIndex++) { //先取欄位名稱,因為兩張table欄位順序不一致 dbname = dtMGD2.Columns[colIndex].ColumnName; if (dbname == "CPSORT") { continue; //這個欄位是拿來排序用的,故無需複製 } dtMGD2Log.Rows[currRow][dbname] = drMGD2[colIndex]; } if (dr["ADJ_CODE"].AsString() == "N") { dtMGD2Log.Rows[currRow]["MGD2_L_TYPE"] = "D"; } else { dtMGD2Log.Rows[currRow]["MGD2_L_TYPE"] = "U"; } dtMGD2Log.Rows[currRow]["MGD2_L_USER_ID"] = GlobalInfo.USER_ID; dtMGD2Log.Rows[currRow]["MGD2_L_TIME"] = wTime; }//foreach (DataRow drMGD2 in dtMGD2.Rows) //刪除已存在資料 ShowMsg = "MGD2資料刪除失敗"; if (daoMGD2.DeleteMGD2(ymd, adjType, kindID) < 0) { MessageDisplay.Error("MGD2資料刪除失敗"); return(ResultStatus.FailButNext); } } //判斷是否重新塞入新資料 count = daoMGD2.IsInsertNeeded(ymd, adjType, kindID); if (count == 0) { dtEmpty.Rows.Add(); found = dtEmpty.Rows.Count - 1; dtEmpty.Rows[found]["MGD2_YMD"] = ymd; dtEmpty.Rows[found]["MGD2_PROD_TYPE"] = dr["PROD_TYPE"]; dtEmpty.Rows[found]["MGD2_KIND_ID"] = kindID; dtEmpty.Rows[found]["MGD2_ADJ_TYPE"] = adjType; curCm = dr["CUR_CM"].AsDecimal(); curMM = dr["CUR_MM"].AsDecimal(); curIM = dr["CUR_IM"].AsDecimal(); dtEmpty.Rows[found]["MGD2_CUR_CM"] = curCm; dtEmpty.Rows[found]["MGD2_CUR_MM"] = curMM; dtEmpty.Rows[found]["MGD2_CUR_IM"] = curIM; if (adjRsn == "S") { rate = dr["SMA_ADJ_RATE"].AsDecimal(); cm = dr["SMA_CM"].AsDecimal(); MM = dr["SMA_MM"].AsDecimal(); IM = dr["SMA_IM"].AsDecimal(); } if (adjRsn == "E") { rate = dr["EWMA_ADJ_RATE"].AsDecimal(); cm = dr["EWMA_CM"].AsDecimal(); MM = dr["EWMA_MM"].AsDecimal(); IM = dr["EWMA_IM"].AsDecimal(); } if (adjRsn == "M") { rate = dr["MAXV_ADJ_RATE"].AsDecimal(); cm = dr["MAXV_CM"].AsDecimal(); MM = dr["MAXV_MM"].AsDecimal(); IM = dr["MAXV_IM"].AsDecimal(); } if (adjRsn == "s") { rate = dr["FUT_SMA_ADJ_RATE"].AsDecimal(); cm = dr["FUT_SMA_CM"].AsDecimal(); MM = dr["FUT_SMA_MM"].AsDecimal(); IM = dr["FUT_SMA_IM"].AsDecimal(); } if (adjRsn == "e") { rate = dr["FUT_EWMA_ADJ_RATE"].AsDecimal(); cm = dr["FUT_EWMA_CM"].AsDecimal(); MM = dr["FUT_EWMA_MM"].AsDecimal(); IM = dr["FUT_EWMA_IM"].AsDecimal(); } if (adjRsn == "m") { rate = dr["FUT_MAXV_ADJ_RATE"].AsDecimal(); cm = dr["FUT_MAXV_CM"].AsDecimal(); MM = dr["FUT_MAXV_MM"].AsDecimal(); IM = dr["FUT_MAXV_IM"].AsDecimal(); } if (adjRsn == "U") { if (kindID == "MXF") { found2 = dtFiltered.Rows.IndexOf(dtFiltered.Select("kind_id = 'TXF'").FirstOrDefault()); cm = dtFiltered.Rows[found2]["USER_CM"].AsDecimal(); MM = dao40070.GetMarginVal("TXF", cm, 0, "MM"); MM = dao40070.GetMarginVal(kindID, MM, 0, "MTX_MM"); IM = dao40070.GetMarginVal("TXF", cm, 0, "IM"); IM = dao40070.GetMarginVal(kindID, IM, 0, "MTX_IM"); cm = dr["USER_CM"].AsDecimal(); } else { cm = dr["USER_CM"].AsDecimal(); MM = dao40070.GetMarginVal(kindID, cm, 0, "MM"); IM = dao40070.GetMarginVal(kindID, cm, 0, "IM"); } rate = dao40070.GetMarginVal(kindID, cm, curCm, "ADJ"); } dtEmpty.Rows[found]["MGD2_ADJ_RATE"] = rate; dtEmpty.Rows[found]["MGD2_CM"] = cm; dtEmpty.Rows[found]["MGD2_MM"] = MM; dtEmpty.Rows[found]["MGD2_IM"] = IM; dtEmpty.Rows[found]["MGD2_ADJ_RSN"] = adjRsn; dtEmpty.Rows[found]["MGD2_ADJ_CODE"] = dr["ADJ_CODE"]; dtEmpty.Rows[found]["MGD2_ISSUE_BEGIN_YMD"] = issueBeginYmd; dtEmpty.Rows[found]["MGD2_STOCK_ID"] = " "; dtEmpty.Rows[found]["MGD2_PROD_SUBTYPE"] = dr["PROD_SUBTYPE"]; dtEmpty.Rows[found]["MGD2_PARAM_KEY"] = dr["PARAM_KEY"]; dtEmpty.Rows[found]["MGD2_AB_TYPE"] = dr["AB_TYPE"]; dtEmpty.Rows[found]["MGD2_CURRENCY_TYPE"] = dr["CURRENCY_TYPE"]; dtEmpty.Rows[found]["MGD2_SEQ_NO"] = dr["SEQ_NO"]; dtEmpty.Rows[found]["MGD2_OSW_GRP"] = dr["OSW_GRP"]; dtEmpty.Rows[found]["MGD2_AMT_TYPE"] = dr["AMT_TYPE"]; dtEmpty.Rows[found]["MGD2_W_TIME"] = wTime; dtEmpty.Rows[found]["MGD2_W_USER_ID"] = GlobalInfo.USER_ID; //type 有AB值分兩筆存 if (dr["AB_TYPE"].AsString() == "A") { //DataRow drA = dtEmpty.Rows[found]; //dtEmpty.Rows.InsertAt(drA, found - 1); dtEmpty.ImportRow(dtEmpty.Rows[found]); found2 = dtTemp.Rows.IndexOf(dtTemp.Select("kind_id = '" + kindID + "' and ab_type = 'B'").FirstOrDefault()); if (found2 < 0) { MessageDisplay.Error(kindID + "無保證金B值資料!"); return(ResultStatus.FailButNext); } found = dtEmpty.Rows.Count - 1; dtEmpty.Rows[found]["MGD2_AB_TYPE"] = "B"; dtEmpty.Rows[found]["MGD2_CUR_CM"] = dtTemp.Rows[found2]["CUR_CM"]; dtEmpty.Rows[found]["MGD2_CUR_MM"] = dtTemp.Rows[found2]["CUR_MM"]; dtEmpty.Rows[found]["MGD2_CUR_IM"] = dtTemp.Rows[found2]["CUR_IM"]; if (adjRsn == "S") { dtEmpty.Rows[found]["MGD2_CM"] = dtTemp.Rows[found2]["SMA_CM"]; dtEmpty.Rows[found]["MGD2_MM"] = dtTemp.Rows[found2]["SMA_MM"]; dtEmpty.Rows[found]["MGD2_IM"] = dtTemp.Rows[found2]["SMA_IM"]; } if (adjRsn == "E") { dtEmpty.Rows[found]["MGD2_CM"] = dtTemp.Rows[found2]["EWMA_CM"]; dtEmpty.Rows[found]["MGD2_MM"] = dtTemp.Rows[found2]["EWMA_MM"]; dtEmpty.Rows[found]["MGD2_IM"] = dtTemp.Rows[found2]["EWMA_IM"]; } if (adjRsn == "M") { dtEmpty.Rows[found]["MGD2_CM"] = dtTemp.Rows[found2]["MAXV_CM"]; dtEmpty.Rows[found]["MGD2_MM"] = dtTemp.Rows[found2]["MAXV_MM"]; dtEmpty.Rows[found]["MGD2_IM"] = dtTemp.Rows[found2]["MAXV_IM"]; } if (adjRsn == "s") { dtEmpty.Rows[found]["MGD2_CM"] = dtTemp.Rows[found2]["FUT_SMA_CM"]; dtEmpty.Rows[found]["MGD2_MM"] = dtTemp.Rows[found2]["FUT_SMA_MM"]; dtEmpty.Rows[found]["MGD2_IM"] = dtTemp.Rows[found2]["FUT_SMA_IM"]; } if (adjRsn == "e") { dtEmpty.Rows[found]["MGD2_CM"] = dtTemp.Rows[found2]["FUT_EWMA_CM"]; dtEmpty.Rows[found]["MGD2_MM"] = dtTemp.Rows[found2]["FUT_EWMA_MM"]; dtEmpty.Rows[found]["MGD2_IM"] = dtTemp.Rows[found2]["FUT_EWMA_IM"]; } if (adjRsn == "m") { dtEmpty.Rows[found]["MGD2_CM"] = dtTemp.Rows[found2]["FUT_MAXV_CM"]; dtEmpty.Rows[found]["MGD2_MM"] = dtTemp.Rows[found2]["FUT_MAXV_MM"]; dtEmpty.Rows[found]["MGD2_IM"] = dtTemp.Rows[found2]["FUT_MAXV_IM"]; } if (adjRsn == "U") { cm = dao40070.GetMarginVal(kindID, cm, 0, "CM_B"); dtEmpty.Rows[found]["MGD2_CM"] = cm; dtEmpty.Rows[found]["MGD2_MM"] = dao40070.GetMarginVal(kindID, MM, cm, "MM_B"); dtEmpty.Rows[found]["MGD2_IM"] = dao40070.GetMarginVal(kindID, IM, cm, "IM_B"); } } //if (dr["AB_TYPE"].AsString() == "A") } //if (count == 0) } //foreach (DataRow dr in dtFiltered.Rows) //if ib_print = True then // ids_1.dataobject = dw_1.dataobject // ids_1.reset() // dw_1.RowsCopy(1, dw_1.rowcount(), primary!, ids_1, 1, primary!) //end if //dw_3.update() ShowMsg = "更新資料庫MGD2錯誤! "; if (dtEmpty.Rows.Count > 0) { ResultData myResultData = daoMGD2.UpdateMGD2(dtEmpty); if (myResultData.Status == ResultStatus.Fail) { MessageDisplay.Error("更新資料庫MGD2錯誤! "); return(ResultStatus.FailButNext); } } //ids_old.update() ShowMsg = "更新資料庫MGD2L錯誤! "; if (dtMGD2Log.Rows.Count > 0) { ResultData myResultData = daoMGD2L.UpdateMGD2L(dtMGD2Log); if (myResultData.Status == ResultStatus.Fail) { MessageDisplay.Error("更新資料庫MGD2L錯誤! "); return(ResultStatus.FailButNext); } } ReportHelper _ReportHelper = new ReportHelper(gcMain, _ProgramID, this.Text); CommonReportLandscapeA3 reportLandscape = new CommonReportLandscapeA3();//設定為橫向列印 reportLandscape.printableComponentContainerMain.PrintableComponent = gcMain; reportLandscape.IsHandlePersonVisible = false; reportLandscape.IsManagerVisible = false; _ReportHelper.Create(reportLandscape); _ReportHelper.Export(FileType.PDF, _ReportHelper.FilePath); MessageDisplay.Info("報表儲存完成!"); } catch (Exception ex) { MessageDisplay.Error(ShowMsg); WriteLog(ex, "", false); //throw ex; } return(ResultStatus.Success); }