课程设计在线学习系统
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