public void InsertYbbxDept(Bill_Ybbxmxb_Fykm_Dept dept, SqlTransaction tran)
{
string sql = @"insert into bill_ybbxmxb_fykm_dept( kmmxGuid, mxGuid, deptCode, je, status)values
( @kmmxGuid, @mxGuid, @deptCode, @je, @status)";
SqlParameter[] sps =
{
new SqlParameter("@kmmxGuid", dept.KmmxGuid),
new SqlParameter("@mxGuid", dept.MxGuid),
new SqlParameter("@deptCode", dept.DeptCode),
new SqlParameter("@je", dept.Je),
new SqlParameter("@status", dept.Status)
};
DataHelper.ExcuteNonQuery(sql, tran, sps, false);
}
public IList <Bill_Ybbxmxb_Fykm_Dept> GetDept(string kmmxGuid)
{
string sql = "select * from bill_ybbxmxb_fykm_dept where kmmxGuid=@kmmxGuid";
SqlParameter[] sps = { new SqlParameter("@kmmxGuid", kmmxGuid) };
DataTable dt = DataHelper.GetDataTable(sql, sps, false);
IList <Bill_Ybbxmxb_Fykm_Dept> list = new List <Bill_Ybbxmxb_Fykm_Dept>();
foreach (DataRow dr in dt.Rows)
{
Bill_Ybbxmxb_Fykm_Dept dept = new Bill_Ybbxmxb_Fykm_Dept();
dept.DeptCode = Convert.ToString(dr["DeptCode"]);
dept.Je = Convert.ToDecimal(dr["Je"]);
dept.KmmxGuid = Convert.ToString(dr["KmmxGuid"]);
dept.MxGuid = Convert.ToString(dr["MxGuid"]);
dept.Status = Convert.ToString(dr["Status"]);
list.Add(dept);
}
return(list);
}
