private void ShowData(string strSql)
{
string strConn = ConfigurationSettings.AppSettings["strConn"];
SqlConnection SqlConn = new SqlConnection(strConn);
SqlDataAdapter SqlCmd = new SqlDataAdapter(strSql, SqlConn);
DataSet SqlDS = new DataSet();
SqlCmd.Fill(SqlDS, "SectionInfo");
RowNum = DataGridBook.CurrentPageIndex * DataGridBook.PageSize + 1;
LinNum = 0;
string SortExpression = DataGridBook.Attributes["SortExpression"];
string SortDirection = DataGridBook.Attributes["SortDirection"];
SqlDS.Tables["SectionInfo"].DefaultView.Sort = SortExpression + " " + SortDirection;
DataGridBook.DataSource = SqlDS.Tables["SectionInfo"].DefaultView;
DataGridBook.DataBind();
for (int i = 0; i < DataGridBook.Items.Count; i++)
{
LinkButton LBSectionName = (LinkButton)DataGridBook.Items[i].FindControl("LinkButSectionName");
LinkButton LBBrowBook = (LinkButton)DataGridBook.Items[i].FindControl("LinkButBrowBook");
LBSectionName.Attributes.Add("onclick", "javascript:NewWin=window.open('BrowBook.aspx?SectionID=" + DataGridBook.Items[i].Cells[0].Text.Trim() + "','BrowBook','titlebar=yes,menubar=no,toolbar=no,location=no,directories=no,status=yes,scrollbars=yes,resizable=no,copyhistory=yes,top=0,left=0,width=screen.availWidth,height=screen.availHeight');NewWin.moveTo(0,0);NewWin.resizeTo(screen.availWidth,screen.availHeight);return false;");
LBBrowBook.Attributes.Add("onclick", "javascript:NewWin=window.open('BrowBook.aspx?SectionID=" + DataGridBook.Items[i].Cells[0].Text.Trim() + "','BrowBook','titlebar=yes,menubar=no,toolbar=no,location=no,directories=no,status=yes,scrollbars=yes,resizable=no,copyhistory=yes,top=0,left=0,width=screen.availWidth,height=screen.availHeight');NewWin.moveTo(0,0);NewWin.resizeTo(screen.availWidth,screen.availHeight);return false;");
}
LabelRecord.Text = Convert.ToString(SqlDS.Tables["SectionInfo"].Rows.Count);
LabelCountPage.Text = Convert.ToString(DataGridBook.PageCount);
LabelCurrentPage.Text = Convert.ToString(DataGridBook.CurrentPageIndex + 1);
SqlConn.Dispose();
}
private void ShowData(string strSql)
{
string strConn = ConfigurationSettings.AppSettings["strConn"];
SqlConnection SqlConn = new SqlConnection(strConn);
SqlDataAdapter SqlCmd = new SqlDataAdapter(strSql, SqlConn);
DataSet SqlDS = new DataSet();
SqlCmd.Fill(SqlDS, "SectionInfo");
RowNum = DataGridBook.CurrentPageIndex * DataGridBook.PageSize + 1;
LinNum = 0;
string SortExpression = DataGridBook.Attributes["SortExpression"];
string SortDirection = DataGridBook.Attributes["SortDirection"];
SqlDS.Tables["SectionInfo"].DefaultView.Sort = SortExpression + " " + SortDirection;
DataGridBook.DataSource = SqlDS.Tables["SectionInfo"].DefaultView;
DataGridBook.DataBind();
for (int i = 0; i < DataGridBook.Items.Count; i++)
{
LinkButton LBEditBook = (LinkButton)DataGridBook.Items[i].FindControl("LinkButEditBook");
LinkButton LBDel = (LinkButton)DataGridBook.Items[i].FindControl("LinkButDel");
if ((myLoginID.Trim().ToUpper() == "ADMIN") || (myLoginID.Trim().ToUpper() == DataGridBook.Items[i].Cells[7].Text.Trim().ToUpper()))
{
LBEditBook.Attributes.Add("onclick", "javascript:jscomNewOpenByFixSize('EditBook.aspx?SectionID=" + DataGridBook.Items[i].Cells[0].Text + "&SectionName=" + DataGridBook.Items[i].Cells[5].Text + "','EditBook',688,496); return false;");
LBDel.Attributes.Add("onclick", "javascript:{if(confirm('确定要删除选择章节吗？')==false) return false;}");
}
else
{
LBEditBook.Attributes.Add("onclick", "javascript:alert('对不起，您没有此操作权限！');return false;");
LBDel.Attributes.Add("onclick", "javascript:alert('对不起，您没有此操作权限！');return false;");
}
}
LabelRecord.Text = Convert.ToString(SqlDS.Tables["SectionInfo"].Rows.Count);
LabelCountPage.Text = Convert.ToString(DataGridBook.PageCount);
LabelCurrentPage.Text = Convert.ToString(DataGridBook.CurrentPageIndex + 1);
SqlConn.Dispose();
}
