protected void ASPxDashboardViewer1_DataLoading(object sender, DevExpress.DashboardWeb.DataLoadingWebEventArgs e)
        {
            using (var connection = new SqlConnection(StrConn))
            {
                var registersTendency = new dsRegister.RegistersTendencyDataTable();
                connection.Open();
                string sqlRegistersTendency = String.Format("select mmr.CreateDate ,mmr.[Hour] ,SUM(mmr.DataValue) DataValue " +
                                                            "from M_MemberRegister mmr WITH(NOLOCK) " +
                                                            "where mmr.ModifyTime >DATEADD(hour, {0}, GETDATE()) " +
                                                            "group by mmr.CreateDate,mmr.[Hour] order by mmr.CreateDate,mmr.[Hour]",
                                                            tendencyHour);
                var result = connection.Query <RegistersTendencyEntity>(sqlRegistersTendency);
                foreach (var item in result)
                {
                    registersTendency.AddRegistersTendencyRow(item.CreateDate, item.Hour, item.DataValue);
                }

                e.Data = registersTendency;
            }
        }
Exemple #2
0
        protected void OnDashBoard2Fresh(object sender, UserEventArgs e)
        {
            using (var connection = new SqlConnection(StrConn))
            {
                var registersTendency = new dsRegister.RegistersTendencyDataTable();
                connection.Open();
                string sqlRegistersTendency = String.Format("select  mmr.CreateDate ,mmr.[Hour] ,mmr.MemberLevel,mmr.DataValue DataValue " +
                                                            "from M_MemberRegister mmr WITH(NOLOCK) " +
                                                            "where mmr.ModifyTime >DATEADD(hour, {0}, GETDATE()) " +
                                                            "order by mmr.CreateDate,mmr.[Hour]",
                                                            e.Value);

                var result = connection.Query <RegistersTendencyEntity>(sqlRegistersTendency);
                foreach (var item in result)
                {
                    registersTendency.AddRegistersTendencyRow(item.CreateDate, item.Hour, item.DataValue);
                }

                dataSourse = registersTendency;
            }

            CallBackDashBoard2.DataSourse = dataSourse;
        }