/// <summary> /// 数据绑定 /// </summary> private void StoreDataBind() { try { DataTable dt = GetDataOfPeccancyAreaSetting(); System.Data.DataView dv = new System.Data.DataView(dt); DataTable dt3 = dv.ToTable(true, new string[] { "col1", "col10" }); StoreStartStation.DataSource = dt3; StoreStartStation.DataBind(); StoreStartStationDict.DataSource = tgsPproperty.GetStationInfo("a.station_type_id in (02,03)"); StoreStartStationDict.DataBind(); this.StoreShow.DataSource = Bll.Common.ChangColName(GetRedisData.GetData("t_sys_code:240034")); //tgsPproperty.GetCommonDict("240034"); this.StoreShow.DataBind(); this.StoreDirection.DataSource = Bll.Common.ChangColName(GetRedisData.GetData("t_sys_code:240025")); // tgsPproperty.GetDirectionDict(); this.StoreDirection.DataBind(); StorePecAreasetting.DataSource = dt; StorePecAreasetting.DataBind(); if (dt.Rows.Count > 0) { SelectFirst(dt.Rows[0]); } } catch (Exception ex) { ILog.WriteErrorLog(ex); logManager.InsertLogError("PeccancyAreaSetting.aspx-StoreDataBind", ex.Message + ";" + ex.StackTrace, "StoreDataBind has an exception"); } }
/// <summary> /// 绑定数据 /// </summary> /// <returns></returns> private void StoreDataBind() { try { // 绑定查询条件开始卡口 StoreStartStation.DataSource = tgsPproperty.GetStartStationInfo(); StoreStartStation.DataBind(); // 绑定展示 开始卡口 StoreStartStationDict.DataSource = tgsPproperty.GetStationInfo("a.station_type_id in (02,03)"); StoreStartStationDict.DataBind(); this.StoreShow.DataSource = Bll.Common.ChangColName(GetRedisData.GetData("t_sys_code:240034")); //tgsPproperty.GetCommonDict("240034"); this.StoreShow.DataBind(); DataTable dtDirection = Bll.Common.ChangColName(GetRedisData.GetData("t_sys_code:240025")); // tgsPproperty.GetDirectionDict(); if (dtDirection.Rows[0][0].ToString().Equals("00")) { dtDirection.Rows.RemoveAt(0); } this.StoreDirection.DataSource = dtDirection; this.StoreDirection.DataBind(); DataTable dt = tgsPproperty.GetPeccancyAreaSetting("1=1"); StorePecAreasetting.DataSource = dt; StorePecAreasetting.DataBind(); if (dt.Rows.Count > 0) { SelectFirst(dt.Rows[0]); } } catch (Exception ex) { ILog.WriteErrorLog(ex); logManager.InsertLogError("PeccancyAreaSetting.aspx-DoYes", ex.Message + ";" + ex.StackTrace, "DoYes has an exception"); } }
/// <summary> /// 根据条件查询数据 /// </summary> private void PecSettingDataBind() { try { GetDataOfPeccancyAreaSetting(); if (Session["dataTable"] != null) { DataTable table = (DataTable)Session["dataTable"]; System.Data.DataView dv2 = new System.Data.DataView(table); DataTable dt3 = dv2.ToTable(true, new string[] { "col1", "col10" }); StoreStartStation.DataSource = dt3; StoreStartStation.DataBind(); System.Data.DataView dv = new System.Data.DataView(table); dv.RowFilter = Getwhere(); StorePecAreasetting.DataSource = dv; StorePecAreasetting.DataBind(); } } catch (Exception ex) { ILog.WriteErrorLog(ex); logManager.InsertLogError("PeccancyAreaSetting.aspx-PecSettingDataBind", ex.Message + ";" + ex.StackTrace, "PecSettingDataBind has an exception"); } }