protected DataSet getAdministratorInfo(string strOrdey)
{
string sql_searchUser;
StandRepComToSQL sql = new StandRepComToSQL();
string sqlReport = "SELECT ViewName FROM ReportList where ID = " + HidReportId.Value;
DataSet ds_qreport = helper.GetDataSet(sqlReport);
string viewName = ds_qreport.Tables[0].Rows[0][0].ToString();
if (viewName.Equals("BookingsSales"))
{
sql_searchUser = sql.RepCompileSql(HidReportId.Value, getLoginRole(), "", "", strOrdey, sql.getSelectMeetingDate(Session["ExecutiveID"].ToString()), Session["ExecutiveID"].ToString());
}
else if (viewName.Equals("SalesBacklog"))
{
sql_searchUser = sql.RepCompileSqlBacklog(HidReportId.Value, getLoginRole(), strOrdey, sql.getSelectMeetingDate(Session["ExecutiveID"].ToString()), Session["ExecutiveID"].ToString());
}
//by yyan ItemW149 20110916 add start
//else if (viewName.Equals("ProjectInformation"))
//{
// sql_searchUser = sql.RepCompileSqlA(HidReportId.Value, getLoginRole(), "", "", strOrdey, viewName);
//}
//by yyan ItemW149 20110916 add end
else {
sql_searchUser = sql.RepCompileSql(HidReportId.Value, getLoginRole(), "", "", strOrdey, Session["ExecutiveID"].ToString());
}
DataSet ds_query_Admin = helper.GetDataSet(sql_searchUser);
return ds_query_Admin;
}
protected DataSet getAdministratorInfo(string strOrdey)
{
string sql_searchUser;
StandRepComToSQL sql = new StandRepComToSQL();
string sqlReport = "SELECT ViewName FROM ReportList where ID = " + HidReportId.Value;
DataSet ds_qreport = helper.GetDataSet(sqlReport);
string viewName = ds_qreport.Tables[0].Rows[0][0].ToString();
if (viewName.Equals("BookingsSales"))
{
sql_searchUser = sql.RepCompileSql(HidReportId.Value, getLoginRole(), "", "", strOrdey, sql.getSelectMeetingDate(Session["RSMID"].ToString()), Session["RSMID"].ToString());
}
else if (viewName.Equals("SalesBacklog"))
{
sql_searchUser = sql.RepCompileSqlBacklog(HidReportId.Value, getLoginRole(), strOrdey, strOrdey, Session["RSMID"].ToString());
}
else {
sql_searchUser = sql.RepCompileSql(HidReportId.Value, getLoginRole(), "", "", strOrdey, Session["RSMID"].ToString());
}
DataSet ds_query_Admin = helper.GetDataSet(sql_searchUser);
return ds_query_Admin;
}