当前文件： HomeTeachingNet/DataBusiness/TeacherMembership.cs[1K，2009-6-12 11:44:15]，打开代码结构图

		            
 1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using System.Web.Security;
 5using System.Data;
 6using System.Data.SqlClient;
 7
 8namespace DataBusiness
 9...{
10    public partial class Teacher
11    ...{
12        public bool DeleteTeacherInBothSide(object UserGuid)
13        ...{
14            //1) 先从Membership中删除
15            MembershipUser sysUser = Membership.GetUser(UserGuid);
16            if (sysUser == null)
17            ...{
18                return false;
19            }
20            bool rt = Membership.DeleteUser(sysUser.UserName);
21            if (!rt)
22            ...{
23                return false;
24            }
25
26            // 2) 从扩展数据表中删除
27            rt = this.DeleteTeacherByGuid(UserGuid.ToString());
28
29            return rt;
30        }
31
32        public int GetTeacherIDByGuid(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                "GetTeacherIDByGuid", 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 DeleteTeacherByGuid(string szUserGuid)
55        ...{
56            SqlParameter[] para = ...{
57                                      new SqlParameter("@UserGuid", szUserGuid)
58                                  };
59            int nAffect = DataExecute.ExecuteNonQuery(DataExecute.CONN_STRING,
60                                                    CommandType.StoredProcedure,
61                                                    "DeleteTeacherByUserGuid",
62                                                    para);
63            return (nAffect == 1);
64        }
65    }
66}
67//51-A-sp-x.com
68