public IList <InFeeInfoAuditListExt> GetInFeeInfoExport(InFeeInfoAuditParam param)
{
//var ctx = this.UnitOfWork as LMS_DbContext;
//Check.Argument.IsNotNull(ctx, "数据库对象");
var ctx = new LMS_DbContext();
var numberlist = new List <string>();
var list = string.Empty;
if (!string.IsNullOrWhiteSpace(param.SearchContext))
{
numberlist = param.SearchContext.Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList();
list = string.Join(",", numberlist.Distinct());
}
var CustomerCode = new SqlParameter {
ParameterName = "CustomerCode", Value = param.CustomerCode, 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 CountryCode = new SqlParameter {
ParameterName = "CountryCode", Value = param.CountryCode, DbType = DbType.String
};
var SearchWhere = new SqlParameter {
ParameterName = "SearchWhere", Value = param.SearchWhere, DbType = DbType.Int32
};
var SearchContext = new SqlParameter {
ParameterName = "SearchContext", Value = list, DbType = DbType.String
};
var Status = new SqlParameter {
ParameterName = "Status", Value = param.Status, DbType = DbType.Int32
};
var PageSize = new SqlParameter {
ParameterName = "PageSize", Value = param.PageSize, DbType = DbType.Int32
};
var PageIndex = new SqlParameter {
ParameterName = "PageIndex", Value = param.Page, DbType = DbType.Int32
};
if (ctx != null)
{
var obj = ctx.ExecuteStoredProcedureList <InFeeInfoAuditListExt>("P_GetReceivingExpensesList_Export @CustomerCode,@ShippingMethodId,@CountryCode,@StartTime,@EndTime,@SearchWhere,@SearchContext,@Status,@PageSize,@PageIndex"
, CustomerCode, ShippingMethodId, CountryCode, StartTime, EndTime, SearchWhere, SearchContext, Status, PageSize, PageIndex);
if (obj != null && obj.Count > 0)
{
return(obj);
}
}
return(null);
}
public int GetInFeeInfoExportTotalCount(InFeeInfoAuditParam param)
{
var ctx = this.UnitOfWork as LMS_DbContext;
Check.Argument.IsNotNull(ctx, "数据库对象");
int isSuccess = 0;
var CustomerCode = new SqlParameter {
ParameterName = "CustomerCode", Value = param.CustomerCode, DbType = DbType.String
};
var ShippingMethodId = new SqlParameter {
ParameterName = "ShippingMethodId", Value = param.ShippingMethodId ?? (object)DBNull.Value, 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 CountryCode = new SqlParameter {
ParameterName = "CountryCode", Value = param.CountryCode ?? (object)DBNull.Value, DbType = DbType.String
};
var Status = new SqlParameter {
ParameterName = "Status", Value = param.Status ?? (object)DBNull.Value, DbType = DbType.Int32
};
var TotalRecord = new SqlParameter {
ParameterName = "TotalRecord", Value = 0, DbType = DbType.Int32, Direction = ParameterDirection.Output
};
if (ctx != null)
{
ctx.ExecuteCommand("Exec P_GetReceivingExpensesList_Export_TotalCount @CustomerCode,@ShippingMethodId,@CountryCode,@StartTime,@EndTime,@Status,@TotalRecord output"
, CustomerCode, ShippingMethodId, CountryCode, StartTime, EndTime, Status, TotalRecord);
Int32.TryParse(TotalRecord.Value.ToString(), out isSuccess);
}
return(isSuccess);
}
/// <summary>
/// 收货费用
/// Add By zhengsong
/// Time:2014-06-30
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public IPagedList <InFeeInfoAuditListExt> GetAuditPagedList(InFeeInfoAuditParam param)
{
var ctx = this.UnitOfWork as LMS_DbContext;
Check.Argument.IsNotNull(ctx, "数据库对象");
var numberlist = new List <string>();
var list = string.Empty;
if (!string.IsNullOrWhiteSpace(param.SearchContext))
{
numberlist = param.SearchContext.Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList();
list = string.Join(",", numberlist.Distinct());
}
var CustomerCode = new SqlParameter {
ParameterName = "CustomerCode", Value = param.CustomerCode, 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 DateWhere = new SqlParameter { ParameterName = "DateWhere", Value = param.DateWhere, DbType = DbType.Int32 };
var CountryCode = new SqlParameter {
ParameterName = "CountryCode", Value = param.CountryCode, DbType = DbType.String
};
var SearchWhere = new SqlParameter {
ParameterName = "SearchWhere", Value = param.SearchWhere, DbType = DbType.Int32
};
var SearchContext = new SqlParameter {
ParameterName = "SearchContext", Value = list, DbType = DbType.String
};
var TotalRecord = new SqlParameter {
ParameterName = "TotalRecord", Value = 0, DbType = DbType.Int32, Direction = ParameterDirection.Output
};
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 TotalPage = new SqlParameter {
ParameterName = "TotalPage", Value = 0, DbType = DbType.Int32, Direction = ParameterDirection.Output
};
var Status = new SqlParameter {
ParameterName = "Status", Value = param.Status, DbType = DbType.Int32
};
if (ctx != null)
{
var obj = ctx.ExecuteStoredProcedureList <InFeeInfoAuditListExt>("P_GetReceivingExpensesPagedList"
, CustomerCode, ShippingMethodId,
StartTime, EndTime, CountryCode, SearchWhere,
SearchContext, Status, TotalRecord,
PageSize, PageIndex, TotalPage);
if (obj != null && obj.Count > 0)
{
return(new PagedList <InFeeInfoAuditListExt>()
{
InnerList = obj.ToList(), PageIndex = param.Page, PageSize = param.PageSize, TotalCount = Int32.Parse(TotalRecord.Value.ToString()), TotalPages = Int32.Parse(TotalPage.Value.ToString())
});
}
}
return(new PagedList <InFeeInfoAuditListExt>()
{
InnerList = null, PageIndex = param.Page, PageSize = param.PageSize, TotalCount = 0, TotalPages = 0
});
}
