formrejectreason.cs

人事管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace HumanResourceManagement
{
    public partial class FormRejectReason : Form
    {
        SqlConnection cnBlueHill_HRM;
        public FormRejectReason()
        {
            InitializeComponent();
        }

        private const int CP_NOCLOSE_BUTTON = 0x200;
        protected override CreateParams CreateParams
        {
            get
            {
                CreateParams myCp = base.CreateParams;
                myCp.ClassStyle = myCp.ClassStyle | CP_NOCLOSE_BUTTON;
                return myCp;
            }
        } 

        private void BtnOK_Click(object sender, EventArgs e)
        {
            string sql = "SELECT UnitsInStock FROM Products" + " WHERE ProductID = @ProdID";
            SqlCommand cmProducts = new SqlCommand(sql, cnBlueHill_HRM);
            SqlParameter param = cmProducts.Parameters.Add(new SqlParameter("@ProdID", SqlDbType.Int, 4));
            cmProducts.Parameters["@ProdID"].Value = txtReason.Text;

            int qty = Convert.ToInt32(cmProducts.ExecuteScalar());
            MessageBox.Show("Quantity in stock:" + qty.ToString());
        }
    }
}