//��ʼ���Ծ��� protected void InitData() { Papermr paper = new Papermr(); DataSet ds = paper.QueryUserPaperList(); GridView1.DataSource = ds; GridView1.DataBind(); LabelPageInfo.Text = "��ǰ����" + (GridView1.PageIndex + 1).ToString() + "ҳ ��" + GridView1.PageCount.ToString() + "ҳ��"; }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string UserID = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //ȡ��Ҫɾ����¼������ֵ1 int PaperID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[1].ToString().Trim());//ȡ��Ҫɾ����¼������ֵ2 Papermr paper = new Papermr(); if (paper.DeleteByProc(UserID, PaperID)) { Response.Write("<script language=javascript>alert('�ɹ�ɾ����')</script>"); } else { Response.Write("<script language=javascript>alert('ɾ��ʧ�ܣ�')</script>"); } InitData(); }
//GridView�ؼ�RowDeleting�¼� protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { Papermr paper = new Papermr(); //����Papermr���� int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //ȡ��Ҫɾ����¼������ֵ if (paper.DeleteByStr(ID)) { Response.Write("<script language=javascript>alert('�ɹ�ɾ�����Ծ��')</script>"); } else { Response.Write("<script language=javascript>alert('ɾ���Ծ�ʧ�ܣ�')</script>"); } //InitData(); Response.Redirect("PaperLists.aspx"); }
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e) { Scoresmr insertExamScore = new Scoresmr(); //����Scoresmr����� insertExamScore.UserID = Request.QueryString["UserID"].ToString(); insertExamScore.ExamTime = Convert.ToDateTime(lblExamtime.Text); insertExamScore.PaperID = int.Parse(Request.QueryString["PaperID"].ToString()); if (queScore.Text.Trim() != "") { insertExamScore.Score = Convert.ToInt32(sumScore.Text); } insertExamScore.PingYu = tbxPingyu.Text; //ʵ����������Papermr Papermr mypaper = new Papermr(); mypaper.UserID= Request.QueryString["UserID"].ToString(); mypaper.PaperID = int.Parse(Request.QueryString["PaperID"].ToString()); mypaper.state = "������"; //ʹ��CheckScore������֤�ɼ��Ƿ���� if (!insertExamScore.CheckScore(insertExamScore.UserID, insertExamScore.PaperID)) { //����InsertByProc���������ݿ��в���ɼ� if (insertExamScore.InsertByProc()) { mypaper.UpdateByProc(mypaper.UserID, mypaper.PaperID,mypaper.state); //�����ɹ���ʾ��Ϣ lblMessage.Text = "�����ɼ�����ɹ�!"; } else { lblMessage.Text = "�����ɼ�����ʧ��!"; } } else { lblMessage.Text = "���û��ijɼ��Ѵ���,����ɾ���ɼ�������!"; } }
//GridView�ؼ�RowUpdating�¼� protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { //ȡ��Ҫɾ����¼������ֵ int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //����Papermr���� Papermr paper = new Papermr(); //Ӧ��FindControl����GridView�ؼ��е�DropDownList���������б��е�ֵת����byte�����蹫����Papermr�е�PaperState�Ծ�״̬���� paper.PaperState = byte.Parse(((DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlPaperState")).SelectedValue); //ʹ��Papermr��UpdateByProc�������Ծ�״̬ if (paper.UpdateByStr(ID)) { Response.Write("<script language=javascript>alert('�Ծ�״̬�ijɹ�!')</script>"); } else { Response.Write("<script language=javascript>alert('�Ծ�״̬��ʧ��!')</script>"); } //ȡ���༭���� GridView1.EditIndex = -1; //�����Զ��巽��InitData()���°�GridView�ؼ�����Ϣ InitData(); }
protected void InitData() { Papermr paper = new Papermr(); DataSet ds = paper.QueryAllPaper(); if (ds.Tables[0].Rows.Count > 0) { GridView1.DataSource = ds; GridView1.DataBind(); } else { lblMessage.Text = "û���Ծ�!"; } }
//��ʼ�����Կ�Ŀ�����б�� protected void InitData() { Papermr paper = new Papermr(); //����Papermr���� DataSet ds = paper.QueryPaper(); //��ѯ���п����Ծ� if (ds.Tables[0].Rows.Count >= 1) { ddlPaper.DataSource = ds; //ָ�����Կ�Ŀ�б������Դ ddlPaper.DataTextField = "PaperName"; //DataTextField��ʾName�ֶ�ֵ ddlPaper.DataValueField = "PaperID"; //DataValueField��ʾID�ֶ�ֵ ddlPaper.DataBind(); //������ } else { ddlPaper.Enabled = false; ImgStartExam.Enabled = false; lblMessage.Text = "û���Ծ��"; } }