totalview.aspx.cs

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

using System;
using System.Collections;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using RWSB.DatabaseOper;
using ZHENGYI ;
using DateManage;

namespace RWSB.GeneralSearch
{
    /// <summary>
    /// 
    /// 
    /// </summary>
    public partial class totalview : RWSB.PageBase
    {
        DatabaseConnect Dbc = new DatabaseConnect();

        protected void Page_Load(object sender, System.EventArgs e)
        {

            // 在此处放置用户代码以初始化页面
            SetDivePage();
            /*if (Session["userid"]==null)
            {
                Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
                return ;
            }*/
            if (!Page.IsPostBack)
            {

                //string str=" select departmentid from users where userid="+Session["userid"].ToString ();
                //object o=Dbc.GetObjectBySql (str);
                //ViewState["departmentid"]=o.ToString ();
                //dstSearch_Bind();
                fwdept_Bind();
                //avail_Bind();
                dataBind();
            }
        }

        /* protected void dg_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
         {
             dg.EditItemIndex = e.Item.ItemIndex;
             BindGridToSource();
         }

         protected void dg_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
         {
             dg.EditItemIndex = -1;
             BindGridToSource();
         }*/

        protected void dg_DeleteCommand(object source, DataGridCommandEventArgs e)
        {
            if (Session["UserGrade"].ToString().Trim() != "管理员")
            {
                Response.Write("<script>alert('对不起，您不具有删除权限');</script>");
                return;
            }

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

            string DeleteCmd = "DELETE FROM rwxx WHERE rwid = @uid";
            SqlCommand MyCommand = new SqlCommand(DeleteCmd, myconn);

            MyCommand.Parameters.Add(new SqlParameter("@uid", SqlDbType.Int, 4));
            MyCommand.Parameters["@uid"].Value = dg.DataKeys[e.Item.ItemIndex];

            try
            {

                MyCommand.ExecuteNonQuery();
                Response.Write("<script>alert('已删除纪录!');</script>");
                dg.EditItemIndex = -1;
            }
            catch (SqlException Exp)
            {

                Response.Write("<script>alert('错误: 无法删除数据纪录!');</script>");
            }

            MyCommand.Connection.Close();
            BindGridToSource();


        }

        /*  protected void dg_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
          {
              string sqlstring = "select DocumentID,Title,RecordID,documentsn,isuse from document order by DocumentID asc ";
              string strconn = ConfigurationSettings.AppSettings["conn"];
              SqlConnection myconn = new SqlConnection(strconn);
              myconn.Open();
              // 建立 UPDATE 命令字符串
              string UpdateCmd = "UPDATE document SET isuse = @usestate  WHERE DocumentID = @uid";

              SqlCommand MyCommand = new SqlCommand(UpdateCmd, myconn);

              // 设定 UPDATE 命令字串中各个参数的数据类型与长度
              MyCommand.Parameters.Add(new SqlParameter("@uid", SqlDbType.Int, 4));
              MyCommand.Parameters.Add(new SqlParameter("@usestate", SqlDbType.Bit));
            

              // 取得主索引键之值
              MyCommand.Parameters["@uid"].Value = dg.DataKeys[e.Item.ItemIndex];

            
              int NumCols = e.Item.Cells.Count;

              // 略过第一栏与第二栏。
              for (int i = 3; i <= NumCols - 1; i++)
              {
               
                  if (i == 4)
                  {
                      CheckBox CkBox;
                      CkBox = (CheckBox)e.Item.FindControl("CKuse");
                
               
                      // 第四个字段将 True 转换成 1，
                      // 并将 False 转换成 0，
                      if (CkBox.Checked == true)
                          MyCommand.Parameters["@usestate"].Value = 1;
                      else
                          MyCommand.Parameters["@usestate"].Value = 0;
                  }
                
              }
              try
              {
                
                  MyCommand.ExecuteNonQuery();
                  Response.Write("<script>alert('已更新数据纪录!');</script>");
                  dg.EditItemIndex = -1;
              }
              catch (SqlException Exp)
              {
                  if (Exp.Number == 2627)
                      Response.Write("<script>alert('错误: 具有相同主索引键的数据纪录已经存在!');</script>");
                  else
                     Response.Write("<script>alert('错误: 无法更新数据纪录，请确定各字段是否都已正确输入!');</script>");
              }

              MyCommand.Connection.Close();
              BindGridToSource();
          }
          */

        protected void BindGridToSource()
        {


            string con1 = "";
            string con2 = "";
            string con3 = "";
            string con4 = "";
            string con5 = "";
            string con6 = "";

            string btsearch = zynrDDL.SelectedItem.Text.Trim();

            string rqsearch = fwrq.Text.Trim().Replace("'", "''");

            string sqlstring = "select rwid,a.sbsj,xb,rwxz,zcqj,zyxm,wcsl,a.zycj,a.zycjorder,rwsn from rwxx  a ";

            if (dstSearch.SelectedItem.Text.Trim() != "")
            {
                con1 = " xb = '" + dstSearch.SelectedItem.Text.Trim() + "'  and ";

            }
            else
            {
                con1 = "";
            }


            if (btsearch != "")
            {
                con2 = " zyxm = '" + zynrDDL.SelectedItem.Text.Trim() + "'  and ";
            }
            else
            {
                con2 = "";
            }


            if (rwxzDDL.SelectedItem.Text.Trim() != "")
            {
                con3 = " rwxz = '" + rwxzDDL.SelectedItem.Text.Trim() + "'  and ";
            }
            else
            {
                con3 = "";
            }

            if (fwdept.SelectedItem.Text.Trim() != "")
            {
                con4 = " a.zycj = '" + fwdept.SelectedItem.Text.Trim() + "'  and ";
            }
            else
            {
                con4 = "";
            }


            if (rqsearch != "")
            {
                con5 = " rwsn  like '%" + rqsearch + "%'  and ";
            }
            else
            {
                con5 = "";
            }



            con6 = " status = 1 ";



            if (con1 == "" && con2 == "" && con3 == "" && con4 == "" && con5 == "")
            {
                //sqlstring += " order by zycjorder asc";
                sqlstring += " ,(select zycjorder,max(rwid) row,sbsj,zycj from rwxx group by zycjorder,sbsj,zycj) b where (a.zycjorder= b.zycjorder and a.sbsj = b.sbsj and a.zycj = b.zycj) order by a.zycjorder asc,b.sbsj desc";
            }
            else
            {
                sqlstring += " ,(select zycjorder,max(rwid) row,sbsj,zycj from rwxx group by zycjorder,sbsj,zycj) b where (a.zycjorder= b.zycjorder and a.sbsj = b.sbsj and " + con1 + con2 + con3 + con4 + con5 + con6 + ") order by a.zycjorder asc,b.sbsj desc";
                // sqlstring += "  where " + con1 + con2 + con3 + con4 + con5 + con6 ;
            }

            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");
                dg.DataSource = ds.Tables["rwxx"].DefaultView;
                dg.DataBind();
            }
            catch (Exception exception)
            {
                //Response.Write("<script>alert('查询任务时出错！');</script>");
                Response.Write(exception.Message);
                Response.End();
                myconn.Close();
                return;
            }
        }

        /*private void dstSearch_Bind()
        {
            string sqlstring = "select zypritype,zytypename from ZyPriType order by zypritype asc ";
            string strconn = ConfigurationSettings.AppSettings["conn"];
            SqlConnection myconn = new SqlConnection(strconn);
            myconn.Open();
            SqlCommand mycmd = new SqlCommand(sqlstring, myconn);
            SqlDataReader dr = mycmd.ExecuteReader();

            dstSearch.DataSource = dr;
            dstSearch.DataTextField = "zytypename";
            dstSearch.DataValueField = "zypritype";
            dstSearch.DataBind();
            myconn.Close();
       
        }*/

        private void fwdept_Bind()
        {
            string sqlstring = "select id,bmname,showorder from ExigenceDegree order by showorder asc ";
            string strconn = ConfigurationSettings.AppSettings["conn"];
            SqlConnection myconn = new SqlConnection(strconn);
            myconn.Open();
            SqlCommand mycmd = new SqlCommand(sqlstring, myconn);
            SqlDataReader dr = mycmd.ExecuteReader();

            fwdept.DataSource = dr;
            fwdept.DataTextField = "bmname";
            fwdept.DataValueField = "showorder";
            fwdept.DataBind();
            myconn.Close();

        }




        private void SetDivePage()
        {
            dg.AllowPaging = true;
            dg.PageSize = 10;

            ZHENGYI.BindDataDelegate f = new ZHENGYI.BindDataDelegate(dataBind);//修改这个dataBind,让f 指向你的方法。 
            divepage.SetTarget(dg, f, 15);
        }

        private void dataBind()
        {

            BindGridToSource();


        }
        #region Web 窗体设计器生成的代码
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }

        /// <summary>
        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
        /// 此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {
            this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
            this.dg.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dg_ItemDataBound);

        }
        #endregion

        private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            dataBind();
        }

        private void dg_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {

                if (e.Item.Cells[3].Text.Length > 30)
                {
                    e.Item.Cells[3].Text = "<a href=\"#\" onclick=\"openwin('" + e.Item.Cells[0].Text + "')\" title=\"" + e.Item.Cells[3].Text + "\">" + e.Item.Cells[3].Text.Substring(0, 30) + "...</a>";

                }
                else
                {

                    e.Item.Cells[3].Text = "<a href=\"#\" onclick=\"openwin('" + e.Item.Cells[0].Text + "')\"  title=\"" + e.Item.Cells[3].Text + "\">" + e.Item.Cells[3].Text + "</a>";
                }

                if (e.Item.Cells[5].Text.Length > 40)
                {
                    e.Item.Cells[5].Text = e.Item.Cells[5].Text.Substring(0, 40) + "...";

                }
                else
                {

                    e.Item.Cells[5].Text = e.Item.Cells[5].Text;
                }
            }
        }


        protected void btnmodify_click(object sender, EventArgs e)
        {
            LinkButton lbtnTemp = sender as LinkButton;
            //取得保存在LinkButton的CommandArgument的ID值. 
            string rID = lbtnTemp.CommandArgument;

            if (Session["UserGrade"].ToString().Trim() != "车间技术员")
            {
                Response.Write("<script>alert('对不起，您不具有修改权限');</script>");
                return;
            }
            /*try
            {
                string strconn = ConfigurationSettings.AppSettings["conn"];
                SqlConnection myconn = new SqlConnection(strconn);
                myconn.Open();

                string EditCmd = "select *  FROM rwxx WHERE rwid = "+rID ;
                SqlCommand MyCommand = new SqlCommand(EditCmd, myconn);              
               
                SqlDataReader edr = MyCommand.ExecuteReader();

                string userdept;
                DateTime xztime;
                //if (edr.Read())
                //{
                Response.Write(edr["zycj"].ToString());
                Response.End();

                  string zjmc = edr["zycj"].ToString();
                  userdept = zjmc;
                  DateTime sbtime = Convert.ToDateTime(edr["sbsj"].ToString());
                  xztime = sbtime;
                //}
                edr.Close();
                edr.Dispose();
                
                if (Session["userbmmc"].ToString().Trim() != userdept)
                {
                    Response.Write("<script>alert('只有该部门技术员才能修改！');</script>");
                    return;
                }

                DateTimeManger dtm = new DateTimeManger();
                long offtime = 2;


                if (dtm.DateDiff(DateInterval.Day, xztime, DateTime.Now) > offtime)
                {
                    Response.Write("<script>alert('已超过修改时限！');</script>");
                    return;
                }

                MyCommand.Connection.Close();
                MyCommand.Dispose();
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
                Response.End();
            }*/
            
            Response.Redirect("AddFilesModify.aspx?rwxxid=" + rID);
        }
    }
}