/// <summary>
/// 获取条件项目树，从根节点为0的开始
/// </summary>
/// <param name="ParentId">父节点</param>
/// <param name="strStandardId">评价标准ID</param>
public void GetEvaluConChild(string ParentId, string strStandardId)
{
DataTable dtConInfor = new DataTable();
TBaseEvaluationConInfoVo coninfo = new TBaseEvaluationConInfoVo();
coninfo.STANDARD_ID = strStandardId;
coninfo.IS_DEL = "0";
coninfo.PARENT_ID = ParentId;
dtConInfor = new TBaseEvaluationConInfoLogic().SelectByTable(coninfo);
DataView dv = new DataView(dtConInfor);
dv.Sort = " PARENT_ID ASC";
//排序结果 重载
dtConInfor = dv.ToTable();
for (int i = 0; i < dtConInfor.Rows.Count; i++)
{
string fisrt = "false";
nodes = "{ id:'" + dtConInfor.Rows[i]["ID"] + "', pId:'" + dtConInfor.Rows[i]["PARENT_ID"] + "', code:'" + dtConInfor.Rows[i]["CONDITION_CODE"] + "', name:'" + dtConInfor.Rows[i]["CONDITION_NAME"] + "',STANDARD_ID:'" + dtConInfor.Rows[i]["STANDARD_ID"] + "',CONDITION_REMARK:'" + dtConInfor.Rows[i]["CONDITION_REMARK"] + "'";
if (dtConInfor.Rows[i]["PARENT_ID"].ToString() == "0" && i == 0)
{
fisrt = "true";
nodes += ", open:true";
}
nodes += ",first:'" + fisrt + "'";
nodes += "}";
treenodes.Add(nodes);
//循环方法，取当前行的ID值作为父ID 查找儿子，依次循环 达到无限
GetEvaluConChild(dtConInfor.Rows[i]["ID"].ToString(), strStandardId);
}
varNodes = "[" + String.Join(",\r\n", treenodes.ToArray()) + "]";
}
/// <summary>
/// 绑定子节点，获取json数据
/// </summary>
/// <param name="strST_ID">标准id</param>
/// <param name="strParentPostID">父节点的ID</param>
private void BindTreeNodes(string strST_ID, string strParentID, string strParentName)
{
TBaseEvaluationConInfoVo objStCon = new TBaseEvaluationConInfoVo();
objStCon.IS_DEL = "0";
objStCon.STANDARD_ID = strST_ID;
objStCon.PARENT_ID = strParentID;
DataTable dt = new TBaseEvaluationConInfoLogic().SelectByTable(objStCon);
DataRow[] ds = dt.Select();
if (ds.Length < 1)
{
return;
}
stData.Append(",children:[");
for (int i = 0; i < ds.Length; i++)
{
DataRow dr = ds[i];
stData.Append("{");
stData.Append("name:\"" + dr[TBaseEvaluationConInfoVo.CONDITION_NAME_FIELD].ToString() + "\"");
stData.Append(",");
stData.Append("id:\"" + dr[TBaseEvaluationConInfoVo.ID_FIELD].ToString() + "\"");
stData.Append(",");
stData.Append("pId:\"" + strParentID + "\"");
stData.Append(",");
stData.Append("pCode:\"" + strParentName + "\"");
stData.Append(",");
stData.Append("IsSt:\"0\"");
stData.Append(",");
stData.Append("open:false");
BindTreeNodes(strST_ID, dr[TBaseEvaluationConInfoVo.ID_FIELD].ToString(), strParentName);// 绑定子节点，获取json数据
stData.Append("}");
if (i != ds.Length - 1)
{
stData.Append(",");
}
}
stData.Append("]");
}
//获取数据
private void GetData(string strID)
{
TBaseCompanyPointVo objPoint = new TBaseCompanyPointLogic().Details(strID);
TBaseEvaluationConInfoLogic logicCon = new TBaseEvaluationConInfoLogic();
TBaseEvaluationInfoLogic logicSt = new TBaseEvaluationInfoLogic();
//按行、地、国标优先顺序进行标准的选定
//国标条件项
if (objPoint.NATIONAL_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.NATIONAL_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.NATIONAL_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidNATIONAL_ST_CON = objCon.ID;
}
//地标条件项
if (objPoint.LOCAL_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.LOCAL_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.LOCAL_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidLOCAL_ST_CON = objCon.ID;
}
//行标条件项
if (objPoint.INDUSTRY_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.INDUSTRY_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.INDUSTRY_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidINDUSTRY_ST_CON = objCon.ID;
}
string strJson = ToJson(objPoint);
Response.Write(strJson);
Response.End();
}
//获取数据
private void GetData(string strID)
{
TBaseCompanyPointVo objPoint = new TBaseCompanyPointLogic().Details(strID);
TBaseEvaluationConInfoLogic logicCon = new TBaseEvaluationConInfoLogic();
TBaseEvaluationInfoLogic logicSt = new TBaseEvaluationInfoLogic();
if (objPoint.NATIONAL_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.NATIONAL_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.NATIONAL_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidNATIONAL_ST_CON = objCon.ID;
}
if (objPoint.LOCAL_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.LOCAL_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.LOCAL_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidLOCAL_ST_CON = objCon.ID;
}
if (objPoint.INDUSTRY_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.INDUSTRY_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.INDUSTRY_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidINDUSTRY_ST_CON = objCon.ID;
}
objPoint.CREATE_DATE = objPoint.CREATE_DATE.Replace(" 0:00:00", "");
string strJson = ToJson(objPoint);
Response.Write(strJson);
Response.End();
}
//获取数据
private void GetData(string strID)
{
TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointLogic().Details(strID);
TBaseEvaluationConInfoLogic logicCon = new TBaseEvaluationConInfoLogic();
TBaseEvaluationInfoLogic logicSt = new TBaseEvaluationInfoLogic();
if (objPoint.NATIONAL_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.NATIONAL_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.NATIONAL_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidNATIONAL_ST_CON = objCon.ID;
}
if (objPoint.LOCAL_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.LOCAL_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.LOCAL_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidLOCAL_ST_CON = objCon.ID;
}
if (objPoint.INDUSTRY_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.INDUSTRY_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.INDUSTRY_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidINDUSTRY_ST_CON = objCon.ID;
}
string strJson = ToJson(objPoint);
Response.Write(strJson);
Response.End();
}
/// <summary>
/// 获取标准、依据名称
/// </summary>
/// <param name="strEvaluationID">条件项ID</param>
/// <returns></returns>
protected string getStandardName(string strEvaluationID)
{
string strStId = ""; //标准ID
string strConText = ""; //所有节点名称
//获得条件项信息
TBaseEvaluationConInfoVo objEvaluationCon = new TBaseEvaluationConInfoVo();
objEvaluationCon.IS_DEL = "0";
objEvaluationCon.ID = strEvaluationID;
objEvaluationCon = new TBaseEvaluationConInfoLogic().Details(objEvaluationCon);
//遍历条件项，构造所有条件项名称
while (objEvaluationCon.PARENT_ID.Length > 0 && objEvaluationCon.PARENT_ID != "0")
{
strConText = objEvaluationCon.CONDITION_NAME + strConText;
objEvaluationCon = new TBaseEvaluationConInfoLogic().Details(objEvaluationCon.PARENT_ID);
strStId = objEvaluationCon.STANDARD_ID;
}
//获得评价标准名称和编码
TBaseEvaluationInfoVo objStandard = new TBaseEvaluationInfoLogic().Details(strStId);
strConText = "根据《" + objStandard.STANDARD_NAME + "》（" + objStandard.STANDARD_CODE + "）中" + strConText + "，";
return(strConText);
}
public string getTreeInfo(string strMonitorId)
{
//组建DataTable
DataTable objTable = new DataTable();
//ID
objTable.Columns.Add("ID", System.Type.GetType("System.String"));
//评价标准ID
objTable.Columns.Add("STANDARD_ID", System.Type.GetType("System.String"));
//评价标准代码
objTable.Columns.Add("STANDARD_CODE", System.Type.GetType("System.String"));
//条件项代码
objTable.Columns.Add("CONDITION_CODE", System.Type.GetType("System.String"));
//名称
objTable.Columns.Add("NAME", System.Type.GetType("System.String"));
//父节点ID
objTable.Columns.Add("PARENT_ID", System.Type.GetType("System.String"));
//类型,0为评价标准，1为条件项
objTable.Columns.Add("TYPE", System.Type.GetType("System.String"));
//获取评价标准信息
TBaseEvaluationInfoVo TBaseEvaluationInfoVo = new TBaseEvaluationInfoVo();
TBaseEvaluationInfoVo.MONITOR_ID = strMonitorId;
TBaseEvaluationInfoVo.IS_DEL = "0";
DataTable dtEvaluationInfo = new TBaseEvaluationInfoLogic().SelectByTable(TBaseEvaluationInfoVo);
//获取评价标准条件项信息
TBaseEvaluationConInfoVo TBaseEvaluationConInfoVo = new TBaseEvaluationConInfoVo();
TBaseEvaluationConInfoVo.IS_DEL = "0";
DataTable dtEvaluationConInfo = new TBaseEvaluationConInfoLogic().SelectByTable(TBaseEvaluationConInfoVo);
//遍历评价标准信息
foreach (DataRow row in dtEvaluationInfo.Rows)
{
DataRow objTableNewRow = objTable.NewRow();
string strStandardId = row["ID"].ToString();
objTableNewRow["ID"] = strStandardId;
objTableNewRow["STANDARD_ID"] = strStandardId;
objTableNewRow["STANDARD_CODE"] = row["STANDARD_CODE"].ToString();
objTableNewRow["NAME"] = row["STANDARD_NAME"].ToString();
objTableNewRow["PARENT_ID"] = "0";
objTableNewRow["TYPE"] = "0";
objTable.Rows.Add(objTableNewRow);
/*//遍历条件项
* foreach (DataRow rowCon in dtEvaluationConInfo.Rows)
* {
* if (rowCon["STANDARD_ID"].ToString() == strStandardId && isExist(dtEvaluationConInfo, rowCon["PARENT_ID"].ToString()))
* {
* DataRow objTableConNewRow = objTable.NewRow();
* objTableConNewRow["ID"] = rowCon["ID"].ToString();
* objTableConNewRow["STANDARD_ID"] = rowCon["STANDARD_ID"].ToString();
* objTableConNewRow["STANDARD_CODE"] = row["STANDARD_CODE"].ToString();
* objTableConNewRow["CONDITION_CODE"] = rowCon["CONDITION_CODE"].ToString();
* objTableConNewRow["NAME"] = rowCon["CONDITION_NAME"].ToString();
* if (rowCon["PARENT_ID"].ToString() == "0")
* objTableConNewRow["PARENT_ID"] = strStandardId;
* else
* objTableConNewRow["PARENT_ID"] = rowCon["PARENT_ID"].ToString();
* objTableConNewRow["TYPE"] = "1";
* objTable.Rows.Add(objTableConNewRow);
* }
* }*/
}
//将DataTable序列化之后返回
return(DataTableToJson(objTable));
}
