예제 #1
0
        // GET api/values/5
        public string Get(int id)
        {
            ClassLoadFieldHelper ClsLoadFieldHelper = new ClassLoadFieldHelper();

            ClsLoadFieldHelper.fAddSqlParameter("@username", id);
            ClsLoadFieldHelper.fAddSqlParameter("@ContentType", "");

            ClsLoadFieldHelper.fBuildDataSet("stp_wf_rss_scs_API_GridInformationTable");
            return(DataTableToJSON(ClsLoadFieldHelper.fGetDataSet().Tables[0]).ToString());
        }
예제 #2
0
        public static object LoadStaffInfo(string psStaffID)
        {
            ClassLoadFieldHelper ClsLoadFieldHelper = new ClassLoadFieldHelper();

            ClsLoadFieldHelper.fAddSqlParameter("@staff_id", psStaffID);
            ClsLoadFieldHelper.fAddSqlParameter("@lang", "sc");

            ClsLoadFieldHelper.fBuildDataSet("stp_getStaffInfo");

            return(WebAPI.Models.LIB_JSON.DataTableToJSON_JavaScriptSerializer(ClsLoadFieldHelper.fGetDataSet().Tables[0]).ToString().Replace("\\", ""));
        }