本文整理汇总了C#中IP.Core.IPUserService.CStoredProc.addDecimalInputParam方法的典型用法代码示例。如果您正苦于以下问题：C# CStoredProc.addDecimalInputParam方法的具体用法？C# CStoredProc.addDecimalInputParam怎么用？C# CStoredProc.addDecimalInputParam使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IP.Core.IPUserService.CStoredProc的用法示例。
在下文中一共展示了CStoredProc.addDecimalInputParam方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: FillDatasetLopMonDaCo
public void FillDatasetLopMonDaCo(DataSet v_ds, decimal id_nhan_vien, decimal id_mon_hoc)
{
CStoredProc v_cstore = new CStoredProc("get_lop_mon_da_co");
v_cstore.addDecimalInputParam("@id_nhan_vien", id_nhan_vien);
v_cstore.addDecimalInputParam("@id_mon_hoc", id_mon_hoc);
v_cstore.fillDataSetByCommand(this, v_ds);
}示例2: GetThamSoBangLuongThang
public void GetThamSoBangLuongThang(DS_BAO_CAO_THAM_SO_BANG_LUONG ip_ds, decimal ip_dec_thang, decimal ip_dec_nam)
{
CStoredProc v_sp = new CStoredProc("PR_GET_THAM_SO_BANG_LUONG");
v_sp.addDecimalInputParam("@THANG", ip_dec_thang);
v_sp.addDecimalInputParam("@NAM", ip_dec_nam);
v_sp.fillDataSetByCommand(this, ip_ds);
}示例3: FillDatasetLogin
public void FillDatasetLogin(DataSet v_ds, string user,string pass, decimal id_chi_nhanh)
{
CStoredProc v_cstore = new CStoredProc("check_login");
v_cstore.addNVarcharInputParam("@user", user);
v_cstore.addNVarcharInputParam("@pass", pass);
v_cstore.addDecimalInputParam("@id_chi_nhanh", id_chi_nhanh);
v_cstore.fillDataSetByCommand(this, v_ds);
}示例4: LayDanhSachHeSoLNS
public DataTable LayDanhSachHeSoLNS(string ip_str_filter, decimal ip_dc_thang, decimal ip_dc_nam)
{
CStoredProc v_cstore = new CStoredProc("pr_LNS_danh_sach_he_so_lns_GetAll");
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_cstore.addNVarcharInputParam("@ip_str_option", ip_str_filter);
v_cstore.addDecimalInputParam("@thang", ip_dc_thang);
v_cstore.addDecimalInputParam("@nam", ip_dc_nam);
v_cstore.fillDataSetByCommand(this, v_ds);
return v_ds.Tables[0];
}示例5: bc_giao_von_quy_bao_tri_theo_qd
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);
}示例6: FillDataset_chi_tiet_dm
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);
}示例7: get_id_trang_thai_lao_dong
public decimal get_id_trang_thai_lao_dong(decimal ip_dc_id_nhan_vien)
{
CStoredProc v_sp = new CStoredProc("pr_get_id_trang_thai_lao_dong_hien_tai");
v_sp.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
SqlParameter v_para = v_sp.addDecimalOutputParam("@op_dc_id_trang_thai_hien_tai", 0);
v_sp.ExecuteCommand(this);
return CIPConvert.ToDecimal(v_para.Value.ToString());
}示例8: FillDatasetGiaoKHByIdDonVi
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);
}示例9: bc_tra_cuu_giao_von_theo_du_an
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);
}示例10: get_don_gia_dinh_muc_and_so_luong_thong_ke
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);
}
}示例11: get_dm_uy_nhiem_chi_by_don_vi_va_ngay_thang
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);
}示例12: FillDataset_by_thang_nam_id_nhan_vien
public void FillDataset_by_thang_nam_id_nhan_vien(
DS_V_F419_BAO_CAO_LCD_NHAN_VIEN_THEO_THANG op_ds_bc_lcd_nv_theo_thang,
decimal ip_dc_thang,
decimal ip_dc_nam,
decimal ip_dc_id_nhan_vien,
decimal ip_co_xem_lich_su_giao_dich)
{
CStoredProc v_cstore = new CStoredProc("pr_f419_bao_cao_lcd_1_nhan_vien_theo_thang_nam");
v_cstore.addDecimalInputParam("@ip_dc_thang", ip_dc_thang);
v_cstore.addDecimalInputParam("@ip_dc_nam", ip_dc_nam);
v_cstore.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
v_cstore.addDecimalInputParam("@ip_co_xem_lich_su_giao_dich", ip_co_xem_lich_su_giao_dich);
v_cstore.fillDataSetByCommand(this, op_ds_bc_lcd_nv_theo_thang);
}开发者ID:assassinadal，项目名称:BKIProject-DichVuMatDat，代码行数:16，代码来源:US_V_F419_BAO_CAO_LCD_NHAN_VIEN_THEO_THANG.cs
示例13: get_co_so_dinh_muc_ap_dung_tu_ngay
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);
}
}示例14: get_grid_uy_nhiem_chi_dataset
public void get_grid_uy_nhiem_chi_dataset(DS_GRID_GIAI_NGAN op_ds
, decimal ip_dc_id_don_vi
, decimal ip_dc_id_dm_uy_nhiem_chi)
{
CStoredProc v_sp = new CStoredProc("pr_get_grid_uy_nhiem_chi");
v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_sp.addDecimalInputParam("@ip_dc_id_dm_uy_nhiem_chi", ip_dc_id_dm_uy_nhiem_chi);
v_sp.fillDataSetByCommand(this, op_ds);
}示例15: get_grid_giay_rut_du_toan
public void get_grid_giay_rut_du_toan(DataSet op_ds
, decimal ip_dc_id_don_vi
, decimal ip_dc_id_dm_uy_nhiem_chi
, decimal ip_dc_id_user
, string ip_str_is_nguon_ns)
{
CStoredProc v_sp = new CStoredProc("pr_F305_giay_rut_du_toan_ngan_sach");
v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_sp.addDecimalInputParam("@ip_dc_id_dm_uy_nhiem_chi", ip_dc_id_dm_uy_nhiem_chi);
v_sp.addDecimalInputParam("@ip_dc_id_user", ip_dc_id_user);
v_sp.addNVarcharInputParam("@ip_str_is_nguon_ns", ip_str_is_nguon_ns);
v_sp.fillDataSetByCommand(this, op_ds);
}