dailymoney.aspx.cs

课程设计了

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Dailymon_DailyMoney : System.Web.UI.Page
{
    protected int CaiGouNum = 0;
    protected double CaiGouAllMon = 0;
    protected int ZhiChuNum = 0;
    protected double ZhiChuAllMon = 0;
    protected int SellNum = 0;
    protected double SellAllMon = 0;
    protected double SellCost = 0;
    protected double Selllr = 0;
    protected double SellMaoLr = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
      
        /*if (Session["flag"] == null)
        {
            Response.Write("<script language=JavaScript>{window.alert('网络超时或你还未登录，请重新登陆!');window.location.href='admin_login.aspx';}</script>");
        
        
        }// 在此处放置用户代码以初始化页面
         * */

        if (!Page.IsPostBack)
        {
            this.LbShowTongBeing.Text = System.DateTime.Now.ToString("yyyy-MM-dd");

            this.LbShowTongEnd.Text = System.DateTime.Now.ToString("yyyy-MM-dd");

            this.LbShowToday.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
            
            string caigousql = "SELECT sum(AffordMoney) FROM SupplyList where (CONVERT (VARCHAR(20), ListDateTime, 120) >= '"+this.LbShowTongBeing.Text.ToString().Trim()+"') AND (CONVERT (VARCHAR(10),ListDateTime, 120) <= '"+this.LbShowTongEnd.Text.ToString().Trim()+"')";
            this.LbCaiGouAllMon.Text = DataBindingtest.zongjia(caigousql);
            string zhichusql = "SELECT sum(MoneyChang) FROM MoneyMag  where (CONVERT (VARCHAR(20), MoneyMagDate, 120) >= '" + this.LbShowTongBeing.Text.ToString().Trim() + "') AND (CONVERT (VARCHAR(10),MoneyMagDate, 120) <= '" + this.LbShowTongEnd.Text.ToString().Trim() + "'and JinChu='出款')";
            this.LbZhiChuAllMon.Text = DataBindingtest.zongjia(zhichusql);
            string sellsql="SELECT sum(SellNum) FROM SellList where (CONVERT (VARCHAR(20), SellDateTime, 120) >=  '"+this.LbShowTongBeing.Text.ToString().Trim()+"')AND (CONVERT (VARCHAR(10),SellDateTime, 120) <='"+this.LbShowTongEnd.Text.ToString().Trim()+"')";
            this.LbSellAllMon.Text = DataBindingtest.zongjia(sellsql);
            string shoyisql = "SELECT sum(MoneyChang) FROM MoneyMag  where (CONVERT (VARCHAR(20), MoneyMagDate, 120) >= '" + this.LbShowTongBeing.Text.ToString().Trim() + "') AND (CONVERT (VARCHAR(10),MoneyMagDate, 120) <= '" + this.LbShowTongEnd.Text.ToString().Trim() + "'and JinChu='进款')";
            this.LbShouyiAllMon.Text = DataBindingtest.zongjia(shoyisql);
            
            string sellcost = Convert.ToString(Convert.ToDouble(this.LbCaiGouAllMon.Text) + Convert.ToDouble(this.LbZhiChuAllMon.Text));
            this.LbSellCost.Text = sellcost;
            string selllr = Convert.ToString(Convert.ToDouble(this.LbSellAllMon.Text) + Convert.ToDouble(this.LbShouyiAllMon.Text));
            this.LbSellLr.Text = selllr;
            string sellmaolr = Convert.ToString(Convert.ToDouble(selllr) - Convert.ToDouble(sellcost));
            this.LbSellMaoLr.Text = sellmaolr;
        
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string BeginTime = this.SearchBeginTime.Text.ToString();
        string EndTime = this.SearchEndTime.Text.ToString();
        this.LbShowTongBeing.Text = BeginTime;
        this.LbShowTongEnd.Text = EndTime;

        this.SqlDataSource1.DataBind();
        this.GridView1.DataBind();
        string sql = "SELECT sum(AffordMoney) FROM SupplyList where (CONVERT (VARCHAR(20), ListDateTime, 120) >= '" +BeginTime.Trim() + "') AND (CONVERT (VARCHAR(10),ListDateTime, 120) <= '" +EndTime.Trim() + "')";
        this.LbCaiGouAllMon.Text = DataBindingtest.zongjia(sql);

        this.SqlDataSource2.DataBind();
        this.GridView2.DataBind();
        string zhichusql = "SELECT sum(MoneyChang) FROM MoneyMag  where (CONVERT (VARCHAR(20), MoneyMagDate, 120) >= '" + this.LbShowTongBeing.Text.ToString().Trim() + "') AND (CONVERT (VARCHAR(10),MoneyMagDate, 120) <= '" + this.LbShowTongEnd.Text.ToString().Trim() + "'and JinChu='出款')";
        this.LbZhiChuAllMon.Text = DataBindingtest.zongjia(zhichusql);

        this.SqlDataSource3.DataBind();
        this.GridView3.DataBind();
        string sellsql = "SELECT sum(SellNum) FROM SellList where (CONVERT (VARCHAR(20), SellDateTime, 120) >=  '" + this.LbShowTongBeing.Text.ToString().Trim() + "')AND (CONVERT (VARCHAR(10),SellDateTime, 120) <='" + this.LbShowTongEnd.Text.ToString().Trim() + "')";
        this.LbSellAllMon.Text = DataBindingtest.zongjia(sellsql) ;


        this.SqlDataSource4.DataBind();
        this.GridView4.DataBind();
        
        string shoyisql = "SELECT sum(MoneyChang) FROM MoneyMag  where (CONVERT (VARCHAR(20), MoneyMagDate, 120) >= '" + this.LbShowTongBeing.Text.ToString().Trim() + "') AND (CONVERT (VARCHAR(10),MoneyMagDate, 120) <= '" + this.LbShowTongEnd.Text.ToString().Trim() + "'and JinChu='进款')";
        this.LbShouyiAllMon.Text = DataBindingtest.zongjia(shoyisql);
       
       string sellcost = Convert.ToString(Convert.ToDouble(this.LbCaiGouAllMon.Text) + Convert.ToDouble(this.LbZhiChuAllMon.Text));
        this.LbSellCost.Text = sellcost;
        string selllr = Convert.ToString(Convert.ToDouble(this.LbSellAllMon.Text) + Convert.ToDouble(this.LbShouyiAllMon.Text));
        this.LbSellLr.Text = selllr;
        string sellmaolr = Convert.ToString(Convert.ToDouble(selllr) - Convert.ToDouble(sellcost));
        this.LbSellMaoLr.Text = sellmaolr;
        
    
    }

  

  
}