温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:特瑞飞家教信息平台源码
当前文件:
HomeTeachingNet/DataBusiness/StudentMembership.cs,打开代码结构图
HomeTeachingNet/DataBusiness/StudentMembership.cs,打开代码结构图1using System; 2
using System.Collections.Generic; 3
using System.Text; 4
using System.Web.Security; 5
using System.Data; 6
using System.Data.SqlClient; 7
///Asp.net源码下载专业站 8
namespace DataBusiness 9
{ 10
public partial class Student 11
{ 12
public bool DeleteStudentInBothSide(object UserGuid) 13
{ 14
bool rt = true; 15
//1) 先从Membership中删除 16
MembershipUser sysUser = Membership.GetUser(UserGuid); 17
if (sysUser != null) 18
{ 19
rt = Membership.DeleteUser(sysUser.UserName); 20
if (!rt) 21
{ 22
return false; 23
} 24
} 25
26
// 2) 从扩展数据表中删除 27
rt = this.DeleteStudentByGuid(UserGuid.ToString()); 28
29
return rt; 30
} 31
32
public int GetStudentIDByGuid(string user_guid) 33
{ 34
SqlParameter[] para = { 35
new SqlParameter("@user_guid", user_guid), 36
}; 37
38
DataSet ds = DataExecute.ExecuteDataset(DataExecute.CONN_STRING, CommandType.StoredProcedure, 39
"GetStudentIDByGuid", para); 40
41
if (ds == null) 42
{ 43
return 0; 44
} 45
if (ds.Tables[0].Rows.Count == 0) 46
{ 47
return 0; 48
} 49
int nID = int.Parse(ds.Tables[0].Rows[0][0].ToString()); 50
51
return nID; 52
} 53
54
private bool DeleteStudentByGuid(string szUserGuid) 55
{ 56
SqlParameter[] para = { 57
new SqlParameter("@UserGuid", szUserGuid) 58
}; 59
int nAffect = DataExecute.ExecuteNonQuery(DataExecute.CONN_STRING, 60
CommandType.StoredProcedure, 61
"DeleteStudentByUserGuid", 62
para); 63
return (nAffect == 1); 64
} 65
} 66
} 67





}
}