private double CountUsedAmount(int WaterUserID, DateTime bg, DateTime ed) { int[] InDevices = WaterUserInDBI.GetInDeviceIds(WaterUserID); int[] OutDevices = WaterUserOutDBI.GetOutDeviceIds(WaterUserID); double InData = 0; double OutData = 0; for (int i = 0; i < InDevices.Length; i++) { DataTable dtin = DitchDataDBI.GetData(bg, ed, InDevices[i]); if (dtin.Rows.Count != 0) { InData = InData + double.Parse(dtin.Rows[dtin.Rows.Count - 1]["UsedAmount"].ToString()) - double.Parse(dtin.Rows[0]["UsedAmount"].ToString()); } } for (int o = 0; o < OutDevices.Length; o++) { DataTable dtout = DitchDataDBI.GetData(bg, ed, OutDevices[o]); if (dtout.Rows.Count != 0) { OutData = OutData + double.Parse(dtout.Rows[dtout.Rows.Count - 1]["UsedAmount"].ToString()) - double.Parse(dtout.Rows[0]["UsedAmount"].ToString()); } } return(InData - OutData); }
private double CountChannelAmount(int ChannelID, DateTime bg, DateTime ed) { int InDevices = ChannelDBI.GetInDeviceIds(ChannelID); int OutDevices = ChannelDBI.GetOutDeviceIds(ChannelID); double InData = 0; double OutData = 0; DataTable dtin = DitchDataDBI.GetData(bg, ed, InDevices); if (dtin.Rows.Count != 0) { InData = InData + double.Parse(dtin.Rows[dtin.Rows.Count - 1]["UsedAmount"].ToString()) - double.Parse(dtin.Rows[0]["UsedAmount"].ToString()); } DataTable dtout = DitchDataDBI.GetData(bg, ed, OutDevices); if (dtout.Rows.Count != 0) { OutData = OutData + double.Parse(dtout.Rows[dtout.Rows.Count - 1]["UsedAmount"].ToString()) - double.Parse(dtout.Rows[0]["UsedAmount"].ToString()); } return(InData - OutData); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Query() { // TODO: 2011-05-27 page_load 之前不能调用 IsValid // //if (IsValid) DateTime begin = UCConditionDTTwo1.Begin; DateTime end = UCConditionDTTwo1.End; //int[] deviceIDs = UCConditionDTTwo1.GetQueryDeviceIDs(); DeviceCollection dc = UCConditionDTTwo1.Stations.GetDeviceCollection(); int[] deviceIDs = dc.GetDeviceIDs(); if (deviceIDs.Length == 0) { // TODO: 2011-05-16 not select station msg // return; } DataTable tbl = DitchDataDBI.GetData(begin, end, deviceIDs); _h.Bind(); //DataTable tbl = GetDataTable(begin, end, deviceIDs[0]); //ColumnNameTextCollection nts = GetColumnNameTextCollection(); //GridViewHelper.SetGridViewColumn(this.GridView1, nts); //this.GridView1.DataSource = tbl; //this.DataBind(); this.UCZedChart1.GraphPaneConfig = this.GetGraphPaneConfig(); this.UCZedChart1.DataSource = tbl; }
/// <summary> /// /// </summary> /// <returns></returns> private DataTable GetDataTable() { DateTime begin = UCConditionDTTwo1.Begin; DateTime end = UCConditionDTTwo1.End; //int[] deviceIDs = UCConditionDTTwo1.GetQueryDeviceIDs(); DeviceCollection dc = UCConditionDTTwo1.Stations.GetDeviceCollection(); int[] deviceIDs = dc.GetDeviceIDs(); if (deviceIDs.Length == 0) { // TODO: 2011-05-16 not select station msg // return(null); } //DataTable tbl = DitchDataDBI.GetData(begin, end, deviceIDs); DataTable tbl = DitchDataDBI.GetData(begin, end, deviceIDs[0]); return(tbl); }