本文介绍了Web应用程序的每周销售的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述


我目前正在开发Web应用程序.在此,我必须显示今天的销售额,每周的销售额和每月的销售额.我不知道要显示每周的销售量.我想同时显示详细信息和图表.任何人都有获取当前周详细信息的想法...?

谢谢....

Hi,
I am currently working on a web application. In this I have to display today''s sales, weekly sale''s and monthly sales. I didn''t get the idea to display weekly sales. I want to display both details and chart. Anybody have the idea to get the current weeks details...?

Thank you....

推荐答案

// to get First date of week
        public string fDate()
        {
            DayOfWeek weekStart = new DayOfWeek();
            DateTime startdate = DateTime.Today.AddDays(weekStart - DateTime.Today.DayOfWeek);
            string Fdateofweek= startdate.ToShortDateString();
            return Fdateofweek;
        }
        // to get today date
        public string cDate()
        {
            DateTime enddate = DateTime.Today;
            string CurrnetDay =enddate.ToShortDateString();
            return CurrnetDay;
        }



现在进行Sql查询
就像



Now Make Sql Query
like

string query = "select * from tablename WHERE Date BETWEEN '" + fDate() + "' AND '" + cDate() + "'";


这篇关于Web应用程序的每周销售的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-18 20:52