public static int themMoi(NhaCungCapDTO dto) { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.ThemNhaCungCap"; //// create a new parameter DbParameter param = command.CreateParameter(); param.ParameterName = "@tenNhaCungCap"; param.Value = dto.TenNhaCungCap; param.DbType = DbType.String; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@dienThoai"; param.Value = dto.DienThoai; param.DbType = DbType.String; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@soTaiKhoan"; param.Value = dto.SoTaiKhoan; param.DbType = DbType.String; command.Parameters.Add(param); return(DataAccessCode.ExecuteNonQuery(command)); }
public static int setNgungGiaoDich(int maNhaCungCap, int maNhaHang, int tinhTrang) { DbCommand command = DataAccessCode.CreateCommand(); //command.CommandText = "dbo.setNgungGiaoDich"; command.CommandText = "dbo.setNgungGiaoDich"; //// create a new parameter DbParameter param = command.CreateParameter(); param.ParameterName = "@maNhaCungCap"; param.Value = maNhaCungCap; param.DbType = DbType.Int32; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@maNhaHang"; param.Value = maNhaHang; param.DbType = DbType.Int32; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@tinhTrang"; param.Value = tinhTrang; param.DbType = DbType.Int16; command.Parameters.Add(param); return(DataAccessCode.ExecuteNonQuery(command)); }
public static DataTable LayBangNhaHang() { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.LayDanhSachNhaHang"; return(DataAccessCode.ExecuteSelectCommand(command)); }
internal static List <LichLamViecDTO> LoadLichLamViec() { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.LayDanhSachLichLamViec"; DataTable dt = DataAccessCode.ExecuteSelectCommand(command); List <LichLamViecDTO> list = new List <LichLamViecDTO>(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { LichLamViecDTO lich = new LichLamViecDTO(); lich.MaNhanVien = Int32.Parse(dt.Rows[i]["MaNhanVien"].ToString()); lich.HoNhanVien = dt.Rows[i]["HoNhanVien"].ToString(); lich.TenNhanVien = dt.Rows[i]["TenNhanVien"].ToString(); lich.Thu = Int32.Parse(dt.Rows[i]["Thu"].ToString()); lich.Ca = Int32.Parse(dt.Rows[i]["Ca"].ToString()); list.Add(lich); } } return(list); }
// cấp phát public static DataTable LayBangNguoiDung() { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.LayTaiKhoan"; return(DataAccessCode.ExecuteSelectCommand(command)); }
public static int layMaThongTinHangNhap(DateTime ngayGioNhap, int maKhoHang) { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.layIDThongTinHangNhap"; DbParameter param = command.CreateParameter(); param.ParameterName = "@ngayGioNhap"; param.Value = ngayGioNhap; param.DbType = DbType.DateTime; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@maKhoHang"; param.Value = maKhoHang; param.DbType = DbType.Int32; command.Parameters.Add(param); DataTable dt = DataAccessCode.ExecuteSelectCommand(command); int id = -1; if (dt != null) { id = Convert.ToInt32(dt.Rows[0]["MaThongTinHangNhap"]); } return(id); }
public static List <ThongTinBanDTO> LayDanhSachThongTinBan(int maKhuVuc) { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.LayDanhSachThongTinBan"; DbParameter param = command.CreateParameter(); param.ParameterName = "@MaKhuVuc"; if (maKhuVuc == 0) { param.Value = DBNull.Value; } else { param.Value = maKhuVuc; } param.DbType = DbType.Int32; command.Parameters.Add(param); DataTable dt = DataAccessCode.ExecuteSelectCommand(command); List <ThongTinBanDTO> list = new List <ThongTinBanDTO>(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { ThongTinBanDTO thongTinBan = new ThongTinBanDTO(); thongTinBan.MaBan = Int32.Parse(dt.Rows[i]["MaBan"].ToString()); thongTinBan.MaKhuVuc = Int32.Parse(dt.Rows[i]["MaKhuVuc"].ToString()); thongTinBan.TenBan = dt.Rows[i]["TenBan"].ToString(); thongTinBan.SucChua = Int32.Parse(dt.Rows[i]["SucChua"].ToString()); list.Add(thongTinBan); } } return(list); }
//LOST UPDATED SOLVED public static int lostUpdatedSolvedXuatNguyenLieu(KhoHang_NguyenLieuDTO dto, int maNhaHang, int mucCoLap) { DbCommand command = DataAccessCode.CreateCommand(); DbParameter param = command.CreateParameter(); command.CommandText = "dbo.lostUpdatedSolvedXuatNguyenLieu"; //// create a new parameter param.ParameterName = "@soLuongXuat"; param.Value = dto.SoLuongXuat; param.DbType = DbType.Int32; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@maNguyenLieu"; param.Value = dto.NguyenLieu.MaNguyenLieu; param.DbType = DbType.Int32; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@maNhaHang"; param.Value = maNhaHang; param.DbType = DbType.Int32; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@mucCoLap"; param.Value = mucCoLap; param.DbType = DbType.Int32; command.Parameters.Add(param); return(DataAccessCode.ExecuteNonQuery(command)); }
public static List <ChiTietThucDonDTO> LayDanhSachMonAnTheoNhaHang(int maNhaHang, DateTime ngay) { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.LayDanhSachMonAnTheoNhaHang"; DbParameter param = command.CreateParameter(); param.ParameterName = "@MaNhaHang"; param.Value = maNhaHang; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Ngay"; param.Value = ngay; param.DbType = DbType.DateTime; command.Parameters.Add(param); DataTable dt = DataAccessCode.ExecuteSelectCommand(command); List <ChiTietThucDonDTO> list = new List <ChiTietThucDonDTO>(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { ChiTietThucDonDTO chiTietThucDon = new ChiTietThucDonDTO(); chiTietThucDon.MaChiTietThucDon = Int32.Parse(dt.Rows[i]["MaChiTietThucDon"].ToString()); chiTietThucDon.MaMonAn = Int32.Parse(dt.Rows[i]["MaMonAn"].ToString()); chiTietThucDon.TenMonAn = dt.Rows[i]["TenMonAn"].ToString(); chiTietThucDon.DonGia = Decimal.Parse(dt.Rows[i]["DonGia"].ToString()); list.Add(chiTietThucDon); } } return(list); }
public static DataTable GetTables() { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "SP_GETTABLES"; return(DataAccessCode.ExecuteSelectCommand(command)); }
public static ArrayList layDanhSachNguyenLieuTheoMonAn(MonAnDTO monAn) { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.LayDanhSachNguyenLieuTheoMonAn"; DbParameter param = command.CreateParameter(); param.ParameterName = "@MaMonAn"; param.Value = monAn.MaMonAn; param.DbType = DbType.Int32; command.Parameters.Add(param); DataTable dt = DataAccessCode.ExecuteSelectCommand(command); ArrayList list = new ArrayList(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { MonAn_NguyenLieuDTO dto = new MonAn_NguyenLieuDTO(); dto.NguyenLieu.MaNguyenLieu = Convert.ToInt32(dt.Rows[i]["MaNguyenLieu"]); dto.NguyenLieu.TenNguyenLieu = dt.Rows[i]["TenNguyenLieu"].ToString(); dto.NguyenLieu.DonViTinh = dt.Rows[i]["DonViTinh"].ToString(); dto.SoLuong = Convert.ToInt32(dt.Rows[i]["SoLuong"]); list.Add(dto); } } return(list); }
public static DataTable TTNhanVien() { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.LayNhanVien"; return(DataAccessCode.ExecuteSelectCommand(command)); }
public static List <KhuVucDTO> LayDanhSachKhuVuc(int maNhaHang) { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.LayDanhSachKhuVuc"; DbParameter param = command.CreateParameter(); param.ParameterName = "@MaNhaHang"; if (maNhaHang == 0) { param.Value = DBNull.Value; } else { param.Value = maNhaHang; } param.DbType = DbType.Int32; command.Parameters.Add(param); DataTable dt = DataAccessCode.ExecuteSelectCommand(command); List <KhuVucDTO> list = new List <KhuVucDTO>(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { KhuVucDTO khuVuc = new KhuVucDTO(); khuVuc.MaKhuVuc = Int32.Parse(dt.Rows[i]["MaKhuVuc"].ToString()); khuVuc.TenKhuVuc = dt.Rows[i]["TenKhuVuc"].ToString(); khuVuc.GiaBan = Decimal.Parse(dt.Rows[i]["GiaBan"].ToString()); list.Add(khuVuc); } } return(list); }
public static ArrayList layDanhSachMonAnTheoPhanLoaiMonAn(LoaiMonAnDTO loaiMonAn, int maNhaHang) { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.LayDanhSachMonAnTheoPhanLoaiMonAn"; DbParameter param = command.CreateParameter(); param.ParameterName = "@MaNhaHang"; param.Value = maNhaHang; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@MaLoaiMonAn"; param.Value = loaiMonAn.MaLoaiMonAn; param.DbType = DbType.Int32; command.Parameters.Add(param); DataTable dt = DataAccessCode.ExecuteSelectCommand(command); ArrayList list = new ArrayList(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { PhanLoaiMonAnDTO plMA = new PhanLoaiMonAnDTO(); plMA.LoaiMonAn.MaLoaiMonAn = Convert.ToInt32(dt.Rows[i]["MaLoaiMonAn"]); plMA.MonAn.MaMonAn = Convert.ToInt32(dt.Rows[i]["MaMonAn"]); plMA.MonAn.TenMonAn = dt.Rows[i]["TenMonAn"].ToString(); plMA.NhaHang.MaNhaHang = maNhaHang; list.Add(plMA); } } return(list); }
public static KhoHang_NguyenLieuDTO layChiTietKhoHangNguyenLieu(int maNhaHang, NguyenLieuDTO nguyenLieuCanTim) { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.layChiTietKhoHangNguyenLieu"; DbParameter param = command.CreateParameter(); param.ParameterName = "@MaNguyenLieu"; param.Value = nguyenLieuCanTim.MaNguyenLieu; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@MaNhaHang"; param.Value = maNhaHang; param.DbType = DbType.Int32; command.Parameters.Add(param); DataTable dt = DataAccessCode.ExecuteSelectCommand(command); KhoHang_NguyenLieuDTO dto = new KhoHang_NguyenLieuDTO(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { dto.NguyenLieu.MaNguyenLieu = Convert.ToInt32(dt.Rows[i]["MaNguyenLieu"]); dto.NguyenLieu.TenNguyenLieu = dt.Rows[i]["TenNguyenLieu"].ToString(); dto.NguyenLieu.DonViTinh = dt.Rows[i]["DonViTinh"].ToString(); dto.SoLuongTon = Convert.ToInt32(dt.Rows[i]["SoLuongTon"]); dto.SucChua = Convert.ToInt32(dt.Rows[i]["SucChua"]); dto.MucTonToiThieu = Convert.ToInt32(dt.Rows[i]["MucChuaToiThieu"]); } } return(dto); }
public static ArrayList traCuuNhaCungCapThoaYeuCauNguyenLieuCanDatHang(string sqlFROM) { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.traCuuNhaCungCapThoaYeuCauNguyenLieuCanDatHang"; DbParameter param = command.CreateParameter(); param.ParameterName = "@sqlFROM"; param.Value = sqlFROM; param.DbType = DbType.String; command.Parameters.Add(param); DataTable dt = DataAccessCode.ExecuteSelectCommand(command); ArrayList list = new ArrayList(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { NhaCungCapDTO dto = new NhaCungCapDTO(); dto.MaNhaCungCap = Convert.ToInt32(dt.Rows[i]["MaNhaCungCap"]); dto.SoLuongNguyenLieuToiDaPhuHopYeuCauDatHang = Convert.ToInt32(dt.Rows[i]["SoLuongNguyenLieuDapUng"]); dto.TenNhaCungCap = dt.Rows[i]["TenNhaCungCap"].ToString(); list.Add(dto); } } return(list); }
//DIRTY READ SOLVED public static int dirtyReadSolvedSetNgungGiaoDich(int maNhaCungCap, int maNhaHang, int tinhTrang) { DbCommand command = DataAccessCode.CreateCommand(); //command.CommandText = "dbo.setNgungGiaoDich"; command.CommandText = "dbo.DirtyReadSolvedT2SetNgungGiaoDich"; //// create a new parameter DbParameter param = command.CreateParameter(); param.ParameterName = "@maNhaCungCap"; param.Value = maNhaCungCap; param.DbType = DbType.Int32; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@maNhaHang"; param.Value = maNhaHang; param.DbType = DbType.Int32; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@tinhTrang"; param.Value = tinhTrang; param.DbType = DbType.Int16; command.Parameters.Add(param); //create a new parameter param = command.CreateParameter(); param.ParameterName = "@isRollback"; param.Direction = ParameterDirection.Output; param.Value = 0; param.DbType = DbType.Int16; command.Parameters.Add(param); return(DataAccessCode.ExecuteNonQueryReturnIsRollBackOutputValue(command)); }
public static bool HuyThongTinKhachVaBanDatUnRRead(int maLich) { try { DbCommand cm = DataAccessCode.CreateCommand(); cm.CommandText = "dbo.CnHuyThongTinKhachBanDatUnRRead"; // DbParameter pm = cm.CreateParameter(); pm.ParameterName = "@maLichBan"; pm.Value = maLich; pm.DbType = DbType.Int32; cm.Parameters.Add(cm); if (DataAccessCode.ExecuteNonQuery(cm) != -1) { MessageBox.Show("Hủy Thành Công"); return(true); } } catch (Exception ex) { MessageBox.Show(ex.Message); } return(false); }
public static DataTable ThongTinKhachVaBanDat() { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.ThongTinKhachVaBanDat"; DataTable dt = DataAccessCode.ExecuteSelectCommand(command); //List<BanDatDTO> list = new List<BanDatDTO>(); //if (dt != null) //{ // for (int i = 0; i < dt.Rows.Count; i++) // { // BanDatDTO bd = new BanDatDTO(); // //bd.MaNhaHang = Int32.Parse(dt.Rows[i]["MaNhaHang"].ToString()); // bd.HoTen = dt.Rows[i]["HoTen"].ToString(); // bd.Cmnd = dt.Rows[i]["CMND"].ToString(); // bd.DienThoai = dt.Rows[i]["DienThoai"].ToString(); // bd.MaBan = Int32.Parse(dt.Rows[i]["MaBan"].ToString()); // bd.NgayDatBan = DateTime.Parse(dt.Rows[i]["NgayDatBan"].ToString()); // bd.MaBuoi = Int32.Parse(dt.Rows[i]["MaBuoi"].ToString()); // bd.SoLuong = Int32.Parse(dt.Rows[i]["SoLuong"].ToString()); // bd.MaThongTinKhachHang = Int32.Parse(dt.Rows[i]["MaThongTinKhachHang"].ToString()); // bd.MaLichBan = Int32.Parse(dt.Rows[i]["MaLichBan"].ToString()); // list.Add(bd); // } //} if (dt == null) { dt = new DataTable(); } return(dt); }
public static int themThongTinHangNhap(ThongTinHangNhapDTO ttNhap) { DbCommand command = DataAccessCode.CreateCommand(); //// create a new parameter DbParameter param = command.CreateParameter(); command.CommandText = "dbo.themThongTinHangNhap"; param.ParameterName = "@ngayNhap"; param.Value = ttNhap.NgayNhap; param.DbType = DbType.DateTime; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@maKhoHang"; param.Value = ttNhap.KhoHang.MaKhoHang; param.DbType = DbType.Int32; command.Parameters.Add(param); int kq = DataAccessCode.ExecuteNonQuery(command); if (kq == 1) { for (int i = 0; i < ttNhap.ChiTietHangNhap.Count; i++) { ((ChiTietHangNhapDTO)ttNhap.ChiTietHangNhap[i]).MaThongTinHangNhap = layMaThongTinHangNhap(ttNhap.NgayNhap, ttNhap.KhoHang.MaKhoHang); themChiTietHangNhap((ChiTietHangNhapDTO)ttNhap.ChiTietHangNhap[i]); } } return(1); }
public static List <LoaiNhanVienCNDTO> LayLoaiNhanVien() { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.LayLoaiNhanVien"; DataTable dt = DataAccessCode.ExecuteSelectCommand(command); List <LoaiNhanVienCNDTO> list = new List <LoaiNhanVienCNDTO>(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { //LoaiNhanVienDTO loaiNV = new LoaiNhanVienDTO(); int maLoaiNhanVien = Int32.Parse(dt.Rows[i]["MaLoaiNhanVien"].ToString()); string tenLoaiNhanVien = dt.Rows[i]["TenLoaiNhanVien"].ToString(); double luong = Int32.Parse(dt.Rows[i]["Luong"].ToString()); LoaiNhanVienCNDTO loaiNV = new LoaiNhanVienCNDTO(maLoaiNhanVien, tenLoaiNhanVien, luong); list.Add(loaiNV); //NhaHangDTO nhaHang = new NhaHangDTO(maNhaHang, tenNhaHang, diaChi, dienThoai); //list.Add(nhaHang); } } return(list); }
public static List <BanDatDTO> LayDanhSachBanDat() { DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.LayDanhSachBanDat"; DataTable dt = DataAccessCode.ExecuteSelectCommand(command); List <BanDatDTO> list = new List <BanDatDTO>(); if (dt != null) { int maThongTinKhachHang; for (int i = 0; i < dt.Rows.Count; i++) { BanDatDTO banDat = new BanDatDTO(); banDat.MaLichBan = Int32.Parse(dt.Rows[i]["MaLichBan"].ToString()); banDat.MaBan = Int32.Parse(dt.Rows[i]["MaBan"].ToString()); banDat.NgayDatBan = DateTime.Parse(dt.Rows[i]["NgayDatBan"].ToString()); banDat.MaBuoi = Int32.Parse(dt.Rows[i]["MaBuoi"].ToString()); if (Int32.TryParse(dt.Rows[i]["MaThongTinKhachHang"].ToString(), out maThongTinKhachHang)) { banDat.MaThongTinKhachHang = maThongTinKhachHang; } banDat.SoLuong = Int32.Parse(dt.Rows[i]["SoLuong"].ToString()); banDat.TinhTrangBan = Boolean.Parse(dt.Rows[i]["TinhTrangBan"].ToString()); list.Add(banDat); } } return(list); }
public static void XoaMonAn(string maChiTietHoaDon, bool isDirtyRead, bool isUnrepeatableRead) { DbCommand command = DataAccessCode.CreateCommand(); if (isDirtyRead) { command.CommandText = "dbo.XoaMonAnDirtyRead"; } else if (isUnrepeatableRead) { command.CommandText = "dbo.XoaMonAnUnrepeatableRead"; } else { command.CommandText = "dbo.XoaMonAn"; } //// create a new parameter DbParameter param = command.CreateParameter(); param.ParameterName = "@MaChiTietHoaDon"; param.Value = maChiTietHoaDon; param.DbType = DbType.String; command.Parameters.Add(param); DataAccessCode.ExecuteNonQuery(command); }
public static Guid ThemHoaDon(int maLichBan, DateTime ngayLapHoaDon) { Guid maHoaDon = Guid.NewGuid(); DbCommand command = DataAccessCode.CreateCommand(); command.CommandText = "dbo.ThemHoaDon"; //// create a new parameter DbParameter param = command.CreateParameter(); param.ParameterName = "@MaHoaDon"; param.Value = maHoaDon.ToString(); param.DbType = DbType.String; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@MaLichBan"; param.Value = maLichBan; param.DbType = DbType.Int32; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@NgayLapHoaDon"; param.Value = ngayLapHoaDon; param.DbType = DbType.DateTime; command.Parameters.Add(param); DataAccessCode.ExecuteNonQuery(command); return(maHoaDon); }
private void button1_Click(object sender, EventArgs e) { RestaurantConfiguration.command = DataAccessCode.CreateCommand(); if (isDirtyRead) { RestaurantConfiguration.command.CommandText = "dbo.T1DirtyRead"; } else { RestaurantConfiguration.command.CommandText = "dbo.T1ResolvedDirtyRead"; } DataTable dt = DataAccessCode.ExecuteSelectCommand(RestaurantConfiguration.command); List <ThongTinNhanVienDTO> list = new List <ThongTinNhanVienDTO>(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { ThongTinNhanVienDTO thongTinNhanVien = new ThongTinNhanVienDTO(); thongTinNhanVien.MaNhanVien = Int32.Parse(dt.Rows[i]["MaNhanVien"].ToString()); //thongTinNhanVien.MaNhaHang = Int32.Parse(dt.Rows[i]["MaNhaHang"].ToString()); list.Add(thongTinNhanVien); } } dgvData.DataSource = list; }
public static void CapNhatChiTietHoaDon(Guid maHoaDon, int maChiTietThucDon, decimal donGia, int soLuong, bool isPhantom, bool isDirtyRead, bool isLostUpdate) { DbCommand command = DataAccessCode.CreateCommand(); DbParameter param; if (isDirtyRead) { command.CommandText = "dbo.CapNhatChiTietHoaDonDirtyRead"; } else if (isPhantom) { command.CommandText = "dbo.CapNhatChiTietHoaDonPhanTom"; } else if (isLostUpdate) { if (GlobalVariables.bLostUpdate) { command.CommandText = "dbo.CapNhatChiTietHoaDonLostUpdate"; } else { command.CommandText = "dbo.CapNhatChiTietHoaDonSolveLostUpdate"; param = command.CreateParameter(); param.ParameterName = "@MucCoLap"; param.Value = GlobalVariables.mucCoLap; param.DbType = DbType.Int32; command.Parameters.Add(param); } } else { command.CommandText = "dbo.CapNhatChiTietHoaDon"; } //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@MaHoaDon"; param.Value = maHoaDon.ToString(); param.DbType = DbType.String; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@MaChiTietThucDon"; param.Value = maChiTietThucDon; param.DbType = DbType.Int32; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@DonGia"; param.Value = donGia; param.DbType = DbType.Decimal; command.Parameters.Add(param); //// create a new parameter param = command.CreateParameter(); param.ParameterName = "@SoLuong"; param.Value = soLuong; param.DbType = DbType.Int32; command.Parameters.Add(param); DataAccessCode.ExecuteNonQuery(command); }
private void button2_Click(object sender, EventArgs e) { RestaurantConfiguration.command = DataAccessCode.CreateCommand(); RestaurantConfiguration.command.CommandText = "dbo.T2"; //DataAccessCode.ExecuteNonQuery(); //command = DataAccessCode.CreateCommand(); //command.CommandText = "dbo.T2"; //DataAccessCode.ExecuteNonQuery(); }
public static ArrayList timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung(string ten, int tinhTrangGiaoDich, int maNhaHang) { DbCommand command = DataAccessCode.CreateCommand(); //command.CommandText = "dbo.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung"; //phantom read //command.CommandText = "dbo.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung"; //dirty //command.CommandText = "dbo.DirtyReadSolvedT1TimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichNgungGiaoDich"; //unrepeat command.CommandText = "dbo.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung"; DbParameter param = command.CreateParameter(); param.ParameterName = "@ten"; param.Value = ten; param.DbType = DbType.String; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@tinhTrangGiaoDich"; param.Value = tinhTrangGiaoDich; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@maNhaHang"; param.Value = maNhaHang; param.DbType = DbType.Int32; command.Parameters.Add(param); DataTable dt = DataAccessCode.ExecuteSelectCommand(command); ArrayList list = new ArrayList(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { NhaCungCapDTO dto = new NhaCungCapDTO(); dto.MaNhaCungCap = Convert.ToInt32(dt.Rows[i]["MaNhaCungCap"]); dto.TenNhaCungCap = dt.Rows[i]["TenNhaCungCap"].ToString(); dto.DienThoai = dt.Rows[i]["DienThoai"].ToString(); dto.SoTaiKhoan = dt.Rows[i]["SoTaiKhoan"].ToString(); if (dt.Rows[i]["TongNo"].ToString() != "") { dto.TongNo = Convert.ToDecimal(dt.Rows[i]["TongNo"]); } list.Add(dto); } } return(list); }
public static bool DoiMatKhau(string userName, string pass) { DbCommand command = DataAccessCode.CreateCommand(); string sql = "UPDATE NguoiDung SET MatKhau = '" + pass + "' WHERE TenDangNhap = '" + userName + "' "; System.Windows.Forms.MessageBox.Show(sql); if (DataAccessCode.ExecuteQuery(sql, command)) { return(true); } return(false); }
public static bool ThayDoiTaiKhoan(int maNhanVien, string taiKhoan, string matKhau) { DbCommand command = DataAccessCode.CreateCommand(); string sql = string.Format("UPDATE NGUOIDUNG SET('N{0}','N{1}',N'{2}')", maNhanVien, taiKhoan, matKhau); if (DataAccessCode.ExecuteQuery(sql, command)) { MessageBox.Show("Thay Đổi Một Tài Khoản Thành Công", "Thông Tin", MessageBoxButtons.OK, MessageBoxIcon.Information); return(true); } return(false); }