Hospital/web/Module/ExamineInfo/SORIS/SumResult.aspx.cs

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

namespace Com.Jpsoft.Hospital.Web.Module.ExamineInfo.SORIS
{
    public partial class SumResult : Com.Jpsoft.Hospital.Web.Common.BasePage
    {
        protected override void OnInit(EventArgs e)
        {
            if (!IsPostBack)
            {
                base.AutoCheckRight = false;
                base.CheckRightParam = Com.Jpsoft.Hospital.Web.Common.PageFuntionType.List;
            }
            base.OnInit(e);
            if (!this.DesignMode)
            {
 
            }
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                ViewState["pageIndex"] = "1";
                Fill(int.Parse(DropDownList1.SelectedValue.ToString()));
            }
        }

        public string GetZYName(object obj)
        {
            if (obj.ToString() != "")
            {
                Com.Jpsoft.Hospital.BLL.ZY_BRSYK bll = new BLL.ZY_BRSYK();
                DataTable dt = bll.GetList(" blh='" + obj.ToString() + "'");
                if (dt.Rows.Count > 0)
                {
                    return dt.Rows[0]["hzxm"].ToString();
                }
            }
            return "";
        }

        public string GetMZName(object obj)
        {
            if (obj.ToString() != "")
            {
                Com.Jpsoft.Hospital.BLL.SF_BRXXK bll = new BLL.SF_BRXXK();
                DataTable dt = bll.GetList(" patid='" + obj.ToString() + "'");
                if (dt.Rows.Count > 0)
                {
                    return dt.Rows[0]["hzxm"].ToString();
                }
            }
            return "";
        }

        public string GetYGName(object obj)
        {
            if (obj.ToString() != "")
            {
                Com.Jpsoft.Hospital.BLL.rs_ygxx bll = new BLL.rs_ygxx();
                DataTable dt = bll.GetList(" ygdm='" + obj.ToString() + "'").Tables[0];
                if (dt.Rows.Count > 0)
                {
                    return dt.Rows[0]["ygxm"].ToString();
                }
            }
            return "";
        }



        private void Fill(int recordType)
        {
            int pageIndex = int.Parse(ViewState["pageIndex"].ToString());
            PagedDataSource pds = new PagedDataSource();
            string start = string.Empty;
            string end = string.Empty;
            ViewState["strWhere"] = "  1=1 and IsProcess=1 ";
            if (recordType == 0)
            {
                if (txtstart.Text.Length > 0)
                {
                    start = Convert.ToDateTime(txtstart.Text).ToString("yyyy/MM/dd");
                    ViewState["strWhere"] += " and ComplainTime>='" + start + "'";
                }
                if (txtEnd.Text.Length > 0)
                {
                    end = Convert.ToDateTime(txtEnd.Text).ToString("yyyy/MM/dd");
                    ViewState["strWhere"] += " and ComplainTime<='" + end + "'";
                }
            }
            else
            {
                if (txtstart.Text.Length > 0)
                {
                    start = Convert.ToDateTime(txtstart.Text).ToString("yyyy/MM/dd");
                    ViewState["strWhere"] += " and PraiseTime>='" + start + "'";
                }
                if (txtEnd.Text.Length > 0)
                {
                    end = Convert.ToDateTime(txtEnd.Text).ToString("yyyy/MM/dd");
                    ViewState["strWhere"] += " and PraiseTime<='" + end + "'";
                }
            }



            if (recordType == 0)
            {
                DataTable dt = GetComplainData().Tables[0];
                //pds.DataSource = dt.DefaultView;
                //this.lblRecordCount.Text = pds.Count.ToString();

                gvList.DataSource = dt;
                gvList.DataBind();
                gvList2.Visible = false;
                gvList.Visible = true;
                #region 动态生成 注释
                //gvList.Columns.Clear();


                //BoundField field = new BoundField();
                //field.DataField = "ComplainTime";
                //field.HeaderText = "投诉时间";
                //gvList.Columns.Add(field);

                //field = new BoundField();
                //field.DataField = "ComplainPhone";
                //field.HeaderText = "投诉人电话";
                //gvList.Columns.Add(field);

                //field = new BoundField();
                //field.DataField = "TypeName";
                //field.HeaderText = "投诉类型";
                //gvList.Columns.Add(field);

                //field = new BoundField();
                //field.DataField = "ygdm";
                //field.HeaderText = "被投诉人工号";
                //gvList.Columns.Add(field);

                //field = new BoundField();
                //field.DataField = "Ygxm";
                //field.HeaderText = "被投诉人姓名";
                //gvList.Columns.Add(field);

                //field = new BoundField();
                //field.DataField = "ksmc";
                //field.HeaderText = "科室";
                //gvList.Columns.Add(field);

                //field = new BoundField();
                //field.DataField = "Context";
                //field.HeaderText = "意见";
                //gvList.Columns.Add(field);
                #endregion
            }
            else
            {
                if (recordType == 1)
                {
                    DataTable dt = GetPraiseData().Tables[0];
                    //pds.DataSource = GetPraiseData().Tables[0].DefaultView;
                    //this.lblRecordCount.Text = pds.Count.ToString();

                    gvList2.DataSource = dt;
                    gvList2.DataBind();

                    gvList.Visible = false;
                    gvList2.Visible = true;
                    #region 动态 注释
                    //gvList.Columns.Clear();
                    //BoundField field = new BoundField();
                    //field.DataField = "PraiseTime";
                    //field.HeaderText = "表扬时间";
                    //gvList.Columns.Add(field);

                    //field = new BoundField();
                    //field.DataField = "PraisePhone";
                    //field.HeaderText = "表扬人电话";
                    //gvList.Columns.Add(field);

                    //field = new BoundField();
                    //field.DataField = "TypeName";
                    //field.HeaderText = "表扬类型";
                    //gvList.Columns.Add(field);

                    //field = new BoundField();
                    //field.DataField = "Ygxm";
                    //field.HeaderText = "被表扬人姓名";
                    //gvList.Columns.Add(field);

                    //field = new BoundField();
                    //field.DataField = "Context";
                    //field.HeaderText = "意见";
                    //gvList.Columns.Add(field);
                    #endregion
                }
            }

            //pds.AllowPaging = true;
            //pds.PageSize = 10;
            //pds.CurrentPageIndex = pageIndex - 1;

            //imabtnNext.Enabled = true;
            //imgbtnPrevious.Enabled = true;
            //if (pds.IsFirstPage)
            //{
            //    imgbtnPrevious.Enabled = false;
            //}
            //if (pds.IsLastPage)
            //{
            //    imabtnNext.Enabled = false;
            //}
            //gvList.DataSource = pds;
            //gvList.DataBind();
        }

        protected void gvList_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            gvList.PageIndex = e.NewPageIndex;
            Fill(int.Parse(DropDownList1.SelectedValue.ToString()));//重新绑定一遍数据
        }

        protected void gvList2_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            gvList2.PageIndex = e.NewPageIndex;
            Fill(int.Parse(DropDownList1.SelectedValue.ToString()));//重新绑定一遍数据
        }




        private DataSet GetComplainData()
        {
            BLL.ts_ComplainRecord bll = new Com.Jpsoft.Hospital.BLL.ts_ComplainRecord();
            string strWhere = string.Empty;
            if (ViewState["strWhere"] != null)
            {
                strWhere = ViewState["strWhere"].ToString();
            }
            return bll.GetListByView(strWhere);
        }

        private DataSet GetPraiseData()
        {
            BLL.ts_PraiseRecord bll = new Com.Jpsoft.Hospital.BLL.ts_PraiseRecord();
            string strWhere = string.Empty;
            if (ViewState["strWhere"] != null)
            {
                strWhere = ViewState["strWhere"].ToString();
            }
            return bll.GetListByView(strWhere);
        }

        protected void imgbtnPrevious_Click(object sender, EventArgs e)
        {
            ViewState["pageIndex"] = (int.Parse(ViewState["pageIndex"].ToString()) - 1).ToString();
            Fill(int.Parse(DropDownList1.SelectedValue.ToString()));
        }

        protected void imabtnNext_Click(object sender, EventArgs e)
        {
            ViewState["pageIndex"] = (int.Parse(ViewState["pageIndex"].ToString()) + 1).ToString();
            Fill(int.Parse(DropDownList1.SelectedValue.ToString()));
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            Fill(int.Parse(DropDownList1.SelectedValue.ToString()));
        }



        protected void btnsftj_Click(object sender, EventArgs e)
        {
            string strWhere = " IsProcess=1 ";
            if (ViewState["strWhere"] != null)
            {
                strWhere = ViewState["strWhere"].ToString();
            }

            //表扬
            if (DropDownList1.SelectedValue == "1")
            {
                Com.Jpsoft.Hospital.BLL.ts_PraiseRecord bll = new BLL.ts_PraiseRecord();
                DataTable dt = bll.GetListByView4Report(strWhere).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    //初始化报表类
                    Com.Jpsoft.Hospital.ReportClass.ExcelReports.Praise praise = new Com.Jpsoft.Hospital.ReportClass.ExcelReports.Praise(txtstart.Text, txtEnd.Text, "", "");

                    //生成并返回报表地址
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        if (dt.Rows[i][0].ToString().Trim() != "")
                        {
                            Com.Jpsoft.Hospital.BLL.ZY_BRSYK zybll = new BLL.ZY_BRSYK();
                            DataTable zydt = zybll.GetList(" blh='" + dt.Rows[i][0].ToString() + "' ");
                            if (zydt.Rows.Count > 0)
                                dt.Rows[i][0] = zydt.Rows[0]["hzxm"].ToString();
                        }
                        else if (dt.Rows[i][1].ToString().Trim() != "")
                        {
                            Com.Jpsoft.Hospital.BLL.SF_BRXXK mzbll = new BLL.SF_BRXXK();
                            DataTable mzdt = mzbll.GetList(" patid='" + dt.Rows[i][1].ToString() + "' ");
                            if (mzdt.Rows.Count > 0)
                                dt.Rows[i][1] = mzdt.Rows[0]["hzxm"].ToString();
                        }
                        else if (dt.Rows[i][2].ToString().Trim() != "")
                        {
                            Com.Jpsoft.Hospital.BLL.rs_ygxx ygbll = new BLL.rs_ygxx();
                            DataTable ygdt = ygbll.GetList(" ygdm='" + dt.Rows[i][2].ToString() + "' ").Tables[0];
                            if (ygdt.Rows.Count > 0)
                                dt.Rows[i][1] = ygdt.Rows[0]["ygxm"].ToString();
                        }
                    }

                    hysftj.NavigateUrl = Page.ResolveClientUrl(praise.GetReportPath(dt, dt.Rows.Count));

                    hysftj.Text = "表扬统计";
                }
            }
            else
            {
                Com.Jpsoft.Hospital.BLL.ts_ComplainRecord bll = new BLL.ts_ComplainRecord();
                DataTable dt = bll.GetListByView4Report(strWhere).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    //初始化报表类
                    Com.Jpsoft.Hospital.ReportClass.ExcelReports.Complain complain = new Com.Jpsoft.Hospital.ReportClass.ExcelReports.Complain(txtstart.Text, txtEnd.Text, "", "");
                    //生成并返回报表地址
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        if (dt.Rows[i][0].ToString().Trim() != "")
                        {
                            Com.Jpsoft.Hospital.BLL.ZY_BRSYK zybll = new BLL.ZY_BRSYK();
                            DataTable zydt = zybll.GetList(" blh='" + dt.Rows[i][0].ToString() + "' ");
                            if (zydt.Rows.Count > 0)
                                dt.Rows[i][0] = zydt.Rows[0]["hzxm"].ToString();
                        }
                        else if (dt.Rows[i][1].ToString().Trim() != "")
                        {
                            Com.Jpsoft.Hospital.BLL.SF_BRXXK mzbll = new BLL.SF_BRXXK();
                            DataTable mzdt = mzbll.GetList(" patid='" + dt.Rows[i][1].ToString() + "' ");
                            if (mzdt.Rows.Count > 0)
                                dt.Rows[i][1] = mzdt.Rows[0]["hzxm"].ToString();
                        }
                        else if (dt.Rows[i][2].ToString().Trim() != "")
                        {
                            Com.Jpsoft.Hospital.BLL.rs_ygxx ygbll = new BLL.rs_ygxx();
                            DataTable ygdt = ygbll.GetList(" ygdm='" + dt.Rows[i][2].ToString() + "' ").Tables[0];
                            if (ygdt.Rows.Count > 0)
                                dt.Rows[i][1] = ygdt.Rows[0]["ygxm"].ToString();
                        }
                    }


                    hysftj.NavigateUrl = Page.ResolveClientUrl(complain.GetReportPath(dt, dt.Rows.Count));

                    hysftj.Text = "投诉统计";
                }
            }


        }

    }
}