/// <summary>
/// query 收款账目
/// </summary>
/// <param name="para">ParaBasicReceiptManagement</param>
/// <param name="id">page index</param>
/// <param name="pageSize">page size</param>
/// <returns>list of FnReceiptTitleAssociation</returns>
/// <remarks>2013-10-9 hw created</remarks>
public Dictionary <int, List <FnReceiptTitleAssociation> > QueryReceipt(ParaBasicReceiptManagement para, int id = 1,
int pageSize = 10)
{
return(IReceiptManagementDao.Instance.QueryReceipt(para, id, pageSize));
}
/// <summary>
/// query 收款账目
/// </summary>
/// <param name="para">ParaBasicReceiptManagement</param>
/// <param name="id">page index</param>
/// <param name="pageSize">page size</param>
/// <returns>list of FnReceiptTitleAssociation</returns>
/// <remarks>2013-10-9 hw created</remarks>
public override Dictionary <int, List <FnReceiptTitleAssociation> > QueryReceipt(ParaBasicReceiptManagement para,
int id = 1, int pageSize = 10)
{
string sqlSelect = @"a.*",
sqlFrom = @"FnReceiptTitleAssociation a",
sqlCondition =
@"(
@CodeOrName is null or a.EasReceiptCode=@CodeOrName or a.EasReceiptName=@CodeOrName)
and (@IsDef is null or a.IsDefault=@IsDef)
and (@PayMentType is null or a.PAYMENTTYPESYSNO=@PayMentType)
";
using (var context = Context.UseSharedConnection(true))
{
var lstResult = context.Select <FnReceiptTitleAssociation>(sqlSelect)
.From(sqlFrom)
.AndWhere(sqlCondition)
.Parameter("CodeOrName", para.CodeOrName)
//.Parameter("CodeOrName", para.CodeOrName)
//.Parameter("CodeOrName", para.CodeOrName)
.Parameter("IsDef", para.IsDef == -1 ? null : para.IsDef)
//.Parameter("IsDef", para.IsDef == -1 ? null : para.IsDef)
.Parameter("PayMentType", para.PayMentType == -1 ? null : para.PayMentType)
//.Parameter("PayMentType", para.PayMentType == -1 ? null : para.PayMentType)
.Paging(id, pageSize) //index从1开始
.OrderBy("a.sysno desc")
.QueryMany();
var count = context.Select <int>(@"count(*)")
.From(sqlFrom)
.AndWhere(sqlCondition)
.Parameter("CodeOrName", para.CodeOrName)
//.Parameter("CodeOrName", para.CodeOrName)
//.Parameter("CodeOrName", para.CodeOrName)
.Parameter("IsDef", para.IsDef == -1 ? null : para.IsDef)
//.Parameter("IsDef", para.IsDef == -1 ? null : para.IsDef)
.Parameter("PayMentType", para.PayMentType == -1 ? null : para.PayMentType)
//.Parameter("PayMentType", para.PayMentType == -1 ? null : para.PayMentType)
.QuerySingle();
return(new Dictionary <int, List <FnReceiptTitleAssociation> > {
{ count, lstResult }
});
}
}
/// <summary> /// query 收款账目 /// </summary> /// <param name="para">ParaBasicReceiptManagement</param> /// <param name="id">page index</param> /// <param name="pageSize">page size</param> /// <returns>list of FnReceiptTitleAssociation</returns> /// <remarks>2013-10-9 hw created</remarks> public abstract Dictionary <int, List <FnReceiptTitleAssociation> > QueryReceipt(ParaBasicReceiptManagement para, int id, int pageSize);
