private DataTable Search(string name, string man, string rec, int isIncome) { string nm = ""; if (!string.IsNullOrEmpty(name) && name.Trim() != "") { nm = " and 项目 like '%" + name + "%'"; } string mn = ""; if (!string.IsNullOrEmpty(man) && man.Trim() != "") { mn = " and 经手人 like '%" + man.Trim() + "%'"; } string rc = ""; if (!string.IsNullOrEmpty(rec) && rec.Trim() != "") { rc = " and 接收人 like '%" + rec.Trim() + "%'"; } string ii = ""; if (isIncome > 0) { ii = " and 进账='" + (isIncome == 1 ? "是" : "否") + "'"; } string where = "(1=1)" + nm + mn + ii; return(FinanceLogic.GetInstance().GetFinances(where)); }
private void LoadFinanceDetails() { List <FinanceDetail> elements = FinanceDetailLogic.GetInstance().GetAllFinanceDetails(); comboBox1.Items.Clear(); foreach (FinanceDetail element in elements) { comboBox1.Items.Add(element); } if (id > 0) { Finance f = FinanceLogic.GetInstance().GetFinance(id); if (f != null) { string ids = "ID=0"; if (!string.IsNullOrEmpty(f.Detail)) { ids = "ID in (" + f.Detail + ")"; } dataGridView1.DataSource = FinanceDetailLogic.GetInstance().GetFinanceDetails(ids); } } else { dataGridView1.DataSource = FinanceDetailLogic.GetInstance().GetFinanceDetails(string.Empty); } }
public static FinanceLogic GetInstance() { if (instance == null) { instance = new FinanceLogic(); } return(instance); }
private void LoadFinances() { List <Finance> elements = FinanceLogic.GetInstance().GetAllFinances(); comboBox1.Items.Clear(); foreach (Finance element in elements) { comboBox1.Items.Add(element); } dataGridView1.DataSource = FinanceLogic.GetInstance().GetFinances(string.Empty); }
private void button3_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex > -1) { if (MessageBox.Show("确定要删除该流水帐?", "删除提醒", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.OK) { Finance finance = (Finance)comboBox1.SelectedItem; if (FinanceLogic.GetInstance().DeleteFinance(finance)) { LoadFinances(); } } } else { MessageBox.Show("先选定要删除的流水帐!"); } }
private void button2_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex > -1) { string jj = textBox2.Text.Trim(); string sj = textBox6.Text.Trim(); decimal JJ = 0; decimal SJ = 0; decimal d = 0; if (string.IsNullOrEmpty(jj) || !decimal.TryParse(jj, out d)) { MessageBox.Show("金额必须为数字!"); textBox2.Focus(); textBox2.SelectAll(); } JJ = d; if (string.IsNullOrEmpty(sj) || !decimal.TryParse(sj, out d)) { MessageBox.Show("余款必须为数字!"); textBox6.Focus(); textBox6.SelectAll(); } SJ = d; Finance finance = (Finance)comboBox1.SelectedItem; finance.项目 = textBox1.Text.Trim(); finance.金额 = JJ; finance.是否进账 = checkBox1.Checked; finance.余款 = SJ; finance.经手人 = textBox3.Text.Trim(); finance.接收人 = textBox4.Text.Trim(); finance.日期 = DateTime.Parse(textBox7.Text.Trim()); finance.Detail = textBox10.Text; FinanceLogic pl = FinanceLogic.GetInstance(); if (pl.UpdateFinance(finance)) { LoadFinances(); MessageBox.Show("修改成功!"); } } else { MessageBox.Show("先选定要修改的流水帐!"); } }
private void button1_Click(object sender, EventArgs e) { string jj = textBox2.Text.Trim(); string sj = textBox6.Text.Trim(); decimal JJ = 0; decimal SJ = 0; decimal d = 0; if (string.IsNullOrEmpty(jj) || !decimal.TryParse(jj, out d)) { MessageBox.Show("金额必须为数字!"); textBox2.Focus(); textBox2.SelectAll(); } JJ = d; if (string.IsNullOrEmpty(sj) || !decimal.TryParse(sj, out d)) { MessageBox.Show("余款必须为数字!"); textBox6.Focus(); textBox6.SelectAll(); } SJ = d; Finance finance = new Finance(); finance.项目 = textBox1.Text.Trim(); finance.金额 = JJ; finance.是否进账 = checkBox1.Checked; finance.余款 = SJ; finance.经手人 = textBox3.Text.Trim(); finance.接收人 = textBox4.Text.Trim(); finance.日期 = DateTime.Parse(textBox7.Text.Trim()); finance.Detail = textBox10.Text; FinanceLogic pl = FinanceLogic.GetInstance(); int id = pl.AddFinance(finance); if (id > 0) { finance.ID = id; LoadFinances(); MessageBox.Show("添加成功!"); } }