public void gen_ma_nhan_vien(ref string v_str_op_ma_nhan_vien)
{
CStoredProc v_obj_csp = new CStoredProc("pr_gen_ma_nhan_vien");
SqlParameter v_op_str = v_obj_csp.addNVarcharOutputParam("@op_ma_nhan_vien", "");
v_obj_csp.ExecuteCommand(this);
v_str_op_ma_nhan_vien = v_op_str.Value.ToString();
}
public bool KiemTraNhanVienCoCongTacChua(decimal ip_dc_id_nhan_vien, decimal ip_dc_id_don_vi)
{
CStoredProc v_cstore = new CStoredProc("pr_NS_nhan_vien_thuoc_phong_ban_Check");
v_cstore.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
v_cstore.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
SqlParameter v_para = v_cstore.addNVarcharOutputParam("@op_str_yn", "");
v_cstore.ExecuteCommand(this);
return v_para.Value.ToString() == "Y" ? true : false;
}
public bool IsLockBangLuong(decimal ip_dc_thang, decimal ip_dc_nam)
{
CStoredProc v_pr = new CStoredProc("pr_TL_infor_lock_bang_luong_Get");
v_pr.addDecimalInputParam("@ip_dc_thang", ip_dc_thang);
v_pr.addDecimalInputParam("@ip_dc_nam", ip_dc_nam);
SqlParameter v_para = v_pr.addNVarcharOutputParam("@op_str_lock_yn", "");
v_pr.ExecuteCommand(this);
return v_para.Value.ToString() == "Y" ? true : false;
}
public bool KiemTraThoiGianHeSoLNSHopLeForInsert(decimal ip_dc_id_nhan_vien, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
{
CStoredProc v_cstore = new CStoredProc("pr_HD_du_lieu_hs_lns_hop_le_CheckInsert");
v_cstore.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
v_cstore.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_cstore.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
SqlParameter v_yn = v_cstore.addNVarcharOutputParam("@op_str_hop_le_yn", "");
v_cstore.ExecuteCommand(this);
return v_yn.Value.ToString() == "Y" ? true : false;
}
public bool KiemTraQuyCoNhanVienChua(decimal ip_dc_id_quy, decimal ip_dc_id_nhan_vien)
{
CStoredProc v_obj = new CStoredProc("pr_TNK_nhan_vien_ton_tai_trong_quy_Check");
v_obj.addDecimalInputParam("@ip_dc_id_quy_tien", ip_dc_id_quy);
v_obj.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
SqlParameter v_para_yn = v_obj.addNVarcharOutputParam("@op_yn", "");
v_obj.ExecuteCommand(this);
var v_bol_ket_qua = v_para_yn.Value.ToString() == "Y" ? true : false;
return v_bol_ket_qua;
}
public bool KiemTraThoiGianHopDongHopLeForUpdate(decimal ip_dc_id_gd_hop_dong, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
{
CStoredProc v_cstore = new CStoredProc("pr_HD_du_lieu_hop_dong_hop_le_CheckUpdate");
v_cstore.addDecimalInputParam("@ip_dc_id_gd_hop_hong", ip_dc_id_gd_hop_dong);
v_cstore.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_cstore.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
SqlParameter v_yn = v_cstore.addNVarcharOutputParam("@op_str_hop_le_yn", "");
v_cstore.ExecuteCommand(this);
return v_yn.Value.ToString() == "Y" ? true : false;
}
public void LayMaMucLNSCuaHopDong(decimal ip_dc_id_hop_dong_con_hieu_luc, out decimal op_dc_he_so, out string op_str_ma, out string op_str_muc)
{
CStoredProc v_sp = new CStoredProc("pr_HD_ma_muc_lns_Get");
v_sp.addDecimalInputParam("@ip_dc_id_hop_dong_con_hieu_luc", @ip_dc_id_hop_dong_con_hieu_luc);
SqlParameter v_p_he_so = v_sp.addDecimalOutputParam("@op_dc_he_so", (decimal)1.123);
v_p_he_so.Precision = 6;
v_p_he_so.Scale = 2;
SqlParameter v_p_muc = v_sp.addNVarcharOutputParam("@op_str_muc_lns", "");
SqlParameter v_p_ma = v_sp.addNVarcharOutputParam("@op_str_ma_lns", "");
v_sp.ExecuteCommand(this);
op_dc_he_so = Convert.ToDecimal(v_p_he_so.Value);
op_str_ma = v_p_ma.Value.ToString();
op_str_muc = v_p_muc.Value.ToString();
}
public string get_all_ma_phong_ban_by_id_user_group(decimal ip_dc_id_user_group)
{
string v_str_ma_phong_ban = "";
CStoredProc v_sp = new CStoredProc("pr_HT_QUAN_HE_SU_DUNG_DU_LIEU_get_all_ma_phong_ban_by_id_user_group");
v_sp.addDecimalInputParam("@ip_dc_id_user_group", ip_dc_id_user_group);
SqlParameter v_sql_para = v_sp.addNVarcharOutputParam("@ip_str_phong_ban", v_str_ma_phong_ban);
v_sp.ExecuteCommand(this);
v_str_ma_phong_ban = v_sql_para.Value.ToString();
return v_str_ma_phong_ban;
}
public bool IsExistNhanVienInDB(string ip_str_ma_nv)
{
CStoredProc v_sp = new CStoredProc("pr_is_exist_nhan_vien");
v_sp.addNVarcharInputParam("@ip_str_ma_nv", ip_str_ma_nv);
SqlParameter v_para = v_sp.addNVarcharOutputParam("@op_yn_is_exist", "");
v_sp.ExecuteCommand(this);
if (v_para.Value.ToString() == "Y")
{
return true;
}
else if (v_para.Value.ToString() == "N")
{
return false;
}
else
{
throw new Exception();
}
}
public bool QuyThuongDaChiaNhanVienChua(decimal ip_dc_id_quy_tien_thuong)
{
CStoredProc v_sp = new CStoredProc("pr_quy_thuong_da_chia_nhan_vien_chua");
v_sp.addDecimalInputParam("@ip_dc_id_quy_thuong", ip_dc_id_quy_tien_thuong);
SqlParameter v_para = v_sp.addNVarcharOutputParam("@op_str_yn", "");
v_sp.ExecuteCommand(this);
return v_para.Value.ToString() == "Y" ? true : false;//Y la da chia thuog cho nhan vien, N la chua chia thuong
}
public bool KiemTraCoDuLieu(decimal ip_dc_thang, decimal ip_dc_nam, decimal ip_dc_id_loai_tien_khac)
{
CStoredProc v_cstore = new CStoredProc("pr_TL_infor_du_lieu_khoan_tien_khac_Get");
v_cstore.addDecimalInputParam("@ip_dc_thang", ip_dc_thang);
v_cstore.addDecimalInputParam("@ip_dc_nam", ip_dc_nam);
v_cstore.addDecimalInputParam("@ip_dc_id_loai_tien_khac", ip_dc_id_loai_tien_khac);
SqlParameter v_para = v_cstore.addNVarcharOutputParam("@op_ton_tai_yn", "");
v_cstore.ExecuteCommand(this);
return v_para.Value.ToString() == "Y" ? true : false;
}
public bool KiemTraXemDaInsertThuong2014Chua(decimal ip_id_quy_tien, decimal ip_dc_id_nhan_vien)
{
CStoredProc v_sp = new CStoredProc("pr_check_before_insert_thuong_2k14");
v_sp.addDecimalInputParam("@ip_dc_id_quy_tien", ip_id_quy_tien);
v_sp.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
SqlParameter v_yn = v_sp.addNVarcharOutputParam("@op_yn_insert", "");
v_sp.ExecuteCommand(this);
return v_yn.Value.ToString() == "Y" ? false : true;//Y la chua co
}
//Bang luong
public void LayTrangThaiBangLuong(decimal ip_dc_thang
, decimal ip_dc_nam
, out decimal op_sl_nv_can_tinh_luong
, out decimal op_sl_nv_da_tinh_luong
, out bool op_bol_co_du_lieu_chua
, out bool op_bol_chot_bang_luong)
{
op_sl_nv_can_tinh_luong = 0;
op_sl_nv_da_tinh_luong = 0;
CStoredProc v_sp = new CStoredProc("pr_TL_trang_thai_bang_luong_Get");
v_sp.addDecimalInputParam("@ip_i_thang", ip_dc_thang);
v_sp.addDecimalInputParam("@ip_i_nam", ip_dc_nam);
SqlParameter v_para_all = v_sp.addDecimalOutputParam("@op_i_tong_so_nhan_vien_can_tinh", 0);
SqlParameter v_para_da_tinh = v_sp.addDecimalOutputParam("@op_i_so_luong_nhan_vien_da_tinh", 0);
SqlParameter v_para_co_du_lieu_chua = v_sp.addNVarcharOutputParam("@op_str_co_du_lieu_chua", "");
SqlParameter v_para_chot_bang_luong = v_sp.addNVarcharOutputParam("@op_str_chot_bang_luong", "");
v_sp.ExecuteCommand(this);
op_sl_nv_can_tinh_luong = CIPConvert.ToDecimal(v_para_all.Value);
op_sl_nv_da_tinh_luong = CIPConvert.ToDecimal(v_para_da_tinh.Value);
op_bol_co_du_lieu_chua = v_para_co_du_lieu_chua.Value.ToString() == "Y" ? true : false;
op_bol_chot_bang_luong = v_para_chot_bang_luong.Value.ToString() == "Y" ? true : false;
}
public bool kiem_tra_nhan_vien_co_duoc_tinh_luong_thang(decimal ip_dc_id_nhan_vien, decimal ip_dc_thang, decimal ip_dc_nam)
{
CStoredProc v_pr = new CStoredProc("pr_TL_nhan_vien_duoc_tinh_luong_Check");
v_pr.addDecimalInputParam("@ip_dc_thang", ip_dc_thang);
v_pr.addDecimalInputParam("@ip_dc_nam", ip_dc_nam);
v_pr.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
SqlParameter v_para = v_pr.addNVarcharOutputParam("@op_str_yn","");
v_pr.ExecuteCommand(this);
return v_para.Value.ToString() == "Y" ? true : false;
}
public void check_hoc_sinh_lm(decimal ip_dc_id_hoc_sinh, decimal ip_dc_id_lop_mon, ref string op_ket_qua_yn)
{
CStoredProc v_obj_spr = new CStoredProc("f315_check_hs_trong_lm");
v_obj_spr.addDecimalInputParam("@ip_dc_id_hoc_sinh", ip_dc_id_hoc_sinh);
v_obj_spr.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
SqlParameter v_op_ket_qua_yn = v_obj_spr.addNVarcharOutputParam("@op_ket_qua_yn", op_ket_qua_yn);
v_obj_spr.ExecuteCommand(this);
op_ket_qua_yn = v_op_ket_qua_yn.Value.ToString();
}
public string get_ten_nguoi_su_dung(decimal v_id)
{
string v_ten = "";
CStoredProc v_cstore = new CStoredProc("get_ten_nguoi_su_dung");
v_cstore.addNVarcharInputParam("@id", v_id);
SqlParameter v_result = v_cstore.addNVarcharOutputParam("@ten", v_ten);
v_cstore.ExecuteCommand(this);
return (string)v_result.Value;
}
public string SelectMaxSoPhieu(decimal ip_dc_id_loai_phieu_thu, int ip_int_thang)
{
CStoredProc v_proc = new CStoredProc("pr_find_max_so_phieu_trong_thang");
v_proc.addDecimalInputParam("@ip_dc_id_loai_phieu", ip_dc_id_loai_phieu_thu);
v_proc.addDecimalInputParam("@ip_int_thang", ip_int_thang);
SqlParameter v_para = v_proc.addNVarcharOutputParam("@op_max_so_phieu", "");
v_proc.ExecuteCommand(this);
decimal v_temp = CIPConvert.ToDecimal(v_para.Value)+1;
string v_cut_1_chu_so = v_temp.ToString().Substring(0, 1);
if(CIPConvert.ToDecimal(v_cut_1_chu_so) < 10 && CIPConvert.ToDecimal(v_cut_1_chu_so) > 1) {
return "0" + v_temp.ToString();
}
else if(CIPConvert.ToDecimal(v_cut_1_chu_so) == 1) {
if(v_temp.ToString().Length < 5 ) {
return "0" + v_temp.ToString();
}
}
return v_temp.ToString();
}
public bool IsDaChotBangLuongThang(decimal ip_dc_thang, decimal ip_dc_nam)
{
CStoredProc v_sp = new CStoredProc("PR_CHOT_BANG_LUONG_THANG");
v_sp.addDecimalInputParam("@ip_dc_thang", ip_dc_thang);
v_sp.addDecimalInputParam("@ip_dc_nam", ip_dc_nam);
SqlParameter v_para_yn = v_sp.addNVarcharOutputParam("@op_yn_result", "");
v_sp.ExecuteCommand(this);
var v_str_yn = v_para_yn.Value.ToString();
if(v_str_yn.Equals("Y"))
{
return true;
}
else if(v_str_yn.Equals("N"))
{
return false;
}
else
{
throw new Exception();
}
}
public void lap_hop_dong_moi_cho_nhan_vien(decimal ID_NHAN_VIEN
, decimal ID_LOAI_HOP_DONG
, string MA_HOP_DONG
, DateTime NGAY_BAT_DAU
, DateTime NGAY_KET_THUC
, DateTime NGAY_KY_HOP_DONG
, DateTime NGAY_LAP
, string NGUOI_LAP
, string DA_XOA
, decimal ID_CD_LCD
, decimal ID_MUC_LCD
, decimal ID_CD_LNS
, decimal ID_MUC_LNS
, ref string op_str_mess)
{
CStoredProc v_sp = new CStoredProc("pr_lap_hop_dong_moi_cho_nhan_vien");
v_sp.addDecimalInputParam("@ID_NHAN_VIEN", ID_NHAN_VIEN);
v_sp.addDecimalInputParam("@ID_LOAI_HOP_DONG", ID_LOAI_HOP_DONG);
v_sp.addNVarcharInputParam("@MA_HOP_DONG", MA_HOP_DONG);
v_sp.addDatetimeInputParam("@NGAY_BAT_DAU", NGAY_BAT_DAU);
v_sp.addDatetimeInputParam("@NGAY_KET_THUC", NGAY_KET_THUC);
v_sp.addDatetimeInputParam("@NGAY_KY_HOP_DONG", NGAY_KY_HOP_DONG);
v_sp.addDatetimeInputParam("@NGAY_LAP", NGAY_LAP);
v_sp.addNVarcharInputParam("@NGUOI_LAP", NGUOI_LAP);
v_sp.addNVarcharInputParam("@DA_XOA", DA_XOA);
v_sp.addDecimalInputParam("@ID_CD_LCD", ID_CD_LCD);
v_sp.addDecimalInputParam("@ID_MUC_LCD", ID_MUC_LCD);
v_sp.addDecimalInputParam("@ID_CD_LNS", ID_CD_LNS);
v_sp.addDecimalInputParam("@ID_MUC_LNS", ID_MUC_LNS);
SqlParameter v_op_str = v_sp.addNVarcharOutputParam("@OP_STR_MESSAGE", op_str_mess);
v_sp.ExecuteCommand(this);
op_str_mess = v_op_str.Value.ToString();
}
public string get_ma_dat_hang_tiep_theo()
{
string v_output = "";
CStoredProc v_cstore = new CStoredProc("pr_get_ma_don_hang");
SqlParameter v_result = v_cstore.addNVarcharOutputParam("@MA_DON_HANG", v_output);
v_cstore.ExecuteCommand(this);
return v_result.Value.ToString();
}
public void get_co_so_dinh_muc_ap_dung_tu_ngay(decimal ip_id_trung_tam, decimal ip_id_loai_dinh_muc
, DateTime ip_from_date, DateTime ip_to_date
, ref decimal op_id_co_so_dinh_muc, ref DateTime op_ap_dung_tu_ngay
, ref string op_ten_co_so_dinh_muc)
{
CStoredProc v_proc = new CStoredProc("pr_get_co_so_dinh_muc_ap_dung_tu_ngay");
v_proc.addDecimalInputParam("@ID_TRUNG_TAM", ip_id_trung_tam);
v_proc.addDecimalInputParam("@ID_LOAI_DINH_MUC", ip_id_loai_dinh_muc);
v_proc.addDatetimeInputParam("@FROM_DATE", ip_from_date);
v_proc.addDatetimeInputParam("@TO_DATE", ip_to_date);
SqlParameter v_obj_id_co_so_dinh_muc = v_proc.addDecimalOutputParam("@ID_CO_SO_DINH_MUC", -1);
SqlParameter v_obj_ten_co_so_dinh_muc = v_proc.addNVarcharOutputParam("@TEN_CO_SO_DINH_MUC", -1);
SqlParameter v_obj_ap_dung_tu_ngay = v_proc.addDatetimeOutputParam("@AP_DUNG_TU_NGAY", -1);
v_proc.ExecuteCommand(this);
op_id_co_so_dinh_muc = CIPConvert.ToDecimal(v_obj_id_co_so_dinh_muc.Value);
string temp = v_obj_ap_dung_tu_ngay.Value.ToString();
if(temp != "") {
temp = temp.Substring(0, temp.IndexOf(" "));
op_ap_dung_tu_ngay = CIPConvert.ToDatetime(temp);
}
if(v_obj_ten_co_so_dinh_muc.Value.ToString() != "") {
op_ten_co_so_dinh_muc = CIPConvert.ToStr(v_obj_ten_co_so_dinh_muc.Value);
}
}
public bool KiemTraDuLieuCongTacHopLeForUpdate(decimal ip_dc_id_gd_cong_tac, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, decimal ip_dc_id_loai_cong_tac)
{
CStoredProc v_cstore = new CStoredProc("pr_CT_du_lieu_cong_tac_hop_le_CheckUpdate");
v_cstore.addDecimalInputParam("@ip_dc_id_gd_cong_tac", ip_dc_id_gd_cong_tac);
v_cstore.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_cstore.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_cstore.addDecimalInputParam("@ip_dc_id_loai_cong_tac", ip_dc_id_loai_cong_tac);
SqlParameter v_yn = v_cstore.addNVarcharOutputParam("@op_str_hop_le_yn", "");
v_cstore.ExecuteCommand(this);
return v_yn.Value.ToString() == "Y" ? true : false;
}
public bool KiemTraThoiGianVoiLuongCungHopLeForUpdate(decimal ip_dc_id_gd_he_so_lns, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
{
CStoredProc v_cstore = new CStoredProc("pr_LNS_kiem_tra_thoi_gian_hop_le_voi_luong_cung_ForUpdate");
v_cstore.addDecimalInputParam("@ip_dc_id_gd_he_so_lns", ip_dc_id_gd_he_so_lns);
v_cstore.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_cstore.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
SqlParameter v_yn = v_cstore.addNVarcharOutputParam("@op_str_hop_le_yn", "");
v_cstore.ExecuteCommand(this);
return v_yn.Value.ToString() == "Y" ? true : false;
}
public void kiem_tra_nam_das_thuong_hs_bo_sung(decimal ip_dc_nam, ref string op_str_nam_da_thuong_hs_bo_sung)
{
CStoredProc v_obj = new CStoredProc("pr_CHECK_NAM_DA_CO_THUONG_HS_BO_SUNG_YN");
v_obj.addDecimalInputParam("@ip_dc_nam", ip_dc_nam);
SqlParameter v_str_nam_da_thuong_hs_bo_sung = v_obj.addNVarcharOutputParam("@op_str_nam_da_thuong_hs_bo_sung", "N");
v_obj.ExecuteCommand(this);
op_str_nam_da_thuong_hs_bo_sung = v_str_nam_da_thuong_hs_bo_sung.Value.ToString();
}
