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

查詢輸出

微信小程序端

界面代碼wxml
界面代碼需要使用for循環(huán)將信息循環(huán)出來

<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的里面定義的一致秕衙，一會(huì)會(huì)標(biāo)記破花。
**dmID={{item.dmID}}**這里兩個(gè)大括號(hào)是需要查詢出來的信息欲芹。
*微信js代碼*js
onShow: function () {
    this.getDepartmentList();
  },
  getDepartmentList: function () {
    var self = this;
    wx.request({
      url: '',//鏈接
      method: "GET",
      header: {
        'content-type': 'application/json' // 默認(rèn)值
      },
      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調(diào)用了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)//微信小程序調(diào)用的這個(gè)方法
        {
            SetPro(department);//調(diào)用上面那個(gè)方法
            //獲取數(shù)據(jù)
            return Content(new AjaxResult { state = ResultType.success.ToString(), message = "true", data = departments }.ToJson());//這里轉(zhuǎn)換了一下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";//數(shù)據(jù)庫查詢語句
            sql = string.Format(sql);
            SqlDataReader Reader = Helper.SQLHelper.GetReader(sql);
            List<Department> list = new List<Department>();//使用model層來進(jìn)行存儲(chǔ)
            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;
        }