public bool SetDefault(string id)
{
//更新所有为不默认0
ExecuteSqlCommand(@"update [dbo].[WC_OfficalAccounts] set IsDefault=0");
//设置当前为默认1
return(ExecuteSqlCommand(@"update [dbo].[WC_OfficalAccounts] set IsDefault=1 where id='" + ResultHelper.Formatstr(id) + "'") > 0);
}
public bool PostData(WC_MessageResponse model)
{
//如果所有开关都关掉，证明不启用回复
if (model.Category == null)
{
return(true);
}
//全部设置为不默认
m_Rep.ExecuteSqlCommand(string.Format("update [dbo].[WC_MessageResponse] set IsDefault=0 where OfficalAccountId ='{0}' and MessageRule={1}", ResultHelper.Formatstr(model.OfficalAccountId), model.MessageRule));
//默认回复和订阅回复,且不是图文另外处理，因为他们有3种模式，但是只有一个是默认的
if (model.Category != WeChatReplyCategory.Image.ToString() && (model.MessageRule == WeChatRequestRuleEnum.Default.ToString() || model.MessageRule == WeChatRequestRuleEnum.Subscriber.ToString()))
{
//查看数据库是否存在数据
var entity = m_Rep.DbContext.WC_MessageResponse.Where(p => p.OfficalAccountId == model.OfficalAccountId && p.MessageRule == model.MessageRule && p.Category == model.Category).FirstOrDefault();
if (entity != null)
{
//删除原来的
m_Rep.DbContext.WC_MessageResponse.Remove(entity);
}
}
//全部设置为默认
m_Rep.ExecuteSqlCommand(string.Format("update [dbo].[WC_MessageResponse] set IsDefault=1 where OfficalAccountId ='{0}' and MessageRule={1} and Category={2}", ResultHelper.Formatstr(model.OfficalAccountId), model.MessageRule, model.Category));
//修改
if (m_Rep.IsContains(a => a.KEY_Id == model.KEY_Id))
{
m_Rep.DbContext.Entry <WC_MessageResponse>(model).State = EntityState.Modified;
return(m_Rep.Update(model));
}
else
{
return(m_Rep.Create(model));
}
}