コード例 #1
0
ファイル: Export.cs プロジェクト: bonizlee/ClassQuestionMark
 private void btnCalulate_Click(object sender, EventArgs e)
 {
     int basemark = Convert.ToInt16(txtBaseMark.Text);
     MarkBLL FMark = new MarkBLL();
     Marks = FMark.FinalMark(cmbClass.ClassID, basemark);
     MarkBind();
 }
コード例 #2
0
ファイル: Mark.cs プロジェクト: bonizlee/ClassQuestionMark
        private void btnOK_Click(object sender, EventArgs e)
        {
            ClassQuestionMark.BLL.MarkBLL bMark = new ClassQuestionMark.BLL.MarkBLL();

            if (bMark.AddMark(stuinfo.SID, Convert.ToInt32(cmbMark.Text)))
            {
                StudentBLL bStudent = new StudentBLL();
                bStudent.ChangeRate(stuinfo.SID, (int)(stuinfo.Rate + Convert.ToInt16(cmbMark.Text)));
                MessageBox.Show(stuinfo.SName + "�÷���:" + cmbMark.Text,"�Ǽ�",MessageBoxButtons.OK,MessageBoxIcon.Information);
                this.Close();
            }
            else
            {

                MessageBox.Show("��ӳɼ�ʧ�ܣ�", "����", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
コード例 #3
0
        private void GridViewMark_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            int CIndex = e.ColumnIndex;
            //ɾ������
            if(CIndex==4)
            {
                MarkBLL bMark = new MarkBLL();
                if (bMark.DeleteMark(GridViewMark.Rows[e.RowIndex].Cells[0].Value.ToString()))
                {
                    MessageBox.Show("ɾ���ɹ�");
                    QueryMark();
                }
                else
                    MessageBox.Show("ɾ��ʧ��");
            }
                //�޸IJ���
            else if (CIndex == 5)
            {
                MarkBLL bMark = new MarkBLL();
                int mark = 0;

                try
                {
                    if (!IsInt(GridViewMark.Rows[e.RowIndex].Cells[2].Value.ToString()))
                        throw new Exception("���������");
                    mark = Convert.ToInt16(GridViewMark.Rows[e.RowIndex].Cells[2].Value.ToString());
                    if (mark > MAXMARK || mark < MINMARK)
                        throw new Exception("�ɼ���ΧԽ��");

                    if (bMark.ChangeMark(GridViewMark.Rows[e.RowIndex].Cells[0].Value.ToString(), mark))
                    {
                        MessageBox.Show("���³ɹ�");
                        QueryMark();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message + "���󡣸���ʧ�ܡ�");
                    return;
                }
            }
        }
コード例 #4
0
        private void QueryMark()
        {
            MarkBLL bMark = new MarkBLL();
            DateTime[] QDate = new DateTime[]
            {
                new DateTime(),
                new DateTime()
            };
            if (!string.IsNullOrEmpty(txtSID.Text) && !string.IsNullOrEmpty(TxtFromDate.Text) && !string.IsNullOrEmpty(TxtToDate.Text))
            {
                QDate[0] = Convert.ToDateTime(TxtFromDate.Text);
                QDate[1] = Convert.ToDateTime(TxtToDate.Text);
                Marks = bMark.SelectMark(txtSID.Text, QDate);
                MarkBind();
                return;
            }

            if (!string.IsNullOrEmpty(txtSID.Text))
            {
                if (!string.IsNullOrEmpty(TxtToDate.Text))
                {
                    QDate[1] = Convert.ToDateTime(TxtToDate.Text);
                    Marks = bMark.SelectMark(txtSID.Text, QDate);
                    MarkBind();
                    return;
                }
                if (!string.IsNullOrEmpty(TxtFromDate.Text))
                {
                    QDate[0] = Convert.ToDateTime(TxtFromDate.Text);
                    Marks = bMark.SelectMark(txtSID.Text, QDate);
                    MarkBind();
                    return;
                }
                Marks = bMark.SelectMark(txtSID.Text);
                MarkBind();
                return;
            }

            if (!string.IsNullOrEmpty(TxtFromDate.Text))
            {
                QDate[0] = Convert.ToDateTime(TxtFromDate.Text);
                if (!string.IsNullOrEmpty(TxtToDate.Text))
                {
                    QDate[1] = Convert.ToDateTime(TxtToDate.Text);
                }
                Marks = bMark.SelectMark(QDate);
                MarkBind();
                return;
            }
            else
            {
                if (!string.IsNullOrEmpty(TxtToDate.Text))
                {
                    QDate[1] = Convert.ToDateTime(TxtToDate.Text);
                    Marks = bMark.SelectMark(QDate);
                    MarkBind();
                    return;
                }
            }
        }