C#查询与新增

这里用的是学院管理系统的案例

1. 先实例化一下引用的数据库

SchoolManageSystemEntities myModel = new SchoolManageSystemEntities();

1. 查询学院信息

public ActionResult selectAcademe(LayuiTablePage layuiTablePage,string searchTxt)

    {

        //查询学院信息

        var LinqAcademe = from tbAcademe in myModel.SYS_Academe

                          select tbAcademe;

        //数据筛选

        if (!string.IsNullOrEmpty(searchTxt))

        {

            LinqAcademe = LinqAcademe.Where(m=>m.academeName.Contains(searchTxt)  

                                            ||  m.academeCode.Contains(searchTxt));

        }

        

        //返回序列中数据的数量

        int totalRow = LinqAcademe.Count();

        //分页操作 分页前先排序

        List<SYS_Academe> dbAcademe = LinqAcademe.OrderByDescending(m=>m.academeID)

        .Skip(layuiTablePage.GetStartIndex()).Take(layuiTablePage.limit).ToList();

        //构建返回页面的数据

        LayuiTableData<SYS_Academe> LayuiTableData = new LayuiTableData<SYS_Academe>();

        LayuiTableData.count = totalRow;

        LayuiTableData.data = dbAcademe;

        return Json(LayuiTableData, JsonRequestBehavior.AllowGet);

    }

3.新增学院信息

public ActionResult saveInsert(SYS_Academe academe)

{

RetuenJsonVo returnJson = new RetuenJsonVo();//创建对象

    //数据验证

    if (!string.IsNullOrEmpty(academe.academeName))

    {

       if (!string.IsNullOrEmpty(academe.academeCode) && Regex.IsMatch(academe.academeCode, "^\\d{2}$"))

       {

           //去重复，判断新增的数据是否与数据库已有的数据重复

           int oldCount = (from tbAcademe in myModel.SYS_Academe

                             where tbAcademe.academeName == academe.academeName ||

                                   tbAcademe.academeCode == academe.academeCode

                             select tbAcademe).Count();

           if(oldCount == 0)

           {

                myModel.SYS_Academe.Add(academe);//没有重复

                if (myModel.SaveChanges() > 0)//保存

                {

                    returnJson.State = true;

                    returnJson.Text = "新增成功！";

                }

                else

                {

                    returnJson.Text = "新增失败！";

                }

            }

           else

           {

                returnJson.Text = "新增数据与数据库数据重复，请检查！";

            }

        }

        else

        {

            returnJson.Text = "学院编号为空或者不是2位数数字！";

        }

    }

    else

    {

        returnJson.Text = "学院名称为空！";

    }   

    return Json(returnJson, JsonRequestBehavior.AllowGet);

}