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(); } } }
void LoadSourcetType(string reportSourceID) { dsAll = new List <ImportDTO>(); allFile = new List <string>(); // 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; } // LoadDetail(dtDetail); ddlSourceType.DataSource = dtDetail; ddlSourceType.DisplayMember = "SourceFileRefName"; ddlSourceType.ValueMember = "KeyWord"; }
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; }