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