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