Winform菜鸟驿站管理系统-数据报表制作方法和逻辑层代码展示

最新推荐文章于 2024-05-30 14:43:08 发布

xinZhu8

最新推荐文章于 2024-05-30 14:43:08 发布

阅读量583

点赞数 10

分类专栏： C# Winform 文章标签： c# 开发语言

本文链接：https://blog.csdn.net/totos11111/article/details/134987177

版权

C# Winform 专栏收录该内容

11 篇文章 1 订阅

订阅专栏

1，上一期分享快递完成度的统计，以及界面代码的展示，本期将展示DAL层和BLL层代码在界面初始化中代码显示如下；

 private void FrmExpCompletionStatistics_Load(object sender, EventArgs e)
 {
     //站点下拉框加载
     FormUtility.LoadCboStations(cboStations, stationBLL);
     cboStations.SelectedIndex = 0;
     //统计当前的完成度
     //默认加载已完成的列表
     dgvExpList.AutoGenerateColumns = false;
     StatisticsCompletionCount();
 }

2，站点下拉框加载部分 BLL层

  /// <summary>
  /// 加载站点下拉框
  /// </summary>
  /// <param name="cboStations"></param>
  public static void LoadCboStations(ComboBox cboStations, StationBLL statBLL)
  {
      List<StationInfo> stationList01 = statBLL.GetCboStationList();
      stationList01.Insert(0, new StationInfo()
      {
          StationId=0,
          StationName= "请选择站点"
      });
      cboStations.DisplayMember = "StationName";
      cboStations.ValueMember = "StationId";
      cboStations.DataSource = stationList01;
  }

站点下拉框加载部分 DAL层

/// <summary>
/// 获取绑定下拉框的所有站点列表
/// </summary>
/// <returns></returns>
public List<StationInfo> GetCboStationList()
{
    return stationDAL.GetCboStationList();
}

3，上一期有个根据站点统计完成度的方法实现如下：StatExpressCountData 如下是BLL层和DAL层代码

 /// <summary>
 /// 快递完成度数量统计 
 /// </summary>
 /// <param name="stationId"></param>
 /// <returns></returns>
 public List<ExpressCountInfo> StatExpressCountData(int stationId = 0)
 {
     int[] reCounts = statisticsDAL.StatExpressCountData(stationId);
     List<ExpressCountInfo> statList = new List<ExpressCountInfo>();
     statList.Add(new ExpressCountInfo() { ExpState = "已完成数", ExpCount = reCounts[0] });
     statList.Add(new ExpressCountInfo() { ExpState = "未完成数", ExpCount = reCounts[1] });
     return statList;
 }

DAL层

 /// <summary>
 /// 统计快递完成度数量
 /// </summary>
 /// <param name="stationId"></param>
 /// <returns></returns>
 public int[] StatExpressCountData(int stationId = 0)
 {
     string sql = "select * from StatisticsExpCompletion(" + stationId + ")";
     DataTable dt = SqlHelper.GetDataTable(sql, 1);
     int[] reCounts = new int[2];  //定义数组   new int[2] 表示两个长度的数组
     if (dt.Rows.Count>0)
     {
         reCounts[0] = (int)dt.Rows[0][0];
         reCounts[1] = (int)dt.Rows[0][1];
     }
     return reCounts;
 }

3，数据类型转换 GetInt

/// <summary>
/// 将object转换为int
/// </summary>
/// <param name="oValue"></param>
/// <returns></returns>
public static int GetInt(this object oValue)
{
    int reInt = 0;
    try
    {
        reInt = Convert.ToInt32(oValue);
    }
    catch
    {
        reInt = 0;
    }

    return reInt;
}

4，结果显示如下