public bool UpdateFinanceDetail(FinanceDetail element) { string sql = "update TF_FinanceDetail set 项目='" + element.项目 + "', 金额=" + element.金额 + ", 是否进账=" + (element.是否进账 ? "1" : "0") + ", 责任人=" + element.责任人.ID + ", 备注='" + element.备注 + "', Flag=" + element.Flag + ", 提交时间=getdate() where ID=" + element.ID; int r = sqlHelper.ExecuteSql(sql); return(r > 0); }
public List <FinanceDetail> GetFinanceDetailList(string where) { List <FinanceDetail> elements = new List <FinanceDetail>(); if (!string.IsNullOrEmpty(where)) { string w = where.Trim().ToLower(); if (!w.StartsWith("where ")) { w = "where " + w; } string sql = "select * from TF_FinanceDetail " + w; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { FinanceDetail element = new FinanceDetail(); element.ID = Convert.ToInt32(dt.Rows[i]["ID"]); element.项目 = dt.Rows[i]["项目"].ToString(); element.金额 = Convert.ToDecimal(dt.Rows[i]["金额"]); element.是否进账 = Convert.ToBoolean(dt.Rows[i]["是否进账"]); element.责任人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[i]["责任人"])); element.备注 = dt.Rows[i]["备注"].ToString(); element.提交时间 = Convert.ToDateTime(dt.Rows[i]["提交时间"]); element.Flag = Convert.ToInt32(dt.Rows[i]["Flag"]); elements.Add(element); } } } return(elements); }
public bool DeleteFinanceDetail(FinanceDetail element) { string sql = "delete from TF_FinanceDetail where ID=" + element.ID; int r = sqlHelper.ExecuteSql(sql); return(r > 0); }
public List <FinanceDetail> GetFinanceDetailsByIds(string ids) { List <FinanceDetail> elements = new List <FinanceDetail>(); string Ids = ""; if (!string.IsNullOrEmpty(ids)) { Ids = " where ID in (" + ids + ")"; } string sql = "select * from TF_FinanceDetail" + Ids; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { FinanceDetail element = new FinanceDetail(); element.ID = Convert.ToInt32(dt.Rows[i]["ID"]); element.项目 = dt.Rows[i]["项目"].ToString(); element.金额 = Convert.ToDecimal(dt.Rows[i]["金额"]); element.是否进账 = Convert.ToBoolean(dt.Rows[i]["是否进账"]); element.责任人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[i]["责任人"])); element.备注 = dt.Rows[i]["备注"].ToString(); element.提交时间 = Convert.ToDateTime(dt.Rows[i]["提交时间"]); element.Flag = Convert.ToInt32(dt.Rows[i]["Flag"]); elements.Add(element); } } return(elements); }
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 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("先选定要修改的流水明细!"); } }
public int AddFinanceDetail(FinanceDetail element) { string sql = "insert into TF_FinanceDetail (项目, 金额, 是否进账, 责任人, 备注, Flag) values ('" + element.项目 + "', " + element.金额 + ", " + (element.是否进账 ? "1" : "0") + ", " + element.责任人.ID + ", '" + element.备注 + "', " + element.Flag + "); select SCOPE_IDENTITY()"; object obj = sqlHelper.ExecuteSqlReturn(sql); int R; if (obj != null && obj != DBNull.Value && int.TryParse(obj.ToString(), out R)) { return(R); } else { return(0); } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox1.SelectedIndex > -1) { FinanceDetail finance = comboBox1.SelectedItem as FinanceDetail; if (finance != null) { textBox1.Text = finance.项目; textBox2.Text = finance.金额.ToString(); checkBox1.Checked = finance.是否进账; textBox3.Text = finance.责任人; textBox4.Text = finance.备注; } } }
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 void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox1.SelectedIndex > -1) { FinanceDetail finance = comboBox1.SelectedItem as FinanceDetail; if (finance != null) { textBox1.Text = finance.项目; textBox2.Text = finance.金额.ToString(); checkBox1.Checked = finance.是否进账; checkBox2.Checked = finance.Flag == 1; selectStaffControl1.SelectedStaffs = new List <Staff>() { finance.责任人 }; textBox4.Text = finance.备注; } } }
public FinanceDetail GetFinanceDetail(int id) { string sql = "select * from TF_FinanceDetail where ID=" + id; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { FinanceDetail element = new FinanceDetail(); element.ID = id; element.项目 = dt.Rows[0]["项目"].ToString(); element.金额 = Convert.ToDecimal(dt.Rows[0]["金额"]); element.是否进账 = Convert.ToBoolean(dt.Rows[0]["是否进账"]); element.责任人 = StaffLogic.GetInstance().GetStaff(Convert.ToInt32(dt.Rows[0]["责任人"])); element.备注 = dt.Rows[0]["备注"].ToString(); element.提交时间 = Convert.ToDateTime(dt.Rows[0]["提交时间"]); element.Flag = Convert.ToInt32(dt.Rows[0]["Flag"]); return(element); } return(null); }