public static bool payAndInsertDetailBill(DataGridView dgv, bill bil) { MessageBox.Show("Toan 3"); bool check = false;; int i = 0; for (i = 0; i < dgv.Rows.Count; i++) { check = false; detailBill detaiBill = new detailBill(); detaiBill.IdBill = bil.IdBill; detaiBill.IdProduct = int.Parse(dgv.Rows[i].Cells["idsp"].Value.ToString()); detaiBill.Price = int.Parse(dgv.Rows[i].Cells["giaban"].Value.ToString()); detaiBill.Quantity = int.Parse(dgv.Rows[i].Cells["soluong"].Value.ToString()); string sql = "insert into CHITIETHOADON values('" + detaiBill.IdBill + "','" + detaiBill.IdProduct + "','" + detaiBill.Price + "','" + detaiBill.Quantity + "')"; if (ConnectDAO.queryNonQuery(sql)) { check = true; } if (!check) { break; } //Console.WriteLine("chi tuet HOA DON"); //Console.WriteLine(" ma ct HOA DON" + detaiBill.IdBill); //Console.WriteLine(" id san pham" + detaiBill.IdProduct); //Console.WriteLine("gia" + detaiBill.Price); //Console.WriteLine("sol luong" + detaiBill.Quantity); } return(check); }
public static DataTable filterCombox(int idLoai) { DataTable data = null; string sql = "select SANPHAM.idSp ,SANPHAM.tenSp,LOAISANPHAM.tenLoai,SANPHAM.size,SANPHAM.mausac,giaban,SANPHAM.doituongsudung,SANPHAM.note from SANPHAM, LOAISANPHAM ,HoaDonNhapHang,nhacungcap where SANPHAM.idLOAISANPHAM = LOAISANPHAM.idLoai and sanpham.idSP=hoadonnhaphang.IdSanPham and NHACUNGCAP.IdNCC= sanpham.IdNhaCungCap and idloaisanpham='" + idLoai + "'; "; data = ConnectDAO.getDataTable(sql); return(data); }
public static DataTable getListProduct() { List <product> list = new List <product>(); string sql = "select SANPHAM.idSp ,SANPHAM.tenSp,LOAISANPHAM.tenLoai,SANPHAM.size,SANPHAM.mausac,giaban,SANPHAM.doituongsudung,SANPHAM.note from SANPHAM, LOAISANPHAM ,HoaDonNhapHang,nhacungcap where SANPHAM.idLOAISANPHAM = LOAISANPHAM.idLoai and sanpham.idSP=hoadonnhaphang.IdSanPham and NHACUNGCAP.IdNCC= sanpham.IdNhaCungCap; "; DataTable dtableProduct = ConnectDAO.getDataTable(sql); return(dtableProduct); }
public static DataTable takeListColor() { String sql = "select (mausac) from SANPHAM group by mausac order by mausac;"; DataTable dtable = ConnectDAO.getDataTable(sql); if (dtable.Rows.Count == 0) { return(null); } return(dtable); }
public static DataTable takeListSize() { String sql = "select (size) from SANPHAM group by size order by size;"; DataTable dtableSize = ConnectDAO.getDataTable(sql); if (dtableSize.Rows.Count == 0) { return(null); } return(dtableSize); }
public static bool checkExistAccount(String name, String pass) { String sql = "select * from acount where userName='******' and pass='******'"; DataTable da = ConnectDAO.getDataTable(sql); if (da.Rows.Count > 0) { return(true); } return(false); }
public static DataTable takeListType() { String sql = "select * from loaisanpham "; DataTable dtableType = ConnectDAO.getDataTable(sql); if (dtableType.Rows.Count == 0) { MessageBox.Show("base base loaisanpham null "); return(null); } return(dtableType); }
public static bool insertCustomerDAO(customer cus) { Console.WriteLine(cus.Name); Console.WriteLine(cus.Address); Console.WriteLine(cus.Phone); Console.WriteLine(cus.Gender); string sql = "insert into khachhang values('',N'" + cus.Name + "',N'" + cus.Address + "',N'" + cus.Phone + "',N'" + cus.Gender + "')"; if (ConnectDAO.queryNonQuery(sql)) { return(true); } return(false); }
public static bool payAndInsertBill(bill bil) { string sql = "insert into HOADON values('" + bil.IdBill + "',N'" + bil.IdStaff + "','" + CONST.customer.Id + "','" + bil.DayOfSell.ToString("yyyy/MM/dd") + "','" + bil.TotalMoney + "')"; if (ConnectDAO.queryNonQuery(sql)) { return(true); } //Console.WriteLine("HOA DON"); //Console.WriteLine(" ma HOA DON" + bil.IdBill); //Console.WriteLine("id nhan vien" + bil.IdStaff); //Console.WriteLine("id n kHach" + CONST.customer.Id); //Console.WriteLine("Ngay ban" + bil.DayOfSell); //Console.WriteLine("tong tien" + bil.TotalMoney); return(false); }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); ConnectDAO c = new ConnectDAO(); }