/// <summary> /// 增加数据 /// </summary> /// <returns></returns> public string frmAdd() { string strMsg = ""; bool isSuccess = true; TEnvPPolluteVo TEnvPPollute = autoBindRequest(Request, new TEnvPPolluteVo()); TEnvPPollute.TYPE_ID = this.TypeId.Value; TEnvPPollute.IS_DEL = "0"; string Meg = new CommonLogic().isExistRepeat(TEnvPPolluteVo.T_ENV_P_POLLUTE_TABLE, TEnvPPollute.YEAR, TEnvPPollute.SelectMonths, TEnvPPolluteVo.POINT_NAME_FIELD, TEnvPPollute.POINT_NAME, TEnvPPolluteVo.POINT_CODE_FIELD, TEnvPPollute.POINT_CODE, TEnvPPolluteVo.ID_FIELD, TEnvPPollute.ID, TEnvPPollute.TYPE_ID); if (!string.IsNullOrEmpty(Meg)) { strMsg = Meg; isSuccess = false; } else { isSuccess = new TEnvPPolluteLogic().CreateInfo(TEnvPPollute, SerialType.T_ENV_POINT_POLLUTE); if (isSuccess) { WriteLog("添加监测点", "", LogInfo.UserInfo.USER_NAME + "添加监测点" + TEnvPPollute.ID); strMsg = "数据保存成功"; } else { strMsg = "数据保存失败"; } } return(isSuccess == true ? "{\"result\":\"success\",\"msg\":\"" + strMsg + "\"}" : "{\"result\":\"fail\",\"msg\":\"" + strMsg + "\"}"); }
/// <summary> /// 修改数据 /// </summary> /// <returns></returns> public string frmUpdate() { string strMsg = ""; bool isSuccess = true; TEnvPPolluteVo TEnvPPollute = autoBindRequest(Request, new TEnvPPolluteVo()); TEnvPPollute.ID = Request["id"].ToString(); TEnvPPollute.IS_DEL = "0"; string Meg = new CommonLogic().isExistRepeat(TEnvPPolluteVo.T_ENV_P_POLLUTE_TABLE, TEnvPPollute.YEAR, TEnvPPollute.MONTH, TEnvPPolluteVo.POINT_NAME_FIELD, TEnvPPollute.POINT_NAME, TEnvPPolluteVo.POINT_CODE_FIELD, TEnvPPollute.POINT_CODE, TEnvPPolluteVo.ID_FIELD, TEnvPPollute.ID, null); if (!string.IsNullOrEmpty(Meg)) { strMsg = Meg; isSuccess = false; } else { isSuccess = new TEnvPPolluteLogic().Edit(TEnvPPollute); if (isSuccess) { WriteLog("编辑监测点", "", LogInfo.UserInfo.USER_NAME + "编辑监测点" + TEnvPPollute.ID); strMsg = "数据保存成功"; } else { strMsg = "数据保存失败"; } } return(isSuccess == true ? "{\"result\":\"success\",\"msg\":\"" + strMsg + "\"}" : "{\"result\":\"fail\",\"msg\":\"" + strMsg + "\"}"); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tEnvPPollute_UpdateSet">UpdateSet用户对象</param> /// <param name="tEnvPPollute_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TEnvPPolluteVo tEnvPPollute_UpdateSet, TEnvPPolluteVo tEnvPPollute_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tEnvPPollute_UpdateSet, TEnvPPolluteVo.T_ENV_P_POLLUTE_TABLE); strSQL += this.BuildWhereStatement(tEnvPPollute_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tEnvPPollute">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TEnvPPolluteVo tEnvPPollute, int iIndex, int iCount) { string strSQL = " select * from T_ENV_P_POLLUTE {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tEnvPPollute)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tEnvPPollute">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TEnvPPolluteVo tEnvPPollute) { string strSQL = SqlHelper.BuildUpdateExpress(tEnvPPollute, TEnvPPolluteVo.T_ENV_P_POLLUTE_TABLE); strSQL += string.Format(" where ID='{0}' ", tEnvPPollute.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TEnvPPolluteVo tEnvPPollute) { string strSQL = "delete from T_ENV_P_POLLUTE "; strSQL += this.BuildWhereStatement(tEnvPPollute); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 加载数据 /// </summary> /// <returns></returns> public string frmLoadData() { TEnvPPolluteVo TEnvPPollute = new TEnvPPolluteVo(); string str = this.formStatus.Value; TEnvPPollute.ID = Request["id"].ToString(); TEnvPPolluteVo TEnvPRiverVTemp = new TEnvPPolluteLogic().Details(TEnvPPollute); return(ToJson(TEnvPRiverVTemp)); }
public static string deleteThreeGridInfo(string strValue) { TEnvPPolluteVo TEnvPEnterInfo = new TEnvPPolluteVo(); TEnvPEnterInfo.ID = strValue; TEnvPEnterInfo.IS_DEL = "1"; bool isSuccess = new TEnvPPolluteLogic().Edit(TEnvPEnterInfo); if (isSuccess) { new PageBase().WriteLog("删除监测点信息", "", new UserLogInfo().UserInfo.USER_NAME + "删除监测点信息" + strValue); } return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tEnvPDrinkSrc">对象</param> /// <param name="strSerial">序列类型</param> /// <returns>是否成功</returns> public bool CreateInfo(TEnvPPolluteVo tEnvPPollute, string strSerial) { ArrayList list = new ArrayList(); string strSQL = string.Empty; List <string> values = tEnvPPollute.SelectMonths.Split(';').ToList(); tEnvPPollute.SelectMonths = ""; foreach (string valueTemp in values) { tEnvPPollute.ID = GetSerialNumber(strSerial); tEnvPPollute.MONTH = valueTemp; strSQL = SqlHelper.BuildInsertExpress(tEnvPPollute, TEnvPPolluteVo.T_ENV_P_POLLUTE_TABLE); list.Add(strSQL); } return(SqlHelper.ExecuteSQLByTransaction(list)); }
public string getThreeGridInfo(string twoGridId) { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TEnvPPolluteVo TEnvPPolluteType = new TEnvPPolluteVo(); TEnvPPolluteType.TYPE_ID = twoGridId; TEnvPPolluteType.IS_DEL = "0"; TEnvPPolluteType.SORT_FIELD = strSortname; TEnvPPolluteType.SORT_TYPE = strSortorder; DataTable dt = new TEnvPPolluteLogic().SelectByTable(TEnvPPolluteType, intPageIndex, intPageSize); int intTotalCount = new TEnvPPolluteLogic().GetSelectResultCount(TEnvPPolluteType); string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
public TEnvPPolluteLogic(TEnvPPolluteVo _tEnvPPollute) { tEnvPPollute = _tEnvPPollute; access = new TEnvPPolluteAccess(); }
public string GetType(TEnvPPolluteVo tEnvPPollute) { return(access.GetType(tEnvPPollute)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool CreateInfo(TEnvPPolluteVo tEnvPPollute, string strSerial) { return(access.CreateInfo(tEnvPPollute, strSerial)); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TEnvPPolluteVo tEnvPPollute) { return(access.Delete(tEnvPPollute)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tEnvPPollute">对象条件</param> /// <returns>对象</returns> public TEnvPPolluteVo Details(TEnvPPolluteVo tEnvPPollute) { string strSQL = String.Format("select * from T_ENV_P_POLLUTE " + this.BuildWhereStatement(tEnvPPollute)); return(SqlHelper.ExecuteObject(new TEnvPPolluteVo(), strSQL)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tEnvPPollute"></param> /// <returns></returns> public DataTable SelectByTable(TEnvPPolluteVo tEnvPPollute) { return(access.SelectByTable(tEnvPPollute)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tEnvPPollute">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TEnvPPolluteVo> SelectByObject(TEnvPPolluteVo tEnvPPollute, int iIndex, int iCount) { return(access.SelectByObject(tEnvPPollute, iIndex, iCount)); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tEnvPPollute">对象</param> /// <returns></returns> public TEnvPPolluteVo SelectByObject(TEnvPPolluteVo tEnvPPollute) { return(access.SelectByObject(tEnvPPollute)); }
public string GetType(TEnvPPolluteVo tEnvPPollute) { string strSQL = "SELECT B.TYPE_NAME FROM T_ENV_P_POLLUTE A LEFT JOIN T_ENV_P_POLLUTE_TYPE B ON A.TYPE_ID=B.ID where A.ID='" + tEnvPPollute.ID + "'"; return(SqlHelper.ExecuteScalar(strSQL).ToString()); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tEnvPPollute"></param> /// <returns></returns> public string BuildWhereStatement(TEnvPPolluteVo tEnvPPollute) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tEnvPPollute) { // if (!String.IsNullOrEmpty(tEnvPPollute.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tEnvPPollute.ID.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.YEAR.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND YEAR = '{0}'", tEnvPPollute.YEAR.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.MONTH.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MONTH = '{0}'", tEnvPPollute.MONTH.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.TYPE_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND TYPE_ID = '{0}'", tEnvPPollute.TYPE_ID.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.POINT_CODE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND POINT_CODE = '{0}'", tEnvPPollute.POINT_CODE.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.POINT_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND POINT_NAME = '{0}'", tEnvPPollute.POINT_NAME.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.WATER_CODE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND WATER_CODE = '{0}'", tEnvPPollute.WATER_CODE.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.WATER_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND WATER_NAME = '{0}'", tEnvPPollute.WATER_NAME.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.SEWERAGE_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SEWERAGE_NAME = '{0}'", tEnvPPollute.SEWERAGE_NAME.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.EQUIPMENT_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND EQUIPMENT_NAME = '{0}'", tEnvPPollute.EQUIPMENT_NAME.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.MO_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MO_NAME = '{0}'", tEnvPPollute.MO_NAME.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.MO_CAPACITY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MO_CAPACITY = '{0}'", tEnvPPollute.MO_CAPACITY.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.MO_UOM.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MO_UOM = '{0}'", tEnvPPollute.MO_UOM.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.MO_DATE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MO_DATE = '{0}'", tEnvPPollute.MO_DATE.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.FUEL_TYPE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND FUEL_TYPE = '{0}'", tEnvPPollute.FUEL_TYPE.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.FUEL_QTY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND FUEL_QTY = '{0}'", tEnvPPollute.FUEL_QTY.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.FUEL_MODEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND FUEL_MODEL = '{0}'", tEnvPPollute.FUEL_MODEL.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.FUEL_TECH.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND FUEL_TECH = '{0}'", tEnvPPollute.FUEL_TECH.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.IS_FUEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_FUEL = '{0}'", tEnvPPollute.IS_FUEL.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.DISCHARGE_WAY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND DISCHARGE_WAY = '{0}'", tEnvPPollute.DISCHARGE_WAY.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.MO_HOUR_QTY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MO_HOUR_QTY = '{0}'", tEnvPPollute.MO_HOUR_QTY.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.LOAD_MODE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LOAD_MODE = '{0}'", tEnvPPollute.LOAD_MODE.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.POINT_TEMP.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND POINT_TEMP = '{0}'", tEnvPPollute.POINT_TEMP.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.IS_RUN.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_RUN = '{0}'", tEnvPPollute.IS_RUN.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.MEASURED.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MEASURED = '{0}'", tEnvPPollute.MEASURED.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.WASTE_AIR_QTY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND WASTE_AIR_QTY = '{0}'", tEnvPPollute.WASTE_AIR_QTY.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.LONGITUDE_DEGREE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LONGITUDE_DEGREE = '{0}'", tEnvPPollute.LONGITUDE_DEGREE.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.LONGITUDE_MINUTE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LONGITUDE_MINUTE = '{0}'", tEnvPPollute.LONGITUDE_MINUTE.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.LONGITUDE_SECOND.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LONGITUDE_SECOND = '{0}'", tEnvPPollute.LONGITUDE_SECOND.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.LATITUDE_DEGREE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LATITUDE_DEGREE = '{0}'", tEnvPPollute.LATITUDE_DEGREE.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.LATITUDE_MINUTE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LATITUDE_MINUTE = '{0}'", tEnvPPollute.LATITUDE_MINUTE.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.LATITUDE_SECOND.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LATITUDE_SECOND = '{0}'", tEnvPPollute.LATITUDE_SECOND.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.IS_DEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tEnvPPollute.IS_DEL.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tEnvPPollute.REMARK1.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tEnvPPollute.REMARK2.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tEnvPPollute.REMARK3.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.REMARK4.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tEnvPPollute.REMARK4.ToString())); } // if (!String.IsNullOrEmpty(tEnvPPollute.REMARK5.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tEnvPPollute.REMARK5.ToString())); } } return(strWhereStatement.ToString()); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tEnvPPollute">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TEnvPPolluteVo tEnvPPollute) { string strSQL = "select Count(*) from T_ENV_P_POLLUTE " + this.BuildWhereStatement(tEnvPPollute); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tEnvPPollute"></param> /// <returns></returns> public DataTable SelectByTable(TEnvPPolluteVo tEnvPPollute) { string strSQL = "select * from T_ENV_P_POLLUTE " + this.BuildWhereStatement(tEnvPPollute); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tEnvPPollute">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TEnvPPolluteVo tEnvPPollute) { return(access.GetSelectResultCount(tEnvPPollute)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TEnvPPolluteVo tEnvPPollute) { return(access.Create(tEnvPPollute)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tEnvPPollute">对象条件</param> /// <returns>对象</returns> public TEnvPPolluteVo Details(TEnvPPolluteVo tEnvPPollute) { return(access.Details(tEnvPPollute)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tEnvPPollute">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TEnvPPolluteVo tEnvPPollute) { return(access.Edit(tEnvPPollute)); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tEnvPPollute">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TEnvPPolluteVo tEnvPPollute, int iIndex, int iCount) { return(access.SelectByTable(tEnvPPollute, iIndex, iCount)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tEnvPPollute_UpdateSet">UpdateSet用户对象</param> /// <param name="tEnvPPollute_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TEnvPPolluteVo tEnvPPollute_UpdateSet, TEnvPPolluteVo tEnvPPollute_UpdateWhere) { return(access.Edit(tEnvPPollute_UpdateSet, tEnvPPollute_UpdateWhere)); }
protected void BindList() { //数据库表名 string strTableName = Request["TableName"].ToString(); //数据库列名 string strColumnName = Request["ColumnName"].ToString(); //需要查询的数据库列名 string strWhereColumnName = Request["strWhereColumnName"].ToString(); //垂线代码 string strPointCode = Request["PointCode"].ToString(); //监测类型 string strMonitorType = Request["MonitorType"].ToString(); if (strTableName == "T_ENV_P_POLLUTE_ITEM") { #region //常规污染源 TEnvPPolluteVo TEnvPEnterInfo = new TEnvPPolluteVo(); TEnvPEnterInfo.ID = strPointCode; //监测项目ID string type = new TEnvPPolluteLogic().GetType(TEnvPEnterInfo); if (!string.IsNullOrEmpty(type)) { if (type.Equals("废水")) { strMonitorType = "000000001"; } if (type.Equals("废气")) { strMonitorType = "000000002"; } if (type.Equals("噪声")) { strMonitorType = "000000004"; } } #endregion } else { strMonitorType = new i3.BusinessLogic.Channels.Env.Point.Common.CommonLogic().getNameByID("T_BASE_MONITOR_TYPE_INFO", "REMARK1", "ID", strMonitorType); } TBaseItemInfoVo objItem = new TBaseItemInfoVo(); objItem.IS_DEL = "0"; objItem.MONITOR_ID = strMonitorType; List <TBaseItemInfoVo> lstItem = new TBaseItemInfoLogic().SelectByObject(objItem, 0, 0); lstItem.Sort(delegate(TBaseItemInfoVo a, TBaseItemInfoVo b) { return(a.ORDER_NUM.CompareTo(b.ORDER_NUM)); }); this.ListBox1.DataSource = lstItem; this.ListBox1.DataValueField = TBaseItemInfoVo.ID_FIELD; this.ListBox1.DataTextField = TBaseItemInfoVo.ITEM_NAME_FIELD; this.ListBox1.DataBind(); DataTable dt = new i3.BusinessLogic.Channels.Env.Point.Common.CommonLogic().getVerticalItem(strTableName, strWhereColumnName, strPointCode); string strPointItemIDs = ""; for (int i = 0; i < dt.Rows.Count; i++) { strPointItemIDs += "," + dt.Rows[i][strColumnName].ToString(); } strPointItemIDs = strPointItemIDs + ","; for (int i = lstItem.Count - 1; i >= 0; i--) { if (!("," + strPointItemIDs + ",").Contains("," + lstItem[i].ID + ",")) { lstItem.RemoveAt(i); } } this.ListBox2.DataSource = lstItem; this.ListBox2.DataValueField = TBaseItemInfoVo.ID_FIELD; this.ListBox2.DataTextField = TBaseItemInfoVo.ITEM_NAME_FIELD; this.ListBox2.DataBind(); for (int i = 0; i < ListBox2.Items.Count; i++) { ListItem item = ListBox2.Items[i]; ListBox1.Items.Remove(item); } lbItemNum.Text = ListBox2.Items.Count.ToString(); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tEnvPPollute">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TEnvPPolluteVo> SelectByObject(TEnvPPolluteVo tEnvPPollute, int iIndex, int iCount) { string strSQL = String.Format("select * from T_ENV_P_POLLUTE " + this.BuildWhereStatement(tEnvPPollute)); return(SqlHelper.ExecuteObjectList(tEnvPPollute, BuildPagerExpress(strSQL, iIndex, iCount))); }