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);
}
