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()
}));
}
}
