HTNResp/Controllers/AdaptMedicineUseController.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Text;
using System.Web.Mvc;
using System.Data.SqlClient;
using HTNResp.Models;
using HTNResp.Codes;


namespace HTNResp.Controllers
{
    public class AdaptMedicineUseController: BaseController
    {
        HTNResp.BLL.AdaptMedicineUse bll = new HTNResp.BLL.AdaptMedicineUse();

        public override ActionResult Index()
        {
            BLL.EvalGuid blLEvalGrid = new BLL.EvalGuid();
            List<Model.EvalGuid> evalGridId = blLEvalGrid.GetModelList("");

            ViewBag.EvalGridId = evalGridId;
            return View();
        }

        public override ActionResult AjaxList()
        {
            int start = 0;  // 分页起始条目数
            int length = 0; // 分页每页分页数

            start = Convert.ToInt32(Request.Params["start"]);
            length = Convert.ToInt32(Request.Params["length"]);

            string strSql = " 1=1 ";

            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            //strSql = "GroupName'" + GroupName + "' and GroupNameDetail'" + GroupNameDetail + "'";
            if (!string.IsNullOrEmpty(Request.Params["GroupName"]))
            {
                sb.Append(" and GroupName='" + Request.Params["GroupName"] + "' ");
            }
            if (!string.IsNullOrEmpty(Request.Params["GroupNameDetail"]))
            {
                sb.Append(" and GroupNameDetail='" + Request.Params["GroupNameDetail"] + "' ");
            }
            if (!string.IsNullOrEmpty(Request.Params["Symptom"]))
            {
                sb.Append(" and Symptom like '%" + Request.Params["Symptom"] + "%' ");
            }
            if (!string.IsNullOrEmpty(Request.Params["SymptomType"]))
            {
                sb.Append(" and SymptomType='" + Request.Params["SymptomType"] + "' ");
            }
            if (!string.IsNullOrEmpty(Request.Params["EvalGuidId"]))
            {
                sb.Append(" and EvalGuidId='" + Request.Params["EvalGuidId"] + "'");
            }
            strSql += sb.ToString();