コード例 #1
0
        public List <BillInfoDTO> getListBillInfoByIdBill(int idBillLoad)
        {
            List <BillInfoDTO> list = new List <BillInfoDTO>();
            SqlConnection      con  = DBUtils.MakeConnection();

            try
            {
                if (con != null)
                {
                    string sql = "Select id, idBill, nameFood, quantity " +
                                 "From BillInfo Where idBill = @IdBill";
                    SqlCommand cmd = new SqlCommand(sql, con);
                    cmd.Parameters.AddWithValue("@IdBill", idBillLoad);
                    SqlDataAdapter da      = new SqlDataAdapter(cmd);
                    DataTable      dtTable = new DataTable();
                    da.Fill(dtTable);
                    foreach (DataRow table in dtTable.Rows)
                    {
                        int         id       = (int)table["id"];
                        int         idBill   = (int)table["idBill"];
                        string      nameFood = (string)table["nameFood"];
                        int         quantity = (int)table["quantity"];
                        BillInfoDTO dto      = new BillInfoDTO(id, idBill, nameFood, quantity);
                        list.Add(dto);
                    }
                }
            } catch (Exception e)
            {
                throw new Exception(e.Message);
            }
            finally
            {
                con.Close();
            }
            return(list);
        }