/// <summary>
/// 新增项目
/// </summary>
/// <param name="xm"></param>
/// <param name="tran"></param>
public void InsertYbbxXm(Bill_Ybbxmxb_Hsxm xm, SqlTransaction tran)
{
string sql = @"insert into bill_ybbxmxb_hsxm( kmmxGuid, mxGuid, xmCode, je)values
( @kmmxGuid, @mxGuid, @xmCode, @je)";
SqlParameter[] sps =
{
new SqlParameter("@kmmxGuid", xm.KmmxGuid),
new SqlParameter("@mxGuid", xm.MxGuid),
new SqlParameter("@xmCode", xm.XmCode),
new SqlParameter("@je", xm.Je)
};
DataHelper.ExcuteNonQuery(sql, tran, sps, false);
}
public IList <Bill_Ybbxmxb_Hsxm> GetXm(string kmmxGuid)
{
string sql = "select * from Bill_Ybbxmxb_Hsxm where kmmxGuid=@kmmxGuid";
SqlParameter[] sps = { new SqlParameter("@kmmxGuid", kmmxGuid) };
DataTable dt = DataHelper.GetDataTable(sql, sps, false);
IList <Bill_Ybbxmxb_Hsxm> list = new List <Bill_Ybbxmxb_Hsxm>();
foreach (DataRow dr in dt.Rows)
{
Bill_Ybbxmxb_Hsxm xm = new Bill_Ybbxmxb_Hsxm();
xm.XmCode = Convert.ToString(dr["XmCode"]);
xm.Je = Convert.ToDecimal(dr["Je"]);
xm.KmmxGuid = Convert.ToString(dr["KmmxGuid"]);
xm.MxGuid = Convert.ToString(dr["MxGuid"]);
list.Add(xm);
}
return(list);
}
