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(); }