public DataTable Get_Chinh_Tri_Info()
{
DataTable dt;
IDataParameter[] paras = new IDataParameter[1] {
new NpgsqlParameter("p_ma_nv", MaNV)
};
dt = dp.getDataTableProc("sp_select_cnvc_chinh_tri", paras);
return(dt);
}
public DataTable GetCNVCList_All(int dv_id)
{
DataTable dt = new DataTable();
IDataParameter[] paras = new IDataParameter[1] {
new NpgsqlParameter("p_dv_id", dv_id)
};
dt = dp.getDataTableProc("sp_select_cnvc_from_dvid", paras);
return(dt);
}
public DataTable GetData()
{
DataTable dt;
IDataParameter[] paras = new IDataParameter[1] {
new NpgsqlParameter("p_ma_nv", manv)
};
dt = dp.getDataTableProc("sp_select_cnvc", paras);
return(dt);
}
public DataTable Search_QD()
{
DataTable dt;
IDataParameter[] paras = new IDataParameter[5] {
new NpgsqlParameter("p_ma_quyet_dinh", ma_qd),
new NpgsqlParameter("p_ten", ten_qd),
new NpgsqlParameter("p_loai_qd", loai_qd_id),
new NpgsqlParameter("p_ngay_ky_tu", ngay_ky_tu),
new NpgsqlParameter("p_ngay_ky_den", ngay_ky_den)
};
dt = dp.getDataTableProc("sp1_qsearch_quyet_dinh", paras);
return(dt);
}
public DataTable GetList_PhuCap_byCNVC(string p_ma_hop_dong, string p_ma_nv)
{
IDataParameter[] paras = new IDataParameter[2] {
new NpgsqlParameter("p_ma_hop_dong", p_ma_hop_dong),
new NpgsqlParameter("p_ma_nv", p_ma_nv)
};
return(dp.getDataTableProc("sp_select_cnvc_phu_cap", paras));
}
public DataTable Search_HD(string p_ma_nv, string p_ho, string p_ten, string p_ma_hop_dong, int?p_ma_loai_hd, bool?p_co_thoi_han, DateTime?p_ngay_ky_tu, DateTime?p_ngay_ky_den)
{
DataTable dt;
IDataParameter[] paras = new IDataParameter[8] {
new NpgsqlParameter("p_ma_nv", p_ma_nv),
new NpgsqlParameter("p_ho_nv", p_ho),
new NpgsqlParameter("p_ten_nv", p_ten),
new NpgsqlParameter("p_ma_hd", p_ma_hop_dong),
new NpgsqlParameter("p_loai_hd", p_ma_loai_hd),
new NpgsqlParameter("p_co_thoi_han", p_co_thoi_han),
new NpgsqlParameter("p_ngay_ky_tu", p_ngay_ky_tu),
new NpgsqlParameter("p_ngay_ky_den", p_ngay_ky_den)
};
dt = dp.getDataTableProc("sp1_qsearch_hop_dong", paras);
return(dt);
}
public DataTable GetData()
{
DataTable dt;
IDataParameter[] paras = new IDataParameter[1]{
new NpgsqlParameter("p_ma_nv",manv)
};
dt = dp.getDataTableProc("sp_select_cnvc_chuyen_mon_tong_quat", paras);
return dt;
}
public DataTable GetNgayNghiByNV(string pMaNV)
{
DataTable dt;
IDataParameter[] paras = new IDataParameter[1] {
new NpgsqlParameter("manv", pMaNV)
};
dt = dp.getDataTableProc("sp2_select_ngay_phep_by_nv", paras);
return(dt);
}
public DataTable GetData()
{
DataTable dt;
List <QD_File> listFile = new List <QD_File>();
IDataParameter[] paras = new IDataParameter[1] {
new NpgsqlParameter("p_ma_nv", MaQD)
};
dt = dp.getDataTableProc("sp_select_qd_File", paras);
return(dt);
}
public DataTable NV_Theo_CD_CV(List <int> lstCD, List <int> lstCV, DateTime?tu_ngay, DateTime?den_ngay)
{
DataTable dt = new DataTable();
IDataParameter[] paras = new IDataParameter[4] {
new NpgsqlParameter("p_ma_nv", lstCD == null ? null : lstCD.ToArray()),
new NpgsqlParameter("p_ma_nv", lstCV == null ? null : lstCV.ToArray()),
new NpgsqlParameter("p_tu_ngay", tu_ngay),
new NpgsqlParameter("p_den_ngay", den_ngay)
};
dt = dp.getDataTableProc("sp4_bc_cnvc_by_cd_cv", paras);
return(dt);
}
//public bool Delete_HD_QD(string[] DeletePaths)
//{
// int check;
// IDataParameter[] paras = new IDataParameter[4]{
// new NpgsqlParameter("p_path",DeletePaths),
// new NpgsqlParameter("p_ma_nv",manv),
// new NpgsqlParameter("p_link",Link),
// new NpgsqlParameter("p_file_type",FileType.ToString().ToLower())
// };
// check = (int)dp.executeScalarProc("sp_delete_cnvc_file_hd_qd", paras);
// if (check > 0)
// {
// return true;
// }
// else
// return false;
//}
//public List<CNVC_File> GetData()
//{
// DataTable dt;
// List<CNVC_File> listFile = new List<CNVC_File>();
// IDataParameter[] paras = new IDataParameter[3]{
// new NpgsqlParameter("p_ma_nv",manv),
// new NpgsqlParameter("p_file_type",FileType.ToString().ToLower()) ,
// new NpgsqlParameter("p_link_id",Link)
// };
// dt = dp.getDataTableProc("sp_select_cnvc_file", paras);
// listFile = dt.AsEnumerable().Select(row =>
// new CNVC_File
// {
// id = row.Field<int>("id"),
// manv = row.Field<string>("ma_nv"),
// path = row.Field<string>("path"),
// mota = row.Field<string>("mo_ta"),
// = ,
// Link = row.Field<string>("p_link_id")
// }).ToList();
// return listFile;
//}
public DataTable GetData()
{
DataTable dt;
List <CNVC_File> listFile = new List <CNVC_File>();
IDataParameter[] paras = new IDataParameter[3] {
new NpgsqlParameter("p_ma_nv", manv),
new NpgsqlParameter("p_group", Group),
new NpgsqlParameter("p_link", Link)
};
dt = dp.getDataTableProc("sp_select_cnvc_file", paras);
return(dt);
}