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