Exemple #1
0
    public string GroupNameLoadByActivity(string ActivityId)
    {
        string    jsonString = "";
        DataTable dtResult;

        DefaultManager.DBReturnCode retCode = DefaultManager.GroupNameLoadByActivity(ActivityId, out dtResult);;
        if (DefaultManager.DBReturnCode.SUCCESS == retCode)
        {
            jsonString = "";
            foreach (DataRow dr in dtResult.Rows)
            {
                jsonString += "{";
                foreach (DataColumn dc in dtResult.Columns)
                {
                    jsonString += "\"" + dc.ColumnName + "\":\"" + escapejosndata(dr[dc].ToString().Replace("\r\n", " ")) + "\",";
                }
                jsonString = jsonString.Trim(',') + "},";
            }
            jsonString = "{\"Session\":\"1\",\"retCode\":\"1\",\"MyGroup\":[" + jsonString.Trim(',') + "]}";
            dtResult.Dispose();
            return(jsonString);
        }
        else
        {
            return("{\"Session\":\"1\",\"retCode\":\"0\"}");
        }
    }