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); }