public void Fill_TONG_HOP_BILL_CHUA_GUI_CHO_CPN(DS_V_BC_TONG_HOP_BILL_BI_TRA_LAI_WEB ip_v_ds, decimal ip_v_id_trung_tam, DateTime ip_v_dat_tu_ngay, DateTime ip_v_dat_den_ngay, string ip_nguoi_gui)
{
CStoredProc v_store_proc = new CStoredProc("pr_BAO_CAO_TONG_HOP_BILL_CHUA_GUI_CHO_CPN_WEB_2");
v_store_proc.addDecimalInputParam("@ID_TRUNG_TAM", ip_v_id_trung_tam);
v_store_proc.addNVarcharInputParam("@NGUOI_GUI", ip_nguoi_gui);
v_store_proc.addDatetimeInputParam("@TU_NGAY", ip_v_dat_tu_ngay);
v_store_proc.addDatetimeInputParam("@DEN_NGAY", ip_v_dat_den_ngay);
v_store_proc.fillDataSetByCommand(this, ip_v_ds);
}
internal void FillDatasetChungChiHetHan(DataSet v_ds, DateTime dateTime)
{
CStoredProc v_cstore = new CStoredProc("get_chung_chi_het_han_theo_ngach");
v_cstore.addDatetimeInputParam("@ngay",dateTime );
v_cstore.fillDataSetByCommand(this, v_ds);
}
public void fill_data_bo_loc(DS_V_HT_LOG_TRUY_CAP op_ds_ht_log_truy_cap
, string ip_str_username
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, decimal ip_dc_id_hanh_dong)
{
CStoredProc v_cstore = new CStoredProc("pr_V_HT_LOG_TRUY_CAP_filter");
v_cstore.addNVarcharInputParam("@USERNAME", ip_str_username);
v_cstore.addDatetimeInputParam("@TU_NGAY", ip_dat_tu_ngay);
v_cstore.addDatetimeInputParam("@DEN_NGAY", ip_dat_den_ngay);
v_cstore.addDecimalInputParam("@ID_LOAI_HANH_DONG", ip_dc_id_hanh_dong);
v_cstore.fillDataSetByCommand(this, op_ds_ht_log_truy_cap);
}
public void bc_giao_von_quy_bao_tri_theo_qd(DataSet ip_ds
, decimal ip_id_don_vi
, decimal ip_dc_id_loai_nhiem_vu
, decimal ip_dc_id_cong_trinh
, decimal ip_dc_id_du_an
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, string ip_str_tu_khoa
, string ip_nguon_ns)
{
CStoredProc v_prc = new CStoredProc("pr_A256_giao_von_theo_quyet_dinh");
v_prc.addDecimalInputParam("@ip_dc_id_don_vi", ip_id_don_vi);
v_prc.addDecimalInputParam("@ip_dc_id_du_an", ip_dc_id_du_an);
v_prc.addDecimalInputParam("@ip_dc_id_cong_trinh", ip_dc_id_cong_trinh);
v_prc.addDecimalInputParam("@ip_dc_id_loai_nhiem_vu", ip_dc_id_loai_nhiem_vu);
v_prc.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_prc.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_prc.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_prc.addNVarcharInputParam("@ip_nguon_ns", ip_nguon_ns);
v_prc.fillDataSetByCommand(this, ip_ds);
}
public void get_dm_uy_nhiem_chi_by_don_vi_va_ngay_thang(DS_DM_GIAI_NGAN op_ds
, decimal ip_dc_id_don_vi
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, string ip_nguon_ns)
{
CStoredProc v_sp = new CStoredProc("pr_get_dm_uy_nhiem_chi_by_don_vi_va_ngay_thang");
v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_sp.addNVarcharInputParam("@ip_nguon_ns", ip_nguon_ns);
v_sp.fillDataSetByCommand(this, op_ds);
}
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 DataTable LayDanhSachHopDongThayDoiHeSoLNS(DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
{
CStoredProc v_cs = new CStoredProc("pr_HD_hop_dong_thay_doi_he_so_lns_GetAll");
v_cs.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_cs.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
DataSet v_ds = new DataSet();
v_ds.Tables.Add();
v_cs.fillDataSetByCommand(this, v_ds);
return v_ds.Tables[0];
}
public void FillDataset(DS_V_RPT_410_BAO_CAO_TAI_CHINH_THEO_LOP_MON op_ds
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, decimal ip_dc_id_lop_mon
, string ip_str_search)
{
CStoredProc v_obj_spr = new CStoredProc("f410_bao_cao_tai_chinh_theo_lop_mon");
v_obj_spr.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
v_obj_spr.addDatetimeInputParam("@ip_dat_dau_thang", ip_dat_tu_ngay);
v_obj_spr.addDatetimeInputParam("@ip_dat_cuoi_thang", ip_dat_den_ngay);
v_obj_spr.addNVarcharInputParam("@ip_str_search", ip_str_search);
v_obj_spr.fillDataSetByCommand(this, op_ds);
}
public void thay_doi_trang_thai_lao_dong(decimal ip_dc_id_nhan_vien
, decimal ip_dc_id_trang_thai_chuyen
, DateTime ip_dat_ngay_lap
, string ip_str_nguoi_lap)
{
CStoredProc v_sp = new CStoredProc("pr_thay_doi_trang_thai_lao_dong");
v_sp.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
v_sp.addDecimalInputParam("@ip_dc_id_trang_thai_chuyen", ip_dc_id_trang_thai_chuyen);
v_sp.addDatetimeInputParam("@ip_dat_ngay_lap", ip_dat_ngay_lap);
v_sp.addNVarcharInputParam("@ip_str_nguoi_lap", ip_str_nguoi_lap);
v_sp.ExecuteCommand(this);
}
public void FillDataset(DS_V_RPT_BAO_CAO_TINH_HINH_TAI_CHINH_HOC_SINH_LOP_MON op_ds
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, decimal ip_dc_id_hoc_sinh
, string ip_str_search)
{
CStoredProc v_obj_spr = new CStoredProc("f480_bao_cao_tien_phai_thu_theo_hoc_sinh_lop_mon");
v_obj_spr.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_obj_spr.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_obj_spr.addDecimalInputParam("@ip_dc_id_hoc_sinh", ip_dc_id_hoc_sinh);
v_obj_spr.addNVarcharInputParam("@ip_str_search", ip_str_search);
v_obj_spr.fillDataSetByCommand(this, op_ds);
}
public void FillDatasetSearch_hocvien_tuyenmoi(DS_V_GD_THONG_KE ip_m_ds, string ip_v_str_tim_kiem, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, decimal v_id_loai_dinh_muc)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_GD_THONG_KE_Search_hocvien_tuyenmoi");
v_stored_proc.addNVarcharInputParam("@TU_KHOA", ip_v_str_tim_kiem);
v_stored_proc.addDatetimeInputParam("@TU_NGAY", ip_dat_tu_ngay);
v_stored_proc.addDatetimeInputParam("@DEN_NGAY", ip_dat_den_ngay);
v_stored_proc.addDecimalInputParam("@ID_LOAI_DINH_MUC", v_id_loai_dinh_muc);
v_stored_proc.fillDataSetByCommand(this, ip_m_ds);
}
public void FillDatasetSearch(DS_V_TONG_HOP_CPN_THEO_PHONG_BAN ip_v_ds, string ip_v_str_tu_khoa, decimal ip_v_id_phong_ban, DateTime ip_v_dt_tu_ngay, DateTime ip_v_dt_den_ngay)
{
CStoredProc v_stored_proc = new CStoredProc("pr_TONG_HOP_CPN_THEO_PHONG_BAN_Search");
v_stored_proc.addNVarcharInputParam("@TU_KHOA", ip_v_str_tu_khoa);
v_stored_proc.addDecimalInputParam("@ID_PHONG_BAN", ip_v_id_phong_ban);
v_stored_proc.addDatetimeInputParam("@TU_NGAY", ip_v_dt_tu_ngay);
v_stored_proc.addDatetimeInputParam("@DEN_NGAY", ip_v_dt_den_ngay);
v_stored_proc.fillDataSetByCommand(this, ip_v_ds);
}
//public decimal getTongTienKH(
// decimal ip_dc_id_don_vi
// , DateTime ip_dat_tu_ngay
// , DateTime ip_dat_den_ngay
// , string ip_str_is_nguon_ns_yn
// , decimal ip_dc_id_loai_du_an)
//{
// decimal op_dc_tong_tien = 0;
// DS_GD_GIAO_KH v_ds = new DS_GD_GIAO_KH();
// v_ds.Clear();
// v_ds.EnforceConstraints = false;
// CStoredProc v_sp = new CStoredProc("pr_GD_GIAO_KH_tong_so_tien");
// v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
// v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
// v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
// v_sp.addNVarcharInputParam("@ip_str_is_nguon_ns_yn", ip_str_is_nguon_ns_yn);
// v_sp.addDecimalInputParam("@ip_dc_id_loai_du_an", ip_dc_id_loai_du_an);
// v_sp.fillDataSetByCommand(this, v_ds);
// for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
// {
// if (v_ds.Tables[0].Rows[i][GD_GIAO_KH.SO_TIEN_NS] != null && v_ds.Tables[0].Rows[i][GD_GIAO_KH.SO_TIEN_QUY_BT] != null)
// {
// op_dc_tong_tien += CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i][GD_GIAO_KH.SO_TIEN_NS]) + CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i][GD_GIAO_KH.SO_TIEN_QUY_BT]);
// }
// }
// return op_dc_tong_tien;
//}
public bool update_ten_du_an_giao_kh_to_giao_von_va_unc(
decimal ip_dc_id_don_vi
, decimal ip_dc_id_loai_nhiem_vu
, decimal ip_dc_id_du_an_cong_trinh
, string ip_str_ten_du_an_cu
, string ip_str_ten_du_an_moi
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay)
{
CStoredProc v_sp = new CStoredProc("pr_update_ten_du_an_from_gd_giao_kh");
v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_sp.addDecimalInputParam("@ip_dc_id_loai_nhiem_vu", ip_dc_id_loai_nhiem_vu);
v_sp.addDecimalInputParam("@ip_dc_id_du_an_cong_trinh", ip_dc_id_du_an_cong_trinh);
v_sp.addNVarcharInputParam("@ip_str_ten_du_an_cu", ip_str_ten_du_an_cu);
v_sp.addNVarcharInputParam("@ip_str_ten_du_an_moi", ip_str_ten_du_an_moi);
v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
try
{
v_sp.ExecuteCommand(this);
}
catch (Exception)
{
return false;
}
return true;
}
public void v_ht_van_thu_history_search_F660(
DS_V_HT_VAN_THU_HISTORY op_ds
,DateTime ip_dat_tu_ngay
,DateTime ip_dat_den_ngay
,string ip_str_tu_khoa)
{
CStoredProc v_sp = new CStoredProc("pr_v_ht_van_thu_history_search_F660");
v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_sp.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_sp.fillDataSetByCommand(this, op_ds);
}
public DataTable FillDatasetBCBienDong(DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
{
CStoredProc v_cstore = new CStoredProc("pr_RPTTH_bao_cao_bien_dong_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);
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_cstore.fillDataSetByCommand(this, v_ds);
return v_ds.Tables[0];
}
public void FillDatasetByNgayChamCong(DS_V_PRT_DANH_SACH_NHAN_VIEN_CON_HAN_HOP_DONG op_ds, DateTime ip_dat_ngay_cham_cong)
{
CStoredProc v_sp = new CStoredProc("PR_LAY_DANH_SACH_NV_HOP_DONG_CON_HAN");
v_sp.addDatetimeInputParam("@ip_dat_ngay_cham_cong", ip_dat_ngay_cham_cong);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void KetThucLuongNangSuatNhanVien(decimal ip_dc_id_nhan_vien, DateTime ip_dat_ngay_ket_thuc)
{
CStoredProc v_cs = new CStoredProc("pr_HD_cap_nhat_ngay_ket_thuc_luong_nang_suat");
v_cs.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
v_cs.addDatetimeInputParam("@ip_dat_ngay_ket_thuc", ip_dat_ngay_ket_thuc);
v_cs.ExecuteCommand(this);
}
public void FillDatasetGiaoKHByIdDonVi(DS_V_DM_QUYET_DINH_KH ip_ds, decimal ip_dc_id_don_vi, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, string ip_str_filter)
{
CStoredProc v_prc = new CStoredProc("pr_F190_danh_sach_quyet_dinh_giao_kh");
v_prc.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_prc.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_prc.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_prc.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_filter);
v_prc.fillDataSetByCommand(this, ip_ds);
}
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 DataSet LayDanhSachNhanVienHetHanLuongCheDo(
DateTime ip_dat_ngay_hien_tai)
{
CStoredProc v_sp = new CStoredProc("pr_lay_danh_sach_nv_het_han_lcd");
v_sp.addDatetimeInputParam("@ip_dat_ngay_hien_tai", ip_dat_ngay_hien_tai);
DataSet v_op_ds = new DataSet();
v_op_ds.Tables.Add();
//v_sp.fillDataSetByCommand(this, v_op_ds);
return v_op_ds;
}
public DS_V_GD_CONG_TAC LayDanhSachNhanVienKiemNhiem(DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
{
CStoredProc v_sp = new CStoredProc("pr_lay_danh_sach_nhan_vien_bo_nhiem");
DS_V_GD_CONG_TAC v_ds = new DS_V_GD_CONG_TAC();
v_ds.EnforceConstraints = false;
v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_sp.fillDataSetByCommand(this, v_ds);
return v_ds;
}
public void fillDatasetByProc(DS_RPT_TONG_TIEN_DINH_MUC ip_ds, DateTime ip_from_date, DateTime ip_to_date)
{
CStoredProc v_proc = new CStoredProc("pr_rpt_tong_tien_dinh_muc");
v_proc.addDatetimeInputParam("@from_date", ip_from_date);
v_proc.addDatetimeInputParam("@to_date", ip_to_date);
v_proc.fillDataSetByCommand(this, ip_ds);
}
public void FillData2DatasetGiaiNgan(
DataSet ip_ds,
DateTime ip_dat_tu_ngay,
DateTime ip_dat_den_ngay,
decimal ip_dc_id_don_vi,
decimal ip_dc_id_loai_nhiem_vu,
decimal ip_dc_id_cong_trinh,
decimal ip_dc_id_du_an,
string ip_str_tu_khoa,
string ip_str_nguon_ns,
decimal ip_dc_id_giai_ngan,
string ip_str_proc)
{
CStoredProc v_prc = new CStoredProc(ip_str_proc);
v_prc.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_prc.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_prc.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_prc.addDecimalInputParam("@ip_dc_id_loai_nhiem_vu", ip_dc_id_loai_nhiem_vu);
v_prc.addDecimalInputParam("@ip_dc_id_cong_trinh", ip_dc_id_cong_trinh);
v_prc.addDecimalInputParam("@ip_dc_id_du_an", ip_dc_id_du_an);
v_prc.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_prc.addNVarcharInputParam("@ip_nguon_ns", ip_str_nguon_ns);
v_prc.addDecimalInputParam("@ip_dc_id_giai_ngan", ip_dc_id_giai_ngan);
v_prc.fillDataSetByCommand(this, ip_ds);
}
public void FillDatasetDauThangCuoiThang(DS_RPT_TONG_TIEN_DINH_MUC ip_ds, DateTime ip_dau_thang, DateTime ip_cuoi_thang)
{
CStoredProc v_proc = new CStoredProc("pr_bang_tong_tien_dinh_muc_hang_thang");
v_proc.addDatetimeInputParam("@DAU_THANG", ip_dau_thang);
v_proc.addDatetimeInputParam("@CUOI_THANG", ip_cuoi_thang);
v_proc.fillDataSetByCommand(this, ip_ds);
}
public void FillDatasetGDChiTietChucVu(DataSet op_ds, DateTime ip_dat)
{
CStoredProc v_cstore = new CStoredProc("rpt_tinh_hinh_dao_tao");
v_cstore.addDatetimeInputParam("@ip_dat_ngay_bao_cao",ip_dat );
v_cstore.fillDataSetByCommand(this, op_ds);
}
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 void bc_tra_cuu_giao_von_theo_du_an(DataSet ip_ds, decimal ip_dc_id_cong_trinh_du_an, string ip_str_ten_du_an, decimal ip_dc_id_don_vi, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
{
CStoredProc v_prc = new CStoredProc("pr_bao_cao_tra_cuu_giao_von_theo_du_an");
v_prc.addDecimalInputParam("@ip_dc_id_du_an_cong_trinh", ip_dc_id_cong_trinh_du_an);
v_prc.addNVarcharInputParam("@ip_str_ten_du_an", ip_str_ten_du_an);
v_prc.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_prc.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_prc.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_prc.fillDataSetByCommand(this, ip_ds);
}
public void get_don_gia_dinh_muc_and_so_luong_thong_ke(decimal ip_id_trung_tam, decimal ip_id_loai_dinh_muc
, DateTime ip_from_date, DateTime ip_to_date
, ref decimal op_don_gia_dinh_muc, ref decimal op_so_luong_thong_ke)
{
CStoredProc v_proc = new CStoredProc("pr_get_don_gia_dinh_muc_and_so_luong_thong_ke");
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_don_gia_dinh_muc = v_proc.addDecimalOutputParam("@DON_GIA_DINH_MUC", -1);
SqlParameter v_obj_so_luong_thong_ke = v_proc.addDecimalOutputParam("@SO_LUONG_THONG_KE", -1);
v_proc.ExecuteCommand(this);
if(v_obj_don_gia_dinh_muc.Value.ToString() != "0" && v_obj_don_gia_dinh_muc.Value.ToString() != "") {
op_don_gia_dinh_muc = CIPConvert.ToDecimal(v_obj_don_gia_dinh_muc.Value);
}
if(v_obj_so_luong_thong_ke.Value.ToString() != "0" && v_obj_so_luong_thong_ke.Value.ToString() != "") {
op_so_luong_thong_ke = CIPConvert.ToDecimal(v_obj_so_luong_thong_ke.Value);
}
}
public void FillDataset_chi_tiet_dm(DS_RPT_BC_CHI_TIET_DM ip_v_ds, DateTime ip_v_dt_tu_ngay, DateTime ip_v_dt_den_ngay, decimal ip_v_id_loai_dm, decimal ip_v_id_trung_tam)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_BC_CHI_TIET_DM_search");
v_stored_proc.addDatetimeInputParam("@TU_NGAY", ip_v_dt_tu_ngay);
v_stored_proc.addDatetimeInputParam("@DEN_NGAY", ip_v_dt_den_ngay);
v_stored_proc.addDecimalInputParam("@ID_LOAI_DINH_MUC", ip_v_id_loai_dm);
v_stored_proc.addDecimalInputParam("@ID_TRUNG_TAM", ip_v_id_trung_tam);
v_stored_proc.fillDataSetByCommand(this, ip_v_ds);
}
public void Fill_TONG_HOP_BILL_MAT_PHI(DS_V_BC_TONG_HOP_BILL_BI_TRA_LAI_WEB ip_v_ds, decimal ip_v_id_trung_tam, DateTime ip_v_dat_tu_ngay, DateTime ip_v_dat_den_ngay)
{
CStoredProc v_store_proc = new CStoredProc("pr_BAO_CAO_TONG_HOP_BILL_BI_TRA_LAI_WEB");
v_store_proc.addDecimalInputParam("@ID_TRUNG_TAM", ip_v_id_trung_tam);
//v_store_proc.addNVarcharInputParam("@TU_KHOA", ip_v_str_tu_khoa);
v_store_proc.addDatetimeInputParam("@TU_NGAY", ip_v_dat_tu_ngay);
v_store_proc.addDatetimeInputParam("@DEN_NGAY", ip_v_dat_den_ngay);
v_store_proc.fillDataSetByCommand(this, ip_v_ds);
}