public string get_ma_dat_hang_tiep_theo() { string v_output = ""; CStoredProc v_cstore = new CStoredProc("pr_get_ma_don_hang"); SqlParameter v_result = v_cstore.addNVarcharOutputParam("@MA_DON_HANG", v_output); v_cstore.ExecuteCommand(this); return(v_result.Value.ToString()); }
public void FillDatasetByID(DS_DM_CHUC_VU op_ds, decimal ip_dc_id, ref string op_str) { CStoredProc v_cstore = new CStoredProc("pr_DM_CHUC_VU_filldataset_by_id"); v_cstore.addDecimalInputParam("@ID", ip_dc_id); SqlParameter v_sql = v_cstore.addNVarcharOutputParam("@TEN", op_str); v_cstore.fillDataSetByCommand(this, op_ds); op_str = v_sql.Value.ToString(); }
public void FillDatasetByID(DS_CM_DM_TU_DIEN v_op_ds, decimal ip_dc_id, ref string op_str_ten) { CStoredProc v_cstore = new CStoredProc("pr_CM_DM_TU_DIEN_search_by_id"); v_cstore.addDecimalInputParam("@ID", ip_dc_id); SqlParameter v_sql = v_cstore.addNVarcharOutputParam("@TEN", op_str_ten); v_cstore.fillDataSetByCommand(this, v_op_ds); op_str_ten = v_sql.Value.ToString(); }
public string get_ten_nguoi_su_dung(decimal v_id) { string v_ten = ""; CStoredProc v_cstore = new CStoredProc("get_ten_nguoi_su_dung"); v_cstore.addNVarcharInputParam("@id", v_id); SqlParameter v_result = v_cstore.addNVarcharOutputParam("@ten", v_ten); v_cstore.ExecuteCommand(this); return((string)v_result.Value); }