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);
}
}
