xmlerWeb/Manage/WenJuan/WenJuanInfoReportList.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections.Generic;

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Common;
using System.Data;
using Maticsoft.BLL.diaocha;
using System.Data.SqlClient;
using Maticsoft.DBUtility;
namespace THG.Web.Manage.WenJuan
{
  

    public partial class WenJuanInfoReportList : AdminPage
    {
        int pageSize = 15;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                ViewState["pageNo"] = 1;
                if (UserMaster.RoleID =="0")//管理员吧
                {
                    ViewState["sWhere"] = " IsPubish='是'";
                }

                if (UserMaster.RoleID == "1")//统计员
                {
                    ViewState["sWhere"] = " IsPubish='是' and TjUserId='" + UserMaster.UserID + "'";
                }

                BindWenJuanInfoList(Convert.ToInt32(ViewState["pageNo"]), pageSize, ViewState["sWhere"].ToString());
            
            }

        }

    

        /// <summary>
        /// 分页绑定方法
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="strSql"></param>
        protected void BindWenJuanInfoList(int pageIndex, int pageSize, string sWhere)
        {
            //采用代码分页方法
            int iRecordCount = 0;

            string sql = @"id,[WenJuanName],[Remark],[StartDate],[EndDate],[isAll],[AddTime],
                        (SELECT [UserName] FROM .[dbo].[UserMaster] where [UserID]=wj.TjUserId ) as TjUserName
                        ,(SELECT count(id) FROM  [MemberDiaoChaMaster]
                         where [WenJuanId]=wj.ID  and [IsOver]=1 and [isLast]=1) as DiaoChaCount
                        ,(SELECT count(id) FROM  WenJuanTitleInfo
                         where [WenJuanId]=wj.ID ) as TmCount";

            DataSet ds = Common.cPageBase.PageList("WenJuanInfo wj", "id", sql, pageSize, pageIndex, " addtime  desc ", sWhere, out iRecordCount);