public DataTable SalaryInfo(SalaryInfoSearchInfo searchInfo)
{
IList<SqlParameter> arrParameter = new List<SqlParameter>();
arrParameter.Add(new SqlParameter { ParameterName = "@page_index", Value = searchInfo.PageIndex });
arrParameter.Add(new SqlParameter { ParameterName = "@page_size", Value = searchInfo.PageSize });
arrParameter.Add(new SqlParameter { ParameterName = "@rows_count", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int });
arrParameter.Add(new SqlParameter { ParameterName = "@salary_sum", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Money });
DataTable dtResult = SqlHelper.ExecuteDataSet(CommandType.StoredProcedure, "SalaryInfo_qry_sp", arrParameter.ToArray()).Tables[0];
searchInfo.RowsCount = Functions.ToConvert<int>(arrParameter.FirstOrDefault(p => p.ParameterName == "@rows_count").SqlValue.ToString());
searchInfo.SalarySum = Functions.ToConvert<double>(arrParameter.FirstOrDefault(p => p.ParameterName == "@salary_sum").SqlValue.ToString());
return dtResult;
}
public IEnumerable<SalaryInfo> SalaryInfo(SalaryInfoSearchInfo searchInfo)
{
DataTable dt = dal.SalaryInfo(searchInfo);
foreach (DataRow dr in dt.Rows)
{
SalaryInfo info = new SalaryInfo
{
Id = Functions.ToConvert<string>(dr["id"]),
Money = Functions.ToConvert<float>(dr["money"]),
SendDate = Functions.ToConvert<string>(dr["send_date"]),
CreateTime = Functions.ToConvert<string>(dr["createtime"])
};
yield return info;
}
}
public DataTable SalaryInfo(SalaryInfoSearchInfo searchInfo)
{
throw new NotImplementedException();
}
public PartialViewResult Index(int pageindex=1)
{
SalaryInfoSearchInfo searchInfo = new SalaryInfoSearchInfo
{
PageIndex = pageindex,
PageSize = MyBlogConfiguration.PagerSize
};
ViewBag.SalaryInfoSearchInfo = searchInfo;
IEnumerable<SalaryInfo> ltSalaryInfo = biz.SalaryInfo(searchInfo);
if (ltSalaryInfo!=null)
{
ViewData.Model = ltSalaryInfo;
return PartialView();
}
return PartialView();
}
