void InitialData() { bal = new SourceFile_MappingHeaderBAL(); ds = bal.FindHeaderAndDetailPK(ReportSourceID, MyLogin.USER_LOGIN); if (ds != null) { dtH = ds.Tables[0]; dtDetail = ds.Tables[1]; dtDetail_Col = ds.Tables[2]; } else { dtH = null; dtDetail = null; dtDetail_Col = null; } if (dtDetail != null) { dvFilter = new DataView(dtDetail); dvFilter.RowFilter = string.Format("KeyWord='{0}'", KeyWord); if (dvFilter != null && dvFilter.Count > 0) { txtSourceFile.Text = dvFilter[0]["SourceFileRefName"].ToString(); txtImport.Text = string.Format("{0},{1}", dvFilter[0]["StartRow"].ToString(), dvFilter[0]["StartColumn"].ToString()); txtKeyWord.Text = dvFilter[0]["KeyWord"].ToString(); // txtRemark.Text = ""; // txtFileNameConditon.Text = dvFilter[0]["KeyWord"].ToString(); } } }
private void btnSearch_Click(object sender, EventArgs e) { bal = new SourceFile_MappingHeaderBAL(); DataView dvFilter = new DataView(dtDetail); dvFilter.RowFilter = string.Format("KeyWord='{0}'", ddlSourceType.SelectedValue.ToString()); ds = bal.FindByKeyWord(string.Format("Temp_{0}", ddlSourceType.SelectedValue.ToString()), dtTranDate.Value, dvFilter[0]["DID"].ToString()); splashScreenManager1.ShowWaitForm(); if (ds.Tables.Count > 1 && ds.Tables[1].Rows.Count > 0) { dtDetailList = ds.Tables[0]; LoadDetail(dtDetailList); txtRemark.Text = ds.Tables[1].Rows[0]["Remark"].ToString(); splashScreenManager1.CloseWaitForm(); } else { ClearDetailData(); splashScreenManager1.CloseWaitForm(); DevExpress.XtraEditors.XtraMessageBox.Show("Not Found Data!!", "VIEW", MessageBoxButtons.OK); } }
private void btnView_Click(object sender, EventArgs e) { bal = new SourceFile_MappingHeaderBAL(); dtDetail = bal.FindByKeyWord(string.Format("Temp_{0}", cbSourceType.SelectedValue.ToString())); splashScreenManager1.ShowWaitForm(); LoadDetail(dtDetail); splashScreenManager1.CloseWaitForm(); }
void InitialData() { bal = new SourceFile_MappingHeaderBAL(); DataTable dtHeaderSearch = bal.GetDropDownList(); ddlReportCondition.DataSource = dtHeaderSearch; ddlReportCondition.DisplayMember = "Text"; ddlReportCondition.ValueMember = "Value"; ddlReportCondition.SelectedIndex = 1; LoadMonth(); LoadSourcetType(ddlReportCondition.SelectedValue.ToString()); pnViewMapping.Visible = false; }
void InitailData() { dsAll = new List <ImportDTO>(); allFile = new List <string>(); bal = new SourceFile_MappingHeaderBAL(); ds = bal.FindHeaderAndDetailPK(null, MyLogin.USER_LOGIN); if (ds != null) { dtH = ds.Tables[0]; dtDetail = ds.Tables[1]; dtDetail_Col = ds.Tables[2]; SetupHeader(dtH); LoadSourcetType(dtDetail); } }
void InitailData() { dsAll = new List <ImportDTO>(); allFile = new List <string>(); bal = new SourceFile_MappingHeaderBAL(); ds = bal.FindHeaderAndDetailPK(null, MyLogin.USER_LOGIN); if (ds != null) { dtH = ds.Tables[0]; dtDetail = ds.Tables[1]; SetupHeader(dtH); LoadDetail(dtDetail); } gridView1.RowCellStyle += GridView1_RowCellStyle; }
void InitialData() { bal = new SourceFile_MappingHeaderBAL(); ds = bal.FindHeaderAndDetailPK("1", MyLogin.USER_LOGIN); if (ds != null) { dtH = ds.Tables[0]; dtDetail = ds.Tables[1]; dtDetail_Col = ds.Tables[2]; } SetupHeader(dtDetail); gridView1.HorzScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Always; gridView1.OptionsView.BestFitMode = DevExpress.XtraGrid.Views.Grid.GridBestFitMode.Full; gridView1.OptionsView.ColumnHeaderAutoHeight = DevExpress.Utils.DefaultBoolean.True; gridView1.OptionsView.ColumnAutoWidth = true; gridView1.BestFitColumns(); gridView2.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.Bottom; gridView2.OptionsNavigation.EnterMoveNextColumn = true; }