Пример #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //表示ラベル
            #region
            //追加
            Add_Number.Text = STUDENT_ID;
            Add_Name.Text   = STUDENT_NAME;
            Add_Point.Text  = STUDENT_POINT;

            //更新
            UP_Number.Text = STUDENT_ID;
            UP_Name.Text   = STUDENT_NAME;
            UP_Point.Text  = STUDENT_POINT;

            //削除
            Del_Number.Text = STUDENT_ID;
            #endregion

            //SQL読み込み
            SqlConnection con = new SqlConnection(@"Data Source=(local);Initial Catalog=ReportDB;Integrated Security=SSPI");
            con.Open();
            SqlCommand    cmd = new SqlCommand("SELECT REPORT_ID,NUMBER,NAME,POINT , iif(RESULT=1,'合格','不合格')AS RESULT FROM Reportmst ORDER BY NUMBER;", con);
            SqlDataReader dr  = cmd.ExecuteReader();
            DB_Grid.DataSource = dr;
            DB_Grid.DataBind();
            con.Close();

            //ヘッダー文字
            DB_Grid.HeaderRow.Cells[2].Text = STUDENT_ID;
            DB_Grid.HeaderRow.Cells[3].Text = STUDENT_NAME;
            DB_Grid.HeaderRow.Cells[4].Text = STUDENT_POINT;
            DB_Grid.HeaderRow.Cells[5].Text = STUDENT_RESULT;
        }
Пример #2
0
        //更新ボタンクリック
        protected void Update_Button_Click(object sender, EventArgs e)
        {
            select_hash = (Hashtable)ViewState["select_hash"];

            try
            {
                id     = (int)select_hash["ID"];
                number = UP_Number_Text.Text;
                name   = UP_Name_Text.Text;

                //例外処理
                #region
                //出席番号が未入力の場合
                if (number == null || number == "")
                {
                    number = DB_Grid.SelectedRow.Cells[2].Text;
                }

                //名前が未入力の場合
                if (name == null || name == "")
                {
                    name = DB_Grid.SelectedRow.Cells[3].Text;
                }

                //成績のチェック
                if (UP_Point_Text.Text != null && UP_Point_Text.Text != "" && int.Parse(UP_Point_Text.Text) <= 100)
                {
                    point = int.Parse((UP_Point_Text.Text));
                }
                else
                {
                    point = int.Parse(DB_Grid.SelectedRow.Cells[4].Text);
                }
                #endregion

                //成績判定
                #region
                if (point >= 60)
                {
                    result = true;
                }
                else
                {
                    result = false;
                }
                #endregion

                //SQL読み込み
                SqlConnection con = new SqlConnection(@"Data Source=(local);Initial Catalog=ReportDB;Integrated Security=SSPI");
                con.Open();
                SqlCommand cmd = new SqlCommand("UPDATE Reportmst SET NUMBER = @NUMBER, NAME = @NAME, POINT = @POINT, RESULT = @RESULT WHERE REPORT_ID = @REPORT_ID;", con);
                cmd.Parameters.Add(new SqlParameter("@REPORT_ID", id));
                cmd.Parameters.Add(new SqlParameter("@NUMBER", number));
                cmd.Parameters.Add(new SqlParameter("@NAME", name));
                cmd.Parameters.Add(new SqlParameter("@POINT", point));
                cmd.Parameters.Add(new SqlParameter("@RESULT", result));

                SqlDataReader dr = cmd.ExecuteReader();
                DB_Grid.DataSource = dr;
                DB_Grid.DataBind();
                con.Close();

                Response.Redirect(Request.Url.OriginalString);
            }
            catch
            {
                return;
            }
        }