/// <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;
}
DAL层,新增一条分页查询语句 DepartmentName
最新推荐文章于 2021-02-02 02:05:36 发布