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