Example #1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnModify_Click(object sender, EventArgs e)
        {
            if (IsValid)
            {
                // check password
                //
                if (CheckEditPassword())
                {
                    foreach (GridViewRow row in this.GridView1.Rows)
                    {
                        int  dataID;
                        bool deleted;
                        GetDataIDAndDeleted(row, out dataID, out deleted);

                        if (deleted)
                        {
                            DitchDataDBI.Delete(dataID);
                        }
                    }

                    this.ClientScript.RegisterStartupScript(
                        this.GetType(),
                        "deletsuccess",
                        JavaScriptHelper.GetAlertScript("数据删除成功")
                        );
                }
                else
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "passworderror", GetScript("修改密码错误"));
                }
            }
        }
Example #2
0
        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);
        }
Example #3
0
        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);
        }
Example #4
0
        /// <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;
        }
Example #5
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnModify_Click(object sender, EventArgs e)
        {
            if (IsValid)
            {
                if (CheckNewWL())
                {
                    if (CheckEditPassword())
                    {
                        this.Device = this.UCChannelStationDTOne1.SelectedStation.DeviceCollection[0];

                        int DATE_COLUMN_INDEX   = 1;
                        int NEW_WL_COLUMN_INDEX = 4;

                        int NEW_WL_VALUE_CONTROL_INDEX = 1;
                        //return;
                        foreach (GridViewRow row in this.GridView1.Rows)
                        {
                            int index = row.RowIndex;

                            TextBox txtNewWL = (TextBox)row.Cells[NEW_WL_COLUMN_INDEX].Controls[NEW_WL_VALUE_CONTROL_INDEX];
                            string  newWL    = txtNewWL.Text;
                            if (newWL.Length > 0)
                            {
                                int      newWLValue  = Convert.ToInt32(newWL);
                                int      dataID      = Convert.ToInt32(this.GridView1.DataKeys[index].Value);
                                DateTime dt          = Convert.ToDateTime(row.Cells[DATE_COLUMN_INDEX].Text);
                                float    instantFlux = CalcInstantFlux(dt, newWLValue);


                                DitchDataDBI.Update(dataID, newWLValue, 0, instantFlux);
                            }
                        }

                        // re query
                        //
                        QueryData();

                        this.ClientScript.RegisterStartupScript(
                            this.GetType(),
                            "modifysuccess",
                            JavaScriptHelper.GetAlertScript("数据修改成功")
                            );
                    }
                    else
                    {
                        // password error
                        ClientScript.RegisterStartupScript(this.GetType(), "passworderror", GetScript("修改密码错误"));
                    }
                }
                else
                {
                    // data error
                    ClientScript.RegisterStartupScript(this.GetType(), "dataerror", GetScript("数据错误"));
                }
            }
        }
Example #6
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnModify_Click(object sender, EventArgs e)
        {
            if (CheckInput())
            {
                if (CheckEditPassword())
                {
                    this.Device = this.UCWLAdd1.SelectedStation.DeviceCollection[0];
                    int deviceID = this.UCWLAdd1.SelectedStation.DeviceCollection[0].DeviceID;

                    // delete history of the day
                    //
                    if (this.chkDeleteHistory.Checked)
                    {
                        DateTime dt = this.UCWLAdd1.Begin.Date;
                        DitchDataDBI.DeleteDay(deviceID, dt);
                    }

                    foreach (GridViewRow row in this.GridView1.Rows)
                    {
                        TextBox txtDT = row.Cells[1].Controls[1] as TextBox;
                        TextBox txtWL = row.Cells[2].Controls[1] as TextBox;

                        DateTime dt  = Convert.ToDateTime(txtDT.Text);
                        int      wl1 = Convert.ToInt32(txtWL.Text);

                        float flux = CalcInstantFlux(dt, wl1);
                        DitchDataDBI.Insert(deviceID, dt, wl1, 0, flux);
                    }

                    // alert success msg
                    //
                    string addSuccessMsg = "数据添加成功";
                    string js            = JavaScriptHelper.GetAlertScript(addSuccessMsg);
                    this.ClientScript.RegisterStartupScript(
                        this.GetType(),
                        "addSuccess",
                        js);
                }
                else
                {
                    ClientScript.RegisterStartupScript(
                        this.GetType(), "passworderror",
                        JavaScriptHelper.GetAlertScript("修改密码错误"));
                }
            }
            else
            {
                string js = JavaScriptHelper.GetAlertScript("输入数据错误!");
                this.ClientScript.RegisterStartupScript(this.GetType(), "key", js);
            }
        }
Example #7
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="deviceID"></param>
        /// <param name="begin"></param>
        /// <param name="end"></param>
        private void QueryData(int deviceID, DateTime begin, DateTime end)
        {
            DataTable tbl = DitchDataDBI.GetWLFluxTable(begin, end, deviceID);

            // AddDeletedColumn
            //
            AddDeletedColumn(tbl);

            H.DataSource = tbl;
            H.Bind();

            bool b = tbl.Rows.Count > 0;

            this.panelOpera.Visible = b;
        }
Example #8
0
        /// <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);
        }
Example #9
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="_queryDeviceID"></param>
        /// <param name="_queryDateTime"></param>
        private void QueryData(int deviceID, DateTime begin, DateTime end)
        {
            DataTable tbl = DitchDataDBI.GetWLFluxTable(begin, end, deviceID);

            //this.GridView1.DataSource = tbl;
            //this.GridView1.DataBind();
            H.DataSource = tbl;
            H.Bind();

            if (tbl.Rows.Count > 0)
            {
                this.btnModify.Visible       = true;
                this.lblEditPassword.Visible = true;
                this.txtEditPassword.Visible = true;
            }
            else
            {
                this.btnModify.Visible       = false;
                this.lblEditPassword.Visible = false;
                this.txtEditPassword.Visible = false;
            }
        }
Example #10
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Calc_Click(object sender, EventArgs e)
        {
            if (Check())
            {
                DataTable tbl = this.GetData();
                foreach (DataRow row in tbl.Rows)
                {
                    int      dataID = Convert.ToInt32(row["ditchdataid"]);
                    DateTime dt     = Convert.ToDateTime(row["dt"]);
                    int      wl1    = Convert.ToInt32(row["wl1"]);
                    float    flux   = this.DeviceFormulaCollectionMap.FormulaCollection.CalcInstantFlux(dt, wl1, 0);

                    DitchDataDBI.Update(dataID, wl1, 0, flux);
                }

                Query();

                this.ClientScript.RegisterStartupScript(
                    this.GetType(),
                    "calcsuccess",
                    JavaScriptHelper.GetAlertScript("重新计算成功")
                    );
            }
        }
Example #11
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="dataID"></param>
 /// <param name="wl1"></param>
 /// <param name="instantFlux"></param>
 private void UpdateData(int dataID, int wl1, float instantFlux)
 {
     //TODO:
     //
     DitchDataDBI.Update(dataID, wl1, 0, instantFlux);
 }