本文整理汇总了C#中IP.Core.IPUserService.CStoredProc类的典型用法代码示例。如果您正苦于以下问题:C# CStoredProc类的具体用法?C# CStoredProc怎么用?C# CStoredProc使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
CStoredProc类属于IP.Core.IPUserService命名空间,在下文中一共展示了CStoredProc类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: FillDatasetWithProc
public void FillDatasetWithProc(DataSet op_ds, string ip_str_table_name, string ip_str_column_name)
{
CStoredProc v_cstore = new CStoredProc("get_data_to_dataset_with_table_name_and_column_name");
v_cstore.addNVarcharInputParam("@TABLE_NAME", ip_str_table_name);
v_cstore.addNVarcharInputParam("@COLUMN_NAME", ip_str_column_name);
v_cstore.fillDataSetByCommand(this, op_ds);
}
开发者ID:anhphamkstn,项目名称:BKI_DVMC,代码行数:7,代码来源:WinFormControls.cs
示例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);
}
开发者ID:assassinadal,项目名称:BKIProject-DichVuMatDat,代码行数:7,代码来源:US_BAO_CAO_THAM_SO_BANG_LUONG.cs
示例3: 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);
}
开发者ID:anhphamkstn,项目名称:DVMC,代码行数:7,代码来源:WebControl.cs
示例4: 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);
}
开发者ID:nguyenducvan,项目名称:quan_ly_hoc_tap,代码行数:8,代码来源:WinFormControls.cs
示例5: FillDatasetCBO
internal void FillDatasetCBO(DataSet op_ds, string ip_str_table_name, string ip_str_value_field, string ip_str_display_field, string ip_str_condition)
{
CStoredProc v_cstore = new CStoredProc("get_data_for_cbo");
v_cstore.addNVarcharInputParam("@TABLE_NAME", ip_str_table_name);
v_cstore.addNVarcharInputParam("@COLUMN_VALUE", ip_str_value_field);
v_cstore.addNVarcharInputParam("@COLUMN_DISPLAY", ip_str_display_field);
v_cstore.addNVarcharInputParam("@CONDITION", ip_str_condition);
v_cstore.fillDataSetByCommand(this, op_ds);
}
开发者ID:anhphamkstn,项目名称:BKI_DVMC,代码行数:9,代码来源:WinFormControls.cs
示例6: load_data_grid
private void load_data_grid(string ip_str_tu_khoa)
{
DS_DM_DAT v_ds_dm_dat = new DS_DM_DAT();
if (ip_str_tu_khoa.Equals(String.Empty))
{
m_us_dm_dat.FillDataset(v_ds_dm_dat);
}
else
{
CStoredProc v_cstore = new CStoredProc("pr_DM_DAT_Search");
v_cstore.addNVarcharInputParam("@TU_KHOA", ip_str_tu_khoa);
v_cstore.fillDataSetByCommand(m_us_dm_dat, v_ds_dm_dat);
}
m_grv_danh_sach_nha.DataSource = v_ds_dm_dat.DM_DAT;
m_grv_danh_sach_nha.DataBind();
}
开发者ID:chutinhha,项目名称:bki-quan-ly-tai-san,代码行数:17,代码来源:Default.aspx.cs
示例7: ExecuteFuntionSql
public static string ExecuteFuntionSql(string ip_str_funtion_name, params object[] parameters)
{
string v_str_select = "select dbo." + ip_str_funtion_name;
string v_str_param = "";
foreach(object item in parameters)
{
v_str_param = v_str_param + "'" + item.ToString()+ "'" + ",";
}
string v_query = v_str_select + "(" + v_str_param;
if(parameters.Length > 0)
{
v_query = v_query.Substring(0, v_query.LastIndexOf(","));
}
v_query = v_query + ")";
CStoredProc v_sp = new CStoredProc("pr_execute_funtion_sql");
v_sp.addNVarcharInputParam("@ip_str_query", v_query);
DataSet v_ds = new DataSet();
v_ds.Tables.Add();
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
v_sp.fillDataSetByCommand(v_us, v_ds);
return v_ds.Tables[0].Rows[0][0].ToString();
}
开发者ID:assassinadal,项目名称:BKIProject-DichVuMatDat,代码行数:24,代码来源:ExcuteFuntion.cs
示例8: FillDatasetGDChiTietChucVu
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);
}
开发者ID:anhphamkstn,项目名称:BKI_DVMC,代码行数:6,代码来源:WinFormControls.cs
示例9: FillDatasetWithTableName
internal void FillDatasetWithTableName(DataSet op_ds, string ip_str_table_name)
{
CStoredProc v_cstore = new CStoredProc("get_data_from_table");
v_cstore.addNVarcharInputParam("@TABLE_NAME", ip_str_table_name);
v_cstore.fillDataSetByCommand(this, op_ds);
}
开发者ID:anhphamkstn,项目名称:BKI_DVMC,代码行数:6,代码来源:WinFormControls.cs
示例10: FillDataSet_Load_data_to_grid_danh_muc_don_vi_by_key_word
public void FillDataSet_Load_data_to_grid_danh_muc_don_vi_by_key_word(
DS_DM_DON_VI op_ds_don_vi
, decimal v_dc_id_loai_don_vi
, string v_str_user_name
, string v_str_key_word)
{
CStoredProc cstored = new CStoredProc("pr_DM_DON_VI_Load_to_grid_danh_muc_by_key_word");
cstored.addDecimalInputParam("@ip_dc_loai_don_vi", v_dc_id_loai_don_vi);
cstored.addNVarcharInputParam("@ip_str_user_name", v_str_user_name);
cstored.addNVarcharInputParam("@ip_str_key_word", v_str_key_word);
cstored.fillDataSetByCommand(this, op_ds_don_vi);
}
开发者ID:chutinhha,项目名称:bki-quan-ly-tai-san,代码行数:12,代码来源:US_DM_DON_VI.cs
示例11: FillDatasetByQueryString
public void FillDatasetByQueryString(
WebDS.DS_DM_DON_VI op_ds_don_vi
, string v_dc_id_loai_don_vi)
{
CStoredProc cstored = new CStoredProc("pr_DM_DON_VI_grid");
cstored.addDecimalInputParam("@ID_LOAI_DON_VI", v_dc_id_loai_don_vi);
cstored.fillDataSetByCommand(this, op_ds_don_vi);
}
开发者ID:chutinhha,项目名称:bki-quan-ly-tai-san,代码行数:8,代码来源:US_DM_DON_VI.cs
示例12: 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);
}
开发者ID:tudm,项目名称:QuanLyHanhChinh,代码行数:9,代码来源:US_RPT_BC_CHI_TIET_DM.cs
示例13: LayDanhSachHopDongThayDoiHeSoLNS
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];
}
开发者ID:assassinadal,项目名称:BKIProject-DichVuMatDat,代码行数:11,代码来源:US_GD_HE_SO_LNS.cs
示例14: FillDatasetWithQuery
internal void FillDatasetWithQuery(DataSet op_ds, string ip_query)
{
CStoredProc v_cstore = new CStoredProc("pr_fill_ds_with_query");
v_cstore.addNVarcharInputParam("@SQL_QUERY", ip_query);
v_cstore.fillDataSetByCommand(this, op_ds);
}
开发者ID:anhphamkstn,项目名称:BKI_DVMC,代码行数:6,代码来源:WinFormControls.cs
示例15: FillDatasetChungChiHetHan
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);
}
开发者ID:anhphamkstn,项目名称:BKI_DVMC,代码行数:6,代码来源:WinFormControls.cs
示例16: FillData2DatasetGiaiNgan
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);
}
开发者ID:nguyendanhtu,项目名称:bki-quan-ly-du-toan,代码行数:25,代码来源:US_V_GD_GIAI_NGAN_QBT.cs
示例17: 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);
}
开发者ID:nguyendanhtu,项目名称:bki-quan-ly-du-toan,代码行数:21,代码来源:US_V_GD_GIAI_NGAN_QBT.cs
示例18: LayDanhSachNhanVienKiemNhiem
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;
}
开发者ID:assassinadal,项目名称:BKIProject-DichVuMatDat,代码行数:11,代码来源:US_V_GD_CONG_TAC.cs
示例19: LayDanhSachNhanVienChuaCoLNS
public DataTable LayDanhSachNhanVienChuaCoLNS()
{
CStoredProc v_cstore = new CStoredProc("pr_LNS_danh_sach_nhan_vien_khong_co_lns_GetAll");
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_cstore.fillDataSetByCommand(this, v_ds);
return v_ds.Tables[0];
}
开发者ID:assassinadal,项目名称:BKIProject-DichVuMatDat,代码行数:8,代码来源:US_GD_HE_SO_LNS.cs
示例20: 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);
}
开发者ID:nguyendanhtu,项目名称:bki-quan-ly-du-toan,代码行数:10,代码来源:US_V_GD_GIAO_VON_QBT.cs
注:本文中的IP.Core.IPUserService.CStoredProc类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论