private TranslateResult CreateDefaultTranslate(string input)
{
TranslateResult result = new TranslateResult();
result.IsValid = 0;
result.BusinessCode = "EOthers";
result.FileCode = "EOthers";
result.Translate = input;
result.InsititutionCode = "EOthers";
return(result);
}
private TranslateResult CreateTranslateByDataRow(DataRow dr)
{
TranslateResult result = new TranslateResult();
result.IsValid = Convert.ToInt32(dr["isvalid"]);
result.BusinessCode = dr["businessCode"].ToString();
result.FileCode = dr["typecode"].ToString();
result.Translate = dr["translate"].ToString();
result.InsititutionCode = dr["InsititutionCode"].ToString();
return(result);
}
private TranslateResult Translate(string input)
{
string sql = "select translate,isvalid ,businessCode,typecode,InsititutionCode from EMAILKEYWORDS where input=:input";
OracleParameter[] paras =
{
new OracleParameter(":input", input)
};
DataTable tb = DBHelper.GetDataTableBySql(sql, paras);
TranslateResult result = null;
if (tb != null && tb.Rows.Count == 1)
{
result = CreateTranslateByDataRow(tb.Rows[0]);
}
else
{
result = CreateDefaultTranslate(input);
}
return(result);
}
public bool InsertReportToService(EmailInfo info, StringBuilder sb)
{
var md5 = ReportManager.MD5_Hash(info.CurrentAttrName);
//处理业务
if (FileExists(md5))
{
sb.Append(string.Format("Email: {0}, attachment name: {1} duplicated with {2}. synced successfully \n",
info.Ename, info.CurrentAttrName, md5));
return(true);
}
var fileDetail = new FileDetail();
fileDetail.InstitutionCode = GetInstitutionCode(info.Ename);
fileDetail.FileOrder = GetFileOrder();
fileDetail.Author = "";
fileDetail.Operator = "";
if (fileDetail.InstitutionCode == "EOthers")
{
sb.Append("[ email:" + info.Ename + " doesn't exist in EMAILKEYWORDS:] \n");
}
string filesize = string.Empty;
byte[] fileData = GetFileData(info.CurrentAttrName, sb, out filesize);
fileDetail.FileSize = filesize;
DateTime dt = DateTime.Parse(info.Etime);
dt = DateTime.SpecifyKind(dt, DateTimeKind.Utc);
dt = TimeZoneInfo.ConvertTime(dt, TimeZoneInfo.Local);
fileDetail.UploadTime = dt;
fileDetail.CreateTime = dt.ToString("yyyy-MM-dd HH:mm:ss");
string ext = Path.GetExtension(info.CurrentAttrName).Substring(1);
fileDetail.Ext = ext;
string attachName = GetFileName(info.CurrentAttrName);
string attachConfigName = string.Empty;
//match attachName
if (Exists(attachName, fileDetail.InstitutionCode, out attachConfigName))
{
TranslateResult tranalate = Translate(attachConfigName);
if (tranalate.BusinessCode == "EOthers" && tranalate.FileCode == "EOthers")
{
return(false);
}
else
{
if (IsChineseOrEnglish(attachConfigName))
{
fileDetail.FileNameCN = attachConfigName;
fileDetail.FileNameEN = tranalate.Translate;
}
else
{
fileDetail.FileNameEN = attachConfigName;
fileDetail.FileNameCN = tranalate.Translate;
}
}
//if email is not exists ,but input is exists ,use input to find institutioncode, most for @ccb.com. yy 20141223
if (fileDetail.InstitutionCode.Equals("EOthers") &&
!fileDetail.InstitutionCode.Equals(tranalate.InsititutionCode))
{
fileDetail.InstitutionCode = tranalate.InsititutionCode;
}
fileDetail.IsValid = tranalate.IsValid;
fileDetail.BusinessCode = tranalate.BusinessCode;
fileDetail.FileCode = tranalate.FileCode;
}
else
{
return(false);
}
var result = SaveResearchReport(fileDetail, fileData, md5);
if (result)
{
sb.Append(string.Format("Email: {0}, attachment name: {1}, fileId: {2} has synced successfully \n", info.Ename, attachName, fileDetail.FileId));
}
return(result);
}