public void InsertYbbxFysq(Bill_Ybbx_Fysq fysq, SqlTransaction tran)
{
string sql = @"insert into bill_ybbx_fysq(billCode, sqCode, status) values
(@billCode, @sqCode, @status)";
SqlParameter[] sps =
{
new SqlParameter("@billCode", SqlNull(fysq.BillCode)),
new SqlParameter("@sqCode", SqlNull(fysq.SqCode)),
new SqlParameter("@status", SqlNull(fysq.Status))
};
DataHelper.ExcuteNonQuery(sql, tran, sps, false);
}
public IList <Bill_Ybbx_Fysq> GetFysq(string billCode)
{
string sql = "select * from bill_ybbx_fysq where billcode=@billCode";
SqlParameter[] sps = { new SqlParameter("@billCode", billCode) };
DataTable dt = DataHelper.GetDataTable(sql, sps, false);
IList <Bill_Ybbx_Fysq> list = new List <Bill_Ybbx_Fysq>();
foreach (DataRow dr in dt.Rows)
{
Bill_Ybbx_Fysq fysq = new Bill_Ybbx_Fysq();
fysq.BillCode = Convert.ToString(dr["BillCode"]);
fysq.SqCode = Convert.ToString(dr["SqCode"]);
fysq.Status = Convert.ToString(dr["Status"]);
list.Add(fysq);
}
return(list);
}
