71 lines
2.4 KiB
C#
71 lines
2.4 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using SuperMap.RealEstate.CoreFrameWork;
|
|
using SuperMap.RealEstate.ServiceModel;
|
|
using SuperMap.RealEstate.Utility;
|
|
using SuperMap.RealEstate.Web.UI;
|
|
using SuperMap.RealEstate.Web.UI.WebControls;
|
|
using SuperMap.RealEstate.Web.Utility;
|
|
using SuperMap.RealEstate.CoreFrameWork.Dictionary.Business;
|
|
using System.Drawing;
|
|
using Business = SuperMap.RealEstate.HighWay.Storage.Business;
|
|
|
|
namespace SuperMap.RealEstate.HighWay.CloudModule.Commodity
|
|
{
|
|
public partial class COMMODITYApprove : BasePage
|
|
{
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
if (IsPostBack) return;
|
|
//初始化并加载列表
|
|
GridViewEx1.SelectingWithInit<Business.APPROVED>(ObjectDataSource1, GridPageEx1,
|
|
DictionaryHelper.GetDictionary(Transaction, "Approved_Type"));
|
|
//
|
|
}
|
|
|
|
//查询
|
|
protected void ButtonSearch_CallBackClick(object sender, ClientSetEventArgs e)
|
|
{
|
|
GridViewEx1.Selecting<Business.COMMODITY>(ObjectDataSource1, GridPageEx1);
|
|
//设置UI变化
|
|
e.SetValue(GridViewEx1);
|
|
e.SetValue(GridPageEx1);
|
|
}
|
|
|
|
//翻页事件
|
|
protected void GridPageEx1_CallBackPageChanged(object src, ClientSetEventArgs e)
|
|
{
|
|
GridViewEx1.Pagging<Business.COMMODITY>(ObjectDataSource1, GridPageEx1);
|
|
//设置UI变化
|
|
e.SetValue(GridViewEx1);
|
|
}
|
|
|
|
//查询SQL设置
|
|
protected void GridViewEx1_SelectMethodParameters(object sender, SelectMethodParametersArgs e)
|
|
{
|
|
if (Request["ID"] == null)
|
|
{
|
|
e.SetOtherUserCustomWhereSqlString = "1!=1";
|
|
}
|
|
else
|
|
{
|
|
e.SetOtherUserCustomWhereSqlString = " HIGHWAYPROINST_ID IN (SELECT HIGHWAYPROINST_ID " +
|
|
"FROM HIGHWAY_STORAGE.T_MODIFYFROMSTORAGE WHERE TABLE_NAME = 'T_COMMODITY' AND FIELD_VALUE = " +
|
|
Request["ID"].ToDecrypt() + ")";
|
|
}
|
|
//搜索选项的搜索条件过滤
|
|
//且搜索条件
|
|
//e.AddAndParams(字段名, 值);
|
|
//或搜索条件
|
|
//e.AddOrParams(字段名, 值);
|
|
//排序
|
|
e.AddOrderByParams("APPROVED_DATE", true);
|
|
}
|
|
}
|
|
}
|