private void button1_Click(object sender, EventArgs e)
{
decimal JE = 0;
decimal d = 0;
string jj = textBox2.Text.Trim();
if (string.IsNullOrEmpty(jj) || !decimal.TryParse(jj, out d))
{
MessageBox.Show("金额必须为数字！");
textBox2.Focus();
textBox2.SelectAll();
}
JE = d;
FinanceDetail finance = new FinanceDetail();
finance.项目 = textBox1.Text.Trim();
finance.金额 = JE;
finance.是否进账 = checkBox1.Checked;
finance.责任人 = (selectStaffControl1.SelectedStaffs != null && selectStaffControl1.SelectedStaffs.Count > 0) ? selectStaffControl1.SelectedStaffs[0] : null;
finance.备注 = textBox4.Text;
finance.Flag = checkBox2.Checked ? 1 : 0;
FinanceDetailLogic pl = FinanceDetailLogic.GetInstance();
int id = pl.AddFinanceDetail(finance);
if (id > 0)
{
finance.ID = id;
LoadFinanceDetails();
MessageBox.Show("添加成功！");
}
}
private DataTable Search(string name, Staff staff, int isIncome, int isCheck)
{
string nm = "";
if (!string.IsNullOrEmpty(name) && name.Trim() != "")
{
nm = " and 项目 like '%" + name + "%'";
}
string mn = "";
if (staff != null)
{
mn = " and 责任人='" + staff.姓名 + "'";
}
string ii = "";
if (isIncome > 0)
{
ii = " and 是否进账='" + (isIncome == 1 ? "是" : "否") + "'";
}
string ic = "";
if (isCheck > 0)
{
ic = " and 已报销='" + (Convert.ToInt32(isCheck - 1) == 1 ? "是" : "否") + "'";
}
string where = "(1=1)" + nm + mn + ii + ic;
return(FinanceDetailLogic.GetInstance().GetFinanceDetails(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);
}
}
private void Search(DateTime start, DateTime end, List <Staff> staffs)
{
string zrr = "";
if (staffs != null && staffs.Count > 0)
{
StringBuilder sb = new StringBuilder();
foreach (Staff staff in staffs)
{
if (sb.Length == 0)
{
sb.Append(staff.ID);
}
else
{
sb.Append("," + staff.ID);
}
}
zrr = " and 责任人 in (" + sb.ToString() + ")";
}
string where = "(1=1)" + zrr + " and (提交时间 >= '" + start + "' and 提交时间 < '" + end.AddDays(1) + "')";
listBox1.Items.Clear();
List <FinanceDetail> details = FinanceDetailLogic.GetInstance().GetFinanceDetailList(where);
listBox1.Tag = details;
foreach (FinanceDetail detail in details)
{
string info = detail.DetailInfo;
listBox1.Items.Add(info);
}
}
private void button2_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex > -1)
{
decimal JE = 0;
decimal d = 0;
string jj = textBox2.Text.Trim();
if (string.IsNullOrEmpty(jj) || !decimal.TryParse(jj, out d))
{
MessageBox.Show("金额必须为数字！");
textBox2.Focus();
textBox2.SelectAll();
}
JE = d;
FinanceDetail finance = new FinanceDetail();
finance.项目 = textBox1.Text.Trim();
finance.金额 = JE;
finance.是否进账 = checkBox1.Checked;
finance.责任人 = textBox3.Text.Trim();
finance.备注 = textBox4.Text;
FinanceDetailLogic pl = FinanceDetailLogic.GetInstance();
if (pl.UpdateFinanceDetail(finance))
{
LoadFinanceDetails();
MessageBox.Show("修改成功！");
}
}
else
{
MessageBox.Show("先选定要修改的流水明细！");
}
}
private void LoadFinanceDetails()
{
List <FinanceDetail> elements = FinanceDetailLogic.GetInstance().GetAllFinanceDetails();
comboBox1.Items.Clear();
foreach (FinanceDetail element in elements)
{
comboBox1.Items.Add(element);
}
}
private void LoadAllDetails()
{
listBox1.Items.Clear();
List <FinanceDetail> details = FinanceDetailLogic.GetInstance().GetAllFinanceDetails();
listBox1.Tag = details;
foreach (FinanceDetail detail in details)
{
string info = detail.DetailInfo;
listBox1.Items.Add(info);
}
}
private void button3_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex > -1)
{
if (MessageBox.Show("确定要删除该流水明细？", "删除提醒", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.OK)
{
FinanceDetail finance = (FinanceDetail)comboBox1.SelectedItem;
if (FinanceDetailLogic.GetInstance().DeleteFinanceDetail(finance))
{
LoadFinanceDetails();
}
}
}
else
{
MessageBox.Show("先选定要删除的流水明细！");
}
}
private DataTable Search(string name, string man, 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 ii = "";
if (isIncome > 0)
{
ii = " and 是否进账=" + (isIncome == 1 ? "1" : "0");
}
string where = "(1=1)" + nm + mn + ii + " order by ID desc";
return(FinanceDetailLogic.GetInstance().GetFinanceDetails(where));
}
public static List <FinanceDetail> GetDetailsByStr(string ids)
{
List <FinanceDetail> details = FinanceDetailLogic.GetInstance().GetFinanceDetailsByIds(ids);
return(details);
}