public static void xxsend(object source, System.Timers.ElapsedEventArgs e)
{
string tmp = DateTime.Now.Hour.ToString();
if ((!zxstat) && (DateTime.Now.Hour.ToString() == "8"))
{
ConsoleApplication1.Http_send user_send = new ConsoleApplication1.Http_send();
SqlConnection connt = new SqlConnection();
connt.ConnectionString = "server=172.22.52.51;database=master;user=snzyy;pwd=Snzyy123.";
connt.Open();
SqlCommand sqlstr = new SqlCommand();
sqlstr.Connection = connt;
sqlstr.CommandType = System.Data.CommandType.Text;
//string sqltext = "SELECT SUM(aa.住院量) AS 住院量,SUM(aa.门诊量)-SUM(aa.急诊量) AS 门诊量,SUM(aa.急诊量) AS 急诊量,SUM(aa.手术量) AS 手术量,SUM(aa.预约挂号数) AS 预约挂号数 ";
//sqltext = sqltext + "FROM (SELECT count(cc.住院量) AS 住院量,0 AS 门诊量, 0 AS 急诊量, 0 AS 手术量 ,0 AS 预约挂号数 FROM (SELECT MAX(a.PAT_IN_HOS_ID) AS 住院量 FROM zy.[IN].PAT_ALL_INFO_VIEW a ";
//sqltext = sqltext + string.Format("LEFT JOIN ZY.[IN].BEDS b ON b.BED_ID = a.BED_ID WHERE IN_HOS_STATUS = 1 AND b.BED_STATUS = 1 AND a.PAT_IN_TIME < '{0}' AND a.PAT_LEAVE_ORDER_LEAVE_TIME < {1} ", DateTime.Now.AddDays(-1).ToShortDateString()+" 00:00:00", DateTime.Now.AddDays(-1).ToShortDateString()+" 23:59:59");
string sqltext = string.Format("SELECT SUM(aa.住院量) AS 住院量,SUM(aa.门诊量)-SUM(aa.急诊量) AS 门诊量,SUM(aa.急诊量) AS 急诊量,SUM(aa.手术量) AS 手术量,SUM(aa.预约挂号数) AS 预约挂号数,SUM(aa.今日出院) 今日出院,SUM(aa.今日入院) 今日入院 FROM (SELECT count(PAT_IN_HOS_CODE) AS 住院量,0 AS 门诊量, 0 AS 急诊量, 0 AS 手术量 ,0 AS 预约挂号数,0 as 今日出院,0 as 今日入院 from zy.[IN].PAT_ALL_INFO_VIEW where PAT_IN_HOS_CODE<>'' and (CONVERT(VARCHAR(18),PAT_IN_TIME,120) = CONVERT(VARCHAR(18),PAT_LEAVE_ORDER_LEAVE_TIME,120) or PAT_LEAVE_ORDER_LEAVE_TIME > '{1}') and PAT_IN_TIME<'{1}' UNION ALL SELECT 0 as 住院量,COUNT(*) AS 门诊量, 0 AS 急诊量, 0 AS 手术量 ,0 AS 预约挂号数,0 as 今日出院,0 as 今日入院 FROM MZ.OUT.REGISTERS WHERE CREATE_TIME > '{0}' AND CREATE_TIME < '{1}' UNION ALL SELECT 0 as 住院量,0 AS 门诊量,SUM(bb.急诊量) AS 急诊量, 0 AS 手术量 ,0 AS 预约挂号数,0 as 今日出院,0 as 今日入院 FROM (SELECT COUNT(*) 急诊量 FROM mz.out.REGISTERS a LEFT JOIN comm.comm.DEPTS b ON b.DEPT_ID = a.DEPT_ID LEFT JOIN COMM.COMM.USERINFO_VIEW d WITH ( NOLOCK ) ON a.DOC_ID = d.USER_SYS_ID LEFT JOIN mz.OUT.DOC_REGISTER e ON a.REGISTER_ID=e.REGISTER_ID WHERE a.CREATE_TIME >= '{0}' AND a.CREATE_TIME <= '{1}' AND a.DEPT_id IN (160,185) AND d.UESR_NAME IS not NULL AND a.FLAG_INVALID = 0 AND a.REGISTER_STATUS = 5 UNION ALL SELECT COUNT(a.PAT_IN_HOS_ID) 急诊量 FROM zy.[IN].PAT_ALL_INFO_VIEW a LEFT JOIN comm.COMM.USERINFO_VIEW d ON a.OUT_DOC_ID=d.USER_SYS_ID LEFT JOIN COMM.COMM.DEPTS c ON c.DEPT_ID = d.DEPT_ID WHERE 1=1 AND a.PAT_IN_TIME >='{0}' AND a.PAT_IN_TIME <='{1}' AND c.DEPT_ID IN (160,185)) bb UNION ALL SELECT 0 as 住院量,0 AS 门诊量, 0 AS 急诊量, COUNT(*) AS 手术量 ,0 AS 预约挂号数,0 as 今日出院,0 as 今日入院 FROM oas4.dbo.OAS_PATIENT_EVENT_DATA WHERE event_begintime > '{0}' AND event_begintime < '{1}' AND event_name = '手术开始' UNION ALL SELECT 0 as 住院量,0 AS 门诊量, 0 AS 急诊量, 0 AS 手术量 ,COUNT(*) AS 预约挂号数,0 as 今日出院,0 as 今日入院 FROM ARS.dbo.APPOINTMENT_REAL_REGISTER WHERE REGISTER_TIME2 >'{0}' AND REGISTER_TIME2 <'{1}' AND INVALID <> 1 union all SELECT 0 AS 住院量,0 AS 门诊量, 0 AS 急诊量, 0 AS 手术量 ,0 AS 预约挂号数,count(PAT_IN_HOS_ID) as 今日出院,0 as 今日入院 FROM zy.[IN].PAT_ALL_INFO_VIEW a WHERE a.PAT_LEAVE_ORDER_LEAVE_TIME > '{0}' AND a.PAT_LEAVE_ORDER_LEAVE_TIME < '{1}' and CONVERT(VARCHAR(18),PAT_IN_TIME,120) <> CONVERT(VARCHAR(18),PAT_LEAVE_ORDER_LEAVE_TIME,120) union all select 0 AS 住院量,0 AS 门诊量, 0 AS 急诊量, 0 AS 手术量 ,0 AS 预约挂号数,0 as 今日出院,count(*) 今日入院 from zy.[IN].PAT_ALL_INFO_VIEW a where PAT_IN_TIME > '{0}' AND PAT_IN_TIME < '{1}' and PAT_IN_HOS_CODE<>'' and FLAG_INVALID=0) aa", DateTime.Now.AddDays(-1).ToShortDateString() + " 08:00:00", DateTime.Now.ToShortDateString() + " 08:00:00");
sqlstr.CommandText = sqltext;
SqlDataReader rder = sqlstr.ExecuteReader();
rder.Read();
string wbtext = DateTime.Now.AddDays(-1).ToLongDateString() + "8点至" + DateTime.Now.ToLongDateString() + "8点" + "\n" + string.Format("门诊量：{0}；预约挂号：{1}；急诊量：{2}；住院量：{3}；手术量：{4}；当日出院：{5}；当日入院：{6}", rder["门诊量"].ToString(), rder["预约挂号数"].ToString(), rder["急诊量"].ToString(), rder["住院量"].ToString(), rder["手术量"].ToString(), rder["今日出院"].ToString(), rder["今日入院"].ToString());
string x_huizong = wbtext + "\n";
rder.Close();
string tx_sr;
tx_sr = DateTime.Now.AddDays(-1).ToLongDateString() + "\n";
sqltext = string.Format("SELECT cast (round(SUM(金额)/10000,2) as numeric(8,2)) AS 总金额 FROM(SELECT SUM(b.GET_AMOUNT)AS 金额 FROM MZ.OUT.INVOICE_MAIN AS A WITH(NOLOCK) INNER JOIN MZ.OUT.INVOICE_DETAILS_CHARGE AS B WITH(NOLOCK) ON A.INVOICE_ID = B.INVOICE_ID WHERE 1=1 AND a.create_time > '{0}' AND a.create_time < '{1}' UNION ALL SELECT SUM(b.GET_AMOUNT)AS 金额 FROM MZ.OUT.INVOICE_MAIN AS A WITH(NOLOCK) INNER JOIN MZ.OUT.INVOICE_DETAILS_MED AS B WITH(NOLOCK) ON A.INVOICE_ID = B.INVOICE_ID WHERE 1=1 AND a.create_time > '{0}' AND a.create_time < '{1}' UNION ALL SELECT SUM(ROUND(AMOUNT,2)) 金额 FROM ZY.[IN].IN_BILL_RECORD B WITH(NOLOCK) WHERE 1=1 AND b.create_time > '{0}' AND b.create_time < '{1}') MM", DateTime.Now.AddDays(-1).ToShortDateString() + " 00:00:00", DateTime.Now.AddDays(-1).ToShortDateString() + " 23:59:59");
sqlstr.CommandText = sqltext;
rder = sqlstr.ExecuteReader();
rder.Read();
tx_sr = tx_sr + "当日收入:" + rder["总金额"].ToString() + "万元\n";
rder.Close();
sqltext = string.Format("SELECT cast (round(SUM(金额)/10000,2) as numeric(8,2)) AS 总金额 FROM(SELECT SUM(b.GET_AMOUNT)AS 金额 FROM MZ.OUT.INVOICE_MAIN AS A WITH(NOLOCK) INNER JOIN MZ.OUT.INVOICE_DETAILS_CHARGE AS B WITH(NOLOCK) ON A.INVOICE_ID = B.INVOICE_ID WHERE 1=1 AND a.create_time > '{0}' AND a.create_time < '{1}' UNION ALL SELECT SUM(b.GET_AMOUNT)AS 金额 FROM MZ.OUT.INVOICE_MAIN AS A WITH(NOLOCK) INNER JOIN MZ.OUT.INVOICE_DETAILS_MED AS B WITH(NOLOCK) ON A.INVOICE_ID = B.INVOICE_ID WHERE 1=1 AND a.create_time > '{0}' AND a.create_time < '{1}' UNION ALL SELECT SUM(ROUND(AMOUNT,2)) 金额 FROM ZY.[IN].IN_BILL_RECORD B WITH(NOLOCK) WHERE 1=1 AND b.create_time > '{0}' AND b.create_time < '{1}') MM", DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + "01" + " 00:00:00", DateTime.Now.AddDays(-1).ToShortDateString() + " 23:59:59");
sqlstr.CommandText = sqltext;
rder = sqlstr.ExecuteReader();
rder.Read();
tx_sr = tx_sr + "当月收入:" + rder["总金额"].ToString() + "万元\n";
rder.Close();
sqltext = string.Format("SELECT cast (round(SUM(金额)/10000,2) as numeric(8,2)) AS 总金额 FROM(SELECT SUM(b.GET_AMOUNT)AS 金额 FROM MZ.OUT.INVOICE_MAIN AS A WITH(NOLOCK) INNER JOIN MZ.OUT.INVOICE_DETAILS_CHARGE AS B WITH(NOLOCK) ON A.INVOICE_ID = B.INVOICE_ID WHERE 1=1 AND a.create_time > '{0}' AND a.create_time < '{1}' UNION ALL SELECT SUM(b.GET_AMOUNT)AS 金额 FROM MZ.OUT.INVOICE_MAIN AS A WITH(NOLOCK) INNER JOIN MZ.OUT.INVOICE_DETAILS_MED AS B WITH(NOLOCK) ON A.INVOICE_ID = B.INVOICE_ID WHERE 1=1 AND a.create_time > '{0}' AND a.create_time < '{1}' UNION ALL SELECT SUM(ROUND(AMOUNT,2)) 金额 FROM ZY.[IN].IN_BILL_RECORD B WITH(NOLOCK) WHERE 1=1 AND b.create_time > '{0}' AND b.create_time < '{1}') MM", DateTime.Now.AddDays(-1).Year.ToString() + "-" + "01" + "-" + "01" + " 00:00:00", DateTime.Now.AddDays(-1).ToShortDateString() + " 23:59:59");
sqlstr.CommandText = sqltext;
rder = sqlstr.ExecuteReader();
rder.Read();
tx_sr = tx_sr + "本年至今:" + rder["总金额"].ToString() + "万元";
rder.Close();
user_send.App_send("", "2", "1", tx_sr);
connt.Close();
SqlConnection connt_old = new SqlConnection();
connt_old.ConnectionString = "server=192.168.8.18;database=my_data;user=sa;pwd=VA4X1abfy76pY";
connt_old.Open();
SqlCommand sqlstr_old = new SqlCommand();
sqlstr_old.Connection = connt_old;
sqlstr_old.CommandType = System.Data.CommandType.Text;
sqltext = string.Format("select sum(总门诊量)-sum(急诊量) 门诊量,sum(急诊量) 急诊量,sum(住院量) 住院量,sum(当日出院) 当日出院,sum(当日入院) 当日入院 from (select count(*) 总门诊量,0 急诊量,0 住院量,0 当日出院,0 当日入院 from (select distinct RTRIM(brxm) brxm,RTRIM(czks) ksys from dzbl_brbl_last where zdrq between '{0}' and '{1}' and tmh not in (select tmh from mzsf_mzfymx where sfrq between '{0}' and '{1}') union all select distinct RTRIM(brxm) brxm,RTRIM(kdks) ksys from mzsf_mzfymx where sfrq between '{0}' and '{1}' union all select distinct RTRIM(brxm) brxm,RTRIM(kdks) ksys from mzsf_mzfymx_bf where sfrq between '{0}' and '{1}') xa union all select 0 总门诊量,count(*) 急诊量,0 住院量,0 当日出院,0 当日入院 from (select distinct rtrim(tmh)+convert(char,sfrq,112) brbs from mzsf_mzfymx where sfrq between '{0}' and '{1}' and tfbz=0 and zfbz=0 and (kdks in (select dm from sys_ksdm where mc like '%急诊%') or czks in (select dm from sys_ksdm where mc like '%急诊%')) union all select distinct rtrim(tmh)+convert(char,sfrq,112) brbs from mzsf_mzfymx_bf where sfrq between '{0}' and '{1}' and tfbz=0 and zfbz=0 and (kdks in (select dm from sys_ksdm where mc like '%急诊%') or czks in (select dm from sys_ksdm where mc like '%急诊%')) union all select distinct rtrim(tmh)+convert(char,sfrq,112) brbs from mzsf_mzfymx_zc where sfrq between '{0}' and '{1}' and tfbz=0 and zfbz=0 and (kdks in (select dm from sys_ksdm where mc like '%急诊%') or czks in (select dm from sys_ksdm where mc like '%急诊%')) ) xb union all select 0 总门诊量,0 急诊量,count(*) 住院量,0 当日出院,0 当日入院 from ( select tmh from zysf_zydj where ryrq<'{1}' and (cybz=0 or cyrq>'{1}') union all select tmh from zysf_cydj where ryrq<'{1}' and (cybz=0 or cyrq>'{1}') union all select tmh from zyzc_zysf_cydj where ryrq<'{1}' and (cybz=0 or cyrq>'{1}') ) xc union all select 0 总门诊量,0 急诊量,0 住院量,count(*) 当日出院,0 当日入院 from ( select tmh from zysf_zydj where cybz=1 and cyrq between '{0}' and '{1}' union all select tmh from zysf_cydj where cybz=1 and cyrq between '{0}' and '{1}' union all select tmh from zyzc_zysf_cydj where cybz=1 and cyrq between '{0}' and '{1}' ) xd union all select 0 总门诊量,0 急诊量,0 住院量,0 当日出院,count(*) 当日入院 from (select zyh from zysf_zydj where ryrq between'{0}' and '{1}' union all select zyh from zysf_cydj where ryrq between'{0}' and '{1}' union all select zyh from zyzc_zysf_cydj where ryrq between'{0}' and '{1}') xe) xxa", DateTime.Now.AddDays(-1).AddYears(-1).ToShortDateString() + " 08:00:00", DateTime.Now.AddYears(-1).ToShortDateString() + " 08:00:00");
sqlstr_old.CommandText = sqltext;
SqlDataReader rder_old = sqlstr_old.ExecuteReader();
rder_old.Read();
wbtext = DateTime.Now.AddYears(-1).AddDays(-1).ToLongDateString() + "8点至" + DateTime.Now.AddYears(-1).ToLongDateString() + "8点" + "\n" + string.Format("门诊量：{0}；急诊量：{1}；住院量：{2}；当日出院：{3}；当日入院：{4}", rder_old["门诊量"].ToString(), rder_old["急诊量"].ToString(), rder_old["住院量"].ToString(), rder_old["当日出院"].ToString(), rder_old["当日入院"].ToString());
x_huizong = x_huizong + wbtext;
user_send.App_send("", "2", "", x_huizong);
user_send.App_send_group("wrLGxDBgAA5Hdw_d2rY7cRhd3hOg4Jsg", x_huizong);
rder_old.Close();
connt_old.Close();
zxstat = true;
}
else
{
if (DateTime.Now.Hour.ToString() != "8")
{
zxstat = false;
}
}
}
public override void handlePOSTRequest(HttpProcessor p, StreamReader inputData)
{
Console.WriteLine("POST request: {0}", p.http_url);
string data = inputData.ReadToEnd();
/*
* Tencent.WXBizMsgCrypt wxcpt = new Tencent.WXBizMsgCrypt(sToken, sEncodingAESKey, sCorpID);
* ------------使用示例二：对用户回复的消息解密-------------- -
* 用户回复消息或者点击事件响应时，企业会收到回调消息，此消息是经过企业微信加密之后的密文以post形式发送给企业，密文格式请参考官方文档
* 假设企业收到企业微信的回调消息如下：
*
* POST / cgi - bin / wxpush ? msg_signature = 477715d11cdb4164915debcba66cb864d751f3e6 & timestamp = 1409659813 & nonce = 1372623149 HTTP / 1.1
*
* Host: qy.weixin.qq.com
*
* Content - Length: 613
* < xml > < ToUserName >< ![CDATA[wx5823bf96d3bd56c7]] ></ ToUserName >< Encrypt >< ![CDATA[RypEvHKD8QQKFhvQ6QleEB4J58tiPdvo + rtK1I9qca6aM / wvqnLSV5zEPeusUiX5L5X / 0lWfrf0QADHHhGd3QczcdCUpj911L3vg3W / sYYvuJTs3TUUkSUXxaccAS0qhxchrRYt66wiSpGLYL42aM6A8dTT + 6k4aSknmPj48kzJs8qLjvd4Xgpue06DOdnLxAUHzM6 + kDZ + HMZfJYuR + LtwGc2hgf5gsijff0ekUNXZiqATP7PF5mZxZ3Izoun1s4zG4LUMnvw2r + KqCKIw + 3IQH03v + BCA9nMELNqbSf6tiWSrXJB3LAVGUcallcrw8V2t9EL4EhzJWrQUax5wLVMNS0 + rUPA3k22Ncx4XXZS9o0MBH27Bo6BpNelZpS +/ uh9KsNlY6bHCmJU9p8g7m3fVKn28H3KDYA5Pl / T8Z1ptDAVe0lXdQ2YoyyH2uyPIGHBZZIs2pDBS8R07 + qN + E7Q ==]] ></ Encrypt >
*
* < AgentID >< ![CDATA[218]] ></ AgentID >
*
* </ xml >
*
* 企业收到post请求之后应该 1.解析出url上的参数，包括消息体签名(msg_signature)，时间戳(timestamp)以及随机数字串(nonce)
*
* 2.验证消息体签名的正确性。
* 3.将post请求的数据进行xml解析，并将<Encrypt> 标签的内容进行解密，解密出来的明文即是用户回复消息的明文，明文格式请参考官方文档
* 第2，3步可以用企业微信提供的库函数DecryptMsg来实现。
*/
Tencent.WXBizMsgCrypt wxcpt = new Tencent.WXBizMsgCrypt(sToken, sEncodingAESKey, sCorpID);
string all_str = p.http_url;
all_str = all_str.Substring(all_str.IndexOf("?") + 1);
string[] parm = all_str.Split('&');
// string sReqMsgSig = HttpUtils.ParseUrl("msg_signature");
string sReqMsgSig = HttpUtility.UrlDecode(parm[0].Substring(parm[0].IndexOf("=") + 1));
// string sReqTimeStamp = HttpUtils.ParseUrl("timestamp");
string sReqTimeStamp = HttpUtility.UrlDecode(parm[1].Substring(parm[1].IndexOf("=") + 1));
// string sReqNonce = HttpUtils.ParseUrl("nonce");
string sReqNonce = HttpUtility.UrlDecode(parm[2].Substring(parm[2].IndexOf("=") + 1));
// Post请求的密文数据
// string sReqData = HttpUtils.PostData();
string sReqData = data;
string sMsg = ""; // 解析之后的明文
int ret = wxcpt.DecryptMsg(sReqMsgSig, sReqTimeStamp, sReqNonce, sReqData, ref sMsg);
if (ret != 0)
{
System.Console.WriteLine("ERR: Decrypt Fail, ret: " + ret);
return;
}
Console.Write(sMsg);
p.writeSuccess();
// ret==0表示解密成功，sMsg表示解密之后的明文xml串
// TODO: 对明文的处理
// For example:
XmlDocument doc = new XmlDocument();
doc.LoadXml(sMsg);
XmlNode root = doc.FirstChild;
bool message_stat = false;
if (root["MsgType"].InnerText == "text" && !message_stat)
{
string content = root["Content"].InnerText;
string content_from = root["FromUserName"].InnerText;
if (content.IndexOf("今天") > -1 && content.IndexOf("应班") > -1 && (content.IndexOf("?") > -1 || content.IndexOf("？") > -1))
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=192.168.8.18;database=my_data;user=sa;pwd=VA4X1abfy76pY";
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from qywx_xxkpb where (pb=DATEDIFF(day,'2020-03-26',getdate())+1 and DATEPART(HOUR,getdate())>=8) or (pb=DATEDIFF(day,'2020-03-26',getdate()) and DATEPART(HOUR,getdate())<8)";
SqlDataReader read1 = cmd.ExecuteReader();
read1.Read();
string huifu = "";
if (read1["userid"].ToString() == content_from)
{
huifu = "问啥问？就是你!";
}
else
{
huifu = "今天是" + read1["name"].ToString() + "应班";
}
ConsoleApplication1.Http_send h1 = new ConsoleApplication1.Http_send();
h1.App_send(content_from, "", "", huifu, "0");
message_stat = true;
}
if (qt.Count > 0 && !message_stat)
{
//foreach (var i in qt)
qt.RemoveAll(x =>
{
if (DateTime.Now.Subtract(x.lasttime).TotalSeconds > 180)
{
return(true);
}
else
{
return(false);
}
});
for (int i = 0; i < qt.Count; i++)
{
if (content_from == qt[i].user_id)
{
if (qt[i].title == "yingbanstat1")
{
if ((content.Trim().Length == 10) || (content.Trim() == "今天") || (content.Trim() == "明天") || (content.Trim() == "后天") || (content.Trim() == "昨天"))
{
if (content.Trim() == "今天")
{
content = DateTime.Now.ToString("yyyy-MM-dd");
}
if (content.Trim() == "明天")
{
content = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
}
if (content.Trim() == "后天")
{
content = DateTime.Now.AddDays(2).ToString("yyyy-MM-dd");
}
if (content.Trim() == "昨天")
{
content = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
}
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=192.168.8.18;database=my_data;user=sa;pwd=VA4X1abfy76pY";
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = string.Format("select * from qywx_xxkpb where (pb=DATEDIFF(day,'2020-03-26','{0}')%6+1 )", content);
try
{
SqlDataReader read1 = cmd.ExecuteReader();
read1.Read();
string huifu = "";
if (read1["userid"].ToString() == content_from)
{
huifu = "问啥问？就是你!";
}
else
{
huifu = content + "是" + read1["name"].ToString() + "应班";
}
ConsoleApplication1.Http_send h1 = new ConsoleApplication1.Http_send();
h1.App_send(content_from, "", "", huifu, "0");
message_stat = true;
}
catch (Exception)
{
return;
}
finally
{
conn.Close();
}
qt.Remove(qt[i]);
break;
}
else
{
ConsoleApplication1.Http_send h1 = new ConsoleApplication1.Http_send();
h1.App_send(content_from, "", "", "请注意输入日期格式例如：（2020-01-01）", "0");
}
}
if (qt[i].title == "txl_qry")
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=192.168.8.18;database=my_data;user=sa;pwd=VA4X1abfy76pY";
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
string sqltext = "";
if (content.IndexOf("姓名") == 0 || content.IndexOf("单位") == 0 || content.IndexOf("标签") == 0)
{
if (content.IndexOf("姓名") == 0)
{
sqltext = string.Format(" name like '%{0}%' ", content.Substring(3));
}
if (content.IndexOf("单位") == 0)
{
sqltext = string.Format(" unit like '%{0}%' ", content.Substring(3));
}
if (content.IndexOf("标签") == 0)
{
sqltext = string.Format(" label like '%{0}%' ", content.Substring(3));
}
cmd.CommandText = string.Format("select * from qywx_phone where {0}", sqltext);
SqlDataReader rder = cmd.ExecuteReader();
ConsoleApplication1.Http_send h1 = new ConsoleApplication1.Http_send();
if (!rder.HasRows)
{
h1.App_send(content_from, "", "", "未查询相关通讯录！", "0");
}
else
{
string jg = "";
while (rder.Read())
{
jg = jg + string.Format("姓名：{0}; 单位：{1}; 电话：{2}（{3}） \n", rder["name"].ToString(), rder["unit"].ToString(), rder["phone"].ToString(), rder["label"].ToString());
}
h1.App_send(content_from, "", "", jg, "0");
}
qt.Remove(qt[i]);
break;
}
else
{
ConsoleApplication1.Http_send h1 = new ConsoleApplication1.Http_send();
h1.App_send(content_from, "", "", "请注意输入查询格式如：（姓名@小明）", "0");
}
}
}
}
}
if (content == "小明小明")
{
ConsoleApplication1.Http_send_cardmessage msg = new ConsoleApplication1.Http_send_cardmessage();
msg.title = "闹啥呢？";
msg.description = "请谨慎选择！！！";
msg.task_id = "ASK" + Convert.ToInt64((DateTime.Now - new DateTime(1970, 1, 1, 0, 0, 0, 0)).TotalSeconds).ToString();
msg.btn = new ConsoleApplication1.Http_send_cardmessage.Message_btn[2];
msg.btn[0] = new ConsoleApplication1.Http_send_cardmessage.Message_btn();
msg.btn[0].key = "btn0";
msg.btn[0].name = "查询应班情况";
msg.btn[0].replace_name = "查询应班情况";
msg.btn[0].btncolor = ConsoleApplication1.Http_send_cardmessage.Message_btn.color.blue;
msg.btn[0].bold = true;
msg.btn[1] = new ConsoleApplication1.Http_send_cardmessage.Message_btn();
msg.btn[1].key = "btn1";
msg.btn[1].name = "通讯录查询";
msg.btn[1].replace_name = "通讯录查询";
msg.btn[1].btncolor = ConsoleApplication1.Http_send_cardmessage.Message_btn.color.blue;
msg.btn[1].bold = true;
ConsoleApplication1.Http_send h1 = new ConsoleApplication1.Http_send();
h1.App_send_card(content_from, "", "", msg);
}
}
else
{
if (root["MsgType"].InnerText == "event")
{
if (root["EventKey"].InnerText == "btn0")
{
ConsoleApplication1.Http_send h1 = new ConsoleApplication1.Http_send();
h1.App_send(root["FromUserName"].InnerText, "", "", "请问查几号应班情况？请输入日期（yyyy-mm-dd）", "0");
for (int i = 0; i < qt.Count; i++)
{
if (qt[i].user_id == root["FromUserName"].InnerText)
{
qt.Remove(qt[i]);
break;
}
}
Question tmp = new Question();
tmp.title = "yingbanstat1";
tmp.user_id = root["FromUserName"].InnerText;
tmp.lasttime = DateTime.Now;
qt.Add(tmp);
}
if (root["EventKey"].InnerText == "btn1")
{
ConsoleApplication1.Http_send h1 = new ConsoleApplication1.Http_send();
h1.App_send(root["FromUserName"].InnerText, "", "", "请输入查询类容？格式（姓名@XXX\\单位@XXX\\标签@XXX）", "0");
for (int i = 0; i < qt.Count; i++)
{
if (qt[i].user_id == root["FromUserName"].InnerText)
{
qt.Remove(qt[i]);
break;
}
}
Question tmp = new Question();
tmp.title = "txl_qry";
tmp.user_id = root["FromUserName"].InnerText;
tmp.lasttime = DateTime.Now;
qt.Add(tmp);
}
}
}
}