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