课程设计在线学习系统的设计与实现(7)

课程设计在线学习系统

Get_Pager_Data(); } }

void Get_Pager_Data() {

SqlConnection cn = DB.OpenConnection();

SqlCommand cmd0 = new SqlCommand(cmdtxt2, cn); AspNetPager1.AlwaysShow = true; AspNetPager1.PageSize = 14;

AspNetPager1.RecordCount = (int)cmd0.ExecuteScalar(); cn.Close(); Get_Data(); }

protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e) {

AspNetPager1.CurrentPageIndex = e.NewPageIndex; Get_Data(); }

void Get_Data()//绑定数据 {

SqlConnection cn=DB.OpenConnection();

SqlCommand cmd=new SqlCommand (sqltxt,cn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet();

da.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, \);

DataView dv = ds.Tables[\].DefaultView; this.Repeater1.DataSource = dv; this.Repeater1.DataBind();

}

//批量删除

protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) {

if (e.CommandName == \) {

if (DB.ExecuteSql(\ + e.CommandArgument.ToString()) >= 0) {

Get_Pager_Data();

27

课程设计在线学习系统

Common.ShowMessage(Page, \删除成功！\, \); } else {

Common.ShowMessage(Page, \删除失败！\, \); } }

}

//全选

protected void CheckBox1_CheckedChanged(object sender, EventArgs e) {

if (CheckBox1.Checked) {

for (int i = 0; i < Repeater1.Items.Count; i++) {

CheckBox chk = (CheckBox)Repeater1.Items[i].FindControl(\); if (chk != null) {

chk.Checked = true; } } } else {

for (int i = 0; i < Repeater1.Items.Count; i++) {

CheckBox chk = (CheckBox)Repeater1.Items[i].FindControl(\); if (chk != null) {

chk.Checked = false; } } }

}

//删除单条数据

protected void LinkButton2_Click(object sender, EventArgs e) {

for (int i = 0; i < Repeater1.Items.Count; i++) {

CheckBox chk = (CheckBox)Repeater1.Items[i].FindControl(\); Label lb5 = (Label)Repeater1.Items[i].FindControl(\); if (chk != null)

28

课程设计在线学习系统

{

if (chk.Checked) {

DB.ExecuteSql(\ + lb5.Text.Trim()); } } }

Get_Pager_Data(); }

protected void Button1_Click(object sender, EventArgs e)//添加 {

string sql = \ + Common.UrnHtml(txt_sub_title.Text) + \;

string sql_isexsit = \ + Common.UrnHtml(txt_sub_title.Text) + \; if (DB.isExists(sql_isexsit)) {

Common.ShowMessage(Page, \该课题已存在！\, \); } else {

if (DB.ExecuteSql(sql) >= 0) {

Get_Pager_Data();//重新绑定类别列表

Common.ShowMessage(Page, \添加成功！\, \); } else {

Common.ShowMessage(Page, \添加失败！\, \); } }

}

29

课程设计在线学习系统

4.5检查评阅

截图与主要代码：

#region SQL语句公共变量

public static string sqltxt = \X_Task_ID=X_Work.X_Task_ID) as taskname from [X_Work] order by X_Work_ID desc\; public static string cmdtxt2 = \; #endregion

protected void Page_Load(object sender, EventArgs e) {

#region 初始化列表数据 if (!IsPostBack) {

Get_Pager_Data(); }

#endregion }

#region 获取数据并分页 void Get_Pager_Data() {

SqlConnection cn = DB.OpenConnection();

SqlCommand cmd0 = new SqlCommand(cmdtxt2, cn); AspNetPager1.AlwaysShow = true; AspNetPager1.PageSize = 14;

30

课程设计在线学习系统

AspNetPager1.RecordCount = (int)cmd0.ExecuteScalar(); DB.DisposeConnection(cn); Get_Data(); }

#endregion

#region 点击分页按钮激发的事件

protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e) {

AspNetPager1.CurrentPageIndex = e.NewPageIndex; Get_Data(); }

#endregion

#region 获取数据

void Get_Data()//绑定数据 {

SqlConnection cn = DB.OpenConnection();

SqlCommand cmd = new SqlCommand(sqltxt, cn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet();

da.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, \);

DataView dv = ds.Tables[\].DefaultView; this.Repeater1.DataSource = dv; this.Repeater1.DataBind(); DB.DisposeConnection(cn); }

#endregion

#region 全选

protected void CheckBox1_CheckedChanged(object sender, EventArgs e) {

if (CheckBox1.Checked) {

for (int i = 0; i < Repeater1.Items.Count; i++) {

CheckBox chk = (CheckBox)Repeater1.Items[i].FindControl(\); if (chk != null)

31

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库课程设计在线学习系统的设计与实现(7)在线全文阅读。