/// <summary> /// 登录页面显示个人信息 /// </summary> public void ShowSelfMessage() { SqlStoreCommand sqlStoreCommand = new SqlStoreCommand(); sqlStoreCommand.StoreProdureName = "?"; sqlStoreCommand.ExecuteDataTable(); sqlStoreCommand.ExecuteNonQuery(); }
/// <summary> /// 以邮箱方式搜寻好友 /// </summary> /// <param name="userEmail">用户邮箱</param> public static void SearchUserEmail(string userEmail) { SqlStoreCommand sqlStoreCommand = new SqlStoreCommand(); sqlStoreCommand.StoreProdureName = "Chat_User"; sqlStoreCommand.ClearParameters(); sqlStoreCommand.AddParameters("@userEmail", userEmail); sqlStoreCommand.ExecuteNonQuery(); }
/// <summary> /// 验证登陆 /// </summary> /// <param name="aUserEmail">用户邮箱</param> /// <param name="aUserPassword">密码</param> public int CheckLogin(string aUserEmail, string aUserPassword) { SqlStoreCommand mSqlStoreCommand = new SqlStoreCommand(); mSqlStoreCommand.StoreProdureName = "Chat_User"; mSqlStoreCommand.ClearParameters(); mSqlStoreCommand.AddParameters("@mFunctionName", "Check"); mSqlStoreCommand.AddParameters("@mUserEmail", aUserEmail); mSqlStoreCommand.AddParameters("@mUserPassword", aUserPassword); int mCheckNum = Convert.ToInt32(mSqlStoreCommand.ExecuteFunction()); return mCheckNum; }
/// <summary> /// 登陆界面显示离线消息 /// </summary> public static void ShowOfflineMessage() { SqlStoreCommand sqlStoreCommand = new SqlStoreCommand(); sqlStoreCommand.StoreProdureName = "?"; sqlStoreCommand.ExecuteNonQuery(); }