自定义博客皮肤VIP专享

*博客头图：

点击选择上传的图片

格式为PNG、JPG，宽度*高度大于1920*100像素，不超过2MB，主视觉建议放在右侧，请参照线上博客头图

请上传大于1920*100像素的图片！

博客底图：

点击选择上传的图片

图片格式为PNG、JPG，不超过1MB，可上下左右平铺至整个背景

栏目图：

点击选择上传的图片

图片格式为PNG、JPG，图片宽度*高度为300*38像素，不超过0.5MB

主标题颜色：

RGB颜色，例如：#AFAFAF

Hover：

RGB颜色，例如：#AFAFAF

副标题颜色：

RGB颜色，例如：#AFAFAF

预览取消提交

自定义博客皮肤

上一步保存

qq_42829097的博客

原创 VS存储过程实例

这里写图片描这里写图片描述述这里写图片描述

2018-07-29 22:05:16 764

原创 WebService三表存储过程

create database LianXi728 use LianXi728 create table School ( SchoolId int primary key identity, SchoolCode int, SchoolName varchar(50) ) create table Class ( ClassId int primary key identit...

2018-07-29 21:42:09 174 5

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

qq_42829097 CSDN认证博客专家 CSDN认证企业博客

码龄6年

暂无认证

IP 属地：河南省

IP属地以运营商信息为准，境内显示到省（区、市），境外显示到国家（地区）

2: 原创

169万+: 周排名

209万+: 总排名

937: 访问

: 等级

28: 积分

1: 粉丝

1: 获赞

5: 评论

0: 收藏

私信

关注

最新评论

WebService三表存储过程
qq_42829097: Update @{ Layout = null; } <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width" /> <title>UpdateStudent</title> <script src="~/Scripts/jquery-3.1.1.js"></script> <script> var StudentId=@Request.QueryString["StudentId"]; $(function () { School(); Show(); $("select[name=SchoolName]").change(function () { Class(); }) }) function School() { $.ajax({ url: "http://localhost:30533/SchoolService.asmx/GetSchool", type: "post", async:false, success: function (d) { $(d).each(function () { $("select[name=SchoolName]").append("<option value=\"" + this.SchoolCode + "\">" + this.SchoolName + "</option>"); }) } }) } function Class() { $("select[name=SchoolName]
WebService三表存储过程
qq_42829097: Add @{ Layout = null; } <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width" /> <title>AddStudent</title> <script src="~/Scripts/jquery-3.1.1.js"></script> <script> $(function () { School(); Class(); }) function School() { $.ajax({ url: "http://localhost:30533/SchoolService.asmx/GetSchool", type: "post", success: function (d) { $(d).each(function () { $("select[name=SchoolName]").append("<option value=\"" + this.SchoolCode + "\">" + this.SchoolName + "</option>"); }) } }) } function Class() { $("select[name=SchoolName]").change(function () { $.ajax({ url: "http://localhost:30533/ClassService.asmx/GetClass", data: { SchoolCode: $(this).val() },
WebService三表存储过程
qq_42829097: iNDEX @{ Layout = null; } <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width" /> <title>Index</title> <script src="~/Scripts/jquery-3.1.1.js"></script> <script> var dangPage = 1; var pageSize = 2; var zongPage = 0; $(function () { Show(); School(); Class(); $("#btnSearch").click(function () { currentPage = 1; Show(); }) }) function School() { $.ajax({ url: "http://localhost:30533/SchoolService.asmx/GetSchool", type: "post", success: function (d) { $(d).each(function () { $("select[name=SchoolName]").append("<option value=\"" + this.SchoolCode + "\">" + this.SchoolName + "</option>"); }) } }) } function Class() {
WebService三表存储过程
qq_42829097: WebService [WebMethod] public void GetStudent(string SchoolCode, string ClassCode, string StudentName, int PageIndex, int PageSize) { Context.Response.ContentType = "application/json=utf-8"; PageBox GetStudent= bll.GetStudent(SchoolCode, ClassCode, StudentName, PageIndex, PageSize); string GetListS = JsonConvert.SerializeObject(GetStudent); Context.Response.Write(GetListS); } [WebMethod] public int AddStudent(int ClassCode, string StudentName, int Sex) { Student s = new Student(); s.ClassCode = ClassCode; s.StudentName = StudentName; s.Sex = Sex; return bll.AddStudent(s); } [WebMethod] public int DeleteStudent(int StudentId) { return bll.DeleteStudent(StudentId); } [WebMethod] public int UpdateStudent(int StudentId,int ClassCode, string StudentName, int Sex)
WebService三表存储过程
qq_42829097: DAL Student public PageBox GetStudent(string SchoolCode=null,string ClassCode=null,string StudentName=null,int PageIndex=1,int PageSize=2) { PageBox pagebox = new PageBox(); SqlParameter[] param=new SqlParameter[] { new SqlParameter("@SchoolCode",SchoolCode), new SqlParameter("@ClassCode",ClassCode), new SqlParameter("@StudentName",StudentName), new SqlParameter("@PageIndex",PageIndex), new SqlParameter("@PageSize",PageSize), new SqlParameter("@PageCount",SqlDbType.Int), }; param[5].Direction = ParameterDirection.Output; var result= DBHelper.ExecuteObjects<StudentMap>("exec p_GetStudentList @SchoolCode,@ClassCode,@StudentName,@PageIndex,@PageSize,@PageCount output", param).ToList(); pagebox.ZongPage =(int)param[5].Value; pagebox.DangPage = PageIndex; pagebox.Date = result; return pagebox; } public int AddStudent(Student s) { var param = new[] { new SqlParameter("@ClassCode",SqlDbType.Int), new SqlParameter("@StudentName",SqlDbType.VarChar), new SqlParameter("@Sex",SqlDbType.Int), }; param[0].Value = s.ClassCode; param[1].Value = s.StudentName; param[2].Value = s.Sex; return DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, "p_AddStudent", param); } public int DeleteStudent(int StudentId) { var param = new[] { new SqlParameter("@StudentId",SqlDbType.Int) }; param[0].Value = StudentId; return DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, "p_DeleteStudent", param); } public int UpdateStudent(Student s) { var param = new[] { new SqlParameter("@StudentId",SqlDbType.Int), new SqlParameter("@ClassCode",SqlDbType.Int), new SqlParameter("@StudentName",SqlDbType.VarChar), new SqlParameter("@Sex",SqlDbType.Int), }; param[0].Value = s.StudentId; param[1].Value = s.ClassCode; param[2].Value = s.StudentName; param[3].Value = s.Sex; return DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, "p_UpdateStudent", param); } public List<StudentMap> GetStudentById(int StudentId) { var param = new[] { new SqlParameter("@StudentId",SqlDbType.Int) }; param[0].Value = StudentId; return DBHelper.ExecuteObjects<StudentMap>(CommandType.StoredProcedure, "p_GetStudentById", param); }