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;
}
