js 简单的向后台传参方式 及简单的导出功能案例c#

 一个简单的导出的按钮。

<div class="btn-group">
<input id="btn_Upload" onclick="btn_Upload()" type="button" class="btn btn-primary" value="导出" />
</div>

然后获取参数向后台传递的过程 

<script>

function btn_Upload() {
        var User_tx = $("#User_tx").val();
        var OP_name = $("#OP_name").val();
        var OP_Phone = $("#OP_Phone").val();
        var province = $("#province option:selected").val();
        var grid = $("#grid option:selected").val();
        $.modalAlert("正在请求数据（请勿关闭，等待处理数据直接下载）", "success");
        window.location.href = CreatFullDeployUrl("/Optimal/GetSearchIndexListOut?User_tx=" + User_tx + "&OP_name=" + OP_name + "&OP_Phone=" + OP_Phone + "&province=" + province + "&grid=" + grid);
    }

</script>

 

后台接收，及简单的导出的功能实例：

        /// <summary>
        /// 数据导出
        /// </summary>
        /// <returns></returns>
        public ActionResult GetSearchIndexListOut()
        {
			//获取登陆人code
			string usercode = ServiceContext.GetUserInfo().UserPhone;
			//根据登录人找到对应省份
			List<string> provinces = FZHelpClass.GetprovinceList(usercode);

			string User_tx = Request["User_tx"];
            string OP_name = Request["OP_name"];
            string OP_Phone = Request["OP_Phone"];
            string province = Request["province"];
            string grid = Request["grid"];
			if (string.IsNullOrWhiteSpace(province))
			{
				foreach (var item in provinces)
				{
					province += "'" + item + "',";
				}
				if (!string.IsNullOrWhiteSpace(province))
				{
					province = province.Substring(0, province.Length - 1);
				}
			} 

            #region     ##报表数据
            List<SMS_OP_DAILY> List = FZHelpClass.GetExChangeDT(User_tx, OP_name, OP_Phone, province, grid);
            List<string> stu = new List<string>() { "##名称","##销售##","##账号","省份","网格","时间","##渠道","##地址",
                    "拜访内容"};
            DataTable tbbody = new DataTable("tb");
            foreach (var item in stu)
                tbbody.Columns.Add(item);
            var rw = tbbody.NewRow();
            for (int i = 0; i < stu.Count; i++)
                rw[i] = stu[i];
            tbbody.Rows.Add(rw);
            int k = 0;
            foreach (var item in List)
            {
                var r = tbbody.NewRow();
                r[0] = item.OPDAILY_NAME;
                r[1] = item.OPDAILY_SALESORSE;
                r[2] = item.OPDAILY_PHONE;
                r[3] = item.OPDAILY_PROVINCENAME;
                r[4] = item.OPDAILY_GRID;
                r[5] = item.CREATEENDDT;
                r[6] = item.OPDAILY_CUSTOM;
                r[7] = item.OPDAILY_ADDR;
                r[8] = item.OPDAILY_CONTENT;
                tbbody.Rows.Add(r);
                k++;
            }
            string filename = "##日报数据";
            var ms = ExcelClass.DataToExcelAsFile(tbbody, "##日报数据", "");
            ms.Position = 0;
            return File(ms, "application/x-msdownload;Charset=utf-8", filename + ".xls");
            #endregion
        }