课程设计在线学习系统
{
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; } } } }
#endregion
#region 批量删除
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) {
if (chk.Checked) {
DB.ExecuteSql(\ + lb5.Text.Trim()); } } }
Get_Pager_Data(); }
#endregion
protected void Button1_Click(object sender, EventArgs e) {
for (int i = 0; i < Repeater1.Items.Count; i++) {
32
课程设计在线学习系统
CheckBox chk = (CheckBox)Repeater1.Items[i].FindControl(\); Label lb5 = (Label)Repeater1.Items[i].FindControl(\); if (chk != null) {
if (chk.Checked) {
DB.ExecuteSql(\已审',X_Work_Score='优' where X_Work_ID=\ + lb5.Text.Trim()); } } }
Get_Pager_Data(); }
protected void Button2_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) {
if (chk.Checked) {
DB.ExecuteSql(\已审',X_Work_Score='良' where X_Work_ID=\ + lb5.Text.Trim()); } } }
Get_Pager_Data(); }
protected void Button3_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) {
if (chk.Checked) {
DB.ExecuteSql(\已审',X_Work_Score='中' where X_Work_ID=\ + lb5.Text.Trim());
33
课程设计在线学习系统
} } }
Get_Pager_Data(); }
protected void Button4_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) {
if (chk.Checked) {
DB.ExecuteSql(\已审',X_Work_Score='差' where X_Work_ID=\ + lb5.Text.Trim()); } } }
Get_Pager_Data(); }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) {
if (e.CommandName == \) {
Label lb2 = (Label)e.Item.FindControl(\);
if (DB.ExecuteSql(\ + e.CommandArgument.ToString()) >= 0) {
Get_Pager_Data();
Common.ShowMessage(Page, \删除成功！\, \); } else {
Common.ShowMessage(Page, \删除失败！\, \); } } }
34
课程设计在线学习系统
4.6上传资料
截图与主要代码：
public static string sqltxt = \desc\;
public static string cmdtxt2 = \; protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
Get_Pager_Data(); } }
void Get_Pager_Data() {
35
课程设计在线学习系统
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 == \) {
Label lb2 = (Label)e.Item.FindControl(\);
File.Delete(Server.MapPath(lb2.Text.Replace(\,\)));
if (DB.ExecuteSql(\ + e.CommandArgument.ToString()) >= 0) {
Get_Pager_Data();
Common.ShowMessage(Page, \删除成功！\, \); } else {
36