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