/// <summary> /// /// </summary> /// <param name="giatri"></param> /// <returns></returns> public int CapNhatDuNoKhachHang(Entities.TruyenGiaTri giatri) { int tra = 0; try { Sql = new Constants.Sql(); string sql = "exec sp_CapNhatDuNoKhachHang @MaKhachHang,@DuNo"; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("MaKhachHang", SqlDbType.VarChar, 20).Value = giatri.Giatritruyen; cmd.Parameters.Add("DuNo", SqlDbType.Float).Value = giatri.Giatrithuhai; tra = cmd.ExecuteNonQuery(); } catch (Exception ex) { string s = ex.Message.ToString(); tra = 0; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return tra; }
//delete public int Delete(Entities.KhoHang kh1) { int tra = 0; try { kh = new Constants.KhoHang(); Entities.KhoHang khohang = new Entities.KhoHang(); Sql = new Constants.Sql(); string sql = Sql.DeleteKhoHang; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(kh.HanhDong, SqlDbType.NVarChar, 20).Value = kh1.HanhDong; cmd.Parameters.Add(kh.KhoHangID, SqlDbType.Int).Value = kh1.KhoHangID; tra = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; } catch (Exception ex) { string s = ex.Message; tra = 0; } return tra; }
public void Delete(Entities.TKNganHang tk1) { try { TKNH = new Constants.TKNganHang(); Entities.TKNganHang TKNganHang = new Entities.TKNganHang(); Sql = new Constants.Sql(); string sql = Sql.DeleteTKNganHang; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(TKNH.HanhDong, SqlDbType.NVarChar, 20).Value = tk1.HanhDong; cmd.Parameters.Add(TKNH.TKNganHangID, SqlDbType.Int).Value = tk1.TKNganHangID; cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; } catch (Exception ex) { string s = ex.Message; } }
public int InsertUpdate(Entities.KMThuChi km1) { try { Kmtc = new Constants.KMThuChi(); Sql = new Constants.Sql(); string sql = Sql.InsertUpdateKMThuChi; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(Kmtc.HanhDong, SqlDbType.NVarChar, 20).Value = km1.HanhDong; cmd.Parameters.Add(Kmtc.ThuChiID, SqlDbType.Int).Value = km1.ThuChiID; cmd.Parameters.Add(Kmtc.MaKhoanMuc, SqlDbType.NVarChar, 20).Value = km1.MaKhoanMuc; cmd.Parameters.Add(Kmtc.TenKhoanMuc, SqlDbType.NVarChar, 200).Value = km1.TenKhoanMuc; cmd.Parameters.Add(Kmtc.LoaiKM, SqlDbType.Bit).Value = km1.LoaiKM; cmd.Parameters.Add(Kmtc.DoiTuong, SqlDbType.NVarChar, 200).Value = km1.DoiTuong; cmd.Parameters.Add(Kmtc.NoTK, SqlDbType.VarChar, 20).Value = km1.NoTK; cmd.Parameters.Add(Kmtc.CoTK, SqlDbType.VarChar, 20).Value = km1.CoTK; cmd.Parameters.Add(Kmtc.GhiChu, SqlDbType.NVarChar, 200).Value = km1.GhiChu; cmd.Parameters.Add(Kmtc.Deleted, SqlDbType.Bit).Value = km1.Deleted; int i = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return i; } catch (Exception ex) { string s = ex.Message; return 0; } }
/// <summary> /// Delete Bảng /// </summary> public int Delete(Entities.NhomKH nkh2) { int Trave = 0; try { nkh = new Constants.NhomKH(); Sql = new Constants.Sql(); string sql = Sql.DeleteNhomKH; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(nkh.HanhDong, SqlDbType.NVarChar, 20).Value = nkh2.Hanhdong.ToString(); cmd.Parameters.Add(nkh.NhomKHID, SqlDbType.Int).Value = nkh2.NhomKHID; Trave = cmd.ExecuteNonQuery(); } catch (Exception ex) { string s = ex.Message.ToString(); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return Trave; }
public int InsertUpdate(Entities.ChiTietPhieuDieuChuyenKho CTPhieuDCK) { try { ctpdck = new Constants.ChiTietPhieuDieuChuyenKho(); Sql = new Constants.Sql(); string sql = Sql.InsertUpdateChiTietPhieuDieuChuyenKho; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(ctpdck.HanhDong, SqlDbType.NVarChar, 20).Value = CTPhieuDCK.HanhDong; cmd.Parameters.Add(ctpdck.MaPhieuDieuChuyenKho, SqlDbType.NVarChar, 20).Value = CTPhieuDCK.MaPhieuDieuChuyenKho; cmd.Parameters.Add(ctpdck.MaHangHoa, SqlDbType.NVarChar, 50).Value = CTPhieuDCK.MaHangHoa; cmd.Parameters.Add(ctpdck.SoLuong, SqlDbType.Int).Value = CTPhieuDCK.SoLuong; cmd.Parameters.Add(ctpdck.GhiChu, SqlDbType.NVarChar, 100).Value = CTPhieuDCK.GhiChu; cmd.Parameters.Add(ctpdck.Deleted, SqlDbType.Bit).Value = CTPhieuDCK.Deleted; int i = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return i; } catch (Exception ex) { string s = ex.Message; return 0; } }
/// <summary> /// /// </summary> /// <param name="gv"></param> /// <returns></returns> public bool Insert(Entities.GiaVonBanHang gv) { bool kt = false; try { string sql = Common.GiaVonBanHang.Insert; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(Common.GiaVonBanHang.MaHoaDon, SqlDbType.VarChar, 50).Value = gv.MaHoaDon; cmd.Parameters.Add(Common.GiaVonBanHang.MaHangHoa, SqlDbType.VarChar, 50).Value = gv.MaHangHoa; cmd.Parameters.Add(Common.GiaVonBanHang.GiaVon, SqlDbType.Float).Value = gv.GiaVon; int i = cmd.ExecuteNonQuery(); if (i == 1) kt = true; else kt = false; cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return kt; } catch (Exception ex) { string s = ex.Message; return false; } }
public void BackUp() { try { string path = duongdanFolder; DirectoryInfo FI = new DirectoryInfo(path); string fileName = "BUSuperMarketDHT" + DateTime.Now.ToString().Replace('/', '-').Replace(" ","_").Replace(":","_"); string sql = "BACKUP DATABASE [SupermarketManagementDHT] TO DISK=N'" + path + @"\" + fileName + "'"; if (!FI.Exists) { FI.Create(); } conn = new Connection(); cmd = new SqlCommand(); cmd.CommandText = sql; cmd.Connection = conn.openConnection(); cmd.ExecuteNonQuery(); } catch { } finally { cmd.Connection.Dispose(); cmd.Connection.Close(); cmd.Dispose(); conn.closeConnection(); } }
//insert update public int InsertUpdate(Entities.CapNhatGia cng1) { cng = new Constants.CapNhatGia(); Sql = new Constants.Sql(); string sql = Sql.InsertUpdateCapNhatGia; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(cng.HanhDong, SqlDbType.NVarChar, 20).Value = cng1.HanhDong; cmd.Parameters.Add(cng.CapNhatGiaID, SqlDbType.Int).Value = cng1.CapNhatGiaID; cmd.Parameters.Add(cng.MaCapNhatGia, SqlDbType.NVarChar, 20).Value = cng1.MaCapNhatGia; cmd.Parameters.Add(cng.NgayBatDau, SqlDbType.DateTime).Value = cng1.NgayBatDau; cmd.Parameters.Add(cng.NgayKetThuc, SqlDbType.DateTime).Value = cng1.NgayKetThuc; cmd.Parameters.Add(cng.MaHangHoa, SqlDbType.NVarChar,20).Value = cng1.MaHangHoa; cmd.Parameters.Add(cng.PhanTramGiaBanBuon, SqlDbType.Float).Value = cng1.PhanTramGiaBanBuon; cmd.Parameters.Add(cng.PhanTramGiaBanLe, SqlDbType.Float).Value = cng1.PhanTramGiaBanLe; cmd.Parameters.Add(cng.GiaNhap, SqlDbType.Float).Value = cng1.GiaNhap; cmd.Parameters.Add(cng.Trangthai, SqlDbType.Bit).Value = cng1.Trangthai; cmd.Parameters.Add(cng.GhiChu, SqlDbType.NVarChar, 100).Value = cng1.GhiChu; cmd.Parameters.Add(cng.Deleted, SqlDbType.Bit).Value = cng1.Deleted; int i = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return i; }
public int InsertUpdate(Entities.PhieuDieuChuyenKhoNoiBo PhieuDCK) { try { pdcknb = new Constants.PhieuDieuChuyenKhoNoiBo(); Sql = new Constants.Sql(); string sql = Sql.InsertUpdatePhieuDieuChuyenKhoNoiBo; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(pdcknb.HanhDong, SqlDbType.NVarChar, 20).Value = PhieuDCK.HanhDong; cmd.Parameters.Add(pdcknb.PhieuDieuChuyenKhoID, SqlDbType.Int).Value = PhieuDCK.PhieuDieuChuyenKhoID; cmd.Parameters.Add(pdcknb.MaPhieuDieuChuyenKho, SqlDbType.NVarChar, 20).Value = PhieuDCK.MaPhieuDieuChuyenKho; cmd.Parameters.Add(pdcknb.NgayDieuChuyen, SqlDbType.DateTime).Value = PhieuDCK.NgayDieuChuyen; cmd.Parameters.Add(pdcknb.TuKho, SqlDbType.VarChar, 20).Value = PhieuDCK.TuKho; cmd.Parameters.Add(pdcknb.DenKho, SqlDbType.VarChar, 20).Value = PhieuDCK.DenKho; cmd.Parameters.Add(pdcknb.MaHoaDonNhap, SqlDbType.VarChar, 20).Value = PhieuDCK.MaHoaDonNhap; cmd.Parameters.Add(pdcknb.XacNhan, SqlDbType.Bit).Value = PhieuDCK.XacNhan; cmd.Parameters.Add(pdcknb.GhiChu, SqlDbType.NVarChar, 100).Value = PhieuDCK.GhiChu; cmd.Parameters.Add(pdcknb.Deleted, SqlDbType.Bit).Value = PhieuDCK.Deleted; int i = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return i; } catch (Exception ex) { string s = ex.Message; return 0; } }
public void BackUp(string duongdan) { try { if (duongdan.Equals("")) { if (!Directory.Exists(duongdanFolder)) { Directory.CreateDirectory(duongdanFolder); } duongdan = duongdanFolder + "\\BUSuperMarketDHT-" + DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year + "_" + DateTime.Now.Hour + "-" + DateTime.Now.Minute + "-" + DateTime.Now.Second + ".bak"; } string sql = "BACKUP DATABASE [SupermarketManagementDHT] TO DISK=N'" + duongdan + "'"; conn = new Connection(); cmd = new SqlCommand(); cmd.CommandText = sql; cmd.Connection = conn.openConnection(); cmd.ExecuteNonQuery(); } catch { } finally { cmd.Connection.Dispose(); cmd.Connection.Close(); cmd.Dispose(); conn.closeConnection(); } }
public int InsertUpdate(Entities.PhongBan pb1) { try { pb = new Constants.PhongBan(); Sql = new Constants.Sql(); string sql = Sql.InsertUpdatePhongBan; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(pb.HanhDong, SqlDbType.NVarChar, 20).Value = pb1.HanhDong; cmd.Parameters.Add(pb.PhongBanID, SqlDbType.Int).Value = pb1.PhongBanID; cmd.Parameters.Add(pb.MaPhongBan, SqlDbType.NVarChar, 20).Value = pb1.MaPhongBan; cmd.Parameters.Add(pb.TenPhongBan, SqlDbType.NVarChar, 200).Value = pb1.TenPhongBan; cmd.Parameters.Add(pb.GhiChu, SqlDbType.NVarChar, 100).Value = pb1.GhiChu; cmd.Parameters.Add(pb.Deleted, SqlDbType.Bit).Value = pb1.Deleted; int i = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return i; } catch (Exception ex) { string s = ex.Message; return 0; } }
/// <summary> /// Insert Update Bảng /// </summary> public bool Insert(Entities.SoDuSoQuy pxh) { try { bool kt = false; pt = new Constants.SoQuy(); Sql = new Constants.Sql(); string sql = Sql.InsertSoDuSoQuy; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(pt.MaSoDuSoQuy, SqlDbType.VarChar, 20).Value = pxh.MaSoDuSoQuy; cmd.Parameters.Add(pt.SoDuDauKy, SqlDbType.Float).Value = pxh.SoDuDauKy; cmd.Parameters.Add(pt.NgayKetChuyen, SqlDbType.DateTime).Value = pxh.NgayKetChuyen; cmd.Parameters.Add(pt.SoDuCuoiKy, SqlDbType.Float).Value = pxh.SoDuCuoiKy; cmd.Parameters.Add(pt.TrangThai, SqlDbType.Bit).Value = pxh.TrangThai; int i = cmd.ExecuteNonQuery(); if (i == 1) kt = true; else kt = false; cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return kt; } catch { return false; } }
//delete public bool Delete(Entities.NhomHang NhomHang) { bool kt = false; try { nhh = new Constants.NhomHangHoa(); Entities.NhomHang nhomhanghoa = new Entities.NhomHang(); Sql = new Constants.Sql(); string sql = Sql.DeleteNhomHangHoa; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(nhh.HanhDong, SqlDbType.NVarChar, 20).Value = NhomHang.HanhDong; cmd.Parameters.Add(nhh.NhomHangID, SqlDbType.Int).Value = NhomHang.NhomHangID; int i = cmd.ExecuteNonQuery(); if (i == 1) kt = true; else kt = false; cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return kt; } catch { return kt; } }
public int InsertUpdate(Entities.QuyDoiDonViTinh nhom) { int rt = 0; try { conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(Common.Constants.Sql.QuyDoiDonViTinh.InsertUpdateQuyDoiDonViTinh, cn); cmd.Parameters.Add(Common.Constants.QuyDoiDonViTinh.HanhDong, SqlDbType.NVarChar).Value = nhom.HanhDong; cmd.Parameters.Add(Common.Constants.QuyDoiDonViTinh.QuyDoiDonViTinhID, SqlDbType.Int).Value = nhom.QuyDoiDonViTinhID; cmd.Parameters.Add(Common.Constants.QuyDoiDonViTinh.MaQuyDoiDonViTinh, SqlDbType.NVarChar, 50).Value = nhom.MaQuyDoiDonViTinh; cmd.Parameters.Add(Common.Constants.QuyDoiDonViTinh.MaHangQuyDoi, SqlDbType.NVarChar, 50).Value = nhom.MaHangQuyDoi; cmd.Parameters.Add(Common.Constants.QuyDoiDonViTinh.TenHangQuyDoi, SqlDbType.NVarChar, 200).Value = nhom.TenHangQuyDoi; cmd.Parameters.Add(Common.Constants.QuyDoiDonViTinh.MaDonViTinh, SqlDbType.NVarChar, 50).Value = nhom.MaDonViTinh; cmd.Parameters.Add(Common.Constants.QuyDoiDonViTinh.SoLuongQuyDoi, SqlDbType.Int).Value = nhom.SoLuongQuyDoi; cmd.Parameters.Add(Common.Constants.QuyDoiDonViTinh.MaHangDuocQuyDoi, SqlDbType.NVarChar, 50).Value = nhom.MaHangDuocQuyDoi; cmd.Parameters.Add(Common.Constants.QuyDoiDonViTinh.TenHangDuocQuyDoi, SqlDbType.NVarChar, 200).Value = nhom.TenHangDuocQuyDoi; cmd.Parameters.Add(Common.Constants.QuyDoiDonViTinh.MaDonViTinhDuocQuyDoi, SqlDbType.NVarChar, 50).Value = nhom.MaDonViTinhDuocQuyDoi; cmd.Parameters.Add(Common.Constants.QuyDoiDonViTinh.SoLuongDuocQuyDoi, SqlDbType.Int).Value = nhom.SoLuongDuocQuyDoi; cmd.Parameters.Add(Common.Constants.QuyDoiDonViTinh.Deleted, SqlDbType.Bit).Value = nhom.Deleted; rt = cmd.ExecuteNonQuery(); } catch (Exception ex) { string s = ex.Message.ToString(); rt = 0; } return rt; }
/// <summary> /// Insert /// </summary> /// <param name="item"></param> /// <returns></returns> public int Insert(Entities.KhuyenMaiSoLuong item) { int rt = 0; try { conn = new Connection(); SqlConnection cn = conn.openConnection(); string sql = "exec sp_InsertKMSL @Id,@MaHangHoa,@TenHangHoa,@NgayBatDau,@NgayKetThuc,@SoLuong,@GiaBanBuon,@GiaBanLe"; SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("Id", SqlDbType.Int).Value = 0; cmd.Parameters.Add("MaHangHoa", SqlDbType.VarChar, 50).Value = item.MaHangHoa; cmd.Parameters.Add("TenHangHoa", SqlDbType.NVarChar, 200).Value = item.TenHangHoa; cmd.Parameters.Add("NgayBatDau", SqlDbType.DateTime).Value = item.NgayBatDau; cmd.Parameters.Add("NgayKetThuc", SqlDbType.DateTime).Value = item.NgayKetThuc; cmd.Parameters.Add("SoLuong", SqlDbType.Float).Value = item.SoLuong; cmd.Parameters.Add("GiaBanBuon", SqlDbType.Float).Value = item.GiaBanBuon; cmd.Parameters.Add("GiaBanLe", SqlDbType.Float).Value = item.GiaBanLe; rt = cmd.ExecuteNonQuery(); } catch { rt = 0; } return rt; }
/// <summary> /// Deleted Update Bảng /// </summary> public bool Delete(Entities.ChiTietXuatHuy ctxh1) { try { bool kt = false; ctxh = new Constants.ChiTietXuatHuy(); Sql = new Constants.Sql(); string sql = Sql.DeleteChiTietXuatHuy; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(ctxh.HanhDong, SqlDbType.VarChar, 20).Value = ctxh1.HanhDong; cmd.Parameters.Add(ctxh.MaPhieuXuatHuy, SqlDbType.VarChar, 20).Value = ctxh1.MaPhieuXuatHuy; cmd.Parameters.Add(ctxh.MaHangHoa, SqlDbType.VarChar, 50).Value = ctxh1.MaHangHoa; int i = cmd.ExecuteNonQuery(); if (i == 1) kt = true; else kt = false; cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return kt; } catch (Exception ex) { string s = ex.Message; return false; } }
/// <summary> /// Delete Bảng /// </summary> public bool Delete(Entities.SoDuCongNo pxh) { try { bool kt = false; pt = new Constants.CongNo(); Sql = new Constants.Sql(); string sql = Sql.DeleteSoDuCongNo; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(pt.MaSoDuCongNo, SqlDbType.VarChar, 20).Value = pxh.MaSoDuCongNo; int i = cmd.ExecuteNonQuery(); if (i == 1) kt = true; else kt = false; cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return kt; } catch { return false; } }
public bool Delete(string maHDBanHang) { try { bool kt = false; hdbh = new Constants.HDBanHang(); Sql = new Constants.Sql(); string sql = Sql.DeleteHDBanHang; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("@maHDBanHang", SqlDbType.VarChar, 20).Value = maHDBanHang; int i = cmd.ExecuteNonQuery(); if (i == 1) kt = true; else kt = false; cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return kt; } catch (Exception ex) { string s = ex.Message; return false; } }
//==============Insert======================== public int InsertTyLeTinh(Entities.TyLeTinh input) { int bg = 0; try { con = new Connection(); cn = con.openConnection(); cmd = new SqlCommand("exec sp_TyLeTinh @ThaoTac,@MaTyLeTinh,@SoTien,@NgayNhap,@GhiChu,@Deleted", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "insert"; //set cmd.Parameters.Add("MaTyLeTinh", SqlDbType.VarChar).Value = input.MaTyLeTinh; cmd.Parameters.Add("SoTien", SqlDbType.Float).Value = input.SoTien; cmd.Parameters.Add("NgayNhap", SqlDbType.DateTime).Value = input.NgayNhap; cmd.Parameters.Add("GhiChu", SqlDbType.NVarChar).Value = input.GhiChu; cmd.Parameters.Add("Deleted", SqlDbType.Bit).Value = input.Deleted; bg = cmd.ExecuteNonQuery(); } catch (Exception) { bg = 0; } finally { cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); } if (bg == 0) return bg; return bg; }
/// <summary> /// /// </summary> /// <param name="gv"></param> /// <returns></returns> public Entities.GiaVonBanHang[] Select(Entities.GiaVonBanHang gv) { string sql = Common.GiaVonBanHang.Select; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(Common.GiaVonBanHang.HanhDong, SqlDbType.VarChar, 50).Value = gv.HanhDong; cmd.Parameters.Add(Common.GiaVonBanHang.MaHoaDon, SqlDbType.VarChar, 50).Value = gv.MaHoaDon; cmd.Parameters.Add(Common.GiaVonBanHang.MaHangHoa, SqlDbType.VarChar, 50).Value = gv.MaHangHoa; SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //Insert Category into ArrayList List<Entities.GiaVonBanHang> arr = new List<Entities.GiaVonBanHang>(); while (dr.Read()) { Entities.GiaVonBanHang item = new Entities.GiaVonBanHang(); //item.HanhDong = dr[Common.GiaVonBanHang.HanhDong].ToString(); item.MaHoaDon = dr[Common.GiaVonBanHang.MaHoaDon].ToString(); item.MaHangHoa = dr[Common.GiaVonBanHang.MaHangHoa].ToString(); item.GiaVon = double.Parse(dr[Common.GiaVonBanHang.GiaVon].ToString()); arr.Add(item); } int n = arr.Count; if (n == 0) return null; //Giai phong bo nho cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return arr.ToArray(); }
public int Delete(Entities.TheGiamGia pb1) { try { pb = new Constants.TheGiamGia(); Sql = new Constants.Sql(); string sql = Sql.DeleteTheGiamGia; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(pb.MaTheGiamGia, SqlDbType.VarChar, 50).Value = pb1.MaTheGiamGia; int i = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return i; } catch (Exception ex) { string s = ex.Message; return 0; } }
public int InsertUpdate(Entities.TienTe tt1) { try { tt = new Constants.TienTe(); Sql = new Constants.Sql(); string sql = Sql.InsertUpdateTienTe; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(tt.HanhDong, SqlDbType.NVarChar, 20).Value = tt1.HanhDong; cmd.Parameters.Add(tt.TienteID, SqlDbType.Int).Value = tt1.TienteID; cmd.Parameters.Add(tt.MaTienTe, SqlDbType.NVarChar, 20).Value = tt1.MaTienTe; cmd.Parameters.Add(tt.TenTienTe, SqlDbType.NVarChar, 200).Value = tt1.TenTienTe; cmd.Parameters.Add(tt.TenTienTeChan, SqlDbType.NVarChar, 200).Value = tt1.TenTienTeChan; cmd.Parameters.Add(tt.TenTienTeLe, SqlDbType.NVarChar, 200).Value = tt1.TenTienTeLe; cmd.Parameters.Add(tt.BieuTuong, SqlDbType.NVarChar, 20).Value = tt1.BieuTuong; cmd.Parameters.Add(tt.DonViLamTron, SqlDbType.Int).Value = tt1.DonViLamTron; cmd.Parameters.Add(tt.GhiChu, SqlDbType.NVarChar, 100).Value = tt1.GhiChu; cmd.Parameters.Add(tt.Deleted, SqlDbType.Bit).Value = tt1.Deleted; int i = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return i; } catch (Exception ex) { string s = ex.Message; return 0; } }
public int Insert(Entities.TheGiamGia pb1) { try { pb = new Constants.TheGiamGia(); Sql = new Constants.Sql(); string sql = Sql.InsertTheGiamGia; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(pb.HanhDong, SqlDbType.NVarChar, 50).Value = pb1.HanhDong; cmd.Parameters.Add(pb.MaTheGiamGia, SqlDbType.VarChar, 50).Value = pb1.MaTheGiamGia; cmd.Parameters.Add(pb.MaKhachHang, SqlDbType.VarChar, 50).Value = pb1.MaKhachHang; cmd.Parameters.Add(pb.GiaTriThe, SqlDbType.Float).Value = pb1.GiaTriThe; cmd.Parameters.Add(pb.NgayBatDau, SqlDbType.DateTime).Value = pb1.NgayBatDau; cmd.Parameters.Add(pb.NgayKetThuc, SqlDbType.DateTime).Value = pb1.NgayKetThuc; cmd.Parameters.Add(pb.Deleted, SqlDbType.Bit).Value = pb1.Deleted; int i = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return i; } catch (Exception ex) { string s = ex.Message; return 0; } }
/// <summary> /// Delete Bảng /// </summary> public bool Delete(Entities.PhieuTTCuaKH pttckh) { try { bool kt = false; pt = new Constants.PhieuTTCuaKH(); Sql = new Constants.Sql(); string sql = Sql.DeletePhieuTTCuaKH; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(pt.HanhDong, SqlDbType.NVarChar, 20).Value = pttckh.HanhDong; cmd.Parameters.Add(pt.PhieuTTCuaKHID, SqlDbType.Int).Value = pttckh.PhieuTTCuaKHID; int i = cmd.ExecuteNonQuery(); if (i == 1) kt = true; else kt = false; cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return kt; } catch { return false; } }
public bool deleteTaiKhoan(Entities.TaiKhoan tk1) { try { bool kt = false; tk = new Constants.TaiKhoan(); Sql = new Constants.Sql(); string sql = Sql.deleteTaiKhoan; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(tk.TenDangNhap, SqlDbType.VarChar, 200).Value = tk1.TenDangNhap; int i = cmd.ExecuteNonQuery(); if (i >= 0) kt = true; else kt = false; cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return kt; } catch (Exception ex) { string s = ex.Message; return false; } }
/// <summary> /// lay bang cong ty /// </summary> /// <param name="ct"></param> /// <returns></returns> public Entities.ThongTinCongTy sp_ThongTinCongTy(Entities.TruyenGiaTri ct) { Entities.ThongTinCongTy banghi = new Entities.ThongTinCongTy(); try { string sql = "exec sp_ThongTinCongTy @MaCongTy"; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("MaCongTy", SqlDbType.VarChar, 20).Value = ct.Giatritruyen; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ArrayList arr = new ArrayList(); while (dr.Read()) { banghi.MaCongTy = dr[0].ToString(); banghi.TenCongTy = dr[1].ToString(); banghi.DiaChi = dr[2].ToString(); banghi.SoDienThoai = dr[3].ToString(); banghi.Email = dr[4].ToString(); banghi.Website = dr[5].ToString(); banghi.Fax = dr[6].ToString(); } } catch (Exception ex) { string s = ex.Message.ToString(); banghi = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return banghi; }
//insert update public int InsertUpdate(Entities.LoaiHangHoa lhh1) { try { lhh = new Constants.LoaiHangHoa(); Sql = new Constants.Sql(); string sql = Sql.InsertUpdateLoaiHangHoa; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(lhh.HanhDong, SqlDbType.NVarChar, 20).Value = lhh1.HanhDong; cmd.Parameters.Add(lhh.LoaiHangID, SqlDbType.Int).Value = lhh1.LoaiHangID; cmd.Parameters.Add(lhh.MaLoaiHang, SqlDbType.NVarChar, 20).Value = lhh1.MaLoaiHang; cmd.Parameters.Add(lhh.TenLoaiHang, SqlDbType.NVarChar, 200).Value = lhh1.TenLoaiHang; cmd.Parameters.Add(lhh.GhiChu, SqlDbType.NVarChar, 250).Value = lhh1.GhiChu; cmd.Parameters.Add(lhh.Deleted, SqlDbType.Bit).Value = lhh1.Deleted; int i = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return i; } catch(Exception ex) { return 0; } }
public int InsertUpdate(Entities.TKNganHang tk1) { TKNH = new Constants.TKNganHang(); Sql = new Constants.Sql(); string sql = Sql.InsertUpdateTKNganHang; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(TKNH.HanhDong, SqlDbType.NVarChar, 20).Value = tk1.HanhDong; cmd.Parameters.Add(TKNH.TKNganHangID, SqlDbType.Int).Value = tk1.TKNganHangID; cmd.Parameters.Add(TKNH.MaTKNganHang, SqlDbType.NVarChar, 20).Value = tk1.MaTKNganHang; cmd.Parameters.Add(TKNH.SoTK, SqlDbType.NVarChar, 20).Value = tk1.SoTK; cmd.Parameters.Add(TKNH.MaTienTe, SqlDbType.NVarChar, 200).Value = tk1.MaTienTe; cmd.Parameters.Add(TKNH.SoDu, SqlDbType.Int).Value = tk1.SoDu; cmd.Parameters.Add(TKNH.SoSecKeTiep, SqlDbType.NVarChar, 20).Value = tk1.SoSecKeTiep; cmd.Parameters.Add(TKNH.NguoiLienHe, SqlDbType.NVarChar, 200).Value = tk1.NguoiLienHe; cmd.Parameters.Add(TKNH.DiaChi, SqlDbType.NVarChar, 200).Value = tk1.DiaChi; cmd.Parameters.Add(TKNH.DienThoai, SqlDbType.NVarChar, 20).Value = tk1.DienThoai; cmd.Parameters.Add(TKNH.Email, SqlDbType.NVarChar, 20).Value = tk1.Email; cmd.Parameters.Add(TKNH.Website, SqlDbType.NVarChar, 20).Value = tk1.Website; cmd.Parameters.Add(TKNH.GhiChu, SqlDbType.NVarChar, 200).Value = tk1.Ghichu; cmd.Parameters.Add(TKNH.Laisuat, SqlDbType.Float).Value = tk1.Laisuat; cmd.Parameters.Add(TKNH.Deleted, SqlDbType.Bit).Value = tk1.Deleted; int i = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return i; }
public int InsertUpdate(Entities.GoiHang nhom) { int rt = 0; try { conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(Common.Constants.Sql.GoiHang.InsertUpdateGoiHang, cn); cmd.Parameters.Add(Common.Constants.GoiHang.HanhDong, SqlDbType.NVarChar).Value = nhom.HanhDong; cmd.Parameters.Add(Common.Constants.GoiHang.GoiHangID, SqlDbType.Int).Value = nhom.GoiHangID; cmd.Parameters.Add(Common.Constants.GoiHang.MaKho, SqlDbType.VarChar, 20).Value = nhom.MaKho.ToUpper(); cmd.Parameters.Add(Common.Constants.GoiHang.MaGoiHang, SqlDbType.VarChar, 50).Value = nhom.MaGoiHang.ToUpper(); cmd.Parameters.Add(Common.Constants.GoiHang.TenGoiHang, SqlDbType.NVarChar, 200).Value = nhom.TenGoiHang; cmd.Parameters.Add(Common.Constants.GoiHang.MaNhomHang, SqlDbType.VarChar, 50).Value = nhom.MaNhomHang; cmd.Parameters.Add(Common.Constants.GoiHang.TenNhomHang, SqlDbType.NVarChar, 200).Value = nhom.TenNhomHang; cmd.Parameters.Add(Common.Constants.GoiHang.GiaNhap, SqlDbType.Float).Value = nhom.GiaNhap; cmd.Parameters.Add(Common.Constants.GoiHang.GiaBanBuon, SqlDbType.Float).Value = nhom.GiaBanBuon; cmd.Parameters.Add(Common.Constants.GoiHang.GiaBanLe, SqlDbType.Float).Value = nhom.GiaBanLe; cmd.Parameters.Add(Common.Constants.GoiHang.Deleted, SqlDbType.Bit).Value = nhom.Deleted; rt = cmd.ExecuteNonQuery(); } catch (Exception ex) { string s = ex.Message.ToString(); rt = 0; } return rt; }