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();
}
}
