internal static BDCFilterResult ImportQSPic(string base64Str, string sLBH, string userName) { BDCFilterResult res = new BDCFilterResult(); int count = 0; FC_REWRITE_TAG tag = new FC_REWRITE_TAG(); //string slbh = row[0].ToString(); try { if (CanImportPic(sLBH)) { ImportQS(base64Str, sLBH, userName); tag.FILECOUNT = count.ToString(); //tag.FILENAME =doc_bin[0].BINID tag.ID = Guid.NewGuid().ToString(); tag.SLBH = sLBH; tag.PUSHDATE = DateTime.Now; tag.ISSUCCESS = "1"; tag.MESSAGE = "成功"; res.ConfirmType = 0; res.IsSuccess = true;; res.Message = tag.MESSAGE; } else { res.ConfirmType = 0; res.IsSuccess = false; res.Message = "无完税信息!"; } } catch (Exception ex) { res.ConfirmType = 0; res.IsSuccess = false; res.Message = ex.Message; tag.FILECOUNT = count.ToString(); //tag.FILENAME =doc_bin[0].BINID tag.ID = Guid.NewGuid().ToString(); tag.SLBH = sLBH; tag.PUSHDATE = DateTime.Now; tag.ISSUCCESS = "0"; tag.MESSAGE = "失败!" + ex.Message; } finally { if (null != tag && null != tag.ID) { ImportDAL.InsertLog(tag); } } //IsSuccess = true; return(res); }
internal static void InsertLog(FC_REWRITE_TAG tag) { string sql = "insert into FC_ReWrite_Tag (ID,SLBH,PUSHDATE,FILECOUNT,FILENAME,ISSUCCESS,MESSAGE) values(:ID,:SLBH,:PUSHDATE,:FILECOUNT,:FILENAME,:ISSUCCESS,:MESSAGE)"; List <DbParameter> list = new List <DbParameter>(); ListAdd(list, ":ID", tag.ID); ListAdd(list, ":SLBH", tag.SLBH); ListAdd(list, ":PUSHDATE", tag.PUSHDATE); ListAdd(list, ":FILECOUNT", tag.FILECOUNT); ListAdd(list, ":FILENAME", tag.FILENAME); ListAdd(list, ":ISSUCCESS", tag.ISSUCCESS); ListAdd(list, ":MESSAGE", tag.MESSAGE); DbHelper.SetProvider(MyDBType.Oracle); DbHelper.ExecuteNonQuery(MyDBType.Oracle, System.Data.CommandType.Text, sql, list.ToArray()); }
public static BDCFilterResult ImportFromFC(string slbh) { int fileCount = 0; bool IsSuccess = false; BDCFilterResult res = new BDCFilterResult(); FC_REWRITE_TAG tag = new FC_REWRITE_TAG(); string FCslbh = GetRealSLBH(slbh); //string slbh = row[0].ToString(); if (CanImport(FCslbh)) { try { List <DOC_BINFILE> doc_bin = GetDoc_Binfile(slbh, FCslbh); if (UseFtp.Equals("是") || UseFtp.ToLower().Equals("true")) { if (null != doc_bin && doc_bin.Count > 0) { fileCount = doc_bin.Count; //using (TransactionScope ts = new TransactionScope()) //{ foreach (DOC_BINFILE item in doc_bin) { try { tag.FILENAME += tag.FILENAME != null ? item.FILENAME : ("," + item.FILENAME); UploadToFtp(FCslbh, item); //item.FTPATH = ChangeFTPPath(item.FTPATH); if (ImportDAL.ExistDoc_binfile(item)) { ImportDAL.UpDateDoc_binfile(item); } else { ImportDAL.InsertDoc_binfile(item); } } catch { continue; } } //ts.Complete(); //} tag.FILECOUNT = fileCount.ToString(); //tag.FILENAME =doc_bin[0].BINID tag.ID = Guid.NewGuid().ToString(); tag.SLBH = slbh; tag.PUSHDATE = DateTime.Now; tag.ISSUCCESS = "1"; tag.MESSAGE = "成功"; IsSuccess = true; ImportDAL.InsertLog(tag); } else { tag.FILECOUNT = fileCount.ToString(); //tag.FILENAME =doc_bin[0].BINID tag.ID = Guid.NewGuid().ToString(); tag.SLBH = slbh; tag.PUSHDATE = DateTime.Now; tag.ISSUCCESS = "0"; tag.MESSAGE = "失败!不动产库中无此受理编号记录。"; //IsSuccess = true; ImportDAL.InsertLog(tag); } } } catch (Exception ex) { tag.FILECOUNT = fileCount.ToString(); //tag.FILENAME =doc_bin[0].BINID tag.ID = Guid.NewGuid().ToString(); tag.SLBH = slbh; tag.PUSHDATE = DateTime.Now; tag.ISSUCCESS = "0"; tag.MESSAGE = "失败!" + ex.Message; ImportDAL.InsertLog(tag); } res.ConfirmType = 0; res.IsSuccess = IsSuccess; res.Message = tag.MESSAGE; } else { res.ConfirmType = 0; res.IsSuccess = false; res.Message = "失败!图像尚未扫描入库!"; } return(res); }