多表存储修改

S
--联查反填
 go
alter proc pro_getStudentID @stid int 
 as
  select A.*,B.XID from dbo.TStudent as A inner join dbo.TClass as B on A.BID=B.BID  where A.stid = @stid
  --执行联查存储
 exec pro_getStudentID  @stid


 go
create proc pro_uptStudent @stid int ,@BID int , @stName nvarchar(50), @stSex nvarchar(50)
as
update dbo.TStudent set stid=@stid,BID=@BID,stName=@stName,stSex=@stSex

exec pro_uptStudent


---修改
go
create proc p_Update @stid int, @BID int, @stName nvarchar(50), @stSex nvarchar(50),@XID int
as 
begin
 begin tran
  begin try
      update dbo.TStudent set stName=@stName,stSex=@stSex,BID=@BID where stid=@stid
      update dbo.TClass set XID=@XID where BID=(select BID from dbo.TStudent where stid=@stid)    
   commit tran
  end try
   begin catch
    rollback tran
   end catch
end

exec p_Update  @stid , @BID , @stName , @stSex ,@XID

---

D

 /// <summary>
        /// 单个查找
        /// </summary>
        public NewStudent findStudent(int stid)
        {
            var get = context.Database.SqlQuery<NewStudent>(" exec pro_getStudentID  @stid", new SqlParameter("@stid", stid));
            return get.FirstOrDefault();
        }
        /// <summary>
        /// 修改
        /// </summary>
        public int UptStudent(int stid, int BID, string stName, string stSex, string XID)
        {
            SqlParameter[] sqlParameters = new SqlParameter[]
          {
                new SqlParameter("@stid",stid),
                new SqlParameter("@BID",BID),
                new SqlParameter("@stName", stName),
                new SqlParameter("@stSex", stSex),
                new SqlParameter("@XID",XID),
           };
            return context.Database.ExecuteSqlCommand("exec p_Update  @stid , @BID , @stName , @stSex ,@XID", sqlParameters);
        }

---

W
 /// <summary>
        /// 单个查找
        /// </summary>
        [WebMethod]
        public void findStudent(int stid)
        {
            Context.Response.ContentType = "application/json";
            NewStudent get = stbll.findStudent(stid);
            var json = JsonConvert.SerializeObject(get);
            Context.Response.Write(json);
        }

        /// <summary>
        /// 修改
        /// </summary>
        [WebMethod]
        public void UptStudent(int stid, int BID, string stName, string stSex, string XID)
        {
            Context.Response.ContentType = "application/json";
            int i = stbll.UptStudent(stid, BID, stName, stSex, XID);
            Context.Response.Write(i);
        }