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.CommodityChange { /// /// T_COMMODITY_商品管理 的WebUserControl /// public partial class Default : UserControl { //流程实例 Running.Business.HIGHWAYPROINST _HighWayProInst = null; protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; GridViewEx1.SelectingWithInit(ObjectDataSource1, GridPageEx1, DictionaryHelper.GetDictionary(Transaction, "COMMODITYGRADE").AsNewKeys("COMMODITY_GRADE")); //工具条按钮事件 GridViewEx1.SetOpenControl(ButtonNew, "/HighWay/Compents/CommodityChange/COMMODITYList.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() { //加载对应的 return true; } //查询 protected void ButtonSearch_CallBackClick(object sender, ClientSetEventArgs e) { GridViewEx1.Selecting(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; } #region 方法 -> 删除商品 protected void CallBack_Delete_CallBackClick(object sender, ClientSetEventArgs e) { CallBackButton _button = (CallBackButton)sender; GridViewRow _Row = (GridViewRow)_button.NamingContainer; string _Key_ID = GridViewEx1.DataKeys[_Row.RowIndex][0].ToString(); using (Running.Business.COMMODITY _COMMODITY = new Running.Business.COMMODITY(this.Transaction)) { _COMMODITY.COMMODITY_ID = int.Parse(_Key_ID); if (_COMMODITY.Select()) { //删除关联关系 Running.Business.MODIFYFROMSTORAGE _MODIFYFROMSTORAGE = new Running.Business.MODIFYFROMSTORAGE(this.Transaction); _MODIFYFROMSTORAGE.AddSearchParameter("HIGHWAYPROINST_ID", _HighWayProInst.HIGHWAYPROINST_ID); _MODIFYFROMSTORAGE.AddSearchParameter("Field_Value", _COMMODITY.COMMODITY_ID); _MODIFYFROMSTORAGE.AddSearchParameter("Table_Name", "T_COMMODITY"); if (_MODIFYFROMSTORAGE.Search()) { _MODIFYFROMSTORAGE.Delete(); } _COMMODITY.Delete(); } } GridViewEx1.SelectingWithInit(ObjectDataSource1, GridPageEx1); //设置UI变化 e.SetValue(GridViewEx1); e.SetValue(GridPageEx1); } #endregion //翻页事件 protected void GridPageEx1_CallBackPageChanged(object src, ClientSetEventArgs e) { GridViewEx1.Pagging(ObjectDataSource1, GridPageEx1); //设置UI变化 e.SetOuterHtml(GridViewEx1, GridViewEx1.OuterHTML); } protected void CallBackButton_Edit_CallBackClick(object sender, ClientSetEventArgs e) { CallBackButton _button = (CallBackButton)sender; GridViewRow _Row = (GridViewRow)_button.NamingContainer; string _Key_ID = GridViewEx1.DataKeys[_Row.RowIndex][0].ToString(); e.ExcuteClientScript(GridViewEx1.GetOpenPopDialogClientScript("/HighWay/Compents/CommodityChange/COMMODITYPage.aspx?ID=" + _Key_ID.ToEncrypt() + "&HIGHWAYPROINST_ID=" + (_HighWayProInst.HIGHWAYPROINST_ID.ToString().ToEncrypt()))); } protected void ButtonSave_Click(object sender, EventArgs e) { foreach (GridViewRow _GVR in GridViewEx1.Rows) { if (_GVR.RowType == DataControlRowType.DataRow) { string KeyID = GridViewEx1.DataKeys[_GVR.RowIndex].Values["COMMODITY_ID"].ToString(); } } } #region 方法 -> 数据行绑定 protected void GridViewEx1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { Storage.Business.COMMODITYTYPE _COMMODITYTYPE = new Storage.Business.COMMODITYTYPE(this.Transaction); _COMMODITYTYPE.COMMODITYTYPE_ID_Encrypt = e.Row.Cells[2].Text.ToEncrypt(); if (_COMMODITYTYPE.Select()) { e.Row.Cells[2].Text = _COMMODITYTYPE.COMMODITYTYPE_NAME; } } } #endregion } }