private void button1_Click(object sender, EventArgs e) { sqlDbHelper sdh = new sqlDbHelper(); string TypeName; if (radioButton1.Checked) { TypeName = "收入"; } else { TypeName = "支出"; } SqlParameter[] pa = { new SqlParameter("@tyName", TypeName), new SqlParameter("@ieTypeName", textBox1.Text), new SqlParameter("@rm", textBox2.Text) }; int c = sdh.ExecuteNonquery("insert into IncomeExpendType values (@tyName, @ieTypeName, @rm)", CommandType.Text, pa); if (c > 0) { MessageBox.Show("添加成功"); if (checkBox1.Checked) { this.Call(sender, e); } else { Close(); } } else { MessageBox.Show("添加失败"); } }
private void 添加收支分类_Load(object sender, EventArgs e) { sqlDbHelper sdh = new sqlDbHelper(); int b = (int)sdh.ExecuteScalar("select count(*) from IncomeExpendType"); textBox1.Text = b.ToString(); }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { if (listView1.SelectedItems.Count <= 0) { MessageBox.Show("请选中至少一项"); } sqlDbHelper helper = new sqlDbHelper(); for (int i = 0; i < listView1.SelectedItems.Count; i++) { string strid = listView1.SelectedItems[i].SubItems[2].Text; helper.ExecuteNonquery("delete from IncomeExpendType where IncomeExependTypeId = @id", CommandType.Text, new SqlParameter("id", strid)); } BindInExpType(sender, e); }
private void BindInExpType(object sender, EventArgs e) { listView1.Items.Clear(); sqlDbHelper helper = new sqlDbHelper(); SqlDataReader reader = helper.ExecuteReader("select * from IncomeExpendType"); while (reader.Read()) { ListViewItem lv = new ListViewItem(reader.GetString(2)); lv.SubItems.Add(reader.GetString(1)); lv.SubItems.Add(reader.GetInt32(0).ToString()); lv.SubItems.Add(reader.GetString(3)); listView1.Items.Add(lv); } reader.Close(); }
private void dataBind(object sender, EventArgs e) { string strSql = "select * from IncomeExpendDet where UserLoginID = @ulid"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@ulid", "1") }; con = new SqlConnection("Data Source=DESKTOP-7OA7319;Database=note;Integrated Security=true;"); sda = sqlDbHelper.ExecuteAdapter(strSql, CommandType.Text, sp, con); scb = new SqlCommandBuilder(sda); dataGridView1.AutoGenerateColumns = false; ds = new DataSet(); sda.Fill(ds, "ttt"); dtinfor = ds.Tables[0]; bindingSource1.DataSource = dtinfor; dataGridView1.DataSource = bindingSource1; bindingNavigator1.BindingSource = bindingSource1; dtinfor.Columns[2].DefaultValue = "1"; dataGridView1.Columns[0].DataPropertyName = dtinfor.Columns[0].ColumnName; dataGridView1.Columns[1].DataPropertyName = dtinfor.Columns[1].ColumnName; dataGridView1.Columns[2].DataPropertyName = dtinfor.Columns[2].ColumnName; dataGridView1.Columns[3].DataPropertyName = dtinfor.Columns[3].ColumnName; dataGridView1.Columns[4].DataPropertyName = dtinfor.Columns[4].ColumnName; dataGridView1.Columns[5].DataPropertyName = dtinfor.Columns[5].ColumnName; string sql = "select IncomeExependTypeId, IncomeExpendTypeName from IncomeExpendType"; sqlDbHelper sdh = new sqlDbHelper(); DataTable dt = sdh.ExecuteDataTable(sql, CommandType.Text, null); 收支类目.DataSource = dt; 收支类目.DisplayMember = "IncomeExpendTypeName"; 收支类目.ValueMember = "IncomeExependTypeId"; //User.DataSource = dt; //User.DisplayMember = "IncomeExependTypeId"; //User.ValueMember = "IncomeExpendTypeName"; cmbType.DataSource = dt; cmbType.DisplayMember = "IncomeExpendTypeName"; cmbType.ValueMember = "IncomeExependTypeId"; con.Close(); }