TurnOverDisplay.aspx.cs

（开头部分） 3KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MyWeb.DBUtility;
using MyWeb.WebUtility;
using System.Data;

namespace MyWeb
{
    public partial class TurnOverDisplay : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if(!IsPostBack){
                DBHelper db = new DBHelper();
                string sql = "select sum(orderPrice) as total from Order_Tbl where isOver=1 and del=0";
                DataSet ds = db.Query(sql);
                if (ds.Tables[0].Rows[0]["total"].ToString() != "")
                {
                    TextBox1.Text = ds.Tables[0].Rows[0]["total"].ToString() + "元";
                }
                else {
                    TextBox1.Text = "0元";
                }
                //sql = "select sum(orderPrice) as Mtotal from Order_Tbl where idOver=1 and del=0 and addDate>=dateadd(dd,-day(getdate())+1,getdate()) and addDate<=getdate()";
                //ds = db.Query(sql);
                //if (ds.Tables[0].Rows[0]["Mtotal"].ToString() != "")
                //{
                //    TextBox2.Text = ds.Tables[0].Rows[0]["Mtotal"].ToString() + "元";
                //    TextBox3.Text = (Convert.ToDouble(ds.Tables[0].Rows[0]["Mtotal"].ToString()) / 30) + "元";
                //}
                //else {
                //    TextBox2.Text =  "0元";
                //    TextBox3.Text =  "0元";
                //}
                
            }
        }
        public void searchTimeRange(object sender, EventArgs e)
        {
            DBHelper db = new DBHelper();
            string sqlwhere="";
            if (TextBox2.Text!="")
            {
                sqlwhere += " and addDate>='" + TextBox2.Text.Replace("T"," ") + "'";
            }
            if (TextBox3.Text != "")
            {
                sqlwhere += " and addDate<='" + TextBox3.Text.Replace("T", " ") + "'";
            }
            string sql = "select sum(orderPrice) as total from Order_Tbl where isOver=1 and del=0 "+sqlwhere+"";
            DataSet ds = db.Query(sql);
            if (ds.Tables[0].Rows[0]["total"].ToString() != "")
            {
                TextBox1.Text = ds.Tables[0].Rows[0]["total"].ToString() + "元";
            }
            else
后面还有 22 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。