public static List <CHITIETPHIEUDATHANG> getDSCTPDH() { List <CHITIETPHIEUDATHANG> ds = new List <CHITIETPHIEUDATHANG>(); ConnectionDB cn = new ConnectionDB(); SqlDataAdapter da = cn.getDa("select * from ct_phieudathang"); DataTable dt = new DataTable(); da.Fill(dt); cn.close(); foreach (DataRow dr in dt.Rows) { CHITIETPHIEUDATHANG ctpdh = new CHITIETPHIEUDATHANG(dr["sophieu"].ToString().Trim(), dr["masp"].ToString().Trim(), int.Parse(dr["soluong"].ToString().Trim()), Decimal.Parse(dr["giatien"].ToString().Trim())); ds.Add(ctpdh); } return(ds); }
public static void ThemCTPDH(List <CHITIETPHIEUDATHANG> dsCTPDH, String sophieu, String masp, int soluong, Decimal giatien) { CHITIETPHIEUDATHANG ct = new CHITIETPHIEUDATHANG(sophieu, masp, soluong, giatien); dsCTPDH.Add(ct); }