微信小程序与.net的Web交互

查询输出

微信小程序端

界面代码wxml
界面代码需要使用for循环将信息循环出来

<navigator url="../DepartmentDetails/DepartmentDetails?dmID={{item.dmID}}" wx:for="{{departments}}" bindtap='toDetail' data-index="{{index}}">
        <view class="weui-cell__bd">{{item.dmName}}</view>
        <view class="weui-cell__ft weui-cell__ft_in-access"></view>
      </navigator>
**wx:for="{{departments}}"** 这里的departments需要与MVC的里面定义的一致，一会会标记。
**dmID={{item.dmID}}**这里两个大括号是需要查询出来的信息。
*微信js代码*js
onShow: function () {
    this.getDepartmentList();
  },
  getDepartmentList: function () {
    var self = this;
    wx.request({
      url: '',//链接
      method: "GET",
      header: {
        'content-type': 'application/json' // 默认值
      },
      success: function (res) {
        console.log(res);//输出一下，看看能不能查不出来
        self.setData({
          departments: res.data.data,//这里的departments需要与界面里面相同
            });
          }
        });
  }

MVC

*controller中的代码*
 List<Department> departments = new List<Department>();
        private void SetPro(Department department)
        {
            List<Department> dm = new DepartmentBLL().GetDepartment(department);
              //这里是controller调用了BLL层，代码在下方
            ViewBag.dl = dm;
            foreach (Model.Department d in ViewBag.dl)
            {
                departments.Add(new Department { dmID = d.dmID, dmName = d.dmName });
            }
        }
        public ActionResult getProgream01(Department department)//微信小程序调用的这个方法
        {
            SetPro(department);//调用上面那个方法
            //获取数据
            return Content(new AjaxResult { state = ResultType.success.ToString(), message = "true", data = departments }.ToJson());//这里转换了一下json格式，需要注意的是**data = departments**这里要与微信小程序的res.data.data相同，需要注意的是MVC.departments=wxjs.departments =wxhtml.departments
        }

BLL层

 public List<Department> GetDepartment(Department department)
        {
            return new DAL.DepartmentDAL().GetDepartment(department);
        }

DAL层

public List<Department> GetDepartment(Department department)
        {
            string sql = "select *  from tb_department";//数据库查询语句
            sql = string.Format(sql);
            SqlDataReader Reader = Helper.SQLHelper.GetReader(sql);
            List<Department> list = new List<Department>();//使用model层来进行存储
            while (Reader.Read())
            {
                list.Add(new Department()
                {
                    dmID = Convert.ToInt32(Reader["dmID"]),
                    dmName = (Reader["dmName"]).ToString(),
                    dmImg1 = Reader["dmImg1"].ToString(),
                    dmImg2 = Reader["dmImg2"].ToString(),
                    dmText = Reader["dmText"].ToString(),
                    dmRange = Reader["dmRange"].ToString(),
                });
            }
            Reader.Close();
            return list;
        }