protected void Button2_Click(object sender, EventArgs e)
{
try
{
if (f_date.Text != "" && t_date.Text != "")
{
//Path
DataSet ds = new DataSet();
DataTable dt = new DataTable();
string fdate = f_date.Text;
DateTime fd = DateTime.ParseExact(fdate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
String fmdate = fd.ToString("yyyy-MM-dd");
string tdate = t_date.Text;
DateTime td = DateTime.ParseExact(tdate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
String tmdate = td.ToString("yyyy-MM-dd");
string skav_no = string.Empty;
if (DD_kaw.SelectedValue != "")
{
DataTable ddokdicno_pro = new DataTable();
ddokdicno_pro = DBCon.Ora_Execute_table("select DISTINCT Area_Code,Area_Name from Ref_Kawasan where Area_Name='" + DD_kaw.SelectedValue + "'");
skav_no = ddokdicno_pro.Rows[0]["Area_Code"].ToString();
}
if (rpt_type.SelectedValue == "01")
{
if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "")
{
dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[1] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "")
{
dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "")
{
dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_region_cd='" + DD_wilayah.SelectedValue + "' group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue != "")
{
dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_region_cd='" + DD_wilayah.SelectedValue + "' and mem_branch_cd='" + DD_cawangan.SelectedValue + "' group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue != "")
{
dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_region_cd='" + DD_wilayah.SelectedValue + "' and mem_branch_cd='" + DD_cawangan.SelectedValue + "' and mem_centre like '%" + txt_pusat.Text + "%' group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "")
{
dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_centre like '%" + txt_pusat.Text + "%' group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "")
{
dt = DBCon.Ora_Execute_table("select ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,mem_new_icno,mem_name,FORMAT(sha_txn_dt,'dd/MM/yyyy', 'en-us') as Tk_dt,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno and mm.Acc_sts='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where ms.Acc_sts='Y' and sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_centre like '%" + txt_pusat.Text + "%' group by wl.wilayah_name,wl.cawangan_name,mem_centre,mem_new_icno,mem_name,sha_txn_dt order by wilayah_name,cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);//
}
string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty, ss5 = string.Empty, rdlc_name = string.Empty, DS_name = string.Empty;
if (DD_kaw.SelectedValue != "")
{
ss1 = DD_kaw.SelectedItem.Text;
}
else
{
ss1 = "SEMUA";
}
if (DD_wilayah.SelectedValue != "")
{
ss2 = DD_wilayah.SelectedItem.Text;
}
else
{
ss2 = "SEMUA";
}
if (DD_cawangan.SelectedValue != "")
{
ss3 = DD_cawangan.SelectedItem.Text;
}
else
{
ss3 = "SEMUA";
}
RptviwerLKSENARI.Reset();
RptviwerLKSENARI.LocalReport.Refresh();
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
if (countRow != 0)
{
RptviwerLKSENARI.LocalReport.DataSources.Clear();
RptviwerLKSENARI.LocalReport.ReportPath = "LK_tambahan_senrept.rdlc";
ReportDataSource rds = new ReportDataSource("LK_tambahan_senrept", dt);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("s1", f_date.Text),
new ReportParameter("s2", t_date.Text),
new ReportParameter("s3", ss1),
new ReportParameter("s4", ss2),
new ReportParameter("s5", ss3),
new ReportParameter("s6", ss4),
new ReportParameter("s7", ss5),
new ReportParameter("s8", rpt_type.SelectedItem.Text)
};
RptviwerLKSENARI.LocalReport.SetParameters(rptParams);
RptviwerLKSENARI.LocalReport.DataSources.Add(rds);
//Refresh
RptviwerLKSENARI.LocalReport.Refresh();
//List<ReportParameter> paramList = new List<ReportParameter>();
//paramList.Add(new ReportParameter("RowsPerPage", "30"));
//RptviwerLKSENARI.LocalReport.SetParameters(paramList);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
else
{
if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "")
{
dt = DBCon.Ora_Execute_table("select count(mem_new_icno) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[1] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "")
{
dt = DBCon.Ora_Execute_table("select count(mem_new_icno) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "")
{
dt = DBCon.Ora_Execute_table("select count(mem_new_icno) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_region_cd='" + DD_wilayah.SelectedValue + "' group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue != "")
{
dt = DBCon.Ora_Execute_table("select count(mem_new_icno) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_region_cd='" + DD_wilayah.SelectedValue + "' and mem_branch_cd='" + DD_cawangan.SelectedValue + "' group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue != "")
{
dt = DBCon.Ora_Execute_table("select count(mem_new_icno) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_region_cd='" + DD_wilayah.SelectedValue + "' and mem_branch_cd='" + DD_cawangan.SelectedValue + "' and mem_centre like '%" + txt_pusat.Text + "%' group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "")
{
dt = DBCon.Ora_Execute_table("select count(mem_new_icno) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_area_cd ='" + skav_no + "' and mem_centre like '%" + txt_pusat.Text + "%' group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "")
{
dt = DBCon.Ora_Execute_table("select count(ISNULL(mem_new_icno,'')) as sh4,ISNULL(wl.wilayah_name,'') as sh1,ISNULL(wl.cawangan_name,'') as sh2,ISNULL(mem_centre,'') as sh3,(SUM(sha_debit_amt)-SUM(sha_credit_amt)) as tot_share from mem_share ms inner join mem_member mm on mm.mem_new_icno = ms.sha_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd where sha_approve_sts_cd = 'TS' and sha_item='TAMBAHAN SYER' and sha_txn_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and sha_txn_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_centre like '%" + txt_pusat.Text + "%' group by wl.wilayah_name,wl.cawangan_name,mem_centre order by wilayah_name,cawangan_name,mem_centre");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);//
}
string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty, ss5 = string.Empty, rdlc_name = string.Empty, DS_name = string.Empty;
if (DD_kaw.SelectedValue != "")
{
ss1 = DD_kaw.SelectedItem.Text;
}
else
{
ss1 = "SEMUA";
}
if (DD_wilayah.SelectedValue != "")
{
ss2 = DD_wilayah.SelectedItem.Text;
}
else
{
ss2 = "SEMUA";
}
if (DD_cawangan.SelectedValue != "")
{
ss3 = DD_cawangan.SelectedItem.Text;
}
else
{
ss3 = "SEMUA";
}
RptviwerLKSENARI.Reset();
RptviwerLKSENARI.LocalReport.Refresh();
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
if (countRow != 0)
{
ss1_stap1.Visible = true;
RptviwerLKSENARI.LocalReport.DataSources.Clear();
RptviwerLKSENARI.LocalReport.ReportPath = "keanggotan/LK_tambahan_ringrept.rdlc";
ReportDataSource rds = new ReportDataSource("LK_tambahan_ringrept", dt);
ss2 = ss2.Replace("s4", String.Empty);
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("s1", f_date.Text),
new ReportParameter("s2", t_date.Text),
new ReportParameter("s3", ss1),
new ReportParameter("s4", ss2),
new ReportParameter("s5", ss3),
new ReportParameter("s6", ss4),
new ReportParameter("s7", ss5),
new ReportParameter("s8", "")
};
RptviwerLKSENARI.LocalReport.SetParameters(rptParams);
RptviwerLKSENARI.LocalReport.DataSources.Add(rds);
//Refresh
RptviwerLKSENARI.LocalReport.Refresh();
System.Threading.Thread.Sleep(1);
//List<ReportParameter> paramList = new List<ReportParameter>();
//paramList.Add(new ReportParameter("RowsPerPage", "30"));
//RptviwerLKSENARI.LocalReport.SetParameters(paramList);
}
else
{
ss1_stap1.Visible = false;
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
}
else
{
ss1_stap1.Visible = false;
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Medan Input Adalah Mandatori.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
catch (Exception ex)
{
throw ex;
//Response.Redirect("LK_SENARI.aspx");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{
if (f_date.Text != "" && t_date.Text != "")
{
//Path
DataSet ds = new DataSet();
DataTable dt = new DataTable();
string fdate = f_date.Text;
DateTime fd = DateTime.ParseExact(fdate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
String fmdate = fd.ToString("yyyy-MM-dd");
string tdate = t_date.Text;
DateTime td = DateTime.ParseExact(tdate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
String tmdate = td.ToString("yyyy-MM-dd");
disp_sts.Text = DD_STS_ANGGO.SelectedItem.Text;
string skav_no = string.Empty;
if (DD_kaw.SelectedValue != "")
{
DataTable ddokdicno_pro = new DataTable();
ddokdicno_pro = DBCon.Ora_Execute_table("select DISTINCT Area_Code,Area_Name from Ref_Kawasan where Area_Name='" + DD_kaw.SelectedValue + "'");
skav_no = ddokdicno_pro.Rows[0]["Area_Code"].ToString();
}
//if (DD_STS_ANGGO.SelectedValue == "TL")
//{
// if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "")
// {
// dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt ");
// ds.Tables.Add(dt);
// }
// else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "")
// {
// dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt ");
// ds.Tables.Add(dt);
// }
// else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "")
// {
// dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and wilayah_cd='" + DD_wilayah.SelectedValue + "' and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt ");
// ds.Tables.Add(dt);
// }
// else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue != "" && DD_STS_ANGGO.SelectedValue != "")
// {
// dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and wilayah_cd='" + DD_wilayah.SelectedValue + "' and cawangan_cd='" + DD_cawangan.SelectedValue + "' and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt ");
// ds.Tables.Add(dt);
// }
// else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue != "" && DD_STS_ANGGO.SelectedValue != "")
// {
// dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and wilayah_cd='" + DD_wilayah.SelectedValue + "' and cawangan_cd='" + DD_cawangan.SelectedValue + "' and mem_centre like ('%" + txt_pusat.Text + "%') and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt ");
// ds.Tables.Add(dt);
// }
// else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "")
// {
// dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and mem_centre like ('%" + txt_pusat.Text + "%') and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt ");
// ds.Tables.Add(dt);
// }
// else if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "")
// {
// dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_centre like ('%" + txt_pusat.Text + "%') and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt ");
// ds.Tables.Add(dt);
// }
// else
// {
// ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Rekod Tidak Dijumpai.');", true);//
// }
//}
//else if (DD_STS_ANGGO.SelectedValue == "L")
//{
if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "")
{
//dt = DBCon.Ora_Execute_table("select ISNULL(rk.Area_Name,'') s1,ISNULL(wilayah_name,'') s2,ISNULL(cawangan_name,'') s3,ISNULL(mem_centre,'') s4,ISNULL(mem_new_icno,'') s5,ISNULL(mem_name,'') s6,ISNULL(set_apply_amt,'') s7,FORMAT(set_appprove_dt,'dd/MM/yyyy') s8 From mem_settlement st inner join mem_member mm on mm.mem_new_icno=st.set_new_icno left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt order by Area_Name,wilayah_name,cawangan_name,mem_centre,mem_new_icno,mem_name,set_apply_amt,set_appprove_dt ");
dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "")
{
dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "")
{
dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and wilayah_cd='" + DD_wilayah.SelectedValue + "' and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text == "" && DD_cawangan.SelectedValue != "" && DD_STS_ANGGO.SelectedValue != "")
{
dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and wilayah_cd='" + DD_wilayah.SelectedValue + "' and cawangan_cd='" + DD_cawangan.SelectedValue + "' and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue != "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue != "" && DD_STS_ANGGO.SelectedValue != "")
{
dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and wilayah_cd='" + DD_wilayah.SelectedValue + "' and cawangan_cd='" + DD_cawangan.SelectedValue + "' and mem_centre like ('%" + txt_pusat.Text + "%') and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue != "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "")
{
dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and kawasan_code='" + skav_no + "' and mem_centre like ('%" + txt_pusat.Text + "%') and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else if (DD_kaw.SelectedValue == "" && DD_wilayah.SelectedValue == "" && txt_pusat.Text != "" && DD_cawangan.SelectedValue == "" && DD_STS_ANGGO.SelectedValue != "")
{
dt = DBCon.Ora_Execute_table("select asb.mem_name as name,asb.mohon_dt,mem_new_icno s3,SUM(asb.set_apply_amt) s4,ISNULL(asb.cawangan_name,'') s1,asb.mem_centre s2 from (select mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,FORMAT(set_txn_dt,'dd/MM/yyyy', 'en-us') as mohon_dt from mem_settlement st left join mem_member mm on mm.mem_new_icno=st.set_new_icno and mm.Acc_sts ='Y' left join Ref_Cawangan as WL on WL.Wilayah_Code=MM.mem_region_cd and WL.cawangan_code=MM.mem_branch_cd left join Ref_Kawasan rk on rk.Area_Code=MM.mem_area_cd where st.Acc_sts ='Y' and set_appprove_dt>=DATEADD(day, DATEDIFF(day, 0, '" + fmdate + "'), 0) and set_appprove_dt<=DATEADD(day, DATEDIFF(day, 0, '" + tmdate + "'), +1) and mem_centre like ('%" + txt_pusat.Text + "%') and set_approve_sts_cd='" + DD_STS_ANGGO.SelectedValue + "' group by mem_new_icno,set_apply_amt,cawangan_name,mem_centre,mem_name,set_txn_dt) asb group by asb.cawangan_name,asb.mem_centre,mem_new_icno,asb.mem_name,asb.mohon_dt order by cawangan_name,mem_centre,mem_name");
ds.Tables.Add(dt);
if (dt.Rows.Count % 20 != 0)
{
int addCount = 20 - dt.Rows.Count % 20;
for (int i = 0; i < addCount; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);//
}
//}
string ss1 = string.Empty, ss2 = string.Empty, ss3 = string.Empty, ss4 = string.Empty, ss5 = string.Empty, ss6 = string.Empty, ss7 = string.Empty;
if (DD_kaw.SelectedValue != "")
{
ss1 = DD_kaw.SelectedItem.Text;
}
else
{
ss1 = "SEMUA";
}
if (DD_wilayah.SelectedValue != "")
{
ss2 = DD_wilayah.SelectedItem.Text;
}
else
{
ss2 = "SEMUA";
}
if (DD_cawangan.SelectedValue != "")
{
ss3 = DD_cawangan.SelectedItem.Text;
}
else
{
ss3 = "SEMUA";
}
if (txt_pusat.Text != "")
{
ss4 = txt_pusat.Text;
}
else
{
ss4 = "SEMUA";
}
RptviwerLKSENARI.Reset();
RptviwerLKSENARI.LocalReport.Refresh();
List <DataRow> listResult = dt.AsEnumerable().ToList();
listResult.Count();
int countRow = 0;
countRow = listResult.Count();
string disp = string.Empty;
if (countRow != 0)
{
ss1_stap1.Visible = true;
RptviwerLKSENARI.LocalReport.DataSources.Clear();
//if (DD_STS_ANGGO.SelectedValue == "TL")
//{
// RptviwerLKSENARI.LocalReport.ReportPath = "TLAB_SENARI.rdlc";
// ReportDataSource rds = new ReportDataSource("TLAB_SENARI", dt);
// RptviwerLKSENARI.LocalReport.DataSources.Add(rds);
// disp = "TIDAK_LULUS_ANGGOTA_BAHARU_SENERAI_" + DateTime.Now.ToString("ddMMyyyy");
//}
//else if (DD_STS_ANGGO.SelectedValue=="L")
//{
RptviwerLKSENARI.LocalReport.ReportPath = "keanggotan/TLAB_RINGASAN_RK.rdlc";
ReportDataSource rds = new ReportDataSource("TLAB_RINGASAN_RK", dt);
RptviwerLKSENARI.LocalReport.DataSources.Add(rds);
disp = "TIDAK_LULUS_ANGGOTA_BAHARU_SENERAI_" + DateTime.Now.ToString("ddMMyyyy");
//}
ReportParameter[] rptParams = new ReportParameter[] {
new ReportParameter("p1", f_date.Text),
new ReportParameter("p2", t_date.Text),
new ReportParameter("p3", ss1),
new ReportParameter("p4", ss2),
new ReportParameter("p5", ss3),
new ReportParameter("p6", ss4),
new ReportParameter("p7", disp_sts.Text)
};
RptviwerLKSENARI.LocalReport.SetParameters(rptParams);
RptviwerLKSENARI.LocalReport.DisplayName = disp;
//Refresh
RptviwerLKSENARI.LocalReport.Refresh();
System.Threading.Thread.Sleep(1);
//List<ReportParameter> paramList = new List<ReportParameter>();
//paramList.Add(new ReportParameter("RowsPerPage", "30"));
//RptviwerLKSENARI.LocalReport.SetParameters(paramList);
}
else
{
ss1_stap1.Visible = false;
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Rekod Tidak Dijumpai.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
else
{
ss1_stap1.Visible = false;
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "$.Zebra_Dialog('Medan Input Adalah Mandatori.',{'type': 'warning','title': 'Warning','auto_close': 2000});", true);
}
}
catch (Exception ex)
{
throw ex;
//Response.Redirect("LK_SENARI.aspx");
}
}
