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