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