web/WebUserControl11.ascx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
public partial class web_WebUserControl11 : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string ConnStr1 = System.Configuration.ConfigurationManager.ConnectionStrings["ConnStr"].ToString();
        SqlConnection cn = new SqlConnection(ConnStr1);
        String sql = "select  History.RoomId 房间号,RoomCategory.Name 房间类型名称,sum(TotalPrice) 每间房盈利,History.BeginTime 赢利开始时间,History.EndTime 赢利结束时间 from History,RoomsInfo,RoomCategory where History.RoomId=RoomsInfo.RoomId and RoomsInfo.RcategoryId=RoomCategory.RcategoryId and RoomCategory.Name='" + DropDownList1.SelectedItem + "' and History.EndTime is not null group by RoomCategory.Name,History.RoomId,History.BeginTime,History.EndTime";
        cn.Open();
        SqlCommand cmd = new SqlCommand(sql, cn);
        SqlDataAdapter da = new SqlDataAdapter(sql, cn);
        DataTable dt = new DataTable();
        da.Fill(dt);
        int i = dt.Rows.Count;
        float f = 0;
        for (int k = 0; k < i; k++)
        {
            string r = dt.Rows[k][2].ToString();
            //if (r.Equals(""))
            //{
            //    dt.Rows[k][4] = "在住";
            //}
           f =f+ float.Parse(r);

        }
        GridView1.DataSource = dt;
        GridView1.DataBind();
        cn.Close();
        Label2.Text = f.ToString();
    }


}