C# 发EDM

最近公司需要写了一个EDM,基本功能可以，暂时还没有优化。压缩的还没测试。

#region 发EDM        #region 创建CSV文件        public static void CreateCSV(DataTable dt, string fileName)        {            FileStream fs = new FileStream(fileName, System.IO.FileMode.Create, System.IO.FileAccess.Write);            StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.Default);            string data = "";            //写出列名称            for (int i = 0; i < dt.Columns.Count; i++)            {                data += dt.Columns[i].ColumnName.ToString();                if (i < dt.Columns.Count - 1)                    data += ",";            }            sw.WriteLine(data);            //写出各行数据            for (int i = 0; i < dt.Rows.Count; i++)            {                data = "";                for (int j = 0; j < dt.Columns.Count; j++)                {                    data += dt.Rows[i][j].ToString();                    if (j < dt.Columns.Count - 1)                        data += ",";                }                sw.WriteLine(data);            }            sw.Close();            fs.Close();            fs.Dispose();        }        #endregion        #region 压缩CSV文件        /// <summary>          /// 压缩单个文件          /// </summary>          /// <param name="fileToZip">要压缩的文件</param>          /// <param name="zipedFile">压缩后的文件全名</param>          /// <param name="compressionLevel">压缩程度，范围0-9，数值越大，压缩程序越高</param>          /// <param name="blockSize">分块大小</param>          public static void ZipFile(string fileToZip, string zipedFile, int compressionLevel, int blockSize)        {            FileStream streamToZip = new FileStream(fileToZip, FileMode.Open, FileAccess.Read);            FileStream zipFile = File.Create(zipedFile);            ZipOutputStream zipStream = new ZipOutputStream(zipFile);            ZipEntry zipEntry = new ZipEntry(fileToZip);            zipStream.PutNextEntry(zipEntry);            zipStream.SetLevel(compressionLevel);            byte[] buffer = new byte[blockSize];            int size = streamToZip.Read(buffer, 0, buffer.Length);            zipStream.Write(buffer, 0, size);            try            {                while (size < streamToZip.Length)                {                    int sizeRead = streamToZip.Read(buffer, 0, buffer.Length);                    zipStream.Write(buffer, 0, sizeRead);                    size += sizeRead;                }            }            catch (Exception ex)            {                GC.Collect();                throw ex;            }            zipStream.Finish();            zipStream.Close();            streamToZip.Close();            GC.Collect();        }        #endregion        #region 发送csv文件        public static string UpLoadFile(string filePath)        {            string url = "接口url";            string fileName = Path.GetFileName(filePath);            string responseContent;            var memStream = new MemoryStream();            // 边界符            var boundary = "---------------" + DateTime.Now.Ticks.ToString("x");            // 开始边界符            var beginBoundary = Encoding.ASCII.GetBytes("--" + boundary + "\r\n");            // 最后的结束符            var endBoundary = Encoding.ASCII.GetBytes("--" + boundary + "--\r\n");            //文件流            var fileStream = new FileStream(filePath, FileMode.Open, FileAccess.Read);            // WebRequest设置属性            var webRequest = (HttpWebRequest)WebRequest.Create(url);            webRequest.Method = "POST";            webRequest.ContentType = "multipart/form-data; boundary=" + boundary;            //写入开始符                       memStream.Write(beginBoundary, 0, beginBoundary.Length);            // 写入文件标题            const string filePartHeader =                "Content-Disposition: form-data; name=\"{0}\"; filename=\"{1}\"\r\n" +                "Content-Type: application/vnd.ms-excel\r\n\r\n";            var header = string.Format(filePartHeader, "customerFile", fileName);            var headerbytes = Encoding.UTF8.GetBytes(header);            memStream.Write(headerbytes, 0, headerbytes.Length);            //写入文件流            var buffer = new byte[1024];            int bytesRead; // =0            while ((bytesRead = fileStream.Read(buffer, 0, buffer.Length)) != 0)            {                memStream.Write(buffer, 0, bytesRead);            }            // 写入最后的结束边界符                             memStream.Write(endBoundary, 0, endBoundary.Length);            webRequest.ContentLength = memStream.Length;            var requestStream = webRequest.GetRequestStream();            memStream.Position = 0;            var tempBuffer = new byte[memStream.Length];            memStream.Read(tempBuffer, 0, tempBuffer.Length);            memStream.Close();            requestStream.Write(tempBuffer, 0, tempBuffer.Length);            requestStream.Close();            var httpWebResponse = (HttpWebResponse)webRequest.GetResponse();            using (var httpStreamReader = new StreamReader(httpWebResponse.GetResponseStream(), Encoding.GetEncoding("utf-8")))            {                responseContent = httpStreamReader.ReadToEnd();            }            fileStream.Close();            httpWebResponse.Close();            webRequest.Abort();            JObject jo = JObject.Parse(responseContent);            string[] values = jo.Properties().Select(item => item.Value.ToString()).ToArray();            return values[0];        }        #endregion        #region csv文件转服务器数据库        public static string csvToDataBase(string csvPath)        {            string postDataStr = GetpostDataStr(csvPath);            string url = "接口url";            string jobid = GetRadicaData(url, postDataStr);            return jobid;        }        public static string GetpostDataStr(string csvPathpar)        {            DataTable dtmapping = new DataTable();            dtmapping.Columns.Add("column", typeof(string));            dtmapping.Columns.Add("propId", typeof(string));            DataRow dr;            dr = dtmapping.NewRow();            dr["column"] = 0;            dr["propId"] = "客户提供";            dtmapping.Rows.Add(dr);            dr = dtmapping.NewRow();            dr["column"] = 1;            dr["propId"] = "客户提供ID";            dtmapping.Rows.Add(dr);            dr = dtmapping.NewRow();            dr["column"] = 2;            dr["propId"] = "客户提供ID";            dtmapping.Rows.Add(dr);            dr = dtmapping.NewRow();            dr["column"] = 3;            dr["propId"] = "57a29bb147b8842f2cea6920";            dtmapping.Rows.Add(dr);            dr = dtmapping.NewRow();            dr["column"] = 4;            dr["propId"] = "客户提供ID";            dtmapping.Rows.Add(dr);            string[] arrtagids = new string[] { };            string[] arrtagnames = new string[] { "test123456" };            CSVObjecrt csvobject = new CSVObjecrt            {                path = csvPathpar,                operation = "replace",                tagids = arrtagids,                tagNames = arrtagnames,                fieldMapping = dtmapping            };            var json = JsonConvert.SerializeObject(csvobject);            return json.ToString();        }        #endregion              #region 调用接口返回json字符串        public static string GetData(string url, string postData)        {            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);            request.Method = "POST";            request.ContentType = "application/json";            //request.ContentLength = Encoding.UTF8.GetByteCount(postDataStr);            Stream myRequestStream = request.GetRequestStream();            StreamWriter myStreamWriter = new StreamWriter(myRequestStream, Encoding.GetEncoding("utf-8"));            myStreamWriter.Write(postData);            myStreamWriter.Close();            HttpWebResponse response = (HttpWebResponse)request.GetResponse();            Stream myResponseStream = response.GetResponseStream();            StreamReader myStreamReader = new StreamReader(myResponseStream, Encoding.GetEncoding("utf-8"));            string retString = myStreamReader.ReadToEnd();            myStreamReader.Close();            myResponseStream.Close();            JObject jo = JObject.Parse(retString);            string[] values = jo.Properties().Select(item => item.Value.ToString()).ToArray();            return values[0];        }        #endregion        #region 发短信        /// <summary>        /// 调用短信接口        /// </summary>        public static void sendSMSTask(DataTable dtcampaign)        {            int result = sendSMSt("手机号", "短信内容", "ID", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));          }        /// <summary>        /// 发送短信        /// </summary>        /// <param name="mobile">收短信人手机</param>        /// <param name="content">短信内容</param>        /// <param name="misc"></param>        /// <param name="time"></param>        /// <returns></returns>        public static int sendSMSt(String mobile, String content, String misc, String time)        {            int iR = 1;            string url = "接口url";            string postStrTpl = "username={0}&password={1}&content={2}&mobile={3}&batchID={4}&senddate={5}";            string username = "用户名";            string pwd = "密码";            UTF8Encoding encoding = new UTF8Encoding();            //统一任务下的ID一样            byte[] postData = encoding.GetBytes(string.Format(postStrTpl, username, pwd, content, mobile, misc, time));            HttpWebRequest myRequest = (HttpWebRequest)WebRequest.Create(url);            myRequest.Method = "POST";            myRequest.ContentType = "application/x-www-form-urlencoded";            myRequest.ContentLength = postData.Length;            Stream newStream = myRequest.GetRequestStream();            // Send the data.            newStream.Write(postData, 0, postData.Length);            newStream.Flush();            newStream.Close();            HttpWebResponse myResponse = (HttpWebResponse)myRequest.GetResponse();            if (myResponse.StatusCode == HttpStatusCode.OK)            {                StreamReader reader = new StreamReader(myResponse.GetResponseStream(), Encoding.UTF8);                string tmp = reader.ReadToEnd();                if (tmp == "0")                    iR = 0;            }            else            {                //访问失败            }            return iR;        }        #endregion        #endregion