/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Query()
{
if (IsValid)
{
DateTime begin = UCConditionDTTwo1.Begin;
DateTime end = UCConditionDTTwo1.End;
//int UCConditionDTTwo1.GetQueryDeviceIDs();
StationCollection sc = this.UCConditionDTTwo1.Stations;
string[] stationNames = sc.GetStationNames();
DataTable tbl = DitchDataDayDBI.GetDayDataTable(begin, end, stationNames, this.DataEnum);
//this.GridView1.DataSource = tbl;
//this.DataBind();
this.GridView1.Columns.Clear();
Xdgk.UI.GridViewHelper H = new Xdgk.UI.GridViewHelper(this.GridView1);
H.GridViewConfig = GetGridViewConfig(tbl);
H.DataSource = tbl;
H.Bind();
this.UCZedChart1.DataSource = tbl;
this.UCZedChart1.GraphPaneConfig = GetGraphPaneConfig(tbl);
}
}
/// <summary>
///
/// </summary>
/// <param name="gv"></param>
/// <param name="dataSource"></param>
/// <param name="cfg"></param>
private void ReBindGridViewDataSource(GridView gv, object dataSource, GridViewConfig cfg)
{
gv.Columns.Clear();
Xdgk.UI.GridViewHelper h = new Xdgk.UI.GridViewHelper(gv);
h.GridViewConfig = cfg;
h.DataSource = dataSource;
h.Bind();
}
/// <summary>
///
/// </summary>
/// <param name="selected"></param>
/// <param name="begin"></param>
/// <param name="end"></param>
private void QueryFlux(StationCollection selected, DateTime begin, DateTime end)
{
string title = string.Format("{0} ~ {1} {2}流量曲线", begin, end, this.GetSelectedChannelName());
string yTitle = "流量(m3/s)";
DataTable tbl = selected.GetFluxDataTable(begin, end);
this.UCAMChart1.SetLineChartInfo(tbl,
YongShuiGuanLiDBI.DBNames.vDitchData.StationName,
YongShuiGuanLiDBI.DBNames.vDitchData.DT,
DataTableHelper.GetExistColumnName(tbl, "InstantFlux", "avgflux"),
title,
yTitle);
this.GridView1.Columns.Clear();
Xdgk.UI.GridViewHelper h = new Xdgk.UI.GridViewHelper(this.GridView1);
h.GridViewConfig = GetGridViewConfig(DataEnum.Flux, tbl);
h.DataSource = tbl;
h.Bind();
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void UCWaterUserListDTTwo1_QueryEvent(object sender, EventArgs e)
{
//Trace.Warn("selected wateruser list");
//foreach (WaterUserClass w in this.UCWaterUserListDTTwo1.WaterUserCollection)
//{
// Trace.Warn(w.Name);
//}
//DateTime begin = this.UCWaterUserListDTTwo1.Begin;
//DateTime end = this.UCWaterUserListDTTwo1.End;
//WaterUserCollection wuc = this.UCWaterUserListDTTwo1.WaterUserCollection;
//// used amount list
////
//StageAmountCollection list = new StageAmountCollection();
//foreach (WaterUserClass w in wuc)
//{
// double amount = w.CalcUsedAmount(begin, end);
// StageAmount a = new StageAmount();
// a.WaterUserID = w.WaterUserID;
// a.WaterUserName = w.Name;
// a.Amount = amount;
// a.Begin = begin;
// a.End = end;
// list.Add(a);
//}
//this.GridView1.Columns.Clear();
//this.GridView1.Columns.Add(CreateHyperLinkField());
//// bind
////
//this.GridView1.DataSource = list;
//this.GridView1.DataBind();
//h.DataSource = list;
h.GridView.Columns.Add(CreateHyperLinkField());
h.Bind();
}
/// <summary>
///
/// </summary>
/// <param name="selected"></param>
/// <param name="begin"></param>
/// <param name="end"></param>
private void QueryWL(StationCollection selected, DateTime begin, DateTime end)
{
string title = string.Format("{0} ~ {1} {2}水位曲线", begin, end, this.GetSelectedChannelName());
string ytitle = "水位(cm)";
DataTable tbl = selected.GetWL1DataTable(begin, end);
this.UCAMChart1.SetLineChartInfo(tbl,
YongShuiGuanLiDBI.DBNames.vDitchData.StationName,
YongShuiGuanLiDBI.DBNames.vDitchData.DT,
DataTableHelper.GetExistColumnName(tbl, "wl1", "avgwl"),
title,
ytitle);
this.GridView1.Columns.Clear();
Xdgk.UI.GridViewHelper h = GetGridViewHelper();
h.GridViewConfig = GetGridViewConfig(DataEnum.WL, tbl);
h.DataSource = tbl;
h.Bind();
}
protected void Page_Load(object sender, EventArgs e)
{
Xdgk.UI.GridViewHelper h = new Xdgk.UI.GridViewHelper(this.GridView1);
this.GridView1.RowEditing += new GridViewEditEventHandler(GridView1_RowEditing);
this.GridView1.DataKeyNames = new string[] { YongShuiGuanLiDBI.DBNames.vStationDevice.StationID };
if (!IsPostBack)
{
h.GridViewConfig = GetViewConfig();
YongShuiGuanLiDBI.GridViewHelper.AddEditColumn(this.GridView1);
}
//GridViewHelper.AddEditDeleteColumn(this.GridView1);
DataTable t = StationDBI.GetStationDataTable(DeviceTypeDefine.CQDeviceTypes);
////this.GridView1.DataSource = t;
//this.GridView1.DataBind();
h.DataSource = t;
h.Bind();
}
/// <summary>
///
/// </summary>
/// <param name="selected"></param>
/// <param name="begin"></param>
/// <param name="end"></param>
private void QueryAmount(StationCollection selected, DateTime begin, DateTime end)
{
string title = string.Format("{0} ~ {1} {2}水量曲线", begin, end, this.GetSelectedChannelName());
string yTitle = "水量(m3)";
DataTable tbl = selected.GetAmountDataTable(begin, end);
this.UCAMChart1.SetLineChartInfo(tbl,
YongShuiGuanLiDBI.DBNames.vDitchDataDay.StationName,
YongShuiGuanLiDBI.DBNames.vDitchDataDay.DT,
YongShuiGuanLiDBI.DBNames.vDitchDataDay.DayAmount,
title,
yTitle);
this.GridView1.Columns.Clear();
Xdgk.UI.GridViewHelper h = new Xdgk.UI.GridViewHelper(this.GridView1);
h.GridViewConfig = GetGridViewConfig(DataEnum.Amount, tbl);
h.DataSource = tbl;
h.Bind();
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
Xdgk.UI.GridViewHelper h = new Xdgk.UI.GridViewHelper(this.GridView1);
this.GridView1.RowEditing += new GridViewEditEventHandler(GridView1_RowEditing);
this.GridView1.RowDeleting += new GridViewDeleteEventHandler(GridView1_RowDeleting);
this.GridView1.DataKeyNames = new string[] { YongShuiGuanLiDBI.DBNames.tblDuringWater.DuringWaterID};
if (!IsPostBack)
{
h.GridViewConfig = GetViewConfig();
YongShuiGuanLiDBI.GridViewHelper.AddEditDeleteColumn(this.GridView1);
}
//GridViewHelper.AddEditDeleteColumn(this.GridView1);
DataTable t = DuringWaterDBI.GetDuringDataTable();
////this.GridView1.DataSource = t;
//this.GridView1.DataBind();
h.DataSource = t;
h.Bind();
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
Xdgk.UI.GridViewHelper h = new Xdgk.UI.GridViewHelper(this.GridView1);
this.GridView1.RowEditing += new GridViewEditEventHandler(GridView1_RowEditing);
this.GridView1.RowDeleting += new GridViewDeleteEventHandler(GridView1_RowDeleting);
this.GridView1.DataKeyNames = new string[] { YongShuiGuanLiDBI.DBNames.tblDuringWater.DuringWaterID };
if (!IsPostBack)
{
h.GridViewConfig = GetViewConfig();
YongShuiGuanLiDBI.GridViewHelper.AddEditDeleteColumn(this.GridView1);
}
//GridViewHelper.AddEditDeleteColumn(this.GridView1);
DataTable t = DuringWaterDBI.GetDuringDataTable();
////this.GridView1.DataSource = t;
//this.GridView1.DataBind();
h.DataSource = t;
h.Bind();
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Query()
{
if (IsValid)
{
DateTime begin = UCConditionDTTwo1.Begin;
DateTime end = UCConditionDTTwo1.End;
//int UCConditionDTTwo1.GetQueryDeviceIDs();
StationCollection sc = this.UCConditionDTTwo1.Stations;
string[] stationNames = sc.GetStationNames();
DataTable tbl = DitchDataDayDBI.GetDayDataTable(begin, end, stationNames, this.DataEnum);
//this.GridView1.DataSource = tbl;
//this.DataBind();
this.GridView1.Columns.Clear();
Xdgk.UI.GridViewHelper H = new Xdgk.UI.GridViewHelper(this.GridView1);
H.GridViewConfig = GetGridViewConfig(tbl);
H.DataSource = tbl;
H.Bind();
this.UCZedChart1.DataSource = tbl;
this.UCZedChart1.GraphPaneConfig = GetGraphPaneConfig(tbl);
}
}
/// <summary>
///
/// </summary>
/// <param name="gv"></param>
/// <param name="dataSource"></param>
/// <param name="cfg"></param>
private void ReBindGridViewDataSource(GridView gv, object dataSource, GridViewConfig cfg)
{
gv.Columns.Clear();
Xdgk.UI.GridViewHelper h = new Xdgk.UI.GridViewHelper(gv);
h.GridViewConfig = cfg;
h.DataSource = dataSource;
h.Bind();
}
/// <summary>
///
/// </summary>
/// <param name="selected"></param>
/// <param name="begin"></param>
/// <param name="end"></param>
private void QueryFlux(StationCollection selected, DateTime begin, DateTime end)
{
string title = string.Format("{0} ~ {1} {2}流量曲线", begin, end, this.GetSelectedChannelName());
string yTitle = "流量(m3/s)";
DataTable tbl = selected.GetFluxDataTable(begin, end);
this.UCAMChart1.SetLineChartInfo(tbl,
YongShuiGuanLiDBI.DBNames.vDitchData.StationName,
YongShuiGuanLiDBI.DBNames.vDitchData.DT,
DataTableHelper.GetExistColumnName (tbl, "InstantFlux","avgflux"),
title,
yTitle);
this.GridView1.Columns.Clear();
Xdgk.UI.GridViewHelper h = new Xdgk.UI.GridViewHelper(this.GridView1);
h.GridViewConfig = GetGridViewConfig(DataEnum.Flux, tbl);
h.DataSource = tbl;
h.Bind();
}
/// <summary>
///
/// </summary>
/// <param name="selected"></param>
/// <param name="begin"></param>
/// <param name="end"></param>
private void QueryAmount(StationCollection selected, DateTime begin, DateTime end)
{
string title = string.Format("{0} ~ {1} {2}水量曲线", begin, end, this.GetSelectedChannelName());
string yTitle = "水量(m3)";
DataTable tbl = selected.GetAmountDataTable(begin, end);
this.UCAMChart1.SetLineChartInfo(tbl,
YongShuiGuanLiDBI.DBNames.vDitchDataDay.StationName,
YongShuiGuanLiDBI.DBNames.vDitchDataDay.DT,
YongShuiGuanLiDBI.DBNames.vDitchDataDay.DayAmount,
title,
yTitle);
this.GridView1.Columns.Clear();
Xdgk.UI.GridViewHelper h = new Xdgk.UI.GridViewHelper(this.GridView1);
h.GridViewConfig = GetGridViewConfig(DataEnum.Amount,tbl);
h.DataSource = tbl;
h.Bind();
}
protected void Page_Load(object sender, EventArgs e)
{
Xdgk.UI.GridViewHelper h = new Xdgk.UI.GridViewHelper(this.GridView1);
this.GridView1.RowEditing += new GridViewEditEventHandler(GridView1_RowEditing);
this.GridView1.DataKeyNames = new string[] { YongShuiGuanLiDBI.DBNames.vStationDevice.StationID };
if (!IsPostBack)
{
h.GridViewConfig = GetViewConfig();
YongShuiGuanLiDBI.GridViewHelper.AddEditColumn(this.GridView1);
}
//GridViewHelper.AddEditDeleteColumn(this.GridView1);
DataTable t = StationDBI.GetStationDataTable(DeviceTypeDefine.CQDeviceTypes);
////this.GridView1.DataSource = t;
//this.GridView1.DataBind();
h.DataSource = t;
h.Bind();
}
