Пример #1
0
        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);
        }
Пример #2
0
        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);
        }
Пример #3
0
        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);
        }
Пример #4
0
        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);
        }
Пример #5
0
        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);
        }
Пример #6
0
        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);
        }
Пример #7
0
        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);
        }
Пример #8
0
        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);
        }
Пример #9
0
        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);
        }
Пример #10
0
 static void Main()
 {
     Application.EnableVisualStyles();
     Application.SetCompatibleTextRenderingDefault(false);
     ConnectDAO c = new ConnectDAO();
 }