public ActionResult CreateOrUpdateKeyWords(int?id, int?sysNo) { //update or just reload after creation if (sysNo != null) { MkWeixinKeywords Entity = new MkWeixinKeywords(); Entity = WeChatBo.Instance.GetMkWeixinKeywordsBySysNo((int)sysNo); //update keywords,load the existed keywords content list var mkWeixinKeywordsReply = new MkWeixinKeywordsReply { WeixinKeywordsSysNo = (int)sysNo }; var dicContent = WeChatBo.Instance.QueryKeyWordsContent(mkWeixinKeywordsReply); var model = new PagedList <MkWeixinKeywordsReply> { TData = dicContent.Any() ? dicContent.First().Value : null, CurrentPageIndex = id ?? 1, TotalItemCount = dicContent.Any() ? dicContent.First().Key : 0 }; //reload if (Request.IsAjaxRequest()) { return(PartialView("QueryKeyWordsContent", model)); } ViewBag.AgentSysNo = Entity.AgentSysNo; ViewBag.DealerSysNo = Entity.DealerSysNo; ViewBag.keyWordSysNo = sysNo; return(View(model)); } return(View()); }
public ActionResult UpdateKeyWordsContent(MkWeixinKeywordsReply model) { var result = WeChatBo.Instance.UpdateKeyWordsContent(new List <MkWeixinKeywordsReply> { model }, HttpContext.Request.ServerVariables["Remote_Add"], CurrentUser.Base.SysNo); return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 新增微信关键字 /// </summary> /// <param name="model">MkWeixinKeywords</param> /// <param name="operatorSysNo">操作人员编号</param> /// <returns>Result instance</returns> /// <remarks>2013-10-24 黄伟 创建</remarks> public override int CreateKeyWordsContent(MkWeixinKeywordsReply model, int operatorSysNo) { model.CreatedBy = operatorSysNo; model.CreatedDate = DateTime.Now; model.LastUpdateBy = operatorSysNo; model.LastUpdateDate = DateTime.Now; model.Status = MarketingStatus.微信关键词回复状态.启用.GetHashCode(); Context.Sql("update MkWeixinKeywords set ReplyCount=ReplyCount+1 where sysno=@sysno") .Parameter("sysno", model.WeixinKeywordsSysNo).Execute(); return(Context.Insert("MkWeixinKeywordsReply", model).AutoMap(m => m.SysNo).Execute()); }
/// <summary> /// 新增微信关键字 /// </summary> /// <param name="model">MkWeixinKeywords</param> /// <param name="userIp">操作人员ip</param> /// <param name="operatorSysno">操作人员编号</param> /// <returns>Result instance</returns> /// <remarks>2013-10-24 黄伟 创建</remarks> public Result <int> CreateKeyWordsContent(MkWeixinKeywordsReply model, string userIp, int operatorSysno) { var sysNo = 0; try { sysNo = IWeChatDao.Instance.CreateKeyWordsContent(model, operatorSysno); } catch (Exception ex) { SysLog.Instance.WriteLog(LogStatus.SysLogLevel.Error, LogStatus.系统日志来源.后台, "新增微信关键字对应内容", LogStatus.系统日志目标类型.WeChatKeyWordsMgm, 0, ex, userIp, operatorSysno); return(new Result <int> { Message = string.Format("保存失败:{0}", ex.Message), Status = false }); } SysLog.Instance.WriteLog(LogStatus.SysLogLevel.Info, LogStatus.系统日志来源.后台, "新增微信关键字对应内容", LogStatus.系统日志目标类型.WeChatKeyWordsMgm, 0, null, userIp, operatorSysno); return(new Result <int> { Data = sysNo, Message = "保存成功!", Status = true }); }
/// <summary> /// query 微信关键字所对应任务列表 /// </summary> /// <param name="para">MkWeixinKeywordsReply</param> /// <returns>list of MkWeixinKeywordsReply</returns> /// <remarks>2013-10-25 hw created</remarks> public override List <MkWeixinKeywordsReply> QueryKeyWordsContentAll(MkWeixinKeywordsReply para) { return(Context.Sql("select * from MkWeixinKeywordsReply").QueryMany <MkWeixinKeywordsReply>()); }
/// <summary> /// query 微信关键字所对应任务列表 /// </summary> /// <param name="para">MkWeixinKeywordsReply</param> /// <param name="id">page index</param> /// <param name="pageSize">page size</param> /// <returns>list of MkWeixinKeywordsReply</returns> /// <remarks>2013-10-25 hw created</remarks> public override Dictionary <int, List <MkWeixinKeywordsReply> > QueryKeyWordsContent(MkWeixinKeywordsReply para, int id = 1, int pageSize = 10) { string sqlSelect = @"a.*", sqlFrom = @"MkWeixinKeywordsReply a", //关键词进行查找 sqlCondition = @"(@WeixinKeywordsSysNo is null or a.WeixinKeywordsSysNo=@WeixinKeywordsSysNo)"; using (IDbContext context = Context.UseSharedConnection(true)) { List <MkWeixinKeywordsReply> lstResult = context.Select <MkWeixinKeywordsReply>(sqlSelect) .From(sqlFrom) .AndWhere(sqlCondition) .Parameter("WeixinKeywordsSysNo", para.WeixinKeywordsSysNo) .Paging(id, pageSize) //index从1开始 .OrderBy("a.sysno desc") .QueryMany(); int count = context.Select <int>(@"count(*)") .From(sqlFrom) .AndWhere(sqlCondition) .Parameter("WeixinKeywordsSysNo", para.WeixinKeywordsSysNo) .QuerySingle(); return(new Dictionary <int, List <MkWeixinKeywordsReply> > { { count, lstResult } }); } }
/// <summary> /// query 微信关键字所对应任务列表 /// </summary> /// <param name="para">MkWeixinKeywordsReply</param> /// <returns>list of MkWeixinKeywordsReply</returns> /// <remarks>2013-10-25 hw created</remarks> public List <MkWeixinKeywordsReply> QueryKeyWordsContentAll(MkWeixinKeywordsReply para) { return(IWeChatDao.Instance.QueryKeyWordsContentAll(para)); }
/// <summary> /// query 微信关键字所对应任务列表 /// </summary> /// <param name="para">MkWeixinKeywordsReply</param> /// <param name="id">page index</param> /// <param name="pageSize">page size</param> /// <returns>list of MkWeixinKeywordsReply</returns> /// <remarks>2013-10-25 hw created</remarks> public Dictionary <int, List <MkWeixinKeywordsReply> > QueryKeyWordsContent(MkWeixinKeywordsReply para, int id = 1, int pageSize = 10) { return(IWeChatDao.Instance.QueryKeyWordsContent(para, id, pageSize)); }
/// <summary> /// 新增微信关键字 /// </summary> /// <param name="model">MkWeixinKeywords</param> /// <param name="operatorSysNo">操作人员编号</param> /// <returns>Result instance</returns> /// <remarks>2013-10-24 黄伟 创建</remarks> public abstract int CreateKeyWordsContent(MkWeixinKeywordsReply model, int operatorSysNo);
/// <summary> /// query 微信关键字所对应任务列表 /// </summary> /// <param name="para">MkWeixinKeywordsReply</param> /// <returns>list of MkWeixinKeywordsReply</returns> /// <remarks>2013-10-25 hw created</remarks> public abstract List <MkWeixinKeywordsReply> QueryKeyWordsContentAll(MkWeixinKeywordsReply para);
/// <summary> /// query 微信关键字所对应任务列表 /// </summary> /// <param name="para">MkWeixinKeywordsReply</param> /// <param name="id">page index</param> /// <param name="pageSize">page size</param> /// <returns>list of MkWeixinKeywordsReply</returns> /// <remarks>2013-10-25 hw created</remarks> public abstract Dictionary <int, List <MkWeixinKeywordsReply> > QueryKeyWordsContent(MkWeixinKeywordsReply para, int id = 1, int pageSize = 10);