//导出应收应付分析报表
public List <ChargePayAnalysesExt> ExportChargePayAnalysesList(ChragePayAnalyeseParam param)
{
var ctx = this.UnitOfWork as LMS_DbContext;
Check.Argument.IsNotNull(ctx, "数据库对象");
var CustomerCode = new SqlParameter {
ParameterName = "CustomerCode", Value = param.CustomerCode, DbType = DbType.String
};
var VenderCode = new SqlParameter {
ParameterName = "VenderCode", Value = param.VenderCode, DbType = DbType.String
};
var ShippingMethodId = new SqlParameter {
ParameterName = "ShippingMethodId", Value = param.ShippingMethodId, DbType = DbType.Int32
};
var StartTime = new SqlParameter {
ParameterName = "StartTime", Value = param.StartTime, DbType = DbType.Time
};
var EndTime = new SqlParameter {
ParameterName = "EndTime", Value = param.EndTime, DbType = DbType.Time
};
if (ctx != null)
{
var obj = ctx.ExecuteStoredProcedureList <ChargePayAnalysesExt>("P_ExportAccountsPayableAnalyses @CustomerCode,@VenderCode,@ShippingMethodId,@StartTime,@EndTime", CustomerCode, VenderCode, ShippingMethodId, StartTime,
EndTime);
if (obj != null && obj.Count > 0)
{
return(obj.ToList());
}
}
return(new List <ChargePayAnalysesExt>());
}
//查询应收应付分析报表
public IPagedList <ChargePayAnalysesExt> GetChargePayAnalysesList(ChragePayAnalyeseParam param, out int TotalRecord, out int TotalPage)
{
var ctx = this.UnitOfWork as LMS_DbContext;
Check.Argument.IsNotNull(ctx, "数据库对象");
TotalRecord = 0;
TotalPage = 0;
var CustomerCode = new SqlParameter {
ParameterName = "CustomerCode", Value = param.CustomerCode, DbType = DbType.String
};
var VenderCode = new SqlParameter {
ParameterName = "VenderCode", Value = param.VenderCode, DbType = DbType.String
};
var ShippingMethodId = new SqlParameter {
ParameterName = "ShippingMethodId", Value = param.ShippingMethodId, DbType = DbType.Int32
};
var StartTime = new SqlParameter {
ParameterName = "StartTime", Value = param.StartTime, DbType = DbType.Time
};
var EndTime = new SqlParameter {
ParameterName = "EndTime", Value = param.EndTime, DbType = DbType.Time
};
var PageSize = new SqlParameter {
ParameterName = "PageSize", Value = param.PageSize, DbType = DbType.Int32
};
var PageIndex = new SqlParameter {
ParameterName = "PageIndex", Value = param.Page, DbType = DbType.Int32
};
var TotalRecordParam = new SqlParameter {
ParameterName = "TotalRecord", Value = 0, DbType = DbType.Int32, Direction = ParameterDirection.Output
};
var TotalPageParam = new SqlParameter {
ParameterName = "TotalPage", Value = 0, DbType = DbType.Int32, Direction = ParameterDirection.Output
};
if (ctx != null)
{
var obj = ctx.ExecuteStoredProcedureList <ChargePayAnalysesExt>("P_GetAccountsPayableAnalyses", CustomerCode, StartTime,
EndTime, VenderCode, ShippingMethodId, PageIndex, PageSize, TotalRecordParam, TotalPageParam);
if (obj != null && obj.Count > 0)
{
TotalRecord = int.Parse(String.IsNullOrEmpty(TotalRecordParam.Value.ToString())?"0":TotalRecordParam.Value.ToString());
TotalPage = int.Parse(String.IsNullOrEmpty(TotalPageParam.Value.ToString()) ? "0" : TotalPageParam.Value.ToString());
return(new PagedList <ChargePayAnalysesExt>()
{
InnerList = obj.ToList(), PageIndex = param.Page, PageSize = param.PageSize, TotalCount = Convert.ToInt32(TotalRecordParam.Value.ToString()), TotalPages = Convert.ToInt32(TotalPageParam.Value.ToString())
});
}
}
return(new PagedList <ChargePayAnalysesExt>()
{
InnerList = null, PageIndex = param.Page, PageSize = param.PageSize, TotalCount = 0, TotalPages = 0
});
}