开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
CheckUser.cs
资源名称：OA_at.rar　[点击查看]
上传用户：tree100901
上传日期：2007-06-03
资源大小：2295k
文件大小：5k
源码类别：

OA系统

开发平台：

C#

CheckUser.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Data.SqlClient;
  4. using System.Web.Security;
  5. namespace OA
  6. {
  7. /// <summary>
  8. /// CheckUser 的摘要说明。
  9. /// </summary>
  10. public class CheckUser
  11. {
  12. private string Is_UserName;
  13. public int Is_UserID;
  14. public string JobID;
  15. public SqlConnection MyConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
  16. public CheckUser()
  17. {
  18. Is_UserName = null;
  19. //
  20. // TODO: 在此处添加构造函数逻辑
  21. //
  22. }
  23. public string UserName
  24. {
  25. get
  26. {
  27. return Is_UserName;
  28. }
  29. set
  30. {
  31. Is_UserName = value;
  32. if(Is_UserName!="")
  33. {
  34. SqlConnection MyConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
  35. SqlCommand MyCommand00 = new SqlCommand("PersonID",MyConnection);
  36. MyCommand00.CommandType = CommandType.StoredProcedure;
  37. MyCommand00.Parameters.Add(new SqlParameter("@Name", SqlDbType.NVarChar, 50));
  38. MyCommand00.Parameters["@Name"].Value = Is_UserName;
  39. if(MyConnection.State.ToString()=="Closed")
  40. MyConnection.Open();
  41. SqlDataReader myReader00 =  MyCommand00.ExecuteReader();
  42. while(myReader00.Read())
  43. { 
  44. Is_UserID = Int32.Parse(myReader00.GetInt32(0).ToString());
  45. JobID = myReader00["JobID"].ToString().Trim();
  46. }
  47. myReader00.Close();
  48. MyConnection.Close();
  49. }
  50. }
  51. }
  52. public int UserID
  53. {
  54. get
  55. {
  56. return Is_UserID;
  57. }
  58. }
  60. public bool Is_SystemManager()
  61. {
  62. string  SMJOBID = "";
  63. SqlConnection MyConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
  64. SqlCommand MyCommand0 = new SqlCommand("SelectSystemManager",MyConnection);
  65. MyCommand0.CommandType = CommandType.StoredProcedure;
  66. if(MyConnection.State.ToString()=="Closed")
  67. MyConnection.Open();
  68. SqlDataReader myReader0 =  MyCommand0.ExecuteReader();
  69. while(myReader0.Read())
  70. { 
  71. SMJOBID = myReader0["JobID"].ToString();
  72. }
  73. myReader0.Close();
  74. MyConnection.Close();
  75. int FJOBID= JobID.ToString().Trim().IndexOf(SMJOBID);
  76. if(FJOBID<0)
  77. return false;
  78. else
  79. return true;
  80. }
  81. public bool Is_FileManager()
  82. {
  83. string  FMJOBID = "";
  84. SqlConnection MyConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
  85. SqlCommand MyCommand0 = new SqlCommand("SelectFileManager",MyConnection);
  86. MyCommand0.CommandType = CommandType.StoredProcedure;
  87. if(MyConnection.State.ToString()=="Closed")
  88. MyConnection.Open();
  89. SqlDataReader myReader0 =  MyCommand0.ExecuteReader();
  90. while(myReader0.Read())
  91. { 
  92. FMJOBID = myReader0["JobID"].ToString();
  93. }
  94. myReader0.Close();
  95. MyConnection.Close();
  96. int FJOBID = JobID.ToString().Trim().IndexOf(FMJOBID);
  97. if(FJOBID<0)
  98. return false;
  99. else
  100. return true;
  101. }
  102. public string isSetUser(string UserName,string Password)
  103. {
  104. SqlConnection MyConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
  105. SqlCommand MyCommand = new SqlCommand("CheckSetUser",MyConnection);
  106. MyCommand.CommandType = CommandType.StoredProcedure;
  107. MyCommand.Parameters.Add(new SqlParameter("@Name", SqlDbType.NVarChar,50));
  108. MyCommand.Parameters["@Name"].Value = UserName;
  109. MyCommand.Parameters.Add(new SqlParameter("@Password", SqlDbType.NVarChar,50));
  110. MyCommand.Parameters["@Password"].Value = FormsAuthentication.HashPasswordForStoringInConfigFile(Password,"MD5");
  111. SqlParameter BoolSetUser = MyCommand.Parameters.Add(new SqlParameter("@SetUser", SqlDbType.Char,10));
  112. BoolSetUser.Direction = ParameterDirection.Output;
  113. SqlParameter UserState = MyCommand.Parameters.Add(new SqlParameter("@State", SqlDbType.Char,10));
  114. UserState.Direction = ParameterDirection.Output;
  115. SqlParameter PersonID = MyCommand.Parameters.Add(new SqlParameter("@PersonID", SqlDbType.Int,4));
  116. PersonID.Direction = ParameterDirection.Output;
  117. if(MyConnection.State.ToString()=="Closed")
  118. MyConnection.Open();
  119. try
  120. {
  121. MyCommand.ExecuteNonQuery();
  122. }
  123. catch
  124. {
  125. }
  126. MyConnection.Close();
  127. MyCommand.Parameters.Clear();
  128. return BoolSetUser.Value.ToString()+"|"+UserState.Value.ToString();
  129. }
  130. public bool isOnlineUser(string UserName)
  131. {
  132. SqlCommand MyCommand = new SqlCommand("CheckOnlineUser",MyConnection);
  133. MyCommand.CommandType = CommandType.StoredProcedure;
  134. MyCommand.Parameters.Add(new SqlParameter("@UserName", SqlDbType.NVarChar,50));
  135. MyCommand.Parameters["@UserName"].Value = UserName;
  136. SqlParameter BoolUserOnline = MyCommand.Parameters.Add(new SqlParameter("@UserOnline", SqlDbType.Char,10));
  137. BoolUserOnline.Direction = ParameterDirection.Output;
  138. if(MyConnection.State.ToString()=="Closed")
  139. MyConnection.Open();
  140. try
  141. {
  142. MyCommand.ExecuteNonQuery();
  143. }
  144. catch
  145. {
  146. }
  147. MyConnection.Close();
  148. MyCommand.Parameters.Clear();
  149. return Convert.ToBoolean(BoolUserOnline.Value.ToString());
  150. }
  151. }
  152. }