/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tBaseEvaluationConInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TBaseEvaluationConInfoVo tBaseEvaluationConInfo, int iIndex, int iCount)
{
string strSQL = " select * from T_BASE_EVALUATION_CON_INFO {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tBaseEvaluationConInfo));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseEvaluationConInfo_UpdateSet">UpdateSet用户对象</param>
/// <param name="tBaseEvaluationConInfo_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseEvaluationConInfoVo tBaseEvaluationConInfo_UpdateSet, TBaseEvaluationConInfoVo tBaseEvaluationConInfo_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tBaseEvaluationConInfo_UpdateSet, TBaseEvaluationConInfoVo.T_BASE_EVALUATION_CON_INFO_TABLE);
strSQL += this.BuildWhereStatement(tBaseEvaluationConInfo_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <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()) + "]";
}
public static string CreateData(string strPARENT_ID, string strSTANDARD_ID, string strCONDITION_CODE, string strCONDITION_NAME, string strCONDITION_REMARK)
{
string result = "";
TBaseEvaluationConInfoVo objConVo = new TBaseEvaluationConInfoVo();
objConVo.ID = GetSerialNumber("t_base_evaluation_con_info_id");
objConVo.PARENT_ID = strPARENT_ID;
objConVo.STANDARD_ID = strSTANDARD_ID;
if (!String.IsNullOrEmpty(strCONDITION_CODE))
{
objConVo.CONDITION_CODE = strCONDITION_CODE;
}
objConVo.CONDITION_NAME = strCONDITION_NAME;
objConVo.CONDITION_REMARK = strCONDITION_REMARK;
objConVo.IS_DEL = "0";
if (new TBaseEvaluationConInfoLogic().Create(objConVo))
{
result = objConVo.ID;
string strMessage = new i3.View.PageBase().LogInfo.UserInfo.USER_NAME + "新增评价标准条件项" + objConVo.ID + "成功";
new i3.View.PageBase().WriteLog(i3.ValueObject.ObjectBase.LogType.AddEvaluationConInfo, "", strMessage);
}
return(result);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseEvaluationConInfo">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseEvaluationConInfoVo tBaseEvaluationConInfo)
{
string strSQL = SqlHelper.BuildUpdateExpress(tBaseEvaluationConInfo, TBaseEvaluationConInfoVo.T_BASE_EVALUATION_CON_INFO_TABLE);
strSQL += string.Format(" where ID='{0}' ", tBaseEvaluationConInfo.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TBaseEvaluationConInfoVo tBaseEvaluationConInfo)
{
string strSQL = "delete from T_BASE_EVALUATION_CON_INFO ";
strSQL += this.BuildWhereStatement(tBaseEvaluationConInfo);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
public static string DelData(string strID)
{
string result = "false";
TBaseEvaluationConInfoVo objtec = new TBaseEvaluationConInfoVo();
objtec.ID = strID;
objtec.IS_DEL = "1";
if (new TBaseEvaluationConInfoLogic().Edit(objtec))
{
result = "true";
string strMessage = new i3.View.PageBase().LogInfo.UserInfo.USER_NAME + "删除评价标准条件项" + objtec.ID + "成功";
new PageBase().WriteLog(i3.ValueObject.ObjectBase.LogType.EditEvaluationConInfo, "", strMessage);
}
return(result);
}
public static string EditDataCon(string strID, string strPARENT_ID, string strSTANDARD_ID, string strCONDITION_CODE, string strCONDITION_NAME, string strCONDITION_REMARK)
{
string result = "false";
TBaseEvaluationConInfoVo objConVo = new TBaseEvaluationConInfoVo();
objConVo.ID = strID;
objConVo.PARENT_ID = strPARENT_ID;
objConVo.STANDARD_ID = strSTANDARD_ID;
objConVo.CONDITION_CODE = strCONDITION_CODE;
objConVo.CONDITION_NAME = strCONDITION_NAME;
objConVo.CONDITION_REMARK = strCONDITION_REMARK;
if (new TBaseEvaluationConInfoLogic().Edit(objConVo))
{
result = "true";
string strMessage = new i3.View.PageBase().LogInfo.UserInfo.USER_NAME + "编辑评价标准条件项" + objConVo.ID + "成功";
new i3.View.PageBase().WriteLog(i3.ValueObject.ObjectBase.LogType.EditEvaluationConInfo, "", strMessage);
}
return(result);
}
/// <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);
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TBaseEvaluationConInfoVo tBaseEvaluationConInfo)
{
return(access.Delete(tBaseEvaluationConInfo));
}
public TBaseEvaluationConInfoLogic(TBaseEvaluationConInfoVo _tBaseEvaluationConInfo)
{
tBaseEvaluationConInfo = _tBaseEvaluationConInfo;
access = new TBaseEvaluationConInfoAccess();
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tBaseEvaluationConInfo">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TBaseEvaluationConInfoVo tBaseEvaluationConInfo)
{
return(access.GetSelectResultCount(tBaseEvaluationConInfo));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tBaseEvaluationConInfo">对象条件</param>
/// <returns>对象</returns>
public TBaseEvaluationConInfoVo Details(TBaseEvaluationConInfoVo tBaseEvaluationConInfo)
{
return(access.Details(tBaseEvaluationConInfo));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tBaseEvaluationConInfo"></param>
/// <returns></returns>
public DataTable SelectByTable(TBaseEvaluationConInfoVo tBaseEvaluationConInfo)
{
string strSQL = "select * from T_BASE_EVALUATION_CON_INFO " + this.BuildWhereStatement(tBaseEvaluationConInfo);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tBaseEvaluationConInfo">对象</param>
/// <returns>是否成功</returns>
public bool Create(TBaseEvaluationConInfoVo tBaseEvaluationConInfo)
{
string strSQL = SqlHelper.BuildInsertExpress(tBaseEvaluationConInfo, TBaseEvaluationConInfoVo.T_BASE_EVALUATION_CON_INFO_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tBaseEvaluationConInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TBaseEvaluationConInfoVo> SelectByObject(TBaseEvaluationConInfoVo tBaseEvaluationConInfo, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_BASE_EVALUATION_CON_INFO " + this.BuildWhereStatement(tBaseEvaluationConInfo));
return(SqlHelper.ExecuteObjectList(tBaseEvaluationConInfo, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tBaseEvaluationConInfo">对象条件</param>
/// <returns>对象</returns>
public TBaseEvaluationConInfoVo Details(TBaseEvaluationConInfoVo tBaseEvaluationConInfo)
{
string strSQL = String.Format("select * from T_BASE_EVALUATION_CON_INFO " + this.BuildWhereStatement(tBaseEvaluationConInfo));
return(SqlHelper.ExecuteObject(new TBaseEvaluationConInfoVo(), strSQL));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tBaseEvaluationConInfo">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TBaseEvaluationConInfoVo tBaseEvaluationConInfo)
{
string strSQL = "select Count(*) from T_BASE_EVALUATION_CON_INFO " + this.BuildWhereStatement(tBaseEvaluationConInfo);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseEvaluationConInfo">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseEvaluationConInfoVo tBaseEvaluationConInfo)
{
return(access.Edit(tBaseEvaluationConInfo));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tBaseEvaluationConInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TBaseEvaluationConInfoVo tBaseEvaluationConInfo, int iIndex, int iCount)
{
return(access.SelectByTable(tBaseEvaluationConInfo, iIndex, iCount));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tBaseEvaluationConInfo"></param>
/// <returns></returns>
public DataTable SelectByTable(TBaseEvaluationConInfoVo tBaseEvaluationConInfo)
{
return(access.SelectByTable(tBaseEvaluationConInfo));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseEvaluationConInfo_UpdateSet">UpdateSet用户对象</param>
/// <param name="tBaseEvaluationConInfo_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseEvaluationConInfoVo tBaseEvaluationConInfo_UpdateSet, TBaseEvaluationConInfoVo tBaseEvaluationConInfo_UpdateWhere)
{
return(access.Edit(tBaseEvaluationConInfo_UpdateSet, tBaseEvaluationConInfo_UpdateWhere));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tBaseEvaluationConInfo">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TBaseEvaluationConInfoVo> SelectByObject(TBaseEvaluationConInfoVo tBaseEvaluationConInfo, int iIndex, int iCount)
{
return(access.SelectByObject(tBaseEvaluationConInfo, iIndex, iCount));
}
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));
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tBaseEvaluationConInfo"></param>
/// <returns></returns>
public string BuildWhereStatement(TBaseEvaluationConInfoVo tBaseEvaluationConInfo)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tBaseEvaluationConInfo)
{
//ID
if (!String.IsNullOrEmpty(tBaseEvaluationConInfo.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tBaseEvaluationConInfo.ID.ToString()));
}
//评价标准ID
if (!String.IsNullOrEmpty(tBaseEvaluationConInfo.STANDARD_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND STANDARD_ID = '{0}'", tBaseEvaluationConInfo.STANDARD_ID.ToString()));
}
//条件项编号
if (!String.IsNullOrEmpty(tBaseEvaluationConInfo.CONDITION_CODE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CONDITION_CODE = '{0}'", tBaseEvaluationConInfo.CONDITION_CODE.ToString()));
}
//父节点ID，如果为根节点，则父节点为“0”
if (!String.IsNullOrEmpty(tBaseEvaluationConInfo.PARENT_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND PARENT_ID = '{0}'", tBaseEvaluationConInfo.PARENT_ID.ToString()));
}
//条件项名称
if (!String.IsNullOrEmpty(tBaseEvaluationConInfo.CONDITION_NAME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CONDITION_NAME = '{0}'", tBaseEvaluationConInfo.CONDITION_NAME.ToString()));
}
//条件项说明
if (!String.IsNullOrEmpty(tBaseEvaluationConInfo.CONDITION_REMARK.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CONDITION_REMARK = '{0}'", tBaseEvaluationConInfo.CONDITION_REMARK.ToString()));
}
//0为在使用、1为停用
if (!String.IsNullOrEmpty(tBaseEvaluationConInfo.IS_DEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tBaseEvaluationConInfo.IS_DEL.ToString()));
}
//备注1
if (!String.IsNullOrEmpty(tBaseEvaluationConInfo.REMARK1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tBaseEvaluationConInfo.REMARK1.ToString()));
}
//备注2
if (!String.IsNullOrEmpty(tBaseEvaluationConInfo.REMARK2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tBaseEvaluationConInfo.REMARK2.ToString()));
}
//备注3
if (!String.IsNullOrEmpty(tBaseEvaluationConInfo.REMARK3.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tBaseEvaluationConInfo.REMARK3.ToString()));
}
//备注4
if (!String.IsNullOrEmpty(tBaseEvaluationConInfo.REMARK4.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tBaseEvaluationConInfo.REMARK4.ToString()));
}
//备注5
if (!String.IsNullOrEmpty(tBaseEvaluationConInfo.REMARK5.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tBaseEvaluationConInfo.REMARK5.ToString()));
}
}
return(strWhereStatement.ToString());
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TBaseEvaluationConInfoVo tBaseEvaluationConInfo)
{
return(access.Create(tBaseEvaluationConInfo));
}
