public override void SetTemplates(FeedTemplateCollection feedTemplates)
{
using (SqlQuery query = new SqlQuery(QueryMode.Prepare))
{
query.CommandText = @"
IF EXISTS(SELECT * FROM [bx_FeedTemplates] WHERE [AppID]=@AppID AND [ActionType]=@ActionType)
UPDATE [bx_FeedTemplates] SET
[Title]=@Title
,[IconUrl]=@IconUrl
,[Description]=@Description
WHERE [AppID]=@AppID AND [ActionType]=@ActionType;
ELSE
INSERT [bx_FeedTemplates] (
[AppID]
,[ActionType]
,[Title]
,[IconUrl]
,[Description]
) VALUES(
@AppID
, @ActionType
, @Title
, @IconUrl
, @Description
);
";
foreach (FeedTemplate feedTemplate in feedTemplates)
{
query.CreateParameter<Guid>("@AppID", feedTemplate.AppID, SqlDbType.UniqueIdentifier);
query.CreateParameter<int>("@ActionType", feedTemplate.ActionType, SqlDbType.Int);
query.CreateParameter<string>("@Title", feedTemplate.Title, SqlDbType.NVarChar, 900);
query.CreateParameter<string>("@IconUrl", feedTemplate.IconSrc, SqlDbType.NVarChar, 200);
query.CreateParameter<string>("@Description", feedTemplate.Description, SqlDbType.NVarChar, 2900);
query.ExecuteNonQuery();
}
//query.Submit();
}
}
private void SaveFeedTemplates()
{
MessageDisplay msgDisplay = CreateMessageDisplay("FeedTemplate.IconSrc", "FeedTemplate.Title", "FeedTemplate.Description");
Guid appID;
string appIDString = _Request.Get("appID", Method.Get);
if (appIDString == null)
appID = new BasicApp().AppID;
else
{
try
{
appID = new Guid(appIDString);
}
catch
{
msgDisplay.AddError(new InvalidParamError("appID").Message);
return;
}
}
string[] ids = GetFeedTemplateIDs();
if (ids != null)
{
FeedTemplateCollection feedTemplates = new FeedTemplateCollection();
Dictionary<int, int> lines = new Dictionary<int, int>();
int i = 0;
foreach (string id in ids)
{
//string changedKey = "FeedTemplate.Changed." + id;
//string changed = _Request.Get(changedKey, Method.Post, "0");
////没改变就不保存
//if (changed == "0")
// continue;
FeedTemplate feedTemplate = new FeedTemplate();
feedTemplate.AppID = appID;
LoadFeedTemplate(appID, id, feedTemplate);
feedTemplates.Add(feedTemplate);
lines.Add(i, int.Parse(id));
i++;
}
if (feedTemplates.Count > 0)
{
try
{
using (new ErrorScope())
{
bool success = FeedBO.Instance.SetTemplates(MyUserID, appID, feedTemplates);
if (!success)
{
CatchError<ErrorInfo>(delegate(ErrorInfo error)
{
msgDisplay.AddError(error.TatgetName, lines[error.TargetLine], error.Message);
});
}
else
_Request.Clear(Method.Post);
}
}
catch (Exception ex)
{
msgDisplay.AddError(ex.Message);
}
}
}
}
private void SaveFeedTemplates()
{
MessageDisplay msgDisplay = CreateMessageDisplay("FeedTemplate.IconSrc", "FeedTemplate.Title", "FeedTemplate.Description");
Guid appID;
string appIDString = _Request.Get("appID", Method.Get);
if (appIDString == null)
{
appID = new BasicApp().AppID;
}
else
{
try
{
appID = new Guid(appIDString);
}
catch
{
msgDisplay.AddError(new InvalidParamError("appID").Message);
return;
}
}
string[] ids = GetFeedTemplateIDs();
if (ids != null)
{
FeedTemplateCollection feedTemplates = new FeedTemplateCollection();
Dictionary <int, int> lines = new Dictionary <int, int>();
int i = 0;
foreach (string id in ids)
{
//string changedKey = "FeedTemplate.Changed." + id;
//string changed = _Request.Get(changedKey, Method.Post, "0");
////没改变就不保存
//if (changed == "0")
// continue;
FeedTemplate feedTemplate = new FeedTemplate();
feedTemplate.AppID = appID;
LoadFeedTemplate(appID, id, feedTemplate);
feedTemplates.Add(feedTemplate);
lines.Add(i, int.Parse(id));
i++;
}
if (feedTemplates.Count > 0)
{
try
{
using (new ErrorScope())
{
bool success = FeedBO.Instance.SetTemplates(MyUserID, appID, feedTemplates);
if (!success)
{
CatchError <ErrorInfo>(delegate(ErrorInfo error)
{
msgDisplay.AddError(error.TatgetName, lines[error.TargetLine], error.Message);
});
}
else
{
_Request.Clear(Method.Post);
}
}
}
catch (Exception ex)
{
msgDisplay.AddError(ex.Message);
}
}
}
}
/// <summary> /// 设置动态模板，存在就更新，不存在就插入 /// </summary> /// <param name="feedTemplete"></param> public abstract void SetTemplates(FeedTemplateCollection feedTemplates);
