//private object GetDataFromDataRow2(DataTable dt, int i) //{ // hDTO = new HoaDonDTO(); // hDTO.MaHoaDon = dt.Rows[i]["MaHoaDon"].ToString(); // hDTO.NgayLap = DateTime.Parse(dt.Rows[i]["NgayLap"].ToString()); // hDTO.TriGia = float.Parse(dt.Rows[i]["TriGia"].ToString().Equals("") ? "0" : dt.Rows[i]["TriGia"].ToString()); // hDTO.ThanhToan = dt.Rows[i]["ThanhToan"].ToString(); //} public HoaDonDTO[] getlistHoaDon() { string sql = "select HOADON.MaHoaDon,HOADON.NgayLap,HOADON.TriGia,HOADON.ThanhToan from HOADON"; DataTable dt = ExecuteQuery(sql); HoaDonDTO[] hDTOArr = new HoaDonDTO[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { object hDTO = GetDataFromDataRow(dt, i); hDTOArr[i] = (HoaDonDTO)hDTO; } return hDTOArr; }
public bool LapHoaDon(HoaDonDTO dtoHD) { return new HoaDonDAO().LapHoaDon(dtoHD); }
public bool LapHoaDon(HoaDonDTO dtoHD) { dtoHD.ThanhToan = "0"; string sql = "insert into HOADON(MaHoaDon,NgayLap,TriGia,ThanhToan) values('" + dtoHD.MaHoaDon + "','" + dtoHD.NgayLap + "','" + dtoHD.TriGia + "','" + dtoHD.ThanhToan + "')"; return ExecuteNonQuery(sql); }
protected override object GetDataFromDataRow(DataTable dt, int i) { HoaDonDTO hDTO = new HoaDonDTO(); //hDTO.DiaChi = dt.Rows[i]["DiaChi"].ToString(); hDTO.MaHoaDon = dt.Rows[i]["MaHoaDon"].ToString(); hDTO.NgayLap = DateTime.Parse(dt.Rows[i]["NgayLap"].ToString()); hDTO.TriGia = float.Parse(dt.Rows[i]["TriGia"].ToString().Equals("")?"0":dt.Rows[i]["TriGia"].ToString()); hDTO.ThanhToan = dt.Rows[i]["ThanhToan"].ToString(); return (object)hDTO; }