C# 委托使用示例

最新推荐文章于 2024-01-05 18:01:05 发布

yingying0708

最新推荐文章于 2024-01-05 18:01:05 发布

阅读量425

点赞数

分类专栏：知识收集

本文链接：https://blog.csdn.net/yingying0708/article/details/34106699

版权

知识收集专栏收录该内容

181 篇文章 0 订阅

订阅专栏

services（DAL）：ProcurementServices

/// <summary>

      /// 调用视图View_Procurement_DeviceName获取设备名称列表
      /// </summary>
      /// <param name="wherestr"></param>
      /// <returns></returns>
      public static DataTable GetDeviceName(string wherestr)
      {
          DataTable dt = null;
          string sql = "select * from View_Procurement_DeviceName where 1=1 ";
          if (wherestr == null || wherestr == "")
          {
              dt = DBHelper.GetDataSet(sql);
          }
          else
          {
              dt = DBHelper.GetDataSet(sql+=wherestr);
          }
          return dt;
      }
      /// <summary>
      /// 调用视图View_Procurement_DeviceBrand获取设备品牌列表
      /// </summary>
      /// <param name="wherestr"></param>
      /// <returns></returns>
      public static DataTable GetDeviceBrand(string wherestr)
      {
          DataTable dt = null;
          string sql = "select * from View_Procurement_DeviceBrand where 1=1 ";
          if (wherestr == null || wherestr == "")
          {
              dt = DBHelper.GetDataSet(sql);
          }
          else
          {
              dt = DBHelper.GetDataSet(sql += wherestr);
          }
          return dt;
      }
      /// <summary>
      /// 调用视图View_Procurement_DeviceModel获取设备型号列表
      /// </summary>
      /// <param name="wherestr"></param>
      /// <returns></returns>
      public static DataTable GetDeviceModel(string wherestr)
      {
          DataTable dt = null;
          string sql = "select * from View_Procurement_DeviceModel where 1=1 ";
          if (wherestr == null || wherestr == "")
          {
              dt = DBHelper.GetDataSet(sql);
          }
          else
          {
              dt = DBHelper.GetDataSet(sql += wherestr);
          }
          return dt;
      }

manager（BLL）：ProcurementManager

      public delegate DataTable GetMyView(string sqlwhere);

      public static DataTable GetView(string sqlwhere,GetMyView myview)
      {
          return myview(sqlwhere);
      }

view调用：

        private void GetDeviceModel(string mnstr)
        {
            var ModelNamevalues = ProcurementManager.GetView(mnstr, ProcurementServices.GetDeviceModel);
            this.ddlModel.DataSource = ModelNamevalues;
            this.ddlModel.DataTextField = "DeviceModel";
            this.ddlModel.DataValueField = "DeviceModel";
            this.ddlModel.DataBind();
        }