public int Add(DTO_Employee emp) { List <SqlParameter> paras = new List <SqlParameter>(); //string sql = " INSERT INTO NhanVien( MaNV, HoNV, TenNV, GioiTinh, SDT, NgaySinh, DiaChiThuongTru, ChucVu)" + // " VALUES (@MaNV, @HoNV, @TenNV, @GioiTinh, @SDT, @NgaySinh, @DiaChiThuongTru, @ChucVu)"; paras.Add(new SqlParameter("@MaNV", emp.MaNV)); paras.Add(new SqlParameter("@HoNV", emp.HoNV)); paras.Add(new SqlParameter("@TenNV", emp.TenNV)); paras.Add(new SqlParameter("@GioiTinh", emp.GioiTinh)); paras.Add(new SqlParameter("@SDT", emp.SDT)); paras.Add(new SqlParameter("@NgaySinh", emp.NgaySinh)); paras.Add(new SqlParameter("@CMND", emp.CMND)); paras.Add(new SqlParameter("@DiaChiThuongTru", emp.DiaChiThuongTru)); paras.Add(new SqlParameter("@ChucVu", emp.ChucVu)); try { return(dp.ExcuteNonQuery("sp_ThemNhanVien", System.Data.CommandType.StoredProcedure, paras)); } catch (SqlException ex) { throw ex; } }
//van de nam o dayyyy !!!!! //public static List<DTO.Bill_DTO> GetListBill(int id) //{ // string stringquery = "select * from BILL where id_Room =" + id + "and payment_Status = 0 "; // DataTable dt = DataProvider.ExcuteQuery(stringquery, con); // List<DTO.Bill_DTO> listBill = new List<DTO.Bill_DTO>(); // for (int i = 0; i < dt.Rows.Count; i++) // { // DTO.Bill_DTO b = new DTO.Bill_DTO(); // b.Id = int.Parse(dt.Rows[i]["id_Bill"].ToString()); // b.TimeIn = (DateTime)dt.Rows[i]["time_In"]); // b.TimeOut = (DateTime)dt.Rows[i]["time_Out"]; // b.PaymentStatus = int.Parse(dt.Rows[i]["payment_Status"].ToString()); // listBill.Add(b); //} // return listBill; public static void AddBill(int idRoom) { string stringquery = "EXEC Proc_addBill " + idRoom; con = DataProvider.OpenConnection(); DataProvider.ExcuteNonQuery(stringquery, con); }
/// <summary> /// Sửa khách hàng /// </summary> /// <param name="soTKLK"></param> /// <param name="hoTen"></param> /// <param name="ngaySinh"></param> /// <param name="noiCap"></param> /// <param name="soCMNN"></param> /// <param name="ngayCap"></param> /// <param name="email"></param> /// <param name="gioiTinh"></param> /// <param name="hanMucVay"></param> /// <param name="diaChi"></param> /// <param name="SDT"></param> /// <param name="maRo"></param> /// <returns></returns> public static bool suaThongTinKH(string soTKLK, string hoTen, DateTime ngaySinh, string noiCap, string soCMNN, DateTime ngayCap, string email, string gioiTinh, int hanMucVay, string diaChi, string SDT, string maRo) { try { OracleCommand oracleCommand = new OracleCommand(); oracleCommand.CommandText = "UPDATE KHACH_HANG SET HO_TEN = :hoTen, NGAY_SINH = :ngaySinh," + " SO_CMND = :soCMNN, NGAY_CAP = :ngayCap, NOI_CAP = :noiCap," + " GIOI_TINH = :gioiTinh, DIA_CHI = :diaChi, SDT = :SDT, EMAIL = :email," + " HAN_MUC_VAY = :hanMucVay ,MA_RO = :maRo WHERE SO_TKLK = :soTKLK"; oracleCommand.Parameters.Add(new OracleParameter("hoTen", hoTen)); oracleCommand.Parameters.Add(new OracleParameter("ngaySinh", ngaySinh)); oracleCommand.Parameters.Add(new OracleParameter("soCMNN", soCMNN)); oracleCommand.Parameters.Add(new OracleParameter("ngayCap", ngayCap)); oracleCommand.Parameters.Add(new OracleParameter("noiCap", noiCap)); oracleCommand.Parameters.Add(new OracleParameter("gioiTinh", gioiTinh)); oracleCommand.Parameters.Add(new OracleParameter("diaChi", diaChi)); oracleCommand.Parameters.Add(new OracleParameter("SDT", SDT)); oracleCommand.Parameters.Add(new OracleParameter("email", email)); oracleCommand.Parameters.Add(new OracleParameter("hanMucVay", hanMucVay)); oracleCommand.Parameters.Add(new OracleParameter("maRo", maRo)); oracleCommand.Parameters.Add(new OracleParameter("soTKLK", soTKLK)); return(DataProvider.ExcuteNonQuery(oracleCommand)); } catch (Exception e) { MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
/// <summary> /// Thêm khách hàng /// </summary> /// <param name="khachHang"></param> /// <returns></returns> public static bool ThemKH(QLyKHDTO khachHang) { try { OracleCommand oracleCommand = new OracleCommand(); oracleCommand.CommandText = "INSERT INTO KHACH_HANG (SO_TKLK, HO_TEN, NGAY_SINH, SO_CMND, NGAY_CAP, NOI_CAP, GIOI_TINH, DIA_CHI, NGAY_MO_TK, SDT, EMAIL, HAN_MUC_VAY, MA_RO, SO_TIEN_MAT, SO_DU_NO) " + "VALUES (:soTKLK, :hotenKH, :ngaysinh, :soCMND, :ngayCap, :noiCap, :gioiTinh, :diaChi, :ngayMoTK, :sdt, :email, :hanMucVay, :maRo, :soTienMat, :soDuNo)"; oracleCommand.Parameters.Add("soTKLK", khachHang.STKLK); oracleCommand.Parameters.Add("hotenKH", khachHang.hoTenKH); oracleCommand.Parameters.Add("ngaysinh", khachHang.ngaySinhKH); oracleCommand.Parameters.Add("soCMND", khachHang.soCMNNKH); oracleCommand.Parameters.Add("ngayCap", khachHang.NgayCap); oracleCommand.Parameters.Add("noiCap", khachHang.NoiCap); oracleCommand.Parameters.Add("gioiTinh", khachHang.gioiTinhKH); oracleCommand.Parameters.Add("diaChi", khachHang.diaChiKH); oracleCommand.Parameters.Add("ngayMoTK", khachHang.ngayMoTKKH); oracleCommand.Parameters.Add("sdt", khachHang.SDTKH); oracleCommand.Parameters.Add("email", khachHang.emailKH); oracleCommand.Parameters.Add("hanMucVay", khachHang.HanMucVay); oracleCommand.Parameters.Add("maRo", khachHang.MaRo); oracleCommand.Parameters.Add("soTienMat", khachHang.SoTienMat); oracleCommand.Parameters.Add("soDuNo", khachHang.SoDuNo); return(DataProvider.ExcuteNonQuery(oracleCommand)); } catch (Exception e) { MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
public static void AddBillInfo(int idBill, int idMenu, int count) { string stringquery = "Proc_addBillInfo " + idBill + ", " + idMenu + ", " + count; con = DataProvider.OpenConnection(); //MessageBox.Show(stringquery.ToString()); DataProvider.ExcuteNonQuery(stringquery, con); }
public static bool Restore(string path) { string query = "Use master Restore Database KARAOKE_MANAGER from disk = N'" + path + "'"; con = DataProvider.OpenConnection(); bool kq = DataProvider.ExcuteNonQuery(query, con); return(kq); }
public static bool DeleteUser(User_DTO u) { string query = string.Format(@"delete from USER_ACCOUNT where id_User= " + u.Id); con = DataProvider.OpenConnection(); bool kq = DataProvider.ExcuteNonQuery(query, con); //DataProvider.DongKetNoi(con); return(kq); }
public static bool AddUser(User_DTO u) { string query = string.Format(@"insert into USER_ACCOUNT values(N'{0}',N'{1}',N'{2}',N'{3}')", u.Username, "202cb962ac59075b964b07152d234b70", u.NameUser, u.Permission); con = DataProvider.OpenConnection(); bool kq = DataProvider.ExcuteNonQuery(query, con); //DataProvider.DongKetNoi(con); return(kq); }
public static bool ChangePassword(string passWord, int id) { string query = string.Format(@"update USER_ACCOUNT set password = '******' where id_User =" + id); con = DataProvider.OpenConnection(); bool kq = DataProvider.ExcuteNonQuery(query, con); //DataProvider.DongKetNoi(con); return(kq); }
public static bool AddMenu(Menu_DTO m) { string query = string.Format(@"insert into MENU values(N'{0}', {1}, {2},{3},{4})", m.Name, m.Kind, m.Original_price, m.Sale_price, m.Amout); con = DataProvider.OpenConnection(); bool kq = DataProvider.ExcuteNonQuery(query, con); //DataProvider.DongKetNoi(con); return(kq); }
public static bool DeleteMenu(int id) { string query = string.Format(@"delete from MENU where Id_nenu= " + id); con = DataProvider.OpenConnection(); bool kq = DataProvider.ExcuteNonQuery(query, con); //DataProvider.DongKetNoi(con); return(kq); }
public static bool ImportGoods(int count, int id) { string query = string.Format(@"update MENU set amout = amout + " + count + " where Id_nenu =" + id); con = DataProvider.OpenConnection(); bool kq = DataProvider.ExcuteNonQuery(query, con); //DataProvider.DongKetNoi(con); return(kq); }
public static bool EditMenu(Menu_DTO m) { string query = string.Format(@"update MENU set name=N'{0}',id_Kind={1},unit_Price={2}, sale_Price = {3} ,amout={4}, where Id_nenu={5}", m.Name, m.Kind, m.Original_price, m.Sale_price, m.Amout, m.Id); con = DataProvider.OpenConnection(); bool kq = DataProvider.ExcuteNonQuery(query, con); //DataProvider.DongKetNoi(con); return(kq); }
// Xóa nhân viên public static bool DeleteRoom(int id) { string query = string.Format(@"delete from ROOM where id_Room= " + id); con = DataProvider.OpenConnection(); bool kq = DataProvider.ExcuteNonQuery(query, con); //DataProvider.DongKetNoi(con); return(kq); }
public static bool EditRoom(RoomDTO r) { string query = string.Format(@"update ROOM set name=N'{0}',status={1},kind_Of_Room={2},price={3} where id_Room={4}", r.Name, r.Status, r.Kind_Of_Room, r.Price, r.IdRoom); con = DataProvider.OpenConnection(); bool kq = DataProvider.ExcuteNonQuery(query, con); //DataProvider.DongKetNoi(con); return(kq); }
public static bool AddRoom(RoomDTO r) { string query = string.Format(@"insert into ROOM values(N'{0}',N'{1}',N'{2}',N'{3}')", r.Name, r.Status, r.Kind_Of_Room, r.Price); con = DataProvider.OpenConnection(); bool kq = DataProvider.ExcuteNonQuery(query, con); //DataProvider.DongKetNoi(con); return(kq); }
/// <summary> /// Mua chung khoan /// </summary> /// <param name="soTKLK"></param> /// <param name="maCK"></param> /// <param name="sl"></param> /// <returns></returns> public static bool ThemMuaCK(string soTKLK, string maCK, long sl, long slBD, long duNoBD, long gtMua, long tienMat) { try { long soDu = duNoBD; if (gtMua > tienMat) { soDu = gtMua - tienMat; tienMat = 0; } else { tienMat -= gtMua; } long tongSo = sl + slBD; OracleCommand oracleCommand = new OracleCommand(); oracleCommand.CommandText = "UPDATE KHACHHANG_CHUNGKHOAN SET SO_LUONG = :sl WHERE SO_TKLK = :soTKLK AND MA_CK = :maCK"; oracleCommand.Parameters.Add("sl", tongSo); oracleCommand.Parameters.Add("soTKLK", soTKLK); oracleCommand.Parameters.Add("maCK", maCK); DataProvider.ExcuteNonQuery(oracleCommand); if (!ktTonTaiMaCK(soTKLK, maCK)) { oracleCommand.Parameters.Clear(); oracleCommand.CommandText = "INSERT INTO KHACHHANG_CHUNGKHOAN (SO_TKLK, MA_CK, SO_LUONG) VALUES (:sO_TKLK, :mA_CK, :sO_LUONG)"; oracleCommand.Parameters.Add("sO_TKLK", soTKLK); oracleCommand.Parameters.Add("mA_CK", maCK); oracleCommand.Parameters.Add("sO_LUONG", sl); DataProvider.ExcuteNonQuery(oracleCommand); } oracleCommand.Parameters.Clear(); oracleCommand.CommandText = "UPDATE KHACH_HANG SET SO_DU_NO = :soDuNo, SO_TIEN_MAT = :tM WHERE SO_TKLK = :soTKLK"; oracleCommand.Parameters.Add("soDuNo", soDu); oracleCommand.Parameters.Add("tM", tienMat); oracleCommand.Parameters.Add("soTKLK", soTKLK); DataProvider.ExcuteNonQuery(oracleCommand); return(true); } catch (Exception e) { MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
public static bool Backup(string path) { string nameOfFile = @"\KaraokeManager (" + DateTime.Now.Day.ToString() + "_" + DateTime.Now.Month.ToString() + "_" + DateTime.Now.Year.ToString() + "_" + DateTime.Now.Hour.ToString() + "_" + DateTime.Now.Minute.ToString() + ").bak"; string query = "BACKUP DATABASE KARAOKE_MANAGER TO DISK = N'" + path + nameOfFile + "'"; con = DataProvider.OpenConnection(); bool kq = DataProvider.ExcuteNonQuery(query, con); return(kq); }
public int AddCustomer(DTO_Customer emp) { List <SqlParameter> paras = new List <SqlParameter>(); //string sql = " INSERT INTO KhachHang( MaKH, HoKH, TenKH, GioiTinh, SDT, NgaySinh, DiaChiThuongTru, Email)" + // " VALUES (@MaKH, @HoKH, @TenKH, @GioiTinh, @SDT, @NgaySinh, @DiaChiThuongTru, @Email)"; paras.Add(new SqlParameter("@MaKH", emp.MaKH)); paras.Add(new SqlParameter("@HoKH", emp.HoKH)); paras.Add(new SqlParameter("@TenKH", emp.TenKH)); paras.Add(new SqlParameter("@GioiTinh", emp.GioiTinh)); paras.Add(new SqlParameter("@SDT", emp.SDT)); paras.Add(new SqlParameter("@NgaySinh", emp.NgaySinh)); paras.Add(new SqlParameter("@DiaChiThuongTru", emp.DiaChiThuongTru)); paras.Add(new SqlParameter("@Email", emp.Email)); try { return(dp.ExcuteNonQuery("sp_ThemKhachHang", System.Data.CommandType.StoredProcedure, paras)); } catch (SqlException ex) { throw ex; } }
public static bool XoaMaCK(string maRo, string maCK) { try { OracleCommand oracleCommand = new OracleCommand(); oracleCommand.CommandText = "DELETE FROM CHI_TIET_RO WHERE MA_RO = :maRo AND MA_CK = :maCK"; oracleCommand.Parameters.Add("maRo", maRo); oracleCommand.Parameters.Add("maCK", maCK); return(DataProvider.ExcuteNonQuery(oracleCommand)); }catch (Exception e) { MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
public static bool ThemRoCK(RoCK roCK) { try { OracleCommand oracleCommand = new OracleCommand(); oracleCommand.CommandText = "INSERT INTO RO_CK (MA_RO,TEN_RO) VALUES (:maRo,:tenRo)"; oracleCommand.Parameters.Add("maRo", roCK.MaRo); oracleCommand.Parameters.Add("tenRo", roCK.TenRo); return(DataProvider.ExcuteNonQuery(oracleCommand)); } catch (Exception e) { MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
public int Add(DTOCTHoaDon cthd) { List <SqlParameter> paras = new List <SqlParameter>(); paras.Add(new SqlParameter("@m", cthd.MaHD)); paras.Add(new SqlParameter("@ms", cthd.MaSP)); paras.Add(new SqlParameter("@sl", cthd.SoLuong)); paras.Add(new SqlParameter("@dg", cthd.DonGia)); try { return(dp.ExcuteNonQuery("ThemCTHD", System.Data.CommandType.StoredProcedure, paras)); } catch (SqlException ex) { throw ex; } }
public int Add(DTOHoaDon hd) { List <SqlParameter> paras = new List <SqlParameter>(); paras.Add(new SqlParameter("@mh", hd.MaHD)); paras.Add(new SqlParameter("@mk", hd.MaKH)); paras.Add(new SqlParameter("@nx", hd.NgayXuat)); paras.Add(new SqlParameter("@tt", hd.ThanhTien)); paras.Add(new SqlParameter("@mv", hd.MaNV)); try { return(dp.ExcuteNonQuery("ThemHD", System.Data.CommandType.StoredProcedure, paras)); } catch (SqlException ex) { throw ex; } }
public int Add(DTOChiTietThue ctt) { List <SqlParameter> paras = new List <SqlParameter>(); paras.Add(new SqlParameter("@map", ctt.MaP)); paras.Add(new SqlParameter("@makh", ctt.MaKH)); paras.Add(new SqlParameter("@nt", ctt.NgayThue)); paras.Add(new SqlParameter("@ndk", ctt.NgayTraDuKien)); paras.Add(new SqlParameter("@ntr", ctt.NgayTra)); try { return(dp.ExcuteNonQuery("ThemCTT", System.Data.CommandType.StoredProcedure, paras)); } catch (SqlException ex) { throw ex; } }
public static bool rutTien(string soTKLK, long soTienMat, long soTienRut) { try { OracleCommand oracleCommand = new OracleCommand(); long tien = soTienMat - soTienRut; oracleCommand.CommandText = "UPDATE KHACH_HANG SET SO_TIEN_MAT = :tien WHERE SO_TKLK = :soTKLK"; oracleCommand.Parameters.Add(new OracleParameter("tien", tien)); oracleCommand.Parameters.Add(new OracleParameter("soTKLK", soTKLK)); return(DataProvider.ExcuteNonQuery(oracleCommand)); } catch (Exception e) { MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
// Sửa thông tin rổ chứng khoán public static bool suaThongTinroCK(string maRo, string tenRo) { try { OracleCommand oracleCommand = new OracleCommand(); oracleCommand.CommandText = "UPDATE RO_CK SET TEN_RO = :tenRo WHERE MA_RO = :maRo"; oracleCommand.Parameters.Add(new OracleParameter("tenRo", tenRo)); oracleCommand.Parameters.Add(new OracleParameter("maRo", maRo)); return(DataProvider.ExcuteNonQuery(oracleCommand)); } catch (Exception e) { MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
/// <summary> /// Thêm khách hàng /// </summary> /// <param name="khachHang"></param> /// <returns></returns> public static bool ThemKH(QLyKHDTO khachHang) { try { OracleCommand oracleCommand = new OracleCommand(); oracleCommand.CommandText = "INSERT INTO KHACH_HANG (SO_TKLK, HO_TEN, NGAY_SINH, SO_CMND, NGAY_CAP, NOI_CAP, GIOI_TINH, DIA_CHI, NGAY_MO_TK, SDT, EMAIL, HAN_MUC_VAY, MA_RO, SO_TIEN_MAT, SO_DU_NO) " + "VALUES (:soTKLK, :hotenKH, :ngaysinh, :soCMND, :ngayCap, :noiCap, :gioiTinh, :diaChi, :ngayMoTK, :sdt, :email, :hanMucVay, :maRo, :soTienMat, :soDuNo)"; oracleCommand.Parameters.Add("soTKLK", khachHang.STKLK); oracleCommand.Parameters.Add("hotenKH", khachHang.hoTenKH); oracleCommand.Parameters.Add("ngaysinh", khachHang.ngaySinhKH); oracleCommand.Parameters.Add("soCMND", khachHang.soCMNNKH); oracleCommand.Parameters.Add("ngayCap", khachHang.NgayCap); oracleCommand.Parameters.Add("noiCap", khachHang.NoiCap); oracleCommand.Parameters.Add("gioiTinh", khachHang.gioiTinhKH); oracleCommand.Parameters.Add("diaChi", khachHang.diaChiKH); oracleCommand.Parameters.Add("ngayMoTK", khachHang.ngayMoTKKH); oracleCommand.Parameters.Add("sdt", khachHang.SDTKH); oracleCommand.Parameters.Add("email", khachHang.emailKH); oracleCommand.Parameters.Add("hanMucVay", khachHang.HanMucVay); oracleCommand.Parameters.Add("maRo", khachHang.MaRo); oracleCommand.Parameters.Add("soTienMat", khachHang.SoTienMat); oracleCommand.Parameters.Add("soDuNo", khachHang.SoDuNo); DataProvider.ExcuteNonQuery(oracleCommand); // Lấy danh sách mã CK của rổ List <QLRoCKDTO> qLRoCKDTOs = QLRoCKDAO.timKiem(khachHang.MaRo); foreach (QLRoCKDTO temp in qLRoCKDTOs) { oracleCommand.Parameters.Clear(); oracleCommand.CommandText = "INSERT INTO KHACHHANG_CHUNGKHOAN (SO_TKLK, MA_CK, SO_LUONG) VALUES (:sO_TKLK, :mA_CK, '0')"; oracleCommand.Parameters.Add("sO_TKLK", khachHang.STKLK); oracleCommand.Parameters.Add("mA_CK", temp.MaCK); DataProvider.ExcuteNonQuery(oracleCommand); } return(true); } catch (Exception e) { MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
public static bool rutLuuKi(string soTKLK, string maCK, long soLuongCK, long soLuongRut) { try { OracleCommand oracleCommand = new OracleCommand(); long CK = soLuongCK - soLuongRut; oracleCommand.CommandText = "UPDATE KHACHHANG_CHUNGKHOAN SET SO_LUONG = :CK WHERE SO_TKLK = :soTKLK AND MA_CK = :maCK"; oracleCommand.Parameters.Add(new OracleParameter("CK", CK)); oracleCommand.Parameters.Add(new OracleParameter("soTKLK", soTKLK)); oracleCommand.Parameters.Add("maCK", maCK); return(DataProvider.ExcuteNonQuery(oracleCommand)); } catch (Exception e) { MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
public static bool ThemCK(QLRoCKDTO roCK) { try { OracleCommand oracleCommand = new OracleCommand(); oracleCommand.CommandText = "INSERT INTO CHI_TIET_RO (MA_RO, MA_CK,GIA_VAY,TI_LE_VAY) VALUES (:maRo,:maCK,:giaVay,:tiLeVay)"; oracleCommand.Parameters.Add("maRo", roCK.MaRo); oracleCommand.Parameters.Add("maCK", roCK.MaCK); oracleCommand.Parameters.Add("giaVay", roCK.GiaVay); oracleCommand.Parameters.Add("tiLeVay", roCK.TiLeVay); return(DataProvider.ExcuteNonQuery(oracleCommand)); } catch (Exception e) { MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
public int Add(DTOKhachHang kh) { List <SqlParameter> paras = new List <SqlParameter>(); paras.Add(new SqlParameter("@ma", kh.MaKH)); paras.Add(new SqlParameter("@ho", kh.Ho)); paras.Add(new SqlParameter("@ten", kh.Ten)); paras.Add(new SqlParameter("@ngaysinh", kh.NgaySinh)); paras.Add(new SqlParameter("@cmnd", kh.CMND)); paras.Add(new SqlParameter("@dc", kh.DiaChi)); paras.Add(new SqlParameter("@sdt", kh.SDT)); try { return(dp.ExcuteNonQuery("ThemKH", System.Data.CommandType.StoredProcedure, paras)); } catch (SqlException ex) { throw ex; } }