private void btThemHD_Click(object sender, EventArgs e) { if (txtThanhTien.Text == "0") { string mh, mk, mv; DateTime nx; int tt; mh = txtMaHD.Text.Trim(); mk = cbbMaKH.Text.Trim(); nx = Convert.ToDateTime(dtpNgayXuat.Text); tt = int.Parse(txtThanhTien.Text); mv = txtMaNV.Text.Trim(); DTOHoaDon hd = new DTOHoaDon(mh, mk, nx, tt, mv); try { int i = new BUSHoaDon().Add(hd); dgvHoaDon.DataSource = GetHD(); load(); xoatrangHD(); txtMaHD.Text = ""; } catch (SqlException ex) { MessageBox.Show(ex.Message); } } else { MessageBox.Show("Chưa Reset lại!"); } }
public List <DTOHoaDon> GetHD(string sql) { dp.connect(); List <DTOHoaDon> list = new List <DTOHoaDon>(); { string mh, mk, mn; DateTime nx; int tt; try { SqlDataReader dr = dp.ExecuteReader(sql); while (dr.Read()) { mh = dr.GetString(0); mk = dr.GetString(1); nx = dr.GetDateTime(2); tt = dr.GetInt32(3); mn = dr.GetString(4); DTOHoaDon hd = new DTOHoaDon(mh, mk, nx, tt, mn); list.Add(hd); } dr.Close(); return(list); } catch (SqlException ex) { throw ex; } finally { dp.disconnect(); } } }
private void btnTiep_Click(object sender, EventArgs e) { DTOHoaDon bill = new DTOHoaDon(fDatHang.mBillID, -1, DateTime.Now, null, 1); DAOHoaDon.Instance.UpdateBillByID(fDatHang.mBillID, bill); DAOShip.Instance.InsertShip(fDatHang.mBillID, doiTac, "NULL", "NULL", "NULL", "NULL", "NULL"); fTrangChu.Finish = true; this.Close(); }
/// <summary> /// Thành công: bill ID /// thất bại: -1 /// </summary> /// <param name="id"></param> /// <returns></returns> public int GetUncheckBillIDByTableID(int id) { DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM dbo.Bill WHERE idTable = " + id + " AND status = 0"); if (data.Rows.Count > 0) { DTOHoaDon bill = new DTOHoaDon(data.Rows[0]); return(bill.ID); } return(-1); }
private void btnTiep_Click(object sender, EventArgs e) { DTOHoaDon bill = new DTOHoaDon(fDatHang.mBillID, -1, DateTime.Now, null, 1); DAOHoaDon.Instance.UpdateBillByID(fDatHang.mBillID, bill); string nguoiGiao, sdtNguoiGiao, nguoiNhan, sdtNguoiNhan, diaChi; nguoiGiao = string.Format("N'{0}'", txtbNguoiGiao.Text); sdtNguoiGiao = string.Format("'{0}'", txtbSDTNguoiGiao.Text); nguoiNhan = string.Format("N'{0}'", txtbNguoiNhan.Text); sdtNguoiNhan = string.Format("'{0}'", txtbSDTNguoiNhan.Text); diaChi = string.Format("N'{0}'", txtbDiaChi.Text); DAOShip.Instance.InsertShip(fDatHang.mBillID, null, nguoiGiao, sdtNguoiGiao, nguoiNhan, sdtNguoiNhan, diaChi); fTrangChu.Finish = true; this.Close(); }
public int Add(DTOHoaDon hd) { List <SqlParameter> paras = new List <SqlParameter>(); paras.Add(new SqlParameter("@mh", hd.MaHD)); paras.Add(new SqlParameter("@mk", hd.MaKH)); paras.Add(new SqlParameter("@nx", hd.NgayXuat)); paras.Add(new SqlParameter("@tt", hd.ThanhTien)); paras.Add(new SqlParameter("@mv", hd.MaNV)); try { return(dp.ExcuteNonQuery("ThemHD", System.Data.CommandType.StoredProcedure, paras)); } catch (SqlException ex) { throw ex; } }
public void UpdateBillByID(int id, DTOHoaDon hoaDon) { string sqlFormattedDate = hoaDon.NgayDat.ToString("yyyy-MM-dd HH:mm:ss.fff"); string strIdKhachHang = "NULL"; string strHinhThucThanhToan = "NULL"; if (hoaDon.ID_KhachHang != -1) { strIdKhachHang = hoaDon.ID_KhachHang.ToString(); } if (hoaDon.HinhThucThanhToan != null) { strHinhThucThanhToan = "N'" + hoaDon.HinhThucThanhToan + "'"; } string query = string.Format( "UPDATE HOADON SET ID_KhachHang = {0}, NgayDat = '{1}', HinhThucThanhToan = {2}, KT_Ship = {3}" + " WHERE ID = {4}", strIdKhachHang, sqlFormattedDate, strHinhThucThanhToan,hoaDon.KT_Ship,id); DataProvider.Instance.ExcuteNonQuery(query); }
public int Add(DTOHoaDon hd) { return(new DAOHoaDon().Add(hd)); }