public void BaoWen_Import()
{
BaoWens_BLL bll = new BaoWens_BLL();
YbUsers_BLL ubll = new YbUsers_BLL();
var shijiandir = FileHelper.GetShareLastDirectory(@"\\172.18.226.48\新城镇报", "20*", "administrator", "ybk");
string path = @"\\172.18.226.48\新城镇报\" + shijiandir.Name + @"\早上6点00前";
// var shijiandir = "201702";
//string path = @"\\172.18.226.48\新城镇报\" + shijiandir + @"\早上6点00前";
List <FileInfo> allFileList = FileHelper.GetShareFileInfos(path, "Z_SEVP_C_BEQD_*16812*", "administrator", "ybk");
//List<FileInfo> nearFileList = allFileList.Where(a => a.CreationTime >= DateTime.Now.AddDays(-7)).ToList();
List <FileInfo> nearFileList = allFileList;
int total = 0;
foreach (FileInfo fileInfo in nearFileList)
{
string fileName = path + @"\" + fileInfo.Name;
if (bll.GetCount(a => a.FileName == fileName) <= 0)
{
if (!fileInfo.Name.Contains("-16812_."))
{
Models.SQL.BaoWens baowen = new Models.SQL.BaoWens();
baowen.BWID = Guid.NewGuid();
baowen.BWType = "早间报文";
baowen.CreateTime = DateTime.Now;
baowen.YBDateTime =
DateTime.ParseExact(fileInfo.Name.Substring(14, 12), "yyyyMMddHHmm",
CultureInfo.InvariantCulture).AddHours(8);
//int leftcount = fileInfo.Name.Length - fileInfo.Name.IndexOf("-16812");
string fileNameUpper = fileInfo.Name.ToUpper();
if (fileNameUpper.Contains("-16812_") && !fileNameUpper.Contains("-16812_."))
{
baowen.YBUserName = fileNameUpper.Substring(fileNameUpper.IndexOf("-16812_") + 7,
fileNameUpper.Length - fileNameUpper.IndexOf("-16812_") - 7 - 4);
}
else
{
baowen.YBUserName = "******";
}
YbUsers user = ubll.Get(a => a.YBUserName == baowen.YBUserName && a.Work == "预报");
if (user == null)
{
int order = (int)ubll.GetList(a => a.Work == "预报").Max(a => a.Order) + 1;
YbUsers newuser = new YbUsers
{
YBUserID = Guid.NewGuid(),
YBUserName = baowen.YBUserName,
Work = "预报",
Position = "预报员",
CreateTime = DateTime.Now,
Order = order
};
baowen.YBUserID = newuser.YBUserID;
ubll.Add(newuser);
}
else
{
baowen.YBUserID = user.YBUserID;
}
baowen.Content =
FileHelper.GetShareTextContent(path + @"\" + fileInfo.Name, "administrator", "ybk", Encoding.Default);
baowen.FileName = path + @"\" + fileInfo.Name;
baowen.IsTranslate = false;
bll.Add(baowen);
total++;
}
}
}
Console.WriteLine(shijiandir.Name);
//Console.WriteLine(shijiandir);
Console.WriteLine("早间报文导入成功，总数：" + total);
}
