columnlist0513.ascx.cs

用vs2005写的一个生产任务管理系统。数据的统计和综合查询是主要功能

	using System;
	using System.Data;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;
    using System.ComponentModel;
    using System.Configuration;
    using System.Data.SqlClient;
    using System.Web.SessionState;
    using System.Web.UI;


using RWSB.DatabaseOper;

namespace RWSB
{
	/// <summary>
	///		columnlist 的摘要说明。
	/// </summary>
    public partial class columnlist : System.Web.UI.UserControl 
	{
        DatabaseConnect Dbc = new DatabaseConnect();

		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (!this.IsPostBack)
			{
               dataBind();
			}		
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		///		设计器支持所需的方法 - 不要使用代码编辑器
		///		修改此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			
		}
		#endregion

        private void dataBind()
        {

            BindGridToSource();

        }

        protected void BindGridToSource()
        {

            string sqlstring = "select zycj as '车间名称', ";
            sqlstring += " (select sum(qmjc) from rwxx where zycj = t.zycj) as '全面检查（km）' , ";
            sqlstring += " (select sum(mdgj) from rwxx where zycj = t.zycj) as '锚段关节（组）', ";
            sqlstring += " (select sum(xc)  from rwxx where zycj = t.zycj) as '线岔（组）', ";
            sqlstring += " (select sum(fd)  from rwxx where zycj = t.zycj) as '分段（组）', ";
            sqlstring += " (select sum(fx)  from rwxx where zycj = t.zycj) as '分相（组）', ";
            sqlstring += " (select sum(gdx) from rwxx where zycj = t.zycj) as '供电线（米）', ";
            sqlstring += " (select sum(jypp) from rwxx where zycj = t.zycj) as '绝缘子（片）', ";
            sqlstring += " (select sum(jypb) from rwxx where zycj = t.zycj)  as '绝缘子（棒）' ";
            sqlstring += " from rwxx t group by zycj ";

   

            string strconn = ConfigurationSettings.AppSettings["conn"];
            SqlConnection myconn = new SqlConnection(strconn);
            try
            {

                myconn.Open();

                SqlDataAdapter mycmd = new SqlDataAdapter(sqlstring, myconn);
                DataSet ds = new DataSet();
                mycmd.Fill(ds, "rwxx");
                tjGV.DataSource = ds.Tables["rwxx"].DefaultView;
                tjGV.DataBind();
            }
            catch (Exception exception)
            {
                //Response.Write("<script>alert('统计查询出错！');</script>");
                Response.Write(exception.Message);
                Response.End();
                myconn.Close();
                return;
            }
        }
	}
}