protected void RetrieveData()
{
System.Data.DataTable dataTable = this.conn.GetDataTable("SELECT * FROM [VW_RFINSTANSI] where INSTANSIID='" + ID + "' ", null, this.dbtimeout, true, true);
if (dataTable.Rows.Count > 0)
{
StaticFramework.Retrieve(dataTable, INSTANSIID);
StaticFramework.Retrieve(dataTable, INSTANSINAME);
}
}
protected void edit_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
//BULAN_PERIODE.SelectedValue = btn.CommandArgument.ToString().Split(':')[0].ToString();
//TANGGAL_PERIODE.SelectedValue = btn.CommandArgument.ToString().Split(':')[1].ToString();
StaticFramework.Retrieve(btn.CommandArgument.ToString().Split(':')[0].ToString(), BULAN_PERIODE);
StaticFramework.Retrieve(btn.CommandArgument.ToString().Split(':')[1].ToString(), KETERANGAN);
}
protected void RetrieveData()
{
object[] param = new object[]
{
ID
};
System.Data.DataTable dataTable = this.conn.GetDataTable("SELECT * FROM [VW_JENISREPORT] where REPORTID =@1", param, this.dbtimeout, true, true);
if (dataTable.Rows.Count > 0)
{
UNIT.Enabled = false;
UNIT.CssClass = "form-control";
StaticFramework.Retrieve(dataTable, REPORTID);
StaticFramework.Retrieve(dataTable, REPORTNAME);
StaticFramework.Retrieve(dataTable, "UNITID", UNIT);
StaticFramework.Retrieve(dataTable, INSTANSIID);
StaticFramework.Retrieve(dataTable, PERIODE);
}
}
protected void RetrieveData()
{
//String AP_REGNO = EncryptAndDecrypt.Decrypt(base.Request.QueryString["IN"].ToString()).ToString();
// String UNIT = EncryptAndDecrypt.Decrypt(base.Request.QueryString["UN"].ToString()).ToString();
// String JENIS = EncryptAndDecrypt.Decrypt(base.Request.QueryString["JN"].ToString()).ToString();
String UNIT = base.Request.QueryString["UN"].ToString().ToString();
String JENIS = base.Request.QueryString["JN"].ToString().ToString();
object[] param = new object[]
{
IdGenerate
};
//System.Data.DataTable dataTable = this.conn.GetDataTable("SELECT INSTANSIID,JENIS, DATETIMELIMIT,KETERANGAN,Sanksi, UNIT,convert(varchar,DATECREATED,126) as DATECREATED,USERCREATED,STATUS FROM DATA_COMPLIANCE where INSTANSIID =@1 and UNIT=@2 and JENIS =@3", param, this.dbtimeout, true, true);
System.Data.DataTable dataTable = conn.GetDataTable("SELECT UNIT,JENIS, DATETIMELIMIT,KETERANGAN,Sanksi,Sanksi_ket, convert(varchar,DATECREATED,126) as DATECREATED,DEPTHEAD,PIC,PERIODE,USERCREATED,STATUS,JENISREPORT FROM VW_DATAALERT where AP_REGNO = @1 ", param, this.dbtimeout, true, true);
if (dataTable.Rows.Count > 0)
{
StaticFramework.Retrieve(dataTable, this.UNIT);
StaticFramework.Retrieve(dataTable, this.KETERANGAN);
StaticFramework.Reff(this.JENIS, "SELECT REPORTID , REPORTNAME FROM VW_JENISREPORT WHERE UNITID ='" + UNIT + "'AND INSTANSIID in (SELECT SPLITDATA FROM [dbo].[fnSplitString]('" + instansi + "',','))", null, this.conn, false);
//StaticFramework.Reff(this.PIC, "SELECT [USERID] , [SU_FULLNAME] FROM [MRSDATA].[dbo].[VW_USER] WHERE UNIT ='" + UNIT + "' and [GROUPID] ='002PEN'", null, this.conn, false);
StaticFramework.Reff(this.DEPTHEAD, "SELECT [USERID] , [SU_FULLNAME] FROM [MRSDATA].[dbo].[VW_HEAD] WHERE UNIT ='" + UNIT + "'", null, this.conn, false);
System.Data.DataTable dt = conn.GetDataTable("SELECT * FROM VW_GETINSTANSI where AP_REGNO = @1 ", param, this.dbtimeout, true, true);
if (dt.Rows.Count > 0)
{
for (int a = 0; a < dt.Rows.Count; a++)
{
for (int i = 0; i < INSTANSIID.Items.Count; i++)
{
if (dt.Rows[a]["INSTANSIID"].ToString() == INSTANSIID.Items[i].Value.ToString())
{
INSTANSIID.Items[i].Selected = true;
}
}
}
}
StaticFramework.Retrieve(dataTable, DEPTHEAD);
StaticFramework.Reff(this.PIC, "SELECT [USERID] , [SU_FULLNAME] FROM [MRSDATA].[dbo].[VW_USER] WHERE UNIT ='" + UNIT + "' and SU_UPLINER='" + DEPTHEAD.SelectedValue.ToString() + "' and [GROUPID] ='002PEN'", null, this.conn, false);
StaticFramework.Retrieve(dataTable, PIC);
StaticFramework.Retrieve(dataTable, PERIODE);
System.Data.DataTable dt_PERIODE = conn.GetDataTable("SELECT * FROM VW_RFPERIODE where PERIODEID= '" + PERIODE.SelectedValue.ToString() + "' ", null, this.dbtimeout, true, true);
if (dt_PERIODE.Rows.Count > 0)
{
s_periode = dt_PERIODE.Rows[0]["FLAG"].ToString();
if (dt_PERIODE.Rows[0]["FLAG"].ToString().Equals("1"))
{
div_ListPelaporan.Style.Add("display", "");
div_BulanPelaporan.Style.Add("display", "");
div_tanggalPelaporan.Style.Add("display", "NONE");
StaticFramework.Reff(this.TANGGAL_PERIODE, Q_TANGGAL, null, this.conn, false);
StaticFramework.Reff(this.BULAN_PERIODE, Q_BULAN, null, this.conn, false);
Bind_DataList();
}
else
if (dt_PERIODE.Rows[0]["FLAG"].ToString().Equals("2"))
{
div_BulanPelaporan.Style.Add("display", "NONE");
div_ListPelaporan.Style.Add("display", "NONE");
div_tanggalPelaporan.Style.Add("display", "NONE");
}
else
{
div_BulanPelaporan.Style.Add("display", "NONE");
div_ListPelaporan.Style.Add("display", "NONE");
div_tanggalPelaporan.Style.Add("display", "");
StaticFramework.Reff(this.DATETIMELIMIT, Q_TANGGAL, null, this.conn, false);
StaticFramework.Retrieve(dataTable, DATETIMELIMIT);
}
}
StaticFramework.Retrieve(dataTable, JENISREPORT);
StaticFramework.Reff(this.JENIS, "SELECT REPORTID , REPORTNAME FROM VW_JENISREPORT WHERE UNITID ='" + UNIT + "' ", null, this.conn, false);
StaticFramework.Retrieve(dataTable, this.JENIS);
//StaticFramework.Retrieve(dataTable, this.Sanksi);
Sanksi.Value = String.Format(CultureInfo.InvariantCulture, "{0:0,0}", Convert.ToDecimal(dataTable.Rows[0]["Sanksi"].ToString().Replace(",00", "").Replace(",", "")));
//Sanksi.Value = string.Format("{0:###,###}", Convert.ToDecimal(dataTable.Rows[0]["Sanksi"].ToString().Replace(",00", "")));
//Sanksi.Value=String.Format(((Math.Round(Convert.ToDouble(dataTable.Rows[0]["Sanksi"].ToString().Replace(",00", ""))) == Convert.ToDouble(dataTable.Rows[0]["Sanksi"].ToString().Replace(",00", ""))) ? "{0:0}" : "{0:###,00}"), Convert.ToDouble(dataTable.Rows[0]["Sanksi"].ToString().Replace(",00", ""))); ;
StaticFramework.Retrieve(dataTable, Sanksi_ket);
}
}
protected void RetrieveData()
{
object[] param = new object[]
{
IdGenerate
};
var dataTable = this.conn.GetDataTable("SELECT userid,UNIT,INSTANSIID,NOSURAT, convert(varchar,TGLSURAT,126) as TGLSURAT,PERIHAL,convert(varchar,DATETIMELIMIT,126) as DATETIMELIMIT,KETERANGAN,Sanksi, UNIT,convert(varchar,TGLINPUT,126) as TGLINPUT, UPLOADFILE,JENIS,PERIODE,JENISREPORT,SANKSI_KET FROM VW_APPMRS where AP_REGINPUT =@1", param, this.dbtimeout, true, true);
if (dataTable.Rows.Count > 0)
{
StaticFramework.Retrieve(dataTable, this.INSTANSIID);
StaticFramework.Retrieve(dataTable, this.NOSURAT);
//StaticFramework.Retrieve(dataTable, this.TGLSURAT);
if (!dataTable.Rows[0]["TGLSURAT"].ToString().Equals(""))
{
dtime = DateTime.ParseExact(dataTable.Rows[0]["TGLSURAT"].ToString(), "yyyy-MM-d", CultureInfo.InvariantCulture);
TGLSURAT.Value = dtime.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
}
StaticFramework.Retrieve(dataTable, this.PERIHAL);
//StaticFramework.Retrieve(dataTable, this.DATETIMELIMIT);
if (!dataTable.Rows[0]["DATETIMELIMIT"].ToString().Equals(""))
{
dtime = DateTime.ParseExact(dataTable.Rows[0]["DATETIMELIMIT"].ToString(), "yyyy-MM-d", CultureInfo.InvariantCulture);
DATETIMELIMIT.Value = dtime.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
}
StaticFramework.Retrieve(dataTable, this.JENISREPORT);
StaticFramework.Retrieve(dataTable, this.SANKSI_KET);
StaticFramework.Retrieve(dataTable, this.PERIODE);
StaticFramework.Retrieve(dataTable, this.KETERANGAN);
//StaticFramework.Retrieve(dataTable, this.TGLINPUT);
if (!dataTable.Rows[0]["TGLINPUT"].ToString().Equals(""))
{
dtime = DateTime.ParseExact(dataTable.Rows[0]["TGLINPUT"].ToString(), "yyyy-MM-d", CultureInfo.InvariantCulture);
TGLINPUT.Value = dtime.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
}
fileupload.Text = dataTable.Rows[0]["UPLOADFILE"].ToString();
//Sanksi.Value = string.Format("{0:#,00}", Convert.ToDecimal(dataTable.Rows[0]["Sanksi"].ToString().Replace(",00", "").Replace(",", "")));
if (!dataTable.Rows[0]["Sanksi"].ToString().Equals(""))
{
Sanksi.Value = String.Format(CultureInfo.InvariantCulture, "{0:0,0}", Convert.ToDecimal(dataTable.Rows[0]["Sanksi"].ToString().Replace(",00", "").Replace(",", "")));
}
if (Session["GROUPID"].ToString().Equals("002PEN"))
{
StaticFramework.Reff(this.JENIS, "SELECT REPORTID , REPORTNAME FROM VW_NAMALAPORAN WHERE UNITID ='" + Session["UnitID"].ToString() + "' AND INSTANSIID ='" + INSTANSIID.SelectedValue.ToString() + "' AND PERIODE ='" + PERIODE.SelectedValue.ToString() + "' and PIC ='" + Session["Userid"].ToString() + "'", null, this.conn, false);
s_user = dataTable.Rows[0]["userid"].ToString();
}
else if (Session["GROUPID"].ToString().Equals("003HEAD") && Request.QueryString["AP"].ToString().Equals(""))
{
StaticFramework.Reff(this.JENIS, "SELECT REPORTID , REPORTNAME FROM VW_NAMALAPORAN WHERE UNITID ='" + Session["UnitID"].ToString() + "' AND INSTANSIID ='" + INSTANSIID.SelectedValue.ToString() + "' AND PERIODE ='" + PERIODE.SelectedValue.ToString() + "' and DEPTHEAD ='" + Session["Userid"].ToString() + "'", null, this.conn, false);
s_user = dataTable.Rows[0]["userid"].ToString();
}
else if (Session["GROUPID"].ToString().Equals("00"))
{
StaticFramework.Retrieve(dataTable, this.UNIT);
StaticFramework.Reff(this.JENIS, "SELECT REPORTID , REPORTNAME FROM VW_NAMALAPORAN WHERE UNITID ='" + UNIT.SelectedValue.ToString() + "' AND INSTANSIID ='" + INSTANSIID.SelectedValue.ToString() + "' AND PERIODE ='" + PERIODE.SelectedValue.ToString() + "'", null, this.conn, false);
s_user = dataTable.Rows[0]["userid"].ToString();
}
else
{
StaticFramework.Retrieve(dataTable, this.UNIT);
StaticFramework.Reff(this.JENIS, "SELECT REPORTID , REPORTNAME FROM VW_NAMALAPORAN WHERE UNITID ='" + UNIT.SelectedValue.ToString() + "' AND INSTANSIID ='" + INSTANSIID.SelectedValue.ToString() + "' AND PERIODE ='" + PERIODE.SelectedValue.ToString() + "'", null, this.conn, false);
}
StaticFramework.Retrieve(dataTable, this.JENIS);
}
}
public void JENIS_SelectedIndexChanged(object sender, EventArgs e)
{
//StaticFramework.Reff(this.JENIS, "SELECT REPORTID , REPORTNAME FROM JENISREPORT WHERE UNITID ='" + Session["UnitID"].ToString() + "' AND INSTANSIID ='" + INSTANSIID.SelectedValue.ToString() + "'", null, this.conn, false);
object[] param = new object[]
{
INSTANSIID.SelectedValue.ToString(),
L_UNIT,
JENIS.SelectedValue.ToString(),
PERIODE.SelectedValue.ToString()
};
var dataTable = this.conn.GetDataTable("SELECT * FROM VW_LIMIT where INSTANSIID =@1 and UNIT=@2 and JENIS=@3 AND PERIODE=@4", param, this.dbtimeout, true, true);
if (dataTable.Rows.Count > 0)
{
//StaticFramework.Retrieve(dataTable, this.DATETIMELIMIT);
if (!dataTable.Rows[0]["DATETIMELIMIT"].ToString().Equals(""))
{
dtime = DateTime.ParseExact(dataTable.Rows[0]["DATETIMELIMIT"].ToString(), "yyyy-MM-d", CultureInfo.InvariantCulture);
DATETIMELIMIT.Value = dtime.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
}
StaticFramework.Retrieve(dataTable, this.SANKSI_KET);
//StaticFramework.Retrieve(dataTable, this.Sanksi);
//Sanksi.Value = string.Format("{0:#,00}", Convert.ToDecimal(dataTable.Rows[0]["Sanksi"].ToString().Replace(",00", "")));
//Sanksi.Value = string.Format("{0:#,00}", Convert.ToDecimal(dataTable.Rows[0]["Sanksi"].ToString().Replace(",00", "").Replace(",", "")));
if (!dataTable.Rows[0]["Sanksi"].ToString().Equals(""))
{
Sanksi.Value = String.Format(CultureInfo.InvariantCulture, "{0:0,0}", Convert.ToDecimal(dataTable.Rows[0]["Sanksi"].ToString().Replace(",00", "").Replace(",", "")));
}
}
else
{
DATETIMELIMIT.Value = "";
SANKSI_KET.Value = "";
Sanksi.Value = "";
}
//if (Session["GROUPID"].ToString().Equals("002PEN") || (Session["GROUPID"].ToString().Equals("003HEAD") && Request.QueryString["AP"].ToString().Equals("")))
//{
// var dataTable1 = this.conn.GetDataTable("SELECT JENISREPORT FROM VW_NAMALAPORAN WHERE UNITID ='" + Session["UnitID"].ToString() + "' AND INSTANSIID ='" + INSTANSIID.SelectedValue.ToString() + "' AND PERIODE ='" + PERIODE.SelectedValue.ToString() + "' and REPORTID='" + JENIS.SelectedValue.ToString() + "'", null, this.dbtimeout, true, true);
// if (dataTable1.Rows.Count > 0)
// {
// JENISREPORT.SelectedValue = dataTable1.Rows[0]["JENISREPORT"].ToString();
// }
//}
if (Session["GROUPID"].ToString().Equals("002PEN"))
{
var dataTable1 = this.conn.GetDataTable("SELECT JENISREPORT FROM VW_NAMALAPORAN WHERE UNITID ='" + Session["UnitID"].ToString() + "' AND INSTANSIID ='" + INSTANSIID.SelectedValue.ToString() + "' AND PERIODE ='" + PERIODE.SelectedValue.ToString() + "' and PIC ='" + Session["Userid"].ToString() + "'", null, this.dbtimeout, true, true);
if (dataTable1.Rows.Count > 0)
{
JENISREPORT.SelectedValue = dataTable1.Rows[0]["JENISREPORT"].ToString();
}
}
else if (Session["GROUPID"].ToString().Equals("003HEAD") && Request.QueryString["AP"].ToString().Equals(""))
{
var dataTable1 = this.conn.GetDataTable("SELECT JENISREPORT FROM VW_NAMALAPORAN WHERE UNITID ='" + Session["UnitID"].ToString() + "' AND INSTANSIID ='" + INSTANSIID.SelectedValue.ToString() + "' AND PERIODE ='" + PERIODE.SelectedValue.ToString() + "' and DEPTHEAD ='" + Session["Userid"].ToString() + "'", null, this.dbtimeout, true, true);
if (dataTable1.Rows.Count > 0)
{
JENISREPORT.SelectedValue = dataTable1.Rows[0]["JENISREPORT"].ToString();
}
}
else
{
var dataTable1 = this.conn.GetDataTable("SELECT distinct JENISREPORT FROM VW_NAMALAPORAN WHERE UNITID ='" + UNIT.SelectedValue.ToString() + "' AND INSTANSIID ='" + INSTANSIID.SelectedValue.ToString() + "' AND PERIODE ='" + PERIODE.SelectedValue.ToString() + "' and REPORTID='" + JENIS.SelectedValue.ToString() + "'", null, this.dbtimeout, true, true);
if (dataTable1.Rows.Count > 0)
{
JENISREPORT.SelectedValue = dataTable1.Rows[0]["JENISREPORT"].ToString();
}
}
}
protected void RetrieveData()
{
object[] param = new object[]
{
ID,
this.USERID
};
System.Data.DataTable dataTable = this.conn.GetDataTable("SELECT * FROM [VW_USER] where USERID =@1", param, this.dbtimeout, true, true);
if (dataTable.Rows.Count > 0)
{
StaticFramework.Retrieve(dataTable, "USERID", NIK);
StaticFramework.Retrieve(dataTable, "SU_FULLNAME", FULLNAME);
StaticFramework.Retrieve(dataTable, "UNIT", this.UNIT);
StaticFramework.Retrieve(dataTable, "SU_HPNUM", this.NOUSER);
StaticFramework.Retrieve(dataTable, "SU_EMAIL", this.email);
StaticFramework.Retrieve(dataTable, "SU_EMAIL_2", this.email2);
//StaticFramework.Retrieve(dataTable, "SU_HPNUM_DEPHEAD", this.NODEVHEAD);
//StaticFramework.Retrieve(dataTable, "SU_EMAIL_DEPHEAD", this.emailDevHead);
//StaticFramework.Retrieve(dataTable, "SU_HPNUM_KADIV", this.NOKADIV);
//StaticFramework.Retrieve(dataTable, "SU_EMAIL_KADIV", this.emailDivisi);
//StaticFramework.Retrieve(dataTable, "SU_HPNUM_DIREKTUR", this.NODIREKTUR);
//StaticFramework.Retrieve(dataTable, "SU_EMAIL_DIREKTUR",this.emailDirektur);
StaticFramework.Retrieve(dataTable, "GROUPID", this.GROUP);
//email.Value = dataTable.Rows[0]["SU_EMAIL"].ToString();
//emailDevHead.Value = dataTable.Rows[0]["SU_EMAIL_DEPHEAD"].ToString();
//emailDivisi.Value = dataTable.Rows[0]["SU_EMAIL_KADIV"].ToString();
//emailDirektur.Value = dataTable.Rows[0]["SU_EMAIL_DIREKTUR"].ToString();
if (GROUP.SelectedValue.Equals("003HEAD"))
{
div_role.Visible = true;
div_kadiv.Visible = false;
div_penerima.Visible = false;
// StaticFramework.Retrieve(dataTable, "SU_HPNUM_KADIV", this.NOKADIV);
// StaticFramework.Retrieve(dataTable, "SU_EMAIL_KADIV", this.emailDivisi);
StaticFramework.Reff(this.SU_UPLINER, "SELECT USERID,SU_FULLNAME FROM VW_KADIV WHERE UNIT='" + UNIT.SelectedValue.ToString() + "'", null, this.conn, false);
StaticFramework.Retrieve(dataTable, "SU_UPLINER", SU_UPLINER);
lb_judul.Text = "Kepala Divisi";
}
else if (GROUP.SelectedValue.Equals("002PEN"))
{
div_penerima.Visible = true;
div_role.Visible = true;
lb_judul.Text = "Approval";
div_kadiv.Visible = false;
StaticFramework.Reff(this.SU_UPLINER, "SELECT USERID,SU_FULLNAME FROM [VW_HEAD] WHERE UNIT='" + UNIT.SelectedValue.ToString() + "'", null, this.conn, false);
StaticFramework.Retrieve(dataTable, "SU_UPLINER", SU_UPLINER);
StaticFramework.Reff(this.PIC2, "SELECT USERID,SU_FULLNAME FROM VW_PIC2 WHERE UNIT='" + UNIT.SelectedValue.ToString() + "' and USERID not in('" + NIK.Value.ToString() + "')", null, this.conn, false);
StaticFramework.Retrieve(dataTable, "USER_DELEGATE", this.PIC2);
}
else if (GROUP.SelectedValue.Equals("004KADIV"))
{
div_kadiv.Visible = true;
div_role.Visible = false;
div_penerima.Visible = false;
StaticFramework.Retrieve(dataTable, "SU_HPNUM_DIREKTUR", this.NODIREKTUR);
StaticFramework.Retrieve(dataTable, "SU_EMAIL_DIREKTUR", this.emailDirektur);
}
else
{
div_role.Visible = false;
div_kadiv.Visible = false;
div_penerima.Visible = false;
}
System.Data.DataTable dataTable1 = this.conn.GetDataTable("select SU_LOGON from SCALLUSERFLAG where USERID =@1", param, this.dbtimeout, true, true);
if (dataTable1.Rows.Count > 0)
{
StaticFramework.Retrieve(dataTable1, "SU_LOGON", this.cb_login);
if (cb_login.Checked)
{
cb_login.Text = "Sedang Login";
}
else
{
cb_login.Text = "Tidak Login";
}
}
div_login.Visible = true;
}
}
private void Retreivedata()
{
try
{
System.Data.DataTable dt = null;
if (Session["GROUPID"].ToString().Equals("002PEN"))
{
Q_RFINSTANSI = "SELECT * FROM VW_DASBOARD_COUNT_USER where USERCREATED ='" + Session["userid"].ToString() + "'";
Q_RFINSTANSICOUNT = "SELECT * FROM [VW_DASBOARD_COUNT_USER1] where USERCREATED ='" + Session["userid"].ToString() + "'";
dt = this.conn.GetDataTable("SELECT distinct [INSTANSIID],[PIC],[UNIT] FROM [MRSDATA].[dbo].[DATA_COMPLIANCE] where PIC='" + Session["Userid"].ToString() + "'", null, this.dbtimeout, true, true);
if (dt.Rows.Count > 0)
{
for (int a = 0; a < dt.Rows.Count; a++)
{
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN001"))
{
IN001.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN002"))
{
IN002.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN003"))
{
IN003.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN004"))
{
IN004.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN005"))
{
IN005.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN006"))
{
IN006.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN007"))
{
IN007.Visible = true;
}
}
}
}
else if (Session["GROUPID"].ToString().Equals("003HEAD"))
{
Q_RFINSTANSI = "SELECT * FROM VW_DASBOARD_COUNT_UNIT where UNIT ='" + Session["UnitID"].ToString() + "' and (DEPTHEAD='" + Session["Userid"].ToString() + "') ";
Q_RFINSTANSICOUNT = "SELECT * FROM VW_DASBOARD_COUNT_UNIT1 where UNIT ='" + Session["UnitID"].ToString() + "' and (DEPTHEAD='" + Session["Userid"].ToString() + "') ";
dt = this.conn.GetDataTable("SELECT distinct [INSTANSIID],[DEPTHEAD],[UNIT] FROM [MRSDATA].[dbo].[DATA_COMPLIANCE] where DEPTHEAD='" + Session["Userid"].ToString() + "'", null, this.dbtimeout, true, true);
if (dt.Rows.Count > 0)
{
for (int a = 0; a < dt.Rows.Count; a++)
{
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN001"))
{
IN001.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN002"))
{
IN002.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN003"))
{
IN003.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN004"))
{
IN004.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN005"))
{
IN005.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN006"))
{
IN006.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN007"))
{
IN007.Visible = true;
}
}
}
}
else if (Session["GROUPID"].ToString().Equals("004KADIV"))
{
Q_RFINSTANSI = "SELECT * FROM [VW_DASBOARD_COUNT_KADIV] where UNIT ='" + Session["UnitID"].ToString() + "' and (USERID='" + Session["Userid"].ToString() + "') ";
Q_RFINSTANSICOUNT = "SELECT * FROM VW_DASBOARD_COUNT_UNIT1 where UNIT ='" + Session["UnitID"].ToString() + "' and (DEPTHEAD in (select USERID from SCALLUSER where SU_UPLINER='" + Session["Userid"].ToString() + "')) ";
dt = this.conn.GetDataTable("SELECT distinct [INSTANSIID],[DEPTHEAD],[UNIT] FROM [MRSDATA].[dbo].[DATA_COMPLIANCE] where DEPTHEAD IN (select USERID from SCALLUSER where SU_UPLINER ='" + Session["Userid"].ToString() + "' and UNIT='" + Session["uNITiD"].ToString() + "') and UNIT='" + Session["uNITiD"].ToString() + "'", null, this.dbtimeout, true, true);
if (dt.Rows.Count > 0)
{
for (int a = 0; a < dt.Rows.Count; a++)
{
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN001"))
{
IN001.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN002"))
{
IN002.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN003"))
{
IN003.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN004"))
{
IN004.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN005"))
{
IN005.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN006"))
{
IN006.Visible = true;
}
if (dt.Rows[a]["INSTANSIID"].ToString().Equals("IN007"))
{
IN007.Visible = true;
}
}
}
}
else
{
Q_RFINSTANSI = "SELECT * FROM VW_DASBOARD_COUNT";
IN001.Visible = true;
IN002.Visible = true;
IN003.Visible = true;
IN004.Visible = true;
IN005.Visible = true;
IN006.Visible = true;
IN007.Visible = true;
}
System.Data.DataTable dataTable = this.conn.GetDataTable(Q_RFINSTANSI, null, this.dbtimeout, true, true);
if (dataTable.Rows.Count > 0)
{
StaticFramework.Retrieve(dataTable, this.count_BI);
StaticFramework.Retrieve(dataTable, this.count_OJK);
StaticFramework.Retrieve(dataTable, this.count_OJK_PASARMODAL);
StaticFramework.Retrieve(dataTable, this.count_PAJAK);
StaticFramework.Retrieve(dataTable, this.count_PPATK);
StaticFramework.Retrieve(dataTable, this.count_REGULATOR_LAIN);
StaticFramework.Retrieve(dataTable, this.count_MANDIRI);
StaticFramework.Retrieve(dataTable, this.BI_7);
StaticFramework.Retrieve(dataTable, this.BI_3);
StaticFramework.Retrieve(dataTable, this.BI_1);
StaticFramework.Retrieve(dataTable, this.OJK_7);
StaticFramework.Retrieve(dataTable, this.OJK_3);
StaticFramework.Retrieve(dataTable, this.OJK_1);
StaticFramework.Retrieve(dataTable, this.OJKPASARMODAL_7);
StaticFramework.Retrieve(dataTable, this.OJKPASARMODAL_3);
StaticFramework.Retrieve(dataTable, this.OJKPASARMODAL_1);
StaticFramework.Retrieve(dataTable, this.PAJAK_7);
StaticFramework.Retrieve(dataTable, this.PAJAK_3);
StaticFramework.Retrieve(dataTable, this.PAJAK_1);
StaticFramework.Retrieve(dataTable, this.PPATK_7);
StaticFramework.Retrieve(dataTable, this.PPATK_3);
StaticFramework.Retrieve(dataTable, this.PPATK_1);
StaticFramework.Retrieve(dataTable, this.MANDIRI_7);
StaticFramework.Retrieve(dataTable, this.MANDIRI_3);
StaticFramework.Retrieve(dataTable, this.MANDIRI_1);
StaticFramework.Retrieve(dataTable, this.REGULATOR_7);
StaticFramework.Retrieve(dataTable, this.REGULATOR_3);
StaticFramework.Retrieve(dataTable, this.REGULATOR_1);
}
else
{
count_BI.Text = "0";
count_OJK.Text = "0";
count_OJK_PASARMODAL.Text = "0";
count_PAJAK.Text = "0";
count_PPATK.Text = "0";
count_REGULATOR_LAIN.Text = "0";
count_MANDIRI.Text = "0";
BI_7.Text = "0";
BI_3.Text = "0";
BI_1.Text = "0";
OJK_7.Text = "0";
OJK_3.Text = "0";
OJK_1.Text = "0";
OJKPASARMODAL_7.Text = "0";
OJKPASARMODAL_3.Text = "0";
OJKPASARMODAL_1.Text = "0";
PAJAK_7.Text = "0";
PAJAK_3.Text = "0";
PAJAK_1.Text = "0";
PPATK_7.Text = "0";
PPATK_3.Text = "0";
PPATK_1.Text = "0";
MANDIRI_7.Text = "0";
MANDIRI_3.Text = "0";
MANDIRI_1.Text = "0";
REGULATOR_7.Text = "0";
REGULATOR_3.Text = "0";
REGULATOR_1.Text = "0";
}
if (!Q_RFINSTANSICOUNT.Equals("") && dataTable.Rows.Count <= 0)
{
System.Data.DataTable dataTable1 = this.conn.GetDataTable(Q_RFINSTANSICOUNT, null, this.dbtimeout, true, true);
if (dataTable1.Rows.Count > 0)
{
StaticFramework.Retrieve(dataTable1, this.BI_7);
StaticFramework.Retrieve(dataTable1, this.BI_3);
StaticFramework.Retrieve(dataTable1, this.BI_1);
StaticFramework.Retrieve(dataTable1, this.OJK_7);
StaticFramework.Retrieve(dataTable1, this.OJK_3);
StaticFramework.Retrieve(dataTable1, this.OJK_1);
StaticFramework.Retrieve(dataTable1, this.OJKPASARMODAL_7);
StaticFramework.Retrieve(dataTable1, this.OJKPASARMODAL_3);
StaticFramework.Retrieve(dataTable1, this.OJKPASARMODAL_1);
StaticFramework.Retrieve(dataTable1, this.PAJAK_7);
StaticFramework.Retrieve(dataTable1, this.PAJAK_3);
StaticFramework.Retrieve(dataTable1, this.PAJAK_1);
StaticFramework.Retrieve(dataTable1, this.PPATK_7);
StaticFramework.Retrieve(dataTable1, this.PPATK_3);
StaticFramework.Retrieve(dataTable1, this.PPATK_1);
StaticFramework.Retrieve(dataTable1, this.MANDIRI_7);
StaticFramework.Retrieve(dataTable1, this.MANDIRI_3);
StaticFramework.Retrieve(dataTable1, this.MANDIRI_1);
StaticFramework.Retrieve(dataTable1, this.REGULATOR_7);
StaticFramework.Retrieve(dataTable1, this.REGULATOR_3);
StaticFramework.Retrieve(dataTable1, this.REGULATOR_1);
}
else
{
BI_7.Text = "0";
BI_3.Text = "0";
BI_1.Text = "0";
OJK_7.Text = "0";
OJK_3.Text = "0";
OJK_1.Text = "0";
OJKPASARMODAL_7.Text = "0";
OJKPASARMODAL_3.Text = "0";
OJKPASARMODAL_1.Text = "0";
PAJAK_7.Text = "0";
PAJAK_3.Text = "0";
PAJAK_1.Text = "0";
PPATK_7.Text = "0";
PPATK_3.Text = "0";
PPATK_1.Text = "0";
MANDIRI_7.Text = "0";
MANDIRI_3.Text = "0";
MANDIRI_1.Text = "0";
REGULATOR_7.Text = "0";
REGULATOR_3.Text = "0";
REGULATOR_1.Text = "0";
}
}
}
catch (Exception e)
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('error : get data')", true);
}
}
