private void binddata()
{
string strSQL = "select * from 分组表";
DataTable dt = DBOper.execQueryBySQLText(strSQL);
GVAdmin.DataSource = dt;
GVAdmin.DataBind();
}
protected void FillAdmin()
{
using (PTCLEntities db = new PTCLEntities())
{
var Admins = db.GetPtclAdmins().ToList();
GVAdmin.DataSource = Admins;
GVAdmin.DataBind();
GVAdmin.UseAccessibleHeader = true;
if (GVAdmin.Rows.Count > 0)
{
GVAdmin.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else
{
lblAdminmsg.Text = "No Record to Show";
}
}
}
protected void GridFill()
{
using (PTCLEntities db = new PTCLEntities())
{
var reportData = db.spReportData().ToList();
GVAdmin.DataSource = reportData;
GVAdmin.UseAccessibleHeader = true;
if (GVAdmin.Rows.Count > 0)
{
GVAdmin.HeaderRow.TableSection = TableRowSection.TableHeader;
lblAdminmsg.Text = "";
}
else
{
;
}
GVAdmin.DataBind();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (ddlAdmins.SelectedValue == "0")
{
lblAdminmsg.Text = "Please Select Admins";
}
if (ddlLocation.SelectedValue == "1")
{
lblAdminmsg.Text = "Please Select Location";
}
using (PTCLEntities db = new PTCLEntities())
{
if (ddlAdmins.SelectedItem.Text == null && ddlLocation.SelectedItem.Text == null)
{
lblAdminmsg.Text = "Please Select both CheckBoxes";
}
else
{
int adminValue = Convert.ToInt32(ddlAdmins.SelectedValue);
int LocationValue = Convert.ToInt32(ddlLocation.SelectedValue);
var reportData = db.spFilterAdminWithLocation(adminValue, LocationValue).ToList();
GVAdmin.DataSource = reportData;
}
GVAdmin.DataBind();
GVAdmin.UseAccessibleHeader = true;
if (GVAdmin.Rows.Count > 0)
{
GVAdmin.HeaderRow.TableSection = TableRowSection.TableHeader;
lblAdminmsg.Text = "";
}
else
{
lblAdminmsg.Text = "No Record to Show";
}
}
}