/// <summary> /// 新增订阅信息 /// </summary> /// <param name="type"></param> /// <param name="status"></param> /// <param name="cusno"></param> /// <param name="declarationcode"></param> /// <param name="cusno"></param> /// <param name="userid"></param> /// <param name="username"></param> /// <param name="openid"></param> /// <param name="codetype"></param> /// <returns></returns> public static bool insertSubscribe(string type, string[] status, string cusno, string declarationcode, int userid, string username, string openid, string codetype, string ordercode) { try { string sql = @"insert into wechat_subscribe(id,cusno,declarationcode,userid,username,substime,substype,status,openid,statusvalue,codetype,ordercode) values(wechat_subscribe_id.nextval,'{0}','{1}','{2}','{3}',sysdate,'{4}','{5}','{6}','{7}','{8}','{9}')"; List <string> sqls = new List <string>(); for (int i = 0; i < status.Length; i++) { string statusvalue = SwitchHelper.switchValue(type, status[i]); sqls.Add(string.Format(sql, cusno, declarationcode, userid, username, type, status[i], openid, statusvalue, codetype, ordercode)); } using (DBSession db = new DBSession()) { return(db.ExecuteBatch(sqls) > 0 ? true : false); } } catch (Exception ex) { LogHelper.Write("SubscribeModel_insertSubscribe:" + ex.Message + "——code:" + cusno + declarationcode); return(false); } }
public static string SaveFile(string mediaIds, string ordercode) { string str = "false"; if (!string.IsNullOrEmpty(mediaIds)) { string url = string.Format("http://file.api.weixin.qq.com/cgi-bin/media/get?access_token={0}&media_id={1}", ModelWeChat.TokenModel.AccessToken, mediaIds); HttpWebRequest req = (HttpWebRequest)HttpWebRequest.Create(url); using (WebResponse wr = req.GetResponse()) { string dicPath = System.AppDomain.CurrentDomain.BaseDirectory; string filename = Guid.NewGuid() + ".jpg"; string filepath = @"uploadimage\" + filename; WebClient mywebclient = new WebClient(); mywebclient.DownloadFile(wr.ResponseUri, dicPath + filepath); if (File.Exists(dicPath + filepath))//ftp 到文件服务器,然后往数据库插入一笔记录 { FileInfo fi = new FileInfo(dicPath + filepath); System.Uri Uri = new Uri("ftp://" + ConfigurationManager.AppSettings["FTPServer"] + ":" + ConfigurationManager.AppSettings["FTPPortNO"]); string UserName = ConfigurationManager.AppSettings["FTPUserName"]; string Password = ConfigurationManager.AppSettings["FTPPassword"]; FtpHelper ftp = new FtpHelper(Uri, UserName, Password); string ftppath = "/67/" + ordercode + "/" + filename; bool bf = ftp.UploadFile(dicPath + filepath, ftppath, true);; if (bf) { using (DBSession db = new DBSession()) { List <string> sqls = new List <string>(); int uploaduserid = 763; string customercode = "KSJSBGYXGS"; string sql = @"insert into LIST_ATTACHMENT (id ,filename,originalname,filetype,uploadtime,uploaduserid,customercode,ordercode ,sizes,filetypename,filesuffix) values(List_Attachment_Id.Nextval,'{0}','{1}','{2}',sysdate,{3},'{4}','{5}' ,'{6}','{7}','{8}')"; sql = string.Format(sql , ftppath, filename, "67", uploaduserid, customercode, ordercode , fi.Length, "查验文件", ".jpg"); string sql2 = "update list_order set checkpic=1 where code='" + ordercode + "'"; sqls.Add(sql); sqls.Add(sql2); int i = db.ExecuteBatch(sqls); if (i > 0)//插入成功,后删除本地文件 { str = "success"; fi.Delete(); } else//插入失败后,远程删除文件,本地文件暂且留着 { ftp.DeleteFile(ftppath); } } }//ftp失败,本地文件暂且留着 } } } return(str); }