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("添加成功！");
}
}
