117 lines
5.2 KiB
C#
117 lines
5.2 KiB
C#
using System;
|
||
using System.Data;
|
||
using System.Linq;
|
||
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 Storage = SuperMap.RealEstate.HighWay.Storage;
|
||
|
||
namespace SuperMap.RealEstate.HighWay.Compents.Commodity
|
||
{
|
||
/// <summary>
|
||
/// T_COMMODITY_商品管理 的WebUserControl
|
||
/// <summary>
|
||
public partial class Default : UserControl<Running.Business.COMMODITY>
|
||
{
|
||
//流程实例
|
||
Running.Business.HIGHWAYPROINST _HighWayProInst = null;
|
||
protected void Page_Load(object sender, EventArgs e)
|
||
{
|
||
if (IsPostBack)
|
||
return;
|
||
GridViewEx1.SelectingWithInit<Running.Business.COMMODITY>(ObjectDataSource1, GridPageEx1,
|
||
DictionaryHelper.GetDictionary(Transaction, "COMMODITYGRADE").AsNewKeys("COMMODITY_GRADE"));
|
||
//工具条按钮事件
|
||
GridViewEx1.SetOpenControl(ButtonNew, "/HighWay/Compents/Commodity/COMMODITYPage.aspx", "HIGHWAYPROINST_ID=" + _HighWayProInst.HIGHWAYPROINST_ID.ToEncrypt());
|
||
//设置回车焦点按钮
|
||
//SetControlClientAction(ButtonSearch);
|
||
}
|
||
|
||
protected override void OnInit(EventArgs e)
|
||
{
|
||
Common.PageHelper.CreateHeaderStyle(Page);
|
||
_HighWayProInst = Running.Business.HIGHWAYPROINST.CreateInstance(Page);
|
||
base.ButtonVisible = false;
|
||
base.OnInit(e);
|
||
}
|
||
|
||
//在此加入界面的数据初始化(Page_Load之前)，如DropDownList的数据源绑定等
|
||
public override void InitializeWebControl()
|
||
{
|
||
//加载对应的数据
|
||
}
|
||
|
||
|
||
//载入数据
|
||
public override bool LoadData()
|
||
{
|
||
//加载对应的
|
||
foreach(Running.Business.MODIFYFROMSTORAGE _MODIFYFROMSTORAGE in (new Running.Business.MODIFYFROMSTORAGE()).FillCollection(
|
||
"WHERE HIGHWAYPROINST_ID =" + (_HighWayProInst.HIGHWAYPROINST_ID == null ? 0 : _HighWayProInst.HIGHWAYPROINST_ID)))
|
||
{
|
||
if (_MODIFYFROMSTORAGE.Table_Name == "T_COMMODITY" && _MODIFYFROMSTORAGE.Field_Name == "COMMODITY_ID")
|
||
{
|
||
Running.Business.COMMODITY _COMMODITY = new Running.Business.COMMODITY(this.Transaction);
|
||
_COMMODITY.COMMODITY_ID = int.Parse(_MODIFYFROMSTORAGE.Field_Value);
|
||
if (_COMMODITY.Select())
|
||
{
|
||
if (int.Parse(_COMMODITY.ExecuteDataTable("select COUNT(COMMODITY_CODE) from HIGHWAY_STORAGE.V_ALL_COMMODITY WHERE COMMODITY_BARCODE = '" +
|
||
_COMMODITY.COMMODITY_BARCODE + "'" + " AND COMMODITY_ID != " + _COMMODITY.COMMODITY_ID +
|
||
" AND SERVERPART_ID = " + _COMMODITY.SERVERPART_ID).Rows[0][0].ToString()) > 0)
|
||
{
|
||
throw new Exception("注意:商品条码为" + _COMMODITY.COMMODITY_BARCODE + "已存在于您的服务区!请验证后重新录入!");
|
||
}
|
||
}
|
||
}
|
||
}
|
||
return true;
|
||
}
|
||
|
||
#region GridPageEx1_CallBackPageChanged翻页事件
|
||
protected void GridPageEx1_CallBackPageChanged(object src, ClientSetEventArgs e)
|
||
{
|
||
GridViewEx1.Pagging<Running.Business.COMMODITY>(ObjectDataSource1, GridPageEx1);
|
||
//设置UI变化
|
||
e.SetOuterHtml(GridViewEx1, GridViewEx1.OuterHTML);
|
||
}
|
||
#endregion
|
||
|
||
//查询
|
||
protected void ButtonSearch_CallBackClick(object sender, ClientSetEventArgs e)
|
||
{
|
||
GridViewEx1.Selecting<Running.Business.COMMODITY>(ObjectDataSource1, GridPageEx1);
|
||
//设置UI变化
|
||
e.SetValue(GridViewEx1);
|
||
e.SetValue(GridPageEx1);
|
||
}
|
||
|
||
protected void GridViewEx1_SelectMethodParameters(object sender, SelectMethodParametersArgs e)
|
||
{
|
||
if (!string.IsNullOrEmpty(TextBox_Search.Text))
|
||
e.AddOrParams(GridViewSearch1, TextBox_Search.Text);
|
||
//搜索选项的搜索条件过滤
|
||
if (e.Parameters.Count > 0)
|
||
{
|
||
e.SetOtherUserCustomWhereSqlString = "AND COMMODITY_ID IN(SELECT FIELD_VALUE FROM HIGHWAY_RUNNING.T_MODIFYFROMSTORAGE WHERE HIGHWAYPROINST_ID=" + _HighWayProInst.HIGHWAYPROINST_ID + ")";
|
||
}
|
||
else
|
||
{
|
||
e.SetOtherUserCustomWhereSqlString = "COMMODITY_ID IN(SELECT FIELD_VALUE FROM HIGHWAY_RUNNING.T_MODIFYFROMSTORAGE WHERE HIGHWAYPROINST_ID=" + _HighWayProInst.HIGHWAYPROINST_ID + ")";
|
||
}
|
||
//排序
|
||
e.AddOrderByParams(GridViewOrderBy1);
|
||
}
|
||
|
||
protected void GridViewEx1_CallBackClick(object sender, ClientSetEventArgs e)
|
||
{
|
||
string _Key_ID = e.Argument;
|
||
e.ExcuteClientScript(GridViewEx1.GetOpenPopDialogClientScript("/HighWay/Compents/Commodity/COMMODITYPage.aspx?ID=" + _Key_ID + "&HIGHWAYPROINST_ID=" + (_HighWayProInst.HIGHWAYPROINST_ID.ToString().ToEncrypt())));
|
||
}
|
||
}
|
||
}
|