/// <summary>
/// 从房产库查询数据构建BDC插入实例
/// </summary>
/// <param name="slbh"></param>
/// <returns></returns>
private static List <DOC_BINFILE> GetDoc_Binfile(string slbh, string fcslbh)
{
List <VolEleArcDtl> veads = ImportDAL.GetVolEleArcDtl(fcslbh);
List <DOC_BINFILE> list = new List <DOC_BINFILE>();
//if(null!=Res_list && Res_list.Count>0)
//{
// foreach (Result res in Res_list)
// {
Thread.Sleep(200);
foreach (VolEleArcDtl v in veads)
{
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("\\", "/");
VolEleArc vea = GetVolEleArc(v.VolEleArc_ID);
DOC_BINFILE doc_binfile = new DOC_BINFILE();
doc_binfile.BINID = GetCID(slbh, vea.EleArcName);
if (doc_binfile.BINID != "")
{
doc_binfile.FTPATH = v.imgName;
doc_binfile.FILEID = Guid.NewGuid().ToString();
doc_binfile.FILENAME = vea.EleArcName;
doc_binfile.EXTNAME = GetExtName(v.imgName);
doc_binfile.ISCOMPRESSED = "否";
doc_binfile.ISENCRYPTED = "否";
list.Add(doc_binfile);
}
}
// }
//}
return(list);
}
public static int Insert_VolEleArc(VolEleArc volEleArc)
{
string sql = "insert into VolEleArc(EleArcVol_ID,ArchiveId,Ordinal,EleArcName,IsShow) values(@EleArcVol_ID,@ArchiveId,@Ordinal,@EleArcName,@IsShow)";
List <DbParameter> list = new List <DbParameter>();
ListAdd(list, "@EleArcVol_ID", volEleArc.EleArcVol_ID);
ListAdd(list, "@ArchiveId", volEleArc.ArchiveId);
ListAdd(list, "@Ordinal", volEleArc.Ordinal);
ListAdd(list, "@EleArcName", volEleArc.EleArcName);
ListAdd(list, "@IsShow", volEleArc.IsShow);
DbHelper.SetProvider(MyDBType.Sql);
return(DbHelper.ExecuteNonQuery(MyDBType.Sql, System.Data.CommandType.Text, sql, list.ToArray()));
}
private static List <VolEleArc> GetVolEleArc(ArchiveIndex archiveIndex, PageParams pageParams)
{
List <VolEleArc> list = new List <VolEleArc>();
List <WFM_ATTACHLST> wfm_ATTACHLST_list = GetWFM_ATTACHLST_list(pageParams);
foreach (WFM_ATTACHLST doc in wfm_ATTACHLST_list)
{
if (doc.CNAME == "流程附件")
{
continue;
}
VolEleArc volEleArc = new VolEleArc();
volEleArc.ArchiveId = archiveIndex.ArchiveId;
volEleArc.EleArcVol_ID = CreateGuid(32);
volEleArc.EleArcName = doc.CNAME;
list.Add(volEleArc);
}
return(list);
}
/// <summary>
/// 从房产库查询数据构建BDC插入实例
/// </summary>
/// <param name="slbh"></param>
/// <returns></returns>
private static List <DOC_BINFILE> GetDoc_Binfile(string slbh)
{
//string[] args = new string[1];
//args[0] = "China";
//object result= WebServiceHelper.InvokeWebService(WebSrvUrl, WebSrvMethon, args);
//List<Result> Res_list = (List<Result>)result;
List <VolEleArcDtl> veads = ImportDAL.GetVolEleArcDtl(slbh);
List <DOC_BINFILE> list = new List <DOC_BINFILE>();
//if(null!=Res_list && Res_list.Count>0)
//{
// foreach (Result res in Res_list)
// {
foreach (VolEleArcDtl v in veads)
{
v.imgName = v.imgName.Replace(@"\\192.168.100.202 \", "").Replace(@"K:\", "");
VolEleArc vea = GetVolEleArc(v.VolEleArc_ID);
DOC_BINFILE doc_binfile = new DOC_BINFILE();
doc_binfile.BINID = GetCID(slbh, vea.EleArcName);
if (doc_binfile.BINID != "")
{
doc_binfile.FTPATH = v.imgName;
doc_binfile.FILEID = Guid.NewGuid().ToString();
doc_binfile.FILENAME = vea.EleArcName;
doc_binfile.EXTNAME = "JPG";
doc_binfile.ISCOMPRESSED = "否";
doc_binfile.ISENCRYPTED = "否";
list.Add(doc_binfile);
}
}
// }
//}
return(list);
}
