Beispiel #1
0
        private void FillComboBox1()
        {
            sqlCmd.Connection  = MyDataBase.GetConn();
            sqlCmd.CommandType = CommandType.Text;
            sqlCmd.CommandText = "select MerchandiseName from Merchandise";
            OleDbDataReader reader = sqlCmd.ExecuteReader();

            while (reader.Read())
            {
                Trace.WriteLine(reader[0].ToString());
                comboBox1.Items.Add(reader[0].ToString());
            }
            reader.Close();

            comboBox1.Text = comboBox1.Items[0].ToString();
        }
Beispiel #2
0
        private void MerchandiseInfoDisplayDlg_Load(object sender, EventArgs e)
        {
            stockCountsText.KeyPress    += new KeyPressEventHandler(characterRestrain.IntRestrain_KeyPress);
            existingCountsText.KeyPress += new KeyPressEventHandler(characterRestrain.IntRestrain_KeyPress);
            comboBox1.Items.Add("");
            sqlCmd.CommandType = CommandType.Text;
            sqlCmd.Connection  = MyDataBase.GetConn();
            sqlCmd.CommandText = @"select merchandisename from merchandise";
            OleDbDataReader reader = sqlCmd.ExecuteReader();

            while (reader.Read())
            {
                comboBox1.Items.Add(reader[0].ToString());
            }
            reader.Close();

            comboBox1.Text = comboBox1.Items[0].ToString();

            InitCombo();
        }
Beispiel #3
0
        private void UpdateDataGridView()
        {
            OleDbConnection objConnection = MyDataBase.GetConn();

            sqlcmd.CommandText = @"select MerchandiseName,StockCounts,ExitingCounts from Merchandise";
            sqlcmd.Connection  = objConnection;
            sqlcmd.CommandType = CommandType.Text;

            OleDbDataAdapter da = new OleDbDataAdapter();

            da.SelectCommand = sqlcmd;
            DataSet ds = new DataSet();

            da.Fill(ds, "table1");

            dataGridView1.DataSource = ds.Tables[0];

            dataGridView1.Columns[0].HeaderCell.Value = "商品名称";
            dataGridView1.Columns[1].HeaderCell.Value = "库存";
            dataGridView1.Columns[2].HeaderCell.Value = "现存";
        }
        private void SaleRecordQueryDlg_Load(object sender, EventArgs e)
        {
            toolTip1.SetToolTip(timedateText, "日期格式:2011-01-01");
            toolTip1.Active        = true;
            toolTip1.UseAnimation  = true;
            timedateText.KeyPress += new KeyPressEventHandler(characterRestrain.TimedateRestrain_KeyPress);

            merchandiseNameCombo.Items.Add("");
            sqlCmd.CommandType = CommandType.Text;
            sqlCmd.Connection  = MyDataBase.GetConn();
            sqlCmd.CommandText = @"select merchandisename from merchandise";
            OleDbDataReader reader = sqlCmd.ExecuteReader();

            while (reader.Read())
            {
                merchandiseNameCombo.Items.Add(reader[0].ToString());
            }
            reader.Close();

            merchandiseNameCombo.Text = merchandiseNameCombo.Items[0].ToString();
        }
Beispiel #5
0
 public void Form1_FormClosed(Object sender, EventArgs e)
 {
     MyDataBase.CloseConn();
 }
Beispiel #6
0
        private void AddMerchandise_Click(object sender, EventArgs e)
        {
            string          strName      = listBox1.SelectedItem.ToString();
            int             stockCounts  = System.Convert.ToInt32(textBox2.Text);
            int             extingCounts = System.Convert.ToInt32(ExtingCountText.Text);
            OleDbConnection conn         = MyDataBase.GetConn();

            if (AddMerchandise.Text.Equals("添加"))
            {
                string strCmd1 = @"update Merchandise set StockCounts=StockCounts+" + stockCounts.ToString();
                strCmd1 += @" where MerchandiseName='" + strName + "'";
                string strCmd2 = @"update Merchandise set ExitingCounts=ExitingCounts+" + stockCounts.ToString();
                strCmd2 += @" where MerchandiseName='" + strName + "'";

                int iRows = 0;
                sqlcmd.CommandText = strCmd1;
                iRows = sqlcmd.ExecuteNonQuery();
                if (iRows == 0)
                {
                    MessageBox.Show("添加失败,请查证后重新添加。");
                    return;
                }
                sqlcmd.CommandText = strCmd2;
                iRows = sqlcmd.ExecuteNonQuery();
                if (iRows == 0)
                {
                    MessageBox.Show("添加失败,请查证后重新添加。");
                    return;
                }
                SetText();

                //////////////////////////////////////////////////////////////////////////
                //添加出售信息
                string timeDate = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
                string strCmd3  = @"INSERT INTO stockmerchandise ( merchandisename, timedate, stockcounts ) values('" + strName + "','" + timeDate + "'," + stockCounts.ToString() + ")";
                sqlcmd.CommandText = strCmd1;
                iRows = sqlcmd.ExecuteNonQuery();
                if (iRows == 0)
                {
                    MessageBox.Show("添加失败,请查证后重新添加。");
                    return;
                }
            }
            else if (AddMerchandise.Text.Equals("更新"))
            {
                string strCmd1 = @"update Merchandise set StockCounts=" + stockCounts.ToString();
                strCmd1 += @" where MerchandiseName='" + strName + "'";
                string strCmd2 = @"update Merchandise set ExitingCounts=" + extingCounts.ToString();
                strCmd2 += @" where MerchandiseName='" + strName + "'";

                int iRows = 0;
                sqlcmd.CommandText = strCmd1;
                iRows = sqlcmd.ExecuteNonQuery();
                if (iRows == 0)
                {
                    MessageBox.Show("更新失败,请查证后重新添加。");
                    return;
                }
                sqlcmd.CommandText = strCmd2;
                iRows = sqlcmd.ExecuteNonQuery();
                if (iRows == 0)
                {
                    MessageBox.Show("更新失败,请查证后重新添加。");
                    return;
                }
                ExtingCountText.Visible  = false;
                ExtingCountLable.Visible = false;
                AddMerchandise.Text      = "添加";
                SetText();
            }

            if (dataGridView1.SelectedRows.Count != 0)
            {
                if (dataGridView1.SelectedRows[0].Cells.Count > 1)
                {
                    DataGridViewRow dRow = dataGridView1.SelectedRows[0];
                    for (int i = 0; i < dataGridView1.RowCount; i++)
                    {
                        string str = dRow.Cells[0].Value.ToString();
                        Trace.WriteLine(str);
                        if (str.Equals(strName))
                        {
                            Trace.WriteLine("Enter if :");
                            dataGridView1.CurrentCell = dataGridView1[0, 1];
                        }
                    }
                }
            }

            UpdateDataGridView();
        }