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