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