/// <summary>
/// 获取支出登帐信息
/// </summary>
/// <param name="model">支出登帐信息查询实体</param>
/// <param name="PageSize">每页条数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">总记录数</param>
/// <returns></returns>
public IList <EyouSoft.Model.FinanceStructure.MSpendRegister> GetList(EyouSoft.Model.FinanceStructure.MQuerySpendRegister model, int PageSize, int PageIndex, ref int RecordCount)
{
if (model == null || model.CompanyId <= 0)
{
return(null);
}
return(dal.GetList(model, base.HaveUserIds, PageSize, PageIndex, ref RecordCount));
}
/// <summary>
/// 根据查询实体生成SqlWhere语句
/// </summary>
/// <param name="model">查询实体</param>
/// <param name="HaveUserIds">用户Id集合，半角逗号分割</param>
/// <param name="strOrder">排序语句</param>
/// <returns>SqlWhere语句</returns>
private string GetSqlWhere(EyouSoft.Model.FinanceStructure.MQuerySpendRegister model, string HaveUserIds
, ref string strOrder)
{
if (model == null || model.CompanyId <= 0)
{
return(string.Empty);
}
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat(" CompanyId = {0} ", model.CompanyId);
if (model.StartTime.HasValue)
{
strWhere.AppendFormat(" and datediff(dd,'{0}',PayTime) >= 0 ", model.StartTime.Value.ToShortDateString());
}
if (model.EndTime.HasValue)
{
strWhere.AppendFormat(" and datediff(dd,PayTime,'{0}') >= 0 ", model.EndTime.Value.ToShortDateString());
}
if (!string.IsNullOrEmpty(HaveUserIds))
{
strWhere.AppendFormat(" and OperatorId in ({0}) ", HaveUserIds);
}
if (model.PayType.HasValue)
{
strWhere.AppendFormat(" and PayType = {0} ", (int)model.PayType.Value);
}
if (model.SupplierId > 0)
{
strWhere.AppendFormat(" and SupplierId = {0} ", model.SupplierId);
}
switch (model.OrderIndex)
{
case 0:
strOrder = " PaymentTime asc ";
break;
case 1:
strOrder = " PaymentTime desc ";
break;
}
return(strWhere.ToString());
}
/// <summary>
/// 获取支出登帐信息
/// </summary>
/// <param name="model">支出登帐信息查询实体</param>
/// <param name="HaveUserIds">用户Id集合，半角逗号分割</param>
/// <param name="PageSize">每页条数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">总记录数</param>
/// <returns></returns>
public IList <EyouSoft.Model.FinanceStructure.MSpendRegister> GetList(EyouSoft.Model.FinanceStructure.MQuerySpendRegister model, string HaveUserIds, int PageSize, int PageIndex, ref int RecordCount)
{
if (model == null || model.CompanyId <= 0)
{
return(null);
}
IList <EyouSoft.Model.FinanceStructure.MSpendRegister> list = new List <EyouSoft.Model.FinanceStructure.MSpendRegister>();
string strFiles = " [RegisterId],[CompanyId],[PayTime],[Amount],[PayType],[SupplierId],[SupplierName],[Realname],[Telephone],[Remark],[RegisterTime],[OperatorId],[OffAmount] ";
string strOrder = string.Empty;
string strWhere = this.GetSqlWhere(model, HaveUserIds, ref strOrder);
using (IDataReader dr = DbHelper.ExecuteReader(_db, PageSize, PageIndex, ref RecordCount, "tbl_CashierRegister", "ID", strFiles, strWhere, strOrder))
{
EyouSoft.Model.FinanceStructure.MSpendRegister tmpModel = null;
while (dr.Read())
{
tmpModel = new EyouSoft.Model.FinanceStructure.MSpendRegister();
if (!dr.IsDBNull(dr.GetOrdinal("RegisterId")))
{
tmpModel.RegisterId = dr.GetInt32(dr.GetOrdinal("RegisterId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CompanyId")))
{
tmpModel.CompanyId = dr.GetInt32(dr.GetOrdinal("CompanyId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PayTime")))
{
tmpModel.PayTime = dr.GetDateTime(dr.GetOrdinal("PayTime"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Amount")))
{
tmpModel.Amount = dr.GetDecimal(dr.GetOrdinal("Amount"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PayType")))
{
tmpModel.PayType = (EyouSoft.Model.EnumType.TourStructure.RefundType)dr.GetInt32(dr.GetOrdinal("PayType"));
}
if (!dr.IsDBNull(dr.GetOrdinal("SupplierId")))
{
tmpModel.SupplierId = dr.GetInt32(dr.GetOrdinal("SupplierId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("SupplierName")))
{
tmpModel.SupplierName = dr.GetString(dr.GetOrdinal("SupplierName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Realname")))
{
tmpModel.Realname = dr.GetString(dr.GetOrdinal("Realname"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Telephone")))
{
tmpModel.Telephone = dr.GetString(dr.GetOrdinal("Telephone"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Remark")))
{
tmpModel.Remark = dr.GetString(dr.GetOrdinal("Remark"));
}
if (!dr.IsDBNull(dr.GetOrdinal("RegisterTime")))
{
tmpModel.RegisterTime = dr.GetDateTime(dr.GetOrdinal("RegisterTime"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OperatorId")))
{
tmpModel.OperatorId = dr.GetInt32(dr.GetOrdinal("OperatorId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OffAmount")))
{
tmpModel.OffAmount = dr.GetDecimal(dr.GetOrdinal("OffAmount"));
}
list.Add(tmpModel);
}
}
return(list);
}
