/// <summary> /// 点击 "添加" 按钮触发的事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnInsert_Click(object sender, EventArgs e) { string date = cboYear.Text + '-' + cboMonth.Text + '-' + cboDay.Text; string sql = string.Format("insert into consume values('{0}','{1}','{2}',{3},'{4}')", date, cboType.Text, cboCategory.Text, txtJinE.Text.Trim(), txtBeizhu.Text.Trim()); SqlCommand cmd = new SqlCommand(sql, DBHelper.connection); DBHelper.connection.Open(); // 增删改的语句使用 ExecuteNonQuery() int rowCount = cmd.ExecuteNonQuery(); // 添加成功弹出对话框让用户知道 if (rowCount > 0) { MessageBox.Show("添加记录成功"); mForm.fill(); } else { MessageBox.Show("添加记录失败"); } DBHelper.connection.Close(); }
/// <summary> /// "查询"按钮触发的事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnChaXun_Click(object sender, EventArgs e) { // 拼接查询条件 sql 语句 string condition = string.Empty; // 按时间段查询 if (rdoDuan.Checked) { condition += string.Format("ConsumeDate>='{0}' and ConsumeDate<='{1}'", cboYear.Text + "-" + cboMonth.Text + "-" + cboDay.Text, cboEndYear.Text + "-" + cboEndMonth.Text + "-" + cboEndDay.Text); } // 按时间点查询 else { condition += string.Format("ConsumeDate='{0}'", cboYear.Text + "-" + cboMonth.Text + "-" + cboDay.Text); } // 按类别查询 if (condition != string.Empty) { string category = string.Empty; if (cbGongZi.Checked) { category += string.Format("'{0}',", cbGongZi.Text); } if (cbQiTaRu.Checked) { category += string.Format("'{0}',", cbQiTaRu.Text); } if (cbYuLe.Checked) { category += string.Format("'{0}',", cbYuLe.Text); } if (cbCanYin.Checked) { category += string.Format("'{0}',", cbCanYin.Text); } if (cbLvYou.Checked) { category += string.Format("'{0}',", cbLvYou.Text); } if (cbGouWu.Checked) { category += string.Format("'{0}',", cbGouWu.Text); } if (cbQiTaChu.Checked) { category += string.Format("'{0}',", cbQiTaChu.Text); } // 上面的字符串结尾都带有逗号 所以在下面去掉 string categoryFina = category.Substring(0, category.Length - 1); condition += string.Format(" and Category in({0})", categoryFina); // 按金额范围查询 double minMoney = 0, maxMoney = 0; // 用户输入不为空的验证 if (txtMin.Text.Trim() == string.Empty) { txtMin.Text = "0"; } if (txtMax.Text.Trim() == string.Empty) { txtMax.Text = "0"; } try { minMoney = Convert.ToDouble(txtMin.Text.Trim()); maxMoney = Convert.ToDouble(txtMax.Text.Trim()); } catch (FormatException ex) { MessageBox.Show("请输入正确金额数值"); return; } if (minMoney > 0) { condition += string.Format(" and ConsumeMoney>={0}", minMoney); } if (maxMoney > 0) { condition += string.Format(" and ConsumeMoney<={0}", maxMoney); } // 备注的模糊搜索 if (txtDescription.Text.Trim() != string.Empty) { condition += string.Format(" and Description like '%{0}%'", txtDescription.Text.Trim()); } } // 调用 MainForm 中的绑定方法 //mainForm.bindData(condition); // 下面写的都是我自己的尝试罢了 SqlCommand cmd = new SqlCommand(mainForm.bindData(condition), DBHelper.connection); DBHelper.connection.Open(); int rowCounts = cmd.ExecuteNonQuery(); if (rowCounts > 0) { MessageBox.Show("query success"); mainForm.fill(); } else { MessageBox.Show("query failure"); } DBHelper.connection.Close(); this.Close(); }