public ModelInvokeResult <WXMessageTemplatePK> Nullify(string strTemplateId) { ModelInvokeResult <WXMessageTemplatePK> result = new ModelInvokeResult <WXMessageTemplatePK> { Success = true }; try { List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>(); string _TemplateId = strTemplateId; WXMessageTemplate wXMessageTemplate = new WXMessageTemplate { TemplateId = _TemplateId, Status = 0 }; /***********************begin 自定义代码*******************/ /***********************end 自定义代码*********************/ statements.Add(new IBatisNetBatchStatement { StatementName = wXMessageTemplate.GetUpdateMethodName(), ParameterObject = wXMessageTemplate.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE }); /***********************begin 自定义代码*******************/ /***********************此处添加自定义代码*****************/ /***********************end 自定义代码*********************/ BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements); result.instance = new WXMessageTemplatePK { TemplateId = _TemplateId }; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
private string ResponseEvent_WX10101(WXReceiveEventMessage receiveMessage) { string result = ""; var stationIds = BuilderFactory.DefaultBulder().List <WXStationAuthRequest>(new WXStationAuthRequest { OpenId = receiveMessage.FromUserName, DoStatus = 1 }.ToStringObjectDictionary(false)).Select(item => item.StationId.ToString()).Distinct(); if (stationIds.Count() > 0) { result = FormatOutputText(receiveMessage.FromUserName, receiveMessage.ToUserName, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "签到成功"); //加入到签到表 BuilderFactory.DefaultBulder().Create <WXCheckIn>(new WXCheckIn { OpenId = receiveMessage.FromUserName }); } else { WXMessageTemplate template = BuilderFactory.DefaultBulder().Load <WXMessageTemplate, WXMessageTemplatePK>(new WXMessageTemplatePK { TemplateId = GlobalManager.TemplateId_Not_As_ServeMan }); if (template != null) { string s = template.TemplateContent.ReplaceEmoji(); result = FormatOutputText(receiveMessage.FromUserName, receiveMessage.ToUserName, s); } } return(result); }
public InvokeResult NullifySelected(string strTemplateIds) { InvokeResult result = new InvokeResult { Success = true }; try { List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>(); string[] arrTemplateIds = strTemplateIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); if (arrTemplateIds.Length == 0) { result.Success = false; result.ErrorCode = 59996; return(result); } string statementName = new WXMessageTemplate().GetUpdateMethodName(); foreach (string strTemplateId in arrTemplateIds) { WXMessageTemplate wXMessageTemplate = new WXMessageTemplate { TemplateId = strTemplateId, Status = 0 }; /***********************begin 自定义代码*******************/ /***********************end 自定义代码*********************/ statements.Add(new IBatisNetBatchStatement { StatementName = statementName, ParameterObject = wXMessageTemplate.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE }); } BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public InvokeResult DeleteSelected(string strTemplateIds) { InvokeResult result = new InvokeResult { Success = true }; try { List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>(); string[] arrTemplateIds = strTemplateIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); if (arrTemplateIds.Length == 0) { result.Success = false; result.ErrorCode = 59996; return(result); } string statementName = new WXMessageTemplate().GetDeleteMethodName(); foreach (string strTemplateId in arrTemplateIds) { WXMessageTemplatePK pk = new WXMessageTemplatePK { TemplateId = strTemplateId }; DeleteCascade(statements, pk); statements.Add(new IBatisNetBatchStatement { StatementName = statementName, ParameterObject = pk, Type = SqlExecuteType.DELETE }); } BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
private string ResponseEvent_WX20103(WXReceiveEventMessage receiveMessage) { string result = ""; int pageSize = 5; StringObjectDictionary filter = new { OpenId = receiveMessage.FromUserName }.ToStringObjectDictionary(); try { var datas = BuilderFactory.DefaultBulder().ListStringObjectDictionary("ServeDurationByServeMan_List", filter); if (datas.Count == 0) { result = FormatOutputText(receiveMessage.FromUserName, receiveMessage.ToUserName, "没有任何服务记录,无法统计"); } else { WXMessageTemplate template_MyServeDurationStatTitle = BuilderFactory.DefaultBulder().Load <WXMessageTemplate, WXMessageTemplatePK>(new WXMessageTemplatePK { TemplateId = GlobalManager.TemplateId_MyServeDurationStatTitle }); List <WXResponseNewsItem> items = datas.Select(item => new WXResponseNewsItem { Title = template_MyServeDurationStatTitle.TemplateContent.ReplaceWithKeys(new { ServeStationName = TypeConverter.ChangeString(item["ServeStationName"]), ServeItemBName = TypeConverter.ChangeString(item["ServeItemBName"]), ByDay = DateTimeAdapter.GetTimeSpanString(DateTimeAdapter.DateInterval.HR, long.Parse(TypeConverter.ChangeString(item["ByDay"]))), ByWeek = DateTimeAdapter.GetTimeSpanString(DateTimeAdapter.DateInterval.HR, long.Parse(TypeConverter.ChangeString(item["ByWeek"]))), ByMonth = DateTimeAdapter.GetTimeSpanString(DateTimeAdapter.DateInterval.HR, long.Parse(TypeConverter.ChangeString(item["ByMonth"]))) }.ToStringObjectDictionary(), false, "$") }).ToList(); if (datas.Count > pageSize) { WXMessageTemplate template_MyServeDurationStatMoreUrl = BuilderFactory.DefaultBulder().Load <WXMessageTemplate, WXMessageTemplatePK>(new WXMessageTemplatePK { TemplateId = GlobalManager.TemplateId_MyServeDurationStatMoreUrl }); items.Add(new WXResponseNewsItem { Title = "更多...", Url = template_MyServeDurationStatMoreUrl.TemplateContent.ReplaceWithKeys(new { DeployAreaCode = GlobalManager.GetDeployArea().code, OpenId = receiveMessage.FromUserName, TimeStamp = DateTimeAdapter.ConvertDateTimeUnix(DateTime.Now).ToString() }.ToStringObjectDictionary(), false, "$") }); } items.Insert(0, new WXResponseNewsItem { Title = "服务时长统计结果:" }); result = FormatOutputNews(receiveMessage.FromUserName, receiveMessage.ToUserName, items); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(result); }
private string ResponseEvent_WX20102(WXReceiveEventMessage receiveMessage) { string result = ""; int pageSize = 5; StringObjectDictionary filter = new { OpenId = receiveMessage.FromUserName }.ToStringObjectDictionary(); try { var datas = BuilderFactory.DefaultBulder().ListStringObjectDictionaryByPage("ServeRecordByServeMan_ListByPage", filter, new ListPager { OrderByClause = "ServeManArriveTime desc", PageNo = 1, PageSize = pageSize }); if (datas.Count == 0) { result = FormatOutputText(receiveMessage.FromUserName, receiveMessage.ToUserName, "没有任何服务记录"); } else { WXMessageTemplate template_MyServeRecordTitle = BuilderFactory.DefaultBulder().Load <WXMessageTemplate, WXMessageTemplatePK>(new WXMessageTemplatePK { TemplateId = GlobalManager.TemplateId_MyServeRecordTitle }); List <WXResponseNewsItem> items = datas.Select(item => new WXResponseNewsItem { Title = template_MyServeRecordTitle.TemplateContent.ReplaceWithKeys(new { ServeDate = DateTime.Parse(TypeConverter.ChangeString(item["ServeDate"])).ToString("yyyy-MM-dd"), ArriveTime = DateTime.Parse(TypeConverter.ChangeString(item["ArriveTime"])).ToString("HH:mm:ss"), LeaveTime = DateTime.Parse(TypeConverter.ChangeString(item["LeaveTime"])).ToString("HH:mm:ss"), OldManName = TypeConverter.ChangeString(item["OldManName"]), ServeItemBName = TypeConverter.ChangeString(item["ServeItemBName"]), ServeStationName = TypeConverter.ChangeString(item["ServeStationName"]) }.ToStringObjectDictionary(), false, "$").ReplaceEmoji() }).ToList(); if (BuilderFactory.DefaultBulder().GetRecordCount("Count_ScheduleByServeMan_ListByPage", filter) > pageSize) { WXMessageTemplate template_MyServeRecordMoreUrl = BuilderFactory.DefaultBulder().Load <WXMessageTemplate, WXMessageTemplatePK>(new WXMessageTemplatePK { TemplateId = GlobalManager.TemplateId_MyServeRecordMoreUrl }); items.Add(new WXResponseNewsItem { Title = "更多...", Url = template_MyServeRecordMoreUrl.TemplateContent.ReplaceWithKeys(new { DeployAreaCode = GlobalManager.GetDeployArea().code, OpenId = receiveMessage.FromUserName, TimeStamp = DateTimeAdapter.ConvertDateTimeUnix(DateTime.Now).ToString() }.ToStringObjectDictionary(), false, "$") }); } items.Insert(0, new WXResponseNewsItem { Title = "服务记录查询结果:" }); result = FormatOutputNews(receiveMessage.FromUserName, receiveMessage.ToUserName, items); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(result); }