钉钉消息加入日志,

zrg

2024-07-02 341da63fe63e2cae3337c5a090624400d7244c11

 DingDingMsg/DingDingMsg/Program.cs

@@ -16,10 +16,9 @@
        {
            string appKey = "dingrsrzhdyn3mlaof95";
            string appSecret = "RAqH6YtZnPLCpDbuqfaYQkKkVtVdS0wqfC8I26X6qiS-8eoCJCNrzx3fubGND4Sq";
            Console.WriteLine("Hello World!");
            Console.WriteLine("程序正在执行,请不要关闭!!!!");
            while (true)
            {
                Console.WriteLine("Hello World!1");
                //查数据
                string sql = "select a.HInterID,a.HReceiveMan 接收人,c.HDingDingUserID 钉钉id,b.HDescription 内容 from OA_ErrMsgBackBillSub2" +
                    " a inner join OA_ErrMsgBackBillMain b on a.HInterID=b.HInterID left join Gy_Czygl c " +
@@ -60,16 +59,14 @@
                            string sql1 = "update OA_ErrMsgBackBillSub2 set HSendFlag='1' where HReceiveMan in ('" + Stares + "')";
                            oCN.RunProc(sql1);
                            Console.WriteLine(sql1);
                           DBHelper.CustomWriteLog("钉钉返回信息:"+response+"    更新子表语句:"+sql1, DateTime.Now.ToString("yyyy-MM-dd"));
                        }
                        else
                        {
                            Console.WriteLine(responseData.errcode);
                            DBHelper.CustomWriteLog("钉钉返回信息:" + response, DateTime.Now.ToString("yyyy-MM-dd"));
                        }

                    }                  

                  
                                    
                    }                                                                        
                }
                        
                // 等待一分钟