public W20231_2(string programID, string programName) : base(programID, programName) { InitializeComponent(); this.Text = "20231 ─ " + _ProgramName + " 新增個股契約基本資料"; GridHelper.SetCommonGrid(gvMain); PrintableComponent = gcMain; dao20231 = new D20231(); //系統 ApdkProdType(); //商品子類別 ApdkProdSubtype(); //商品對照類別 //ApdkParamKey(); //上市/上櫃 UnderlyingMarket(); //一般/小型 ApdkRemark(); //盤別 ApdkMarketClose(); //幣別 ApdkCurrencyType(); // 設定List LookupItem變數項目 SetOtherLookupItem(); }
public void TxtWriteToDataTableTest() { Stream openFile = FileToStream(Path.Combine(Environment.CurrentDirectory, "Excel_Template", "20231.txt")); DataTable dtReadTxt = new D20231().List20231("20180329").Clone(); DataTable dataTable = new B20231().TxtWriteToDataTable(openFile, dtReadTxt); Assert.IsNotNull(dataTable); }
public W20231(string programID, string programName) : base(programID, programName) { InitializeComponent(); this.Text = _ProgramID + "─" + _ProgramName; GridHelper.SetCommonGrid(gvMain); PrintableComponent = gcMain; dao20231 = new D20231(); //統一設定下拉選單TextEditStyles TextEditStyles textEditStyles = TextEditStyles.DisableTextEditor; //期貨 //List<LookupItem> futList = new List<LookupItem>(){ // new LookupItem() { ValueMember = " ", DisplayMember = " "}, // new LookupItem() { ValueMember = "F", DisplayMember = "○" }}; DataTable dtFut = new CODW().ListLookUpEdit("20231", "PLS4_FUT"); Pls4FutLookUpEdit.SetColumnLookUp(dtFut, "CODW_ID", "CODW_DESC", textEditStyles, null); PLS4_FUT.ColumnEdit = Pls4FutLookUpEdit; //選擇權 //List<LookupItem> optList = new List<LookupItem>(){ // new LookupItem() { ValueMember = " ", DisplayMember = " "}, // new LookupItem() { ValueMember = "O", DisplayMember = "○" }}; DataTable dtOpt = new CODW().ListLookUpEdit("20231", "PLS4_OPT"); Pls4OptLookUpEdit.SetColumnLookUp(dtOpt, "CODW_ID", "CODW_DESC", textEditStyles, null); PLS4_OPT.ColumnEdit = Pls4OptLookUpEdit; //商品類別 //List<LookupItem> codeList = new List<LookupItem>(){ // new LookupItem() { ValueMember = "I", DisplayMember = "新增"}, // new LookupItem() { ValueMember = "M", DisplayMember = "小型"}, // new LookupItem() { ValueMember = "N", DisplayMember = " " }}; DataTable dtCode = new CODW().ListLookUpEdit("20231", "PLS4_STATUS_CODE"); Pls4StatusCodeLookUpEdit.SetColumnLookUp(dtCode, "CODW_ID", "CODW_DESC", textEditStyles, null); PLS4_STATUS_CODE.ColumnEdit = Pls4StatusCodeLookUpEdit; //上市/上櫃 //Pls4PidLookUpEdit.SetColumnLookUp(new COD().ListByCol("TFXM", "TFXM_PID"), "COD_ID", "COD_DESC", textEditStyles, null); DataTable dtTFXM = new CODW().ListLookUpEdit("APDK", "UNDERLYING_MARKET"); Pls4PidLookUpEdit.SetColumnLookUp(dtTFXM, "CODW_ID", "CODW_DESC", textEditStyles, null); PLS4_PID.ColumnEdit = Pls4PidLookUpEdit; //預設隱藏DataGridView gcMain.Visible = false; }