protected void Button1_Click(object sender, EventArgs e)
{
ManagerPagePowerBll managerPagePowerBll = new ManagerPagePowerBll();
ManagerPagePowerEnitity managerPagePowerEntity = new ManagerPagePowerEnitity();
string managerID = this.GetManagerID();
managerPagePowerEntity.ManagerID = managerID;
managerPagePowerBll.DeleteByManager(managerPagePowerEntity);
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
CheckBoxList checkBoxList = (CheckBoxList)this.GridView1.Rows[i].FindControl("ckChild");
LinkButton linkButton = (LinkButton)this.GridView1.Rows[i].FindControl("lkPages");
CheckBox checkBox = (CheckBox)this.GridView1.Rows[i].FindControl("ckParent");
if (checkBoxList != null && linkButton != null && checkBox != null && checkBox.Checked)
{
managerPagePowerEntity.ManagerID = managerID;
managerPagePowerEntity.Id = int.Parse(linkButton.CommandArgument);
managerPagePowerBll.Add(managerPagePowerEntity);
for (int j = 0; j < checkBoxList.Items.Count; j++)
{
if (checkBoxList.Items[j].Selected)
{
managerPagePowerEntity.Id = int.Parse(checkBoxList.Items[j].Value);
managerPagePowerBll.Add(managerPagePowerEntity);
}
}
}
}
}
public DataTable GetAllByManager(ManagerPagePowerEnitity en)
{
DataBase db = new DataBase();
string comstr = "select p.id,p.pagesort,p.parentid,p.pid,p.pagename,p.pageurl ,(select count(*) from pages pp where pp.parentid=p.id )as ChildCount ,tpp.managerid from managerpagepower tpp,pages p where p.id=tpp.id and tpp.Managerid=@ManagerID order by p.pagesort ";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@ManagerID", SqlDbType.VarChar, 50)
};
param[0].Value = en.ManagerID;
return(db.GetDataTable(comstr, param));
}
public DataTable GetByID(ManagerPagePowerEnitity en)
{
DataBase db = new DataBase();
string comstr = "select p.id,p.pagesort,p.parentid,p.pid,p.pagename,p.pageurl from pages p ,ManagerPagePower tpp,Manager t where tpp.id=p.id and tpp.managerid=t.managerid and tpp.TPP_ID=@ID";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@TPP_ID", SqlDbType.Int, 4)
};
param[0].Value = en.Tpp_ID;
return(db.GetDataTable(comstr, param));
}
public DataTable GetByManager(ManagerPagePowerEnitity en)
{
DataBase db = new DataBase();
string comstr = "select pagesort as id,pagename as title ,pageurl as url,pid as ParentID from Managerpagepower tpp,pages p where p.id=tpp.id and tpp.Managerid=@ManagerID order by p.pagesort ";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@ManagerID", SqlDbType.VarChar, 50)
};
param[0].Value = en.ManagerID;
return(db.GetDataTable(comstr, param));
}
public bool Add(ManagerPagePowerEnitity en)
{
DataBase db = new DataBase();
string comstr = "Insert into ManagerPagePower(ManagerID,ID) values(@ManagerID,@ID)";
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ID", SqlDbType.Int, 4);
param[0].Value = en.Id;
param[1] = new SqlParameter("@ManagerID", SqlDbType.VarChar, 50);
param[1].Value = en.ManagerID;
return(db.ExecuteSql(comstr, param) > 0);
}
public bool DeleteByManager(ManagerPagePowerEnitity en)
{
DataBase db = new DataBase();
string comstr = "delete ManagerPagePower where ManagerID=@ManagerID";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@ManagerID", SqlDbType.VarChar, 50)
};
param[0].Value = en.ManagerID;
return(db.ExecuteSql(comstr, param) > 0);
}
protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
ManagerPagePowerBll teacherPagePowerBll = new ManagerPagePowerBll();
ManagerPagePowerEnitity teacherPagePowerEntity = new ManagerPagePowerEnitity();
DataList dataList = (DataList)e.Row.FindControl("DataList1");
LinkButton linkButton = (LinkButton)e.Row.FindControl("lkPages");
Label label = (Label)e.Row.FindControl("lbID");
if (dataList != null && linkButton != null && label != null)
{
int i = int.Parse(linkButton.CommandArgument.ToString());
teacherPagePowerEntity.ManagerID = label.Text;
dataList.DataSource = teacherPagePowerBll.GetByTeacher(teacherPagePowerEntity, i);
dataList.DataBind();
}
}
}
public bool Add(ManagerPagePowerEnitity en)
{
return(this.dal.Add(en));
}
public bool DeleteByManager(ManagerPagePowerEnitity en)
{
return(this.dal.DeleteByManager(en));
}
public DataTable GetByTeacher(ManagerPagePowerEnitity en, int i)
{
return(this.dal.GetByManager(en, i));
}
public DataTable GetAllByManager(ManagerPagePowerEnitity en)
{
return(this.dal.GetAllByManager(en));
}
public DataTable GetByID(ManagerPagePowerEnitity en)
{
return(this.dal.GetByID(en));
}
