private bool SaveFeedPrivacy() { MessageDisplay msgDisplay = CreateMessageDisplay("feedprivacy"); int userID = MyUserID; AppBaseCollection apps = AppManager.GetAllApps(); //所有动作都加入动态的应用 //string appIDString = _Request.Get("apps", Method.Post); //string[] appIDs; //if (!string.IsNullOrEmpty(appIDString)) //{ // appIDs = appIDString.Split(','); //} //else // appIDs = new string[] { }; UserNoAddFeedAppCollection userNoAddFeedApps = new UserNoAddFeedAppCollection(); foreach (AppBase app in apps) { //bool isAddAllAction = false; //foreach (string appID in appIDs) //{ // if (app.AppID.ToString() == appID)//该应用的所有动作都加入动态 // { // isAddAllAction = true; // break; // } //} //if (!isAddAllAction) //{ //加入动态的动作 string actionIDString = _Request.Get("app_" + app.AppID.ToString() + "_Actions", Method.Post); string[] actionIDs; if (!string.IsNullOrEmpty(actionIDString)) { actionIDs = actionIDString.Split(','); } else { actionIDs = new string[] { } }; foreach (AppAction appAction in app.AppActions) { bool isAddFeed = false; foreach (string actionType in actionIDs) { if (appAction.ActionType.ToString() == actionType) { isAddFeed = true; break; } } UserNoAddFeedApp userNoAddFeedApp = new UserNoAddFeedApp(); userNoAddFeedApp.AppID = app.AppID; userNoAddFeedApp.ActionType = appAction.ActionType; userNoAddFeedApp.UserID = MyUserID; userNoAddFeedApp.Send = isAddFeed; userNoAddFeedApps.Add(userNoAddFeedApp); } //} } try { FeedBO.Instance.SetUserNoAddFeedApps(userID, userNoAddFeedApps); //msgDisplay.ShowInfo(this); //ShowSuccess(); } catch (Exception ex) { msgDisplay.AddException(ex); return(false); } return(true); }
private bool SaveFeedPrivacy() { MessageDisplay msgDisplay = CreateMessageDisplay("feedprivacy"); int userID = MyUserID; AppBaseCollection apps = AppManager.GetAllApps(); //所有动作都加入动态的应用 //string appIDString = _Request.Get("apps", Method.Post); //string[] appIDs; //if (!string.IsNullOrEmpty(appIDString)) //{ // appIDs = appIDString.Split(','); //} //else // appIDs = new string[] { }; UserNoAddFeedAppCollection userNoAddFeedApps = new UserNoAddFeedAppCollection(); foreach (AppBase app in apps) { //bool isAddAllAction = false; //foreach (string appID in appIDs) //{ // if (app.AppID.ToString() == appID)//该应用的所有动作都加入动态 // { // isAddAllAction = true; // break; // } //} //if (!isAddAllAction) //{ //加入动态的动作 string actionIDString = _Request.Get("app_" + app.AppID.ToString() + "_Actions", Method.Post); string[] actionIDs; if (!string.IsNullOrEmpty(actionIDString)) { actionIDs = actionIDString.Split(','); } else actionIDs = new string[] { }; foreach (AppAction appAction in app.AppActions) { bool isAddFeed = false; foreach (string actionType in actionIDs) { if (appAction.ActionType.ToString() == actionType) { isAddFeed = true; break; } } UserNoAddFeedApp userNoAddFeedApp = new UserNoAddFeedApp(); userNoAddFeedApp.AppID = app.AppID; userNoAddFeedApp.ActionType = appAction.ActionType; userNoAddFeedApp.UserID = MyUserID; userNoAddFeedApp.Send = isAddFeed; userNoAddFeedApps.Add(userNoAddFeedApp); } //} } try { FeedBO.Instance.SetUserNoAddFeedApps(userID, userNoAddFeedApps); //msgDisplay.ShowInfo(this); //ShowSuccess(); } catch (Exception ex) { msgDisplay.AddException(ex); return false; } return true; }
public override UserNoAddFeedAppCollection GetUserNoAddFeedApps(int userID) { using (SqlQuery query = new SqlQuery()) { query.CommandText = "bx_GetUserNoAddFeedApps"; query.CommandType = CommandType.StoredProcedure; query.CreateParameter<int>("@UserID", userID, SqlDbType.Int); using (XSqlDataReader reader = query.ExecuteReader()) { UserNoAddFeedAppCollection userNoAddFeedApps = new UserNoAddFeedAppCollection(reader); return userNoAddFeedApps; } } }
/// <summary> /// 用户设置自己的动态不加入通知 /// </summary> /// <param name="userNoAddFeedApp">不记录动态的应用</param> public abstract void SetUserNoAddFeedApps(int userID, UserNoAddFeedAppCollection userNoAddFeedApp);
public override void SetUserNoAddFeedApps(int userID, UserNoAddFeedAppCollection userNoAddFeedApps) { using (SqlSession db = new SqlSession()) { db.BeginTransaction(); //using (SqlQuery query = db.CreateQuery()) //{ // query.CommandText = "DELETE [bx_UserNoAddFeedApps] WHERE [UserID]=@UserID;"; // query.CreateParameter<int>("@UserID", userID, SqlDbType.Int); // query.ExecuteNonQuery(); //} using (SqlQuery query = db.CreateQuery(QueryMode.Prepare)) { query.CommandText = @" IF EXISTS(SELECT * FROM [bx_UserNoAddFeedApps] WHERE AppID=@AppID AND UserID=@UserID AND ActionType=@ActionType) UPDATE [bx_UserNoAddFeedApps] SET [Send]=@Send WHERE AppID=@AppID AND UserID=@UserID AND ActionType=@ActionType; ELSE INSERT INTO [bx_UserNoAddFeedApps]( [AppID] ,[UserID] ,[ActionType] ,[Send] ) VALUES ( @AppID ,@UserID ,@ActionType ,@Send ); "; foreach (UserNoAddFeedApp userNoAddFeedApp in userNoAddFeedApps) { query.CreateParameter<Guid>("@AppID", userNoAddFeedApp.AppID, SqlDbType.UniqueIdentifier); query.CreateParameter<int>("@ActionType", userNoAddFeedApp.ActionType, SqlDbType.Int); query.CreateParameter<int>("@UserID", userID, SqlDbType.Int); query.CreateParameter<bool>("@Send", userNoAddFeedApp.Send, SqlDbType.Bit); query.ExecuteNonQuery(); } } db.CommitTransaction(); } }