예제 #1
0
 public static int xoa_PN(PhieuNhap a)
 {
     SqlParameter[] para = new SqlParameter[]
     {
         new SqlParameter("@maPN", a.MaPN),
     };
     return(Dataprovider.ExecuteNonQuery("xoa_PN", para));
 }
예제 #2
0
 public static int xoa_HH(HangHoa a)
 {
     SqlParameter[] para = new SqlParameter[]
     {
         new SqlParameter("@maHH", a.MaHH),
     };
     return(Dataprovider.ExecuteNonQuery("xoa_HH", para));
 }
예제 #3
0
 public static int xoa_NCC(NCC a)
 {
     SqlParameter[] para = new SqlParameter[]
     {
         new SqlParameter("@maNCC", a.MaNCC),
     };
     return(Dataprovider.ExecuteNonQuery("xoa_NCC", para));
 }
예제 #4
0
 public static int xoa_CTX(ChiTietXuat a)
 {
     SqlParameter[] para = new SqlParameter[]
     {
         new SqlParameter("@maCTX", a.MaCTX),
     };
     return(Dataprovider.ExecuteNonQuery("xoa_CTX", para));
 }
예제 #5
0
 public static int xoa_PX(PhieuXuat a)
 {
     SqlParameter[] para = new SqlParameter[]
     {
         new SqlParameter("@maPX", a.MaPX),
     };
     return(Dataprovider.ExecuteNonQuery("xoa_PX", para));
 }
예제 #6
0
 public static int sua_HH(HangHoa a)
 {
     SqlParameter[] para = new SqlParameter[]
     {
         new SqlParameter("@maHH", a.MaHH),
         new SqlParameter("@tenHH", a.TenHH),
         new SqlParameter("@maNCC", a.MaNCC),
     };
     return(Dataprovider.ExecuteNonQuery("sua_HH", para));
 }
예제 #7
0
 public static int them_PN(PhieuNhap a)
 {
     SqlParameter[] para = new SqlParameter[]
     {
         new SqlParameter("@maPN", a.MaPN),
         new SqlParameter("@ngayNhap", a.NgayNhap),
         new SqlParameter("@tongTien", a.TongTien),
     };
     return(Dataprovider.ExecuteNonQuery("them_PN", para));
 }
예제 #8
0
 public static int them_PX(PhieuXuat a)
 {
     SqlParameter[] para = new SqlParameter[]
     {
         new SqlParameter("@maPX", a.MaPX),
         new SqlParameter("@ngayXuat", a.NgayXuat),
         new SqlParameter("@tongTien", a.TongTien),
     };
     return(Dataprovider.ExecuteNonQuery("them_PX", para));
 }
예제 #9
0
 //sua
 public static int sua_CTN(ChiTietNhap a)
 {
     SqlParameter[] para = new SqlParameter[]
     {
         new SqlParameter("@maCTN", a.MaCTN),
         new SqlParameter("@maPN", a.MaPN),
         new SqlParameter("@maHH", a.MaHH),
         new SqlParameter("@soLuong", a.SoLuong),
         new SqlParameter("@donGia", a.DonGia),
     };
     return(Dataprovider.ExecuteNonQuery("sua_CTN", para));
 }
예제 #10
0
 public static int them_CTX(ChiTietXuat a)
 {
     SqlParameter[] para = new SqlParameter[]
     {
         new SqlParameter("@maCTX", a.MaCTX),
         new SqlParameter("@maPX", a.MaPX),
         new SqlParameter("@maHH", a.MaHH),
         new SqlParameter("@soLuong", a.SoLuong),
         new SqlParameter("@donGia", a.DonGia),
     };
     return(Dataprovider.ExecuteNonQuery("them_CTX", para));
 }
예제 #11
0
 public static int them_NCC(NCC a)
 {
     SqlParameter[] para = new SqlParameter[]
     {
         new SqlParameter("@maNCC", a.MaNCC),
         new SqlParameter("@tenNCC", a.TenNCC),
         new SqlParameter("@diaChi", a.DiaChi),
         new SqlParameter("@SDT", a.SoDT),
         new SqlParameter("@email", a.Email),
     };
     return(Dataprovider.ExecuteNonQuery("them_NCC", para));
 }
예제 #12
0
 public static DataTable tk_nhap()
 {
     return(Dataprovider.GetData("tk_nhap"));
 }
예제 #13
0
 //thống kê
 public static DataTable tk_hh()
 {
     return(Dataprovider.GetData("tk_hh"));
 }
예제 #14
0
 public static DataTable xuat_ncc()
 {
     return(Dataprovider.GetData("xuat_NCC"));
 }
예제 #15
0
 public static DataTable xuat_hh_tk()
 {
     return(Dataprovider.GetData("xuat_hh_tk"));
 }
예제 #16
0
 public static DataTable xuat_ctx(string ma)
 {
     return(Dataprovider.GetData("xuat_CTX2" + "'" + ma + "'"));
 }
예제 #17
0
 public static DataTable xuat_px()
 {
     return(Dataprovider.GetData("xuat_PX"));
 }
예제 #18
0
 public static DataTable tk_xuat()
 {
     return(Dataprovider.GetData("tk_xuat"));
 }