public override IResponseMessage OnTextRequest(IRequestMessage requestMessage)
{
var art1 = new ResponseMessageInnerType.Article
{
Title = "ESAP第十四弹 手把手教你玩转ES微信开发",
Description = "来自村长的ESAP系统最新技术分享。",
PicUrl = "http://iesap.net/wp-content/uploads/2015/12/esap3-1.jpg",
Url = "http://iesap.net/index.php/2015/12/28/esap14/"
};
var art2 = new ResponseMessageInnerType.Article
{
Title = "打通信息化的“任督二脉”(二)",
Description = "来自村长的ESAP2.0系统技术分享。",
PicUrl = "http://iesap.net/wp-content/uploads/2015/12/taiji.jpg",
Url = "http://iesap.net/index.php/2015/12/16/esap2-1/"
};
var art3 = new ResponseMessageInnerType.Article
{
Title = "打通信息化的“任督二脉”(一)",
Description = "来自村长的ESAP2.0系统技术分享。",
PicUrl = "http://iesap.net/wp-content/uploads/2015/12/rdem.jpg",
Url = "http://iesap.net/index.php/2015/12/11/esap2-0/"
};
var responseMessage = ResponseMessage.CreateFromRequestMessage(requestMessage, QY.Enums.ResponseType.News);
responseMessage.Articles.Add(art1);
responseMessage.Articles.Add(art2);
responseMessage.Articles.Add(art3);
return(responseMessage);
}
public override IResponseMessage OnTextRequest(IRequestMessage requestMessage)
{
IResponseMessage responseMessage = null;
DateTime retdate;
IFormatProvider ifp = new System.Globalization.CultureInfo("zh-CN", true);
var bDate = DateTime.TryParseExact(requestMessage.Content, "yyyyMM", ifp, System.Globalization.DateTimeStyles.None, out retdate);
if (requestMessage.Content.Length != 6 || !bDate)
{
responseMessage = ResponseMessage.CreateFromRequestMessage(requestMessage, QY.Enums.ResponseType.Text);
responseMessage.Content = "您输入的格式有误。";
return(responseMessage);
}
var jsonObj = JObject.Parse(JsonSend.GetQyUserinfo(postModel.CorpId, postModel.Secret, requestMessage.FromUserName));
var sUserid = (string)jsonObj["userid"];
Debug.WriteLine(sUserid);
if (sUserid == "1")
{
sUserid = "330421199506040511";
}
var sSelect = "SELECT * FROM 考勤期间 AS T1 INNER JOIN 考勤汇总_明细 AS T2 ON T1.ExcelServerRCID=T2.ExcelServerRCID INNER JOIN (SELECT 人员编号 as 'id' FROM 人员档案 AS T1 WHERE T1.证件号码 = '{0}') AS T3 ON T3.id = T2.人员编号 WHERE T1.年=SUBSTRING('{1}',1,4) AND T1.月=SUBSTRING('{1}',5,2)";
sSelect = string.Format(sSelect, sUserid, requestMessage.Content);
var ds = SqlHelper.ExecuteDataset(QyWeixin.QyEntry.sqlConnectstr, CommandType.Text, sSelect);
if (ds.Tables[0].Rows.Count == 0)
{
Debug.WriteLine(sSelect);
responseMessage = ResponseMessage.CreateFromRequestMessage(requestMessage, QY.Enums.ResponseType.Text);
responseMessage.Content = "查询不到关于你的数据。";
return(responseMessage);
}
var sID = (string)ds.Tables[0].Rows[0]["id"];
var sName = (string)ds.Tables[0].Rows[0]["姓名"];
var sStardard = Math.Round((decimal)ds.Tables[0].Rows[0]["标准工时"], 1);
var sReal = Math.Round((decimal)ds.Tables[0].Rows[0]["实出勤"], 1);
var sJiaban = sReal - sStardard > 0 ? sReal - sStardard : 0;
var sQuanqin = (string)ds.Tables[0].Rows[0]["是否全勤"];
var sDescription = "{0}，该月标准工时{1}小时，您实际出勤{2}小时，其中{3}小时将作为加班工时为您结算加班工资。全勤：{4}";
var sUrl = "http://www.skyflag.com:6018/kaoqin.aspx?id={0}&date={1}&name={2}";
var sDate = requestMessage.Content;
sUrl = string.Format(sUrl, sID, sDate, sName);
sDescription = string.Format(sDescription, sName, sStardard, sReal, sJiaban, sQuanqin);
Debug.WriteLine(sUserid);
Debug.WriteLine(sSelect);
responseMessage = ResponseMessage.CreateFromRequestMessage(requestMessage, QY.Enums.ResponseType.News);
var art1 = new ResponseMessageInnerType.Article
{
Title = requestMessage.Content + "考勤数据",
Description = sDescription,
Url = sUrl,
PicUrl = "http://www.skyflag.com:6018/img/salary.jpg"
};
responseMessage.Articles.Add(art1);
return(responseMessage);
}
