// 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());
}
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("\\", ""));
}