private void GetBugIssueDetail(HttpContext context) { string BI_ID = context.Request["BI_ID"]; BLL.V_BugDetail bll = new BLL.V_BugDetail(); DataSet ds = bll.GetList("*", "BI_ID=" + BI_ID); List <Model.V_BugDetail> list = new List <Model.V_BugDetail>(); DataRow dr = ds.Tables[0].Rows[0]; list.Add(new Model.V_BugDetail() { TT_Title = dr["TT_Title"].ToString(), S_ScenarioName = dr["S_ScenarioName"].ToString(), SR_RoleTitle = dr["SR_RoleTitle"].ToString(), BI_CaseNumber = dr["BI_CaseNumber"].ToString(), BI_EnvironmentServer = dr["BI_EnvironmentServer"].ToString(), BI_TopologyName = dr["BI_TopologyName"].ToString(), BI_UpdateTime = dr["BI_UpdateTime"].ToString(), BI_CloseTime = dr["BI_CloseTime"].ToString(), BI_Owner = Convert.ToInt32(dr["BI_Owner"]), BI_Status = dr["BI_Status"].ToString(), BI_Priority = dr["BI_Priority"].ToString() }); JavaScriptSerializer jss = new JavaScriptSerializer(); string strJson = jss.Serialize(list).TrimStart('[').TrimEnd(']'); context.Response.Write(strJson); }
private void QueryBugIssueListGroup(HttpContext context) { string strKeyWord = context.Request["keyWord"]; BLL.V_BugDetail bll = new BLL.V_BugDetail(); DataSet ds = new DataSet(); string strFields = "BI_ID,BI_Title,BI_Type,BI_Status,BI_CreateDate,BI_Priority,U_nickname"; if (string.IsNullOrEmpty(strKeyWord)) { ds = bll.GetList(strFields, "BI_Status='Open'"); } else if (strKeyWord.ToLower() == "@all") { ds = bll.GetList(strFields, ""); } else { ds = bll.GetList(strFields, string.Format("BI_Title like '%{0}%'", strKeyWord)); } List <Model.V_BugDetailForBugListGroup> list = new List <Model.V_BugDetailForBugListGroup>(); foreach (DataRow dr in ds.Tables[0].Rows) { list.Add(new Model.V_BugDetailForBugListGroup() { BI_ID = Convert.ToInt32(dr["BI_ID"]), BI_Title = dr["BI_Title"].ToString(), BI_Type = dr["BI_Type"].ToString(), BI_Status = dr["BI_Status"].ToString(), BI_CreateDate = dr["BI_CreateDate"].ToString(), BI_Priority = dr["BI_Priority"].ToString(), U_nickname = dr["U_nickname"].ToString() }); } JavaScriptSerializer jss = new JavaScriptSerializer(); string strJson = jss.Serialize(list); context.Response.Write(strJson); }