public static string GetList(string Two_WayChecklist_Id) { try { StringBuilder stbHtml = new StringBuilder(); string SqlBig = @"select Two_WayChecklistDetail_Id,Two_WayChecklist_Id,ParentId,TestQuestions_Num,TestQuestions_NumStr,TestQuestions_Type from Two_WayChecklistDetail where Two_WayChecklist_Id='" + Two_WayChecklist_Id + "' and ParentId='0' order by TestQuestions_Num,CreateTime"; string TempBig = "<tr><td colspan=\"7\"><b>{0}</b></td><td class='opera'><a href=\"javascript:EditData('{1}');\">修改</a></td></tr>"; string TempSmall = "<tr><td>{0}</td><td>{1}</td><td class='hide'>{7}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td id=\"TQ_{6}\">{8}</td><td class='opera'><a href=\"javascript:UpdateSmall('{6}');\">修改</a></td></tr>"; DataTable dtBig = Rc.Common.DBUtility.DbHelperSQL.Query(SqlBig).Tables[0]; DataTable dtAttr = new BLL_Two_WayChecklistDetailToAttr().GetList("Two_WayChecklist_Id='" + Two_WayChecklist_Id + "'").Tables[0]; //DataTable dtSmall = new BLL_Two_WayChecklistDetail().GetList("Two_WayChecklist_Id='" + Two_WayChecklist_Id + "'").Tables[0]; DataTable dtTQCount = Rc.Common.DBUtility.DbHelperSQL.Query(@"select Two_WayChecklistDetail_Id,count(1) as icount from Two_WayChecklistDetailToTestQuestions where Two_WayChecklist_Id='" + Two_WayChecklist_Id + "' group by Two_WayChecklistDetail_Id").Tables[0]; if (dtBig.Rows.Count > 0) { foreach (DataRow itemBig in dtBig.Rows) { stbHtml.AppendFormat(TempBig, itemBig["TestQuestions_NumStr"].ToString(), itemBig["Two_WayChecklistDetail_Id"].ToString(), itemBig["TestQuestions_Type"].ToString()); string SqlSmall = @"select t.* ,t3.D_Name from Two_WayChecklistDetail t left join TestPaper_FrameDetail t1 on t1.TestPaper_FrameDetail_Id =t.TestPaper_FrameDetail_Id left join Common_Dict t3 on t3.Common_Dict_ID = t1.TestQuestionType_Web where t.Two_WayChecklist_Id='" + Two_WayChecklist_Id + "' and t.ParentId='" + itemBig["Two_WayChecklistDetail_Id"].ToString() + "' order by t.TestQuestions_Num,t.CreateTime"; DataTable dtSmall = Rc.Common.DBUtility.DbHelperSQL.Query(SqlSmall).Tables[0]; DataRow[] drSmall = dtSmall.Select(); if (drSmall.Length > 0) { foreach (DataRow itemSmall in drSmall) { stbHtml.AppendFormat(TempSmall , itemSmall["TestQuestions_NumStr"].ToString() , itemSmall["D_Name"].ToString() , GetAttr(dtAttr, itemSmall["Two_WayChecklistDetail_Id"].ToString(), "2") , GetAttr(dtAttr, itemSmall["Two_WayChecklistDetail_Id"].ToString(), "1") , GetAttr(dtAttr, itemSmall["Two_WayChecklistDetail_Id"].ToString(), "3") , itemSmall["Score"].ToString().clearLastZero() , itemSmall["Two_WayChecklistDetail_Id"].ToString() , itemSmall["TestQuestions_Num"].ToString() , GetQuestions(dtTQCount, itemSmall["Two_WayChecklistDetail_Id"].ToString())); } } } stbHtml.Append("<span class=\"tag_add\" data-name=\"addKnowledge\" data-BigId=\"\" data-SmallId=\"\" data-question=\"1\">+</span>"); return(stbHtml.ToString()); } else { return("<tr><td colspan=\"100\"></td>暂无数据</tr>"); } } catch (Exception ex) { return("1"); } }
public static string GetSxxmbList(string Two_WayChecklist_Id) { try { #region 双向细目表 DataTable dt = new DataTable(); List <object> listReturn = new List <object>(); string strSql = string.Empty; string strSqlCount = string.Empty; //strSql = @"select * from Two_WayChecklistDetail where Two_WayChecklist_Id ='" + Two_WayChecklist_Id + "' and ParentId<>'0' order by TestQuestions_Num,CreateTime"; dt = new BLL_Two_WayChecklistDetail().GetList("Two_WayChecklist_Id ='" + Two_WayChecklist_Id + "' and ParentId<>'0' order by TestQuestions_Num,CreateTime").Tables[0]; //Rc.Common.DBUtility.DbHelperSQL.Query(strSql).Tables[0]; int inum = 0; DataTable dtAttr = new BLL_Two_WayChecklistDetailToAttr().GetList("Two_WayChecklist_Id='" + Two_WayChecklist_Id + "'").Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { inum++; listReturn.Add(new { inum = (i + 1), TestQuestions_NumStr = dt.Rows[i]["TestQuestions_NumStr"].ToString(), TestQuestions_Type = Rc.Common.EnumService.GetDescription <Rc.Model.Resources.TestQuestions_Type>(dt.Rows[i]["TestQuestions_Type"].ToString()), KnowledgePoint = GetAttr(dtAttr, dt.Rows[i]["Two_WayChecklistDetail_Id"].ToString(), "1").TrimEnd(','), TargetText = GetAttr(dtAttr, dt.Rows[i]["Two_WayChecklistDetail_Id"].ToString(), "2").TrimEnd(','), ComplexityText = GetAttr(dtAttr, dt.Rows[i]["Two_WayChecklistDetail_Id"].ToString(), "3").TrimEnd(','), Score = dt.Rows[i]["Score"].ToString().clearLastZero(), }); } #endregion if (inum > 0) { return(JsonConvert.SerializeObject(new { err = "null", list = listReturn })); } else { return(JsonConvert.SerializeObject(new { err = "暂无数据" })); } } catch (Exception) { return(JsonConvert.SerializeObject(new { err = "error"//ex.Message.ToString() })); } }
public static string GetTwo_WayChecklist(string Two_WayChecklist_Id) { try { #region 双向细目表 DataTable dt = new DataTable(); List <object> listReturn = new List <object>(); string strSql = string.Empty; string strSqlCount = string.Empty; strSql = @"select t.*,t4.Analysis,cd.D_Name from Two_WayChecklistDetail t inner join Two_WayChecklistDetail t2 on t.ParentId=t2.Two_WayChecklistDetail_Id left join Two_WayChecklist t3 on t3.Two_WayChecklist_Id=t.Two_WayChecklist_Id inner join TestPaper_Frame t4 on t3.ParentId=t4.TestPaper_Frame_Id inner join TestPaper_FrameDetail t5 on t5.TestPaper_FrameDetail_Id=t.TestPaper_FrameDetail_Id left join Common_Dict cd on cd.Common_Dict_ID=t5.TestQuestionType_Web where t.ParentId!='0' and t.Two_WayChecklist_Id='" + Two_WayChecklist_Id + "' order by t2.TestQuestions_Num,t2.CreateTime,t.TestQuestions_Num,t.CreateTime"; dt = Rc.Common.DBUtility.DbHelperSQL.Query(strSql).Tables[0]; int inum = 0; string Analysis = dt.Rows[0]["Analysis"].ToString(); DataTable dtAttr = new BLL_Two_WayChecklistDetailToAttr().GetList("Two_WayChecklist_Id='" + Two_WayChecklist_Id + "'").Tables[0]; DataTable dtTQCount = Rc.Common.DBUtility.DbHelperSQL.Query(@"select Two_WayChecklistDetail_Id,count(1) as icount from Two_WayChecklistDetailToTestQuestions where Two_WayChecklist_Id='" + Two_WayChecklist_Id + "' group by Two_WayChecklistDetail_Id").Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { inum++; listReturn.Add(new { inum = (i + 1), TestQuestions_NumStr = dt.Rows[i]["TestQuestions_NumStr"].ToString(), TestQuestions_Type = dt.Rows[i]["D_Name"].ToString(), TargetText = GetAttr(dtAttr, dt.Rows[i]["Two_WayChecklistDetail_Id"].ToString(), "2").TrimEnd(','), KnowledgePoint = GetAttr(dtAttr, dt.Rows[i]["Two_WayChecklistDetail_Id"].ToString(), "1").TrimEnd(','), ComplexityText = GetAttr(dtAttr, dt.Rows[i]["Two_WayChecklistDetail_Id"].ToString(), "3").TrimEnd(','), Score = dt.Rows[i]["Score"].ToString().clearLastZero(), SumQuestions = GetQuestions(dtTQCount, dt.Rows[i]["Two_WayChecklistDetail_Id"].ToString()), }); } #endregion if (inum > 0) { return(JsonConvert.SerializeObject(new { err = "null", list = listReturn, Analysis = Analysis })); } else { return(JsonConvert.SerializeObject(new { err = "暂无数据" })); } } catch (Exception) { return(JsonConvert.SerializeObject(new { err = "error"//ex.Message.ToString() })); } }