调用钉钉的WebAPI接口实现与ERP数据的同步

一、调用钉钉的api接口实现与ERP中数据的对接，其中用到的主要技术有EF，linq，序列化，webAPI，文件的基本操作。

哪里不懂的直接看代码，或者给我评论留言。

using Modell;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Text;
using System.Web.Script.Serialization;
using libraries;
using System.IO;
using System.Collections;
namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            AdwinErpEntities db = new AdwinErpEntities();
            
           
            int next_cursor = 0;
            int count = 0;


            ArrayList list = new ArrayList();
            ArrayList list1 = new ArrayList();
           
            //查询出所有的id的值
            var t_pALM_Employeeslist1 = from a in db.t_PALM_Employees
                                        select a.fEmpNo;
            t_pALM_Employeeslist1.ToArray();
            while (true)
            {
                //获取员工ID
                string result = queryonjob(next_cursor);
                //Console.Write(result);
                JavaScriptSerializer js = new JavaScriptSerializer();
                GetUserId getUserId = js.Deserialize<GetUserId>(result);
                list.AddRange(getUserId.result.data_list);
                next_cursor = getUserId.result.next_cursor;
                if (next_cursor == 0)
                {
                    break;
                }
                else
                {
                    continue;
                }
            }
            //一条一条遍历
            foreach (object li in list)
            {
                string resut = Employeelist(Convert.ToString(li));
                JavaScriptSerializer js1 = new JavaScriptSerializer();
                EmployeeList employeelist = js1.Deserialize<EmployeeList>(resut);
                try
                {
                    if ((employeelist.result[0].field_list[2].label.ToString()).StartsWith("ADW"))
                    {

                        //string[] s = employeelist.result[0].field_list[2].label.ToString().Split(' ');
                        //Console.WriteLine(s[1]);

                        list1.Add(employeelist.result[0].field_list[2].label.ToString());

                        string gonghao = employeelist.result[0].field_list[2].label.ToString();
                        var t_pALM_Employeeslist = from t in db.t_PALM_Employees
                                                   where t.fEmpNo == gonghao
                                                   select t;
                        t_PALM_Employees b = t_pALM_Employeeslist.FirstOrDefault();
                        if (b == null)
                        {
                            t_PALM_Employees c = new t_PALM_Employees();
                            c.fEmpNo = employeelist.result[0].field_list[2].label.ToString();    //工号
                            c.fEmpName = employeelist.result[0].field_list[0].label.ToString();   //姓名
                            c.fPhone = employeelist.result[0].field_list[1].label.ToString();    //手机号
                            c.fSex = "1";
                            c.fDeptID = 323;
                            c.fID = "111111111111111111";
                            c.fIfMarried = "0";
                            c.fLogInDate = Convert.ToDateTime(DateTime.Now.ToString());
                            c.fProbation = 30;
                            c.fIfNeedCont = "0";
                            c.fWorkMode = "2";
                            c.fIfCardFree = "0";
                            c.fIfFullAttBonus = "0";
                            c.fIfRecordHR = "1";
                            c.fIfRecordOTCost = "1";
                            c.fCFlag = "2";
                            c.fIfResign = "0";
                            c.fIfUse = "1";
                            c.fAssignRate = 1;
                            c.fIfPFM = "0";
                            c.fIfSupper = "0";
                            c.fAttendanceType = "1";
                            c.fLinkNo = "";
                            //db.t_PALM_Employees.Add(c);
                            //db.SaveChanges();
                           // Console.WriteLine("插入成功");
                            //count += 1;
                        }
                        else
                        {
                            string [] str = employeelist.result[0].field_list[1].label.ToString().Split('-');
                            b.fPhone = str[1];
                            b.fCFlag = "1";
                            //db.Entry<t_PALM_Employees>(b).State = System.Data.EntityState.Modified;
                            //db.SaveChanges();
                            //Console.WriteLine("更新成功");
                            //count += 1;
                        }
                    }
                    else
                    {
                        //Console.WriteLine();
                        continue;
                    }
                    
                }
                catch
                {
                    continue;
                }
            }

            foreach (object i in t_pALM_Employeeslist1)
            {
                if (list1.Contains(i))
                {
                    continue;
                }
                else
                {
                    string o = i.ToString();
                    var t_pALM_Employeeslist = from t in db.t_PALM_Employees
                                               where t.fEmpNo == o
                                               select t;
                    //t_pALM_Employeeslist = "2";
                    t_PALM_Employees d = t_pALM_Employeeslist.FirstOrDefault();
                    d.fIfUse="0";
                    d.fCFlag = "2";
                    db.Entry<t_PALM_Employees>(d).State = System.Data.EntityState.Modified;
                    
                    Console.WriteLine(i);
                    count += 1;
                }
            }
            db.SaveChanges();
            Console.WriteLine(count);
            Console.Read();
          


        }
        /// <summary>
        /// 获取单个员工的信息
        /// </summary>
        /// <returns></returns>
        public static string GetUser(string userid)
        {

            string access_token = fileStr();
            
            string personUrl = "https://oapi.dingtalk.com/user/get?access_token={0}&userid={1}";
            //string userid = "274805565923472895";
            personUrl = string.Format(personUrl, access_token, userid);
            var result1 = GetAccessToken(personUrl);
            return result1;
        }
        /// <summary>
        /// 获取token
        /// </summary>
        public static string GainToken()
        {
            //Directory.CreateDirectory(@"D:\Token");
            string requestUrl = "https://oapi.dingtalk.com/gettoken?appkey={0}&appsecret={1}";

            string appkey = "dingke8bw3rjb";
            string appsecret = "gd1MGMSDwwkKE7qOky0fpFdS-9u9WY3dg3O2_pB6v1fdxlDiMNtbagi91N_gtCs5";

            requestUrl = string.Format(requestUrl, appkey, appsecret);
            var result = GetAccessToken(requestUrl);
            JavaScriptSerializer js = new JavaScriptSerializer();
            Token token = js.Deserialize<Token>(result);
            string access_token = token.access_token;
            return access_token;
        }
        /// <summary>
        /// 查询员工的userid
        /// </summary>
        public static string queryonjob(int offset)
        {
            string token = fileStr();
            string requestUrl = "https://oapi.dingtalk.com/topapi/smartwork/hrm/employee/queryonjob?access_token={0}";
            requestUrl = string.Format(requestUrl, token);
            string postData = "status_list=3&offset={0}&size=20";
            postData = string.Format(postData, offset);
            string result = PostAccessToken(requestUrl, postData);
            return result;
        }
        /// <summary>
        /// 获取源文件
        /// </summary>
        /// <param name="_Url">链接地址</param>
        /// <param name="_Charset">编码</param>
        /// <returns></returns>
        public static string GetAccessToken(string _Url, string _Charset = "UTF-8")
        {
            string strRet = string.Empty;
            // 网页客户端，用于打开链接，获取返回参数
            WebClient wc = new WebClient();
            try
            {
                byte[] responseData = null;
                wc.Headers.Add("Content-Type", "application/x-www-form-urlencoded");
                responseData = wc.DownloadData(_Url);
                strRet = Encoding.GetEncoding(_Charset).GetString(responseData);
                strRet = strRet.Trim();
            }
            catch (Exception ex)
            {
                strRet = "错误:" + ex.Message;
            }
            finally
            {
                wc.Dispose();
                wc = null;
            }
            return strRet;
        }
        /// <summary>
        ////// </summary>
        /// <param name="_Url"></param>
        /// <param name="postData"></param>
        /// <returns></returns>
        public static string PostAccessToken(string _Url, string postData)
        {
            // 网页客户端，用于打开链接，获取返回参数
            WebClient wc = new WebClient();
            byte[] bytes = Encoding.UTF8.GetBytes(postData);
            WebClient client = new WebClient();
            client.Headers.Add("Content-Type", "application/x-www-form-urlencoded");
            client.Headers.Add("ContentLength", postData.Length.ToString());
            Encoding enc = Encoding.GetEncoding("UTF-8");
            byte[] responseData = client.UploadData(_Url, "POST", bytes);
            string re = enc.GetString(responseData);
            return re;
        }
        /// <summary>
        /// 判断token的值是否过期
        /// </summary>
        /// <returns></returns>
        public static string fileStr() 
        {
            if (File.Exists(@"d:\Token.txt"))
            {
                string token = File.ReadAllText(@"d:\Token.txt");
                string [] date = token.Split(',');
                if(DateTime.Compare(Convert.ToDateTime(DateTime.Now.ToString()),Convert.ToDateTime(date[1]))<0)
                {
                    return date[0];
                }
                else
                {
                    string inputToken = "";
                    string token1 = GainToken();
                    inputToken = token1 + "," + DateTime.Now.AddMinutes(118).ToString();
                    FileStream stream = new FileStream(@"d:\Token.txt", FileMode.Create);//fileMode指定是读取还是写入
                    StreamWriter writer = new StreamWriter(stream);//创建一个写入流
                    writer.WriteLine(inputToken);//写入一行，写完后会自动换行
                    writer.Close();//释放内存
                    stream.Close();//释放内存
                    string Token1 = File.ReadAllText(@"d:\Token.txt");
                    string[] token2 = Token1.Split(',');
                    return token2[0];
                }
            }
            else
            {
                string inputToken = "";
                string token= GainToken();
                inputToken = token + "," + DateTime.Now.AddMinutes(118).ToString();
                FileStream stream = new FileStream(@"d:\Token.txt", FileMode.Create);//fileMode指定是读取还是写入
                StreamWriter writer = new StreamWriter(stream);//创建一个写入流
                writer.WriteLine(inputToken);//写入一行，写完后会自动换行
                writer.Close();//释放内存
                stream.Close();//释放内存
                string Token = File.ReadAllText(@"d:\Token.txt");
                string[] token1 = Token.Split(',');
                return token1[0];
            }
        }
        /// <summary>
        /// 获取员工的详细信息
        /// </summary>
        /// <param name="userid"></param>
        /// <returns></returns>
        public static string Employeelist(string userid)
        {
            string token = fileStr();
            string requestUrl = "https://oapi.dingtalk.com/topapi/smartwork/hrm/employee/list?access_token={0}";
            requestUrl = string.Format(requestUrl, token);
            string postData = "userid_list={0}&field_filter_list={1}";
                                                    //手机号    部门                            姓名         身份证号码      出生日期
            postData = string.Format(postData, userid, "sys00-mobile,sys00-jobNumber,sys00-name,sys02-certNo");
            string result = PostAccessToken(requestUrl, postData);
            return result;
        }
    }
}

 

转载于:https://www.cnblogs.com/wangjinya/p/10915269.html