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