/// <summary>
        /// 输出系统日志
        /// </summary>
        /// <param name="userInfo">用户信息</param>
        /// <param name="ex">异常信息</param>
        private static void WriteSystemLog(UserInfoUtil userInfo, int ModuleType, Exception ex)
        {
            /* 
             * 出现异常时，输出系统日志到文本文件 
             * 考虑出现异常情况比较少，尽管一个方法可能多次异常，
             *      但还是考虑将异常日志的变量定义放在catch里面
             */
            //定义变量
            LogInfo logSys = new LogInfo();
            //设置日志类型 需要指定为系统日志
            logSys.Type = LogInfo.LogType.SYSTEM;
            //指定系统日志类型 出错信息
            logSys.SystemKind = LogInfo.SystemLogKind.SYSTEM_ERROR;
            //指定登陆用户信息
            logSys.UserInfo = userInfo;
            //设定模块ID
            if (ModuleType == 0)
            {
                logSys.ModuleID = ConstUtil.MODULE_ID_INCOMEBILL_ADD;
            }
            else
            {
                logSys.ModuleID = ConstUtil.MODULE_ID_INCOMEBILL_LIST;
            }
            //描述
            logSys.Description = ex.ToString();

            //输出日志
            LogUtil.WriteLog(logSys);
        }

    protected void Page_Load(object sender, EventArgs e)
    {
        userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
        if (!Page.IsPostBack)
        {
            this.txt_begintime.Text = DateTime.Now.ToString("yyyy-MM-01");
            this.txt_endtime.Text = DateTime.Now.ToString("yyyy-MM-dd");

            string flag = this.summaryType.Value;
            switch (flag)
            {
                case "1":
                    lbl_title.Text = "部门/分店名称";
                    break;
                case "2":
                    lbl_title.Text = "业务员姓名";
                    break;
                case "3":
                    lbl_title.Text = "产品名称";
                    break;
            }
            rpt_result1.DataSource = UserProjectInfoBus.GetSummaryData(this.txt_begintime.Text, this.txt_endtime.Text, userInfo, typeorder.Value, int.Parse(this.summaryType.Value),userInfo.SelPoint);
            rpt_result1.DataBind();
        }
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        userInfo = SessionUtil.Session["UserInfo"] as UserInfoUtil;
        // 小数位数
        _selPoint = int.Parse(userInfo.SelPoint);
        if (!IsPostBack)
        {
            FlowApply1.BillTypeFlag = ConstUtil.BILL_TYPECODE_STORAGE_QUALITY;
            FlowApply1.BillTypeCode = ConstUtil.BILL_TYPECODE_STORAGE_NOPASS;

            checkNo.CodingType = ConstUtil.CODING_RULE_StorageQuality_NO;
            checkNo.ItemTypeID = ConstUtil.CODING_RULE_StorageNOPass_NO;
            #region 初始化
            int EmployeeId = userInfo.EmployeeID;
            string Company = userInfo.CompanyCD;
            string UserID = userInfo.UserID;
            txtCloseDate.Text = Convert.ToDateTime(DateTime.Now.ToShortDateString()).ToString("yyyy-MM-dd");
            txtCloser.Value = userInfo.EmployeeName;
            txtCloserReal.Value = userInfo.EmployeeName;
            txtCloser.Value = EmployeeId.ToString();
            txtConfirmor.Value = userInfo.EmployeeName;
            txtConfirmDate.Text = Convert.ToDateTime(DateTime.Now.ToShortDateString()).ToString("yyyy-MM-dd");
            tbCreater.Text = userInfo.EmployeeName;
            txtCreateDate.Text = Convert.ToDateTime(DateTime.Now.ToShortDateString()).ToString("yyyy-MM-dd");
            txtModifiedUserID.Text = UserID;
            txtModifiedDate.Text = Convert.ToDateTime(DateTime.Now.ToShortDateString()).ToString("yyyy-MM-dd");
            tbProcessDate.Text = Convert.ToDateTime(DateTime.Now.ToShortDateString()).ToString("yyyy-MM-dd");

            hiddenModifiedUserID.Value = UserID;

            #endregion
        }
    }

        /// <summary>
        /// 获得任务状态
        /// </summary>
        /// <param name="userInfo">当前用户信息</param>
        /// <param name="userList">查询人员列表</param>
        /// <param name="dtS">开始时间</param>
        /// <param name="dtE">结束时间</param>
        /// <returns></returns>
        public static DataTable GetTask(UserInfoUtil userInfo, string userList, Nullable<DateTime> dtS, Nullable<DateTime> dtE)
        {
            string sql = @"SELECT tab1.UserID, tab1.MainDate, tab1.ReportStatus, tab1.TaskType,COUNT(*) AS Num  FROM (
                                SELECT t.Principal AS UserID
                                  ,SUBSTRING(CONVERT(VARCHAR ,t.CompleteDate ,120) ,0 ,11) AS MainDate
                                  ,CASE t.[Status]
			                            WHEN 1 THEN '待下达'
			                            WHEN 2 THEN '未完成'
			                            WHEN 3 THEN '已完成'
			                            WHEN 4 THEN '已撤销'
			                            WHEN 5 THEN '已考评'
					                    ELSE '状态错误'
		                            END AS ReportStatus
                                  ,t.TaskType
                            FROM   officedba.Task t
                            WHERE  [email protected] 
                                AND t.Principal IN ({0})
                                AND DATEDIFF(DAY, @DateStart, t.CompleteDate) >= 0 
                                AND DATEDIFF(DAY, t.CreateDate, @DateEnd) >= 0
) AS tab1
GROUP BY tab1.MainDate,tab1.ReportStatus,tab1.UserID,tab1.TaskType";
            SqlParameter[] parms = 
                           {
                               new SqlParameter("@CompanyCD",userInfo.CompanyCD),
                               new SqlParameter("@DateStart",dtS.Value),
                               new SqlParameter("@DateEnd",dtE.Value)
                           };

            return SqlHelper.ExecuteSql(String.Format(sql, userList), parms);
        }

        /// <summary>
        /// 获得日志状态
        /// </summary>
        /// <param name="userInfo">当前用户信息</param>
        /// <param name="userList">查询人员列表</param>
        /// <param name="dtS">开始时间</param>
        /// <param name="dtE">结束时间</param>
        /// <returns></returns>
        public static DataTable GetPersonalNote(UserInfoUtil userInfo, string userList, Nullable<DateTime> dtS, Nullable<DateTime> dtE)
        {
            string sql = @"SELECT  pn.Creator AS UserID, SUBSTRING(CONVERT(VARCHAR, pn.NoteDate, 120), 0, 11) AS MainDate
		                    , CASE pn.[Status]
			                    WHEN 0 THEN '草稿'
			                    WHEN 1 THEN '已提交'
			                    WHEN 2 THEN '已点评'
					            ELSE '状态错误'
		                      END AS ReportStatus
		                    ,pn.[Status]
                            FROM   officedba.PersonalNote pn
                            WHERE [email protected] 
                                AND pn.Creator IN ({0}) 
                                AND DATEDIFF(DAY, @DateStart, pn.NoteDate) >= 0 
                                AND DATEDIFF(DAY, pn.NoteDate, @DateEnd) >= 0
                            GROUP BY pn.Creator,pn.NoteDate,pn.[Status]";
            SqlParameter[] parms = 
                           {
                               new SqlParameter("@CompanyCD",userInfo.CompanyCD),
                               new SqlParameter("@DateStart",dtS.Value),
                               new SqlParameter("@DateEnd",dtE.Value)
                           };

            return SqlHelper.ExecuteSql(String.Format(sql, userList), parms);
        }

 private static int ruleCode; //企业员工编号规则码
 protected void Page_Load(object sender, EventArgs e)
 {
     userinfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
     if (!Page.IsPostBack)
     {
         initState();
     }
 }

 protected void Page_Load(object sender, EventArgs e)
 {
     userInfo = SessionUtil.Session["UserInfo"] as UserInfoUtil;
     // 小数位数
     _selPoint = int.Parse(userInfo.SelPoint);
     if (!Page.IsPostBack)
     {
         BinddrpStorageName();//绑定仓库名称
     }
 }

    //protected bool Check_page_security_validate_code(string fromUrl)
    //{
    //   string _page_security_validate_code = GetParam("_page_security_validate_code");
    //   bool isok = CRCer.CheckString(_page_security_validate_code);
    //    if(!isok)
    //    {
    //        return false;
    //    }

    //    string _fromUrl = _page_security_validate_code.Substring(0,_page_security_validate_code.Length - 6);

    //    return (_fromUrl == fromUrl);

    //}

    public void ProcessRequest(HttpContext context)
    {
        
        _context = context;
        _request = context.Request;
        _response = context.Response;
        _context.Response.ContentType = "text/plain";

        UserInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];

        if (UserInfo == null)
        {
            OutputResult(false,"Session过期,请重新登陆");
            return;
        }

        if (_request.UrlReferrer == null)
        {
            OutputResult(false, "未授权的访问.");
            return;
        }

        if (_request.UrlReferrer.Host != _request.Url.Host)
        {
            OutputResult(false, "未授权的访问.");
            return;
        }

        //string fromUrl = _request.UrlReferrer.PathAndQuery;
        //if (fromUrl.IndexOf("))/") != -1)
        //{ 
        //    fromUrl = fromUrl.Substring(  fromUrl.IndexOf("))/")+3);
        //}
      
        //if (!Check_page_security_validate_code(fromUrl))
        //{
        //    OutputResult(false, "未授权的访问.");
        //    return;
        //}



     

        _action = GetParam("action");//获取当前的ACTION

        if (_action == string.Empty)
        {
            Output("未指定action");
        }
        else
        {
            ActionHandler(_action);
        }
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        txtContent.Attributes.Add("onkeyup", "freshLength(this)");
        ImageButton1.Attributes.Add("onclick", "return checkInput()");

        UserInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];

        //XBase.Model.SystemManager.CompanyOpenServModel entity = XBase.Business.SystemManager.CompanyOpenServBus.GetCompanyOpenServInfo(UserInfo.CompanyCD);
        DataSet ds = new XBase.Business.KnowledgeCenter.MyKeyWord().GetCompanyOpenServ(UserInfo.CompanyCD);
        smCnt.Text = ds.Tables[0].Rows[0]["ManMsgNum"].ToString();

    }

    protected void Page_Load(object sender, EventArgs e)
    {
        userInfo = SessionUtil.Session["UserInfo"] as UserInfoUtil;
        // 小数位数
        _selPoint = int.Parse(userInfo.SelPoint);

        if (!Page.IsPostBack)
        {
            DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString());

            if (dt != null)
            {
                HidDeptID.Value = dt["ID"].ToString();

            }
        }
    }

 /// <summary>
 /// 输出系统日志
 /// </summary>
 /// <param name="userInfo">用户信息</param>
 /// <param name="ex">异常信息</param>
 private static void WriteSystemLog(UserInfoUtil userInfo, Exception ex)
 {
     /* 
      * 出现异常时，输出系统日志到文本文件 
      * 考虑出现异常情况比较少，尽管一个方法可能多次异常，
      * 但还是考虑将异常日志的变量定义放在catch里面
      */
     //定义变量
     LogInfo logSys = new LogInfo();
     //设置日志类型 需要指定为系统日志
     logSys.Type = LogInfo.LogType.SYSTEM;
     //指定系统日志类型 出错信息
     logSys.SystemKind = LogInfo.SystemLogKind.SYSTEM_ERROR;
     //指定登陆用户信息
     logSys.UserInfo = userInfo;
     //设定模块ID
     logSys.ModuleID = ConstUtil.MODULE_ID_ACCOUNTSUBJECTS_SETTING;
     //描述
     logSys.Description = ex.ToString();
     //输出日志
     LogUtil.WriteLog(logSys);
 }

 public string errorstr = string.Empty; //错误串
 protected void Page_Load(object sender, EventArgs e)
 {
     userinfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
 }

        /// <summary>
        /// 根据日期获得汇报任务列表
        /// </summary>
        /// <param name="reportDate">时间</param>
        /// <param name="isNew">是否是新增</param>
        /// <param name="userInfo">用户信息</param>
        /// <returns></returns>
        public static DataTable GetAllReport(DateTime reportDate, bool isNew, UserInfoUtil userInfo)
        {
            string strSql = @"SELECT t.id AS ID,t.Title AS Title,t.[Content] AS [Content],0 AS ReportType
FROM officedba.Task t
WHERE [email protected] 
        AND ([email protected] OR CHARINDEX(','[email protected]+',',','+ISNULL(t.Joins,'')+',')>0 ) 
	    AND DATEDIFF(DAY,t.CreateDate,@Time)>=0 AND DATEDIFF(DAY,@Time,t.CompleteDate)>=0
        {0}
UNION ALL
SELECT pda.id AS ID,pda.ArrangeTItle AS Title,pda.[Content] AS [Content],1 AS ReportType
FROM officedba.PersonalDateArrange pda
WHERE [email protected] 
        AND ([email protected] OR CHARINDEX(','+cast(@userID AS VARCHAR)+',',','+ISNULL(pda.CanViewUser,'')+',')>0 ) 
	    AND DATEDIFF(DAY,pda.StartDate,@Time)>=0 AND DATEDIFF(DAY,@Time, pda.EndDate)>=0 {1} ";
            SqlParameter[] parameters = new SqlParameter[] 
                        {
                            new SqlParameter("@Time", SqlDbType.DateTime),
                            new SqlParameter("@CompanyCD", SqlDbType.VarChar),
                            new SqlParameter("@userID", SqlDbType.Int),
                            new SqlParameter("@userName", SqlDbType.VarChar)
                        };
            parameters[0].Value = reportDate;
            parameters[1].Value = userInfo.CompanyCD;
            parameters[2].Value = userInfo.EmployeeID;
            parameters[3].Value = userInfo.UserName;
            strSql = String.Format(strSql, isNew ? "AND t.Status=2" : "", isNew ? "AND pda.Status<>'2'" : "");
            return SqlHelper.ExecuteSql(strSql, parameters);
        }

 /// <summary>
 /// 获得人员岗位权限
 /// </summary>
 /// <param name="userInfo">当前用户信息</param>
 /// <param name="userList">查询人员列表</param>
 /// <returns></returns>
 public static DataTable GetQuarter(UserInfoUtil userInfo, string userList)
 {
     return XBase.Data.OperatingModel.AimManager.PersonalAnalysisDBHelper.GetQuarter(userInfo, userList);
 }

 /// <summary>
 /// 获得目标状态
 /// </summary>
 /// <param name="userInfo">当前用户信息</param>
 /// <param name="userList">查询人员列表</param>
 /// <param name="dtS">开始时间</param>
 /// <param name="dtE">结束时间</param>
 /// <returns></returns>
 public static DataTable GetAim(UserInfoUtil userInfo, string userList, Nullable<DateTime> dtS, Nullable<DateTime> dtE)
 {
     return XBase.Data.OperatingModel.AimManager.PersonalAnalysisDBHelper.GetAim(userInfo, userList, dtS, dtE);
 }

 /// <summary>
 /// 导入数据命令
 /// </summary>
 /// <param name="dr">数据集</param>
 /// <param name="userInfo">人员信息</param>
 /// <returns></returns>
 private static SqlCommand GetImportInsert(DataRow dr, UserInfoUtil userInfo)
 {
     SqlCommand cmd = new SqlCommand();
     cmd.CommandText = @"INSERT INTO officedba.SubProductSendPrice(CompanyCD, ProductID, DeptID, SendPrice,SendPriceTax, SendTax, Discount, Creator, CreateDate, ModifiedDate,ModifiedUserID)
                         SELECT @CompanyCD
                                 ,(SELECT TOP(1) pi1.ID FROM officedba.ProductInfo pi1 WHERE [email protected] AND [email protected])
                                 ,ISNULL((SELECT TOP(1) di.ID FROM officedba.DeptInfo di WHERE [email protected] AND [email protected]),0)
                                 ,@SendPrice,@SendPrice*([email protected]),@SendTax,@Discount,@Creator,GETDATE(),GETDATE(),@ModifiedUserID";
     SqlParameter[] paras = { 
                                new SqlParameter("@CompanyCD",SqlDbType.VarChar),
                                new SqlParameter("@ProdNo",SqlDbType.VarChar),
                                new SqlParameter("@DeptName",SqlDbType.VarChar),
                                new SqlParameter("@SendPrice",SqlDbType.Decimal),
                                new SqlParameter("@SendTax",SqlDbType.Decimal),
                                new SqlParameter("@Discount",SqlDbType.Decimal),
                                new SqlParameter("@Creator",SqlDbType.Int),
                                new SqlParameter("@ModifiedUserID",SqlDbType.VarChar)
                            };
     int i = 0;
     paras[i++].Value = userInfo.CompanyCD;
     paras[i++].Value = dr["物品编号"];
     paras[i++].Value = dr["分店名称"];
     paras[i++].Value = dr["去税单价"];
     paras[i++].Value = dr["税率"];
     paras[i++].Value = dr["折扣(%)"];
     paras[i++].Value = userInfo.EmployeeID;
     paras[i++].Value = userInfo.UserID;
     cmd.Parameters.AddRange(paras);
     return cmd;
 }

    protected void Page_PreLoad(object sender, EventArgs e)
    {
        //获得用户页面控制权限
        UserInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];

        //XBase.Common.CRCer.GetValidateCode(this.Page);


        //获得工程路径
        String currentDomainPath = System.AppDomain.CurrentDomain.BaseDirectory;
        //Session时间过期
        if (UserInfo == null)
        {
            Response.Redirect("~/Pages/SystemErrorPage/TimeOutPage.aspx");
            return;
        }

        //获得ModuleID
        string moduleID = (string)Request.QueryString["ModuleID"];
        //ModuleID为空时，默认为不对页面进行权限控制
        if (string.IsNullOrEmpty(moduleID))
        {
            moduleID = (string)Session["curpage_ModuleID"];
            if (string.IsNullOrEmpty(moduleID))
                return;
        }
        else
        {
            Session["curpage_ModuleID"] = moduleID;
        }

        //ModuleID类型判断，如果不为数字，则输出Error
        if (!ValidateUtil.IsInt(moduleID))
        {
            // ModuleID不为数字时，为错误ID，页面跳转去没有权限的页面
            //Response.Redirect("~/Pages/SystemErrorPage/NoAuthorityPage.aspx");
            return;
        }
        //获得页面控制权限
        string[] AuthInfo = SafeUtil.GetPageAuthority(moduleID, UserInfo);
        //有权限操作页面
        if (AuthInfo != null && AuthInfo.Length > 0)
        {
            //可操作的控件显示
            for (int i = 0; i < AuthInfo.Length; i++)
            {
                try
                {
                    //设置可见
                    this.FindControl(AuthInfo[i].Trim()).Visible = true;
                }
                catch //页面没有此控件时
                {
                    //TODO
                    continue;
                }
            }
        }
        //没有权限操作页面，页面跳转
        else
        {
            // Response.Redirect("~/Pages/SystemErrorPage/NoAuthorityPage.aspx");
        }
    }

        /// <summary>
        /// 获得日程状态
        /// </summary>
        /// <param name="userInfo">当前用户信息</param>
        /// <param name="userList">查询人员列表</param>
        /// <param name="dtS">开始时间</param>
        /// <param name="dtE">结束时间</param>
        /// <returns></returns>
        public static DataTable GetArrange(UserInfoUtil userInfo, string userList, Nullable<DateTime> dtS, Nullable<DateTime> dtE)
        {
            string sql = @"SELECT pda.Creator
	                              ,pda.StartDate
                                  ,pda.EndDate
                                  ,ISNULL(pda.[Status],0) AS Status
                                  ,CASE ISNULL(pda.[Status],0)
                                        WHEN 0 THEN '草稿'
                                        WHEN 1 THEN '已提交'
                                        WHEN 2 THEN '已点评'
					                    ELSE '状态错误'
                                   END AS ReportStatus
                            FROM   officedba.PersonalDateArrange pda
                            WHERE  [email protected] 
                                AND pda.Creator IN ({0})
                                AND DATEDIFF(DAY, @DateStart, pda.EndDate) >= 0 
                                AND DATEDIFF(DAY, pda.StartDate, @DateEnd) >= 0";
            SqlParameter[] parms = 
                           {
                               new SqlParameter("@CompanyCD",userInfo.CompanyCD),
                               new SqlParameter("@DateStart",dtS.Value),
                               new SqlParameter("@DateEnd",dtE.Value)
                           };

            return SqlHelper.ExecuteSql(String.Format(sql, userList), parms);
        }

 /// <summary>
 /// 根据日期获得汇报任务列表
 /// </summary>
 /// <param name="reportDate">时间</param>
 /// <param name="isNew">是否是新增</param>
 /// <param name="userInfo">用户信息</param>
 /// <returns></returns>
 public static DataTable GetAllReport(DateTime reportDate, bool isNew, UserInfoUtil userInfo)
 {
     return PersonalNoteDBHelper.GetAllReport(reportDate, isNew, userInfo);
 }

 /// <summary>
 /// 获得采购订单编号
 /// </summary>
 /// <param name="pageIndex">当前页</param>
 /// <param name="pageCount">每页记录数</param>
 /// <param name="orderBy">排序方法</param>
 /// <param name="TotalCount">总记录数</param>
 /// <param name="userInfo">用户信息实体类</param>
 /// <returns></returns>
 public static DataTable SelectPurchaseOrder(int pageIndex, int pageCount, string orderBy, ref int TotalCount
     , UserInfoUtil userInfo)
 {
     SqlCommand comm = new SqlCommand();
     comm.CommandText = @"SELECT DISTINCT po.ID
                               ,po.OrderNo
                               ,po.Title
                         FROM   officedba.PurchaseOrder po
                                INNER JOIN officedba.PurchaseOrderDetail pod
                                     ON  po.CompanyCD = pod.CompanyCD
                                         AND po.OrderNo = pod.OrderNo
                                         AND pod.ProductCount>pod.ArrivedCount
                         WHERE [email protected] AND po.BillStatus<>'1'";
     comm.Parameters.Add(new SqlParameter("@CompanyCD", userInfo.CompanyCD));
     return SqlHelper.PagerWithCommand(comm, pageIndex, pageCount, orderBy, ref TotalCount);
 }