public static void InsertPIC(string p) { DataTable dt = FCDA_DAL.GetVolEleArcDtlByVolEleArcID(p); int i = 1; string dir = "10000-450000/110000/100001/"; FTP souFTp = new FTP() { hostname = ConfigurationManager.AppSettings["FCFtpIP"], username = ConfigurationManager.AppSettings["FCFtpUser"], password = ConfigurationManager.AppSettings["FCFtpPWD"] }; List <string> list = FTPHelper.ListDirectory(dir, souFTp, ""); foreach (DataRow row in dt.Rows) { string s = row[0].ToString(); VolEleArcDtl v = new VolEleArcDtl(); v.VolEleArcDtl_id = Guid.NewGuid(); v.VolEleArc_ID = new Guid(s); v.imgName = dir + list[i - 1]; FCDA_DAL.Insert_VolEleArcDtl(v); i++; } }
private static int Insert_VolEleArcDtl(VolEleArcDtl volEleArcDtl, DbTransaction trans) { string sql = "insert into VolEleArcDtl(VolEleArcDtl_id,VolEleArc_ID,imgName,PageNo,ScanDate) " + "values(@VolEleArcDtl_id,@VolEleArc_ID,@imgName,@PageNo,@ScanDate)"; List <DbParameter> list = new List <DbParameter>(); ListAdd(list, "@VolEleArcDtl_id", volEleArcDtl.VolEleArcDtl_id); ListAdd(list, "@VolEleArc_ID", volEleArcDtl.VolEleArc_ID); ListAdd(list, "@imgName", volEleArcDtl.imgName); ListAdd(list, "@PageNo", volEleArcDtl.PageNo); ListAdd(list, "@ScanDate", volEleArcDtl.ScanDate); DbHelper.SetProvider(MyDBType.Sql); return(DbHelper.ExecuteNonQuery(MyDBType.Sql, trans, System.Data.CommandType.Text, sql, list.ToArray())); }
private static List <VolEleArcDtl> GetVolEleArcDtl(List <VolEleArc> volEleArc, PageParams pageParams) { List <VolEleArcDtl> list = new List <VolEleArcDtl>(); List <DOC_BINFILE> doc_bin_list = GetDoc_binfile_list(pageParams); for (int i = 0; i < doc_bin_list.Count; i++) { DOC_BINFILE doc = doc_bin_list[i]; VolEleArcDtl volEleArcDtl = new VolEleArcDtl(); volEleArcDtl.VolEleArc_ID = volEleArc[i].EleArcVol_ID; volEleArcDtl.VolEleArcDtl_id = CreateGuid(32); volEleArcDtl.imgName = doc.FTPATH; try { volEleArcDtl.PageNo = null == doc.PAGECOUNT ? 0 : Convert.ToInt32(doc.PAGECOUNT); } catch { } volEleArcDtl.ScanDate = DateTime.Now.ToString("YYYYMMdd"); list.Add(volEleArcDtl); } return(list); }
private static void ImportFCDA(string slbh, string FCslbh, string user, ref int count) { List <Result> list = new List <Result>(); List <VolEleArc> vol_list = ImportDAL.GetVolEleArc_list(FCslbh); string errStr = ""; foreach (VolEleArc vol in vol_list) { Result res = new Result(); string cid = GetCID(slbh, vol.EleArcName, "文件夹", user); List <VolEleArcDtl> dtlList = ImportDAL.GetVolEleArcDtlByVol(vol.EleArcVol_ID); if (null != dtlList && dtlList.Count > 0) { count = dtlList.Count; for (int i = 0; i < dtlList.Count; i++) { try { VolEleArcDtl v = dtlList[i]; v.imgName = v.imgName.Replace(@"\\192.168.134.245\", "").Replace(@"\\192.168.100.202\", "").Replace(@"K:\", "").Replace(@"\\192.168.100.202 \", ""); v.imgName = v.imgName.Replace("\\", "/"); DOC_BINFILE doc_binfile = new DOC_BINFILE(); string EleArcName = ""; if (i == 0) { EleArcName = vol.EleArcName; } if (i > 0) { EleArcName = vol.EleArcName + "-" + i; } string binid = GetCID(slbh, EleArcName, "文件", user, cid);//att.CID; doc_binfile.BINID = binid; doc_binfile.FTPATH = v.imgName; doc_binfile.FILEID = Guid.NewGuid().ToString(); doc_binfile.FILENAME = vol.EleArcName; doc_binfile.EXTNAME = GetExtName(v.imgName); doc_binfile.ISCOMPRESSED = "否"; doc_binfile.ISENCRYPTED = "否"; UploadToFtp(FCslbh, doc_binfile); if (ImportDAL.ExistDoc_binfile(doc_binfile)) { ImportDAL.UpDateDoc_binfile(doc_binfile); } else { ImportDAL.InsertDoc_binfile(doc_binfile); } } catch (Exception ex) { if (!errStr.Contains(ex.Message)) { errStr += ex.Message; } continue; } } } } if (!string.IsNullOrEmpty(errStr)) { throw new Exception(errStr); } }