DAL层，新增一条分页查询语句 DepartmentName

来源：互联网发布：xalharmp3软件怎么下载编辑：程序博客网时间：2024/06/16 16:52
        /// <summary>        /// 获取一个分页列表        /// </summary>        /// <param name="ShiftStatisticsCode">班次号</param>        /// <param name="DepartmentCode">门店编号</param>        /// <param name="IsSend">是否同步</param>        /// <param name="StartShiftDate">班次开始日期</param>        /// <param name="EndShiftDate">班次结束日期</param>        /// <param name="PageSize">每页记录数</param>        /// <param name="PageIndex">当前页码</param>        /// <returns></returns>        public static PageSetInfo Get(string ShiftStatisticsCode, int DepartmentCode,int IsSend, string StartShiftDate, string EndShiftDate, int PageSize, int PageIndex)        {            return Get(ShiftStatisticsCode, DepartmentCode, "", IsSend, StartShiftDate, EndShiftDate, PageSize, PageIndex);        }        /// <summary>        /// 获取一个分页列表        /// </summary>        /// <param name="ShiftStatisticsCode">班次号</param>        /// <param name="DepartmentCode">门店编号</param>        /// <param name="IsSend">是否同步</param>        /// <param name="StartShiftDate">班次开始日期</param>        /// <param name="EndShiftDate">班次结束日期</param>        /// <param name="PageSize">每页记录数</param>        /// <param name="PageIndex">当前页码</param>        /// <returns></returns>        public static PageSetInfo Get(string ShiftStatisticsCode, int DepartmentCode,string DepartmentName, int IsSend, string StartShiftDate, string EndShiftDate, int PageSize, int PageIndex)        {            SqlConnection myConnection = new SqlConnection(string.Format("{0};database={1}", ConstInfo.const_CashDataBaseSource, ConstInfo.const_CashDataBaseName));            SqlCommand myCommand = new SqlCommand("ShiftStatistics_Get", myConnection);            myCommand.CommandType = CommandType.StoredProcedure;            myCommand.Parameters.Add("@ShiftStatisticsCode", SqlDbType.VarChar).Value = ShiftStatisticsCode;            myCommand.Parameters.Add("@DepartmentCode", SqlDbType.Int).Value = DepartmentCode;            myCommand.Parameters.Add("@DepartmentName", SqlDbType.VarChar).Value = DepartmentName;            myCommand.Parameters.Add("@IsSend", SqlDbType.Int).Value = IsSend;            myCommand.Parameters.Add("@StartShiftDate", SqlDbType.VarChar).Value = StartShiftDate;            myCommand.Parameters.Add("@EndShiftDate", SqlDbType.VarChar).Value = EndShiftDate;            myCommand.Parameters.Add("@PageSize", SqlDbType.Int).Value = PageSize;            myCommand.Parameters.Add("@PageIndex", SqlDbType.Int).Value = PageIndex;            myConnection.Open();            PageSetInfo _ShiftStatisticsSetInfo = new PageSetInfo();            try            {                SqlDataReader dr = myCommand.ExecuteReader();                while (dr.Read())                    _ShiftStatisticsSetInfo.ShiftStatisticsInfo.Add(Populate(dr));                dr.NextResult();                while (dr.Read())                    _ShiftStatisticsSetInfo.TotalRecords = Convert.ToInt32(dr["TotalRecords"]);                dr.Close();            }            catch (Exception ex)            {                #region 记录日志                Log_ErrorInfo log_info = new Log_ErrorInfo();                log_info.OperatorNO = DrugSaleSystem.Components.ConstInfo.const_UserCode;                log_info.OperatorName = DrugSaleSystem.Components.ConstInfo.const_UserTrueName;                log_info.OperatorDate = DateTime.Now;                log_info.ErrType = ErrLogParaType.GetEnumName(ErrLogPara.DataBaseErr);                log_info.ErrData = WriteErrLog.ConvertStoredProcedureSQL(myCommand);                log_info.Content = ex.ToString();                DrugSaleSystem.File.WriteErrLog.AppendErr(log_info);                #endregion            }            myConnection.Close();            return _ShiftStatisticsSetInfo;        }
0 0