private static void NewMethod2()
{
List <StatsisLib.UserInfo> infos = new List <StatsisLib.UserInfo>();
string path = @"E:\Projects\tt\11.txt";
string t = File.ReadAllText(path);
foreach (var item in t.Split('\n'))
{
string[] aa = item.Replace("\r", "").Split('|');
if (aa.Length == 2)
{
string num = aa[1];
if (string.IsNullOrWhiteSpace(num))
{
continue;
}
infos.Add(new StatsisLib.UserInfo()
{
Num = num, GroupName = aa[0]
});
}
}
DataService.QHXEntities DBContext = new DataService.QHXEntities();
foreach (var item in infos)
{
var s = DBContext.UserInfo.FirstOrDefault(x => x.Id.ToString() == item.Num);
if (s == null)
{
Console.WriteLine("缺少：{0}", item.Num);
}
else if (s.GroupName != item.GroupName)
{
Console.WriteLine("对不上：{0},{1}=>{2}", item.Num, s.GroupName, item.GroupName);
}
}
foreach (var item in DBContext.UserInfo.ToList())
{
var s = infos.FirstOrDefault(x => x.Num == item.Id.ToString());
if (s == null)
{
Console.WriteLine("多余：{0}", item.Id, item.GroupName);
}
//else if(s.GroupName!=item.GroupName)
//{
// Console.WriteLine("对不上：{0}", item.Num);
//}
}
}
private static void UpdateUser()
{
var dataInfos = StatsisLib.Common.DTToList <DateInfo>(NPOIHelper.ImportExceltoDt(@"E:\Projects\tt\2月\date.xls"));
DataService.QHXEntities DBContext = new DataService.QHXEntities();
foreach (var uItem in dataInfos)
{
var s = DBContext.UserInfo.FirstOrDefault(x => x.Id.ToString() == uItem.工号);
if (s != null)
{
Console.WriteLine("{0},{1}=>{2}", uItem.姓名, s.InTime, uItem.岗时间);
s.InTime = uItem.岗时间;
}
else
{
Console.WriteLine("{0},xx", uItem.姓名);
}
}
DBContext.SaveChanges();
}
private static void NewMethod1()
{
DataService.QHXEntities DBContext = new DataService.QHXEntities();
var NDirectory = StatsisLib.NestDirectory.Deserialize("C:\\g1.xml");
foreach (var item in NDirectory.Children)
{
DBContext.StatsicInfo.Add(new StatsicInfo()
{
IsDel = 0, StatsicName = item.Name
});
foreach (var subItem in item.Children)
{
DBContext.StatsicRelation.Add(new StatsicRelation()
{
GroupName = subItem.Name, StatsicName = item.Name
});
}
}
DBContext.SaveChanges();
}
private static void NewMethod4()
{
string data = File.ReadAllText(@"E:\Projects\tt\22.txt", Encoding.Default);
string gName = "";
List <StatsisLib.UserInfo> infos = new List <StatsisLib.UserInfo>();
data.Replace("\r", "").Split('\n').ToList().ForEach(x =>
{
string[] paramss = x.Split('|');
if (paramss.Length == 4)
{
if (!string.IsNullOrWhiteSpace(paramss[0]))
{
gName = paramss[0];
}
if (!string.IsNullOrWhiteSpace(paramss[1]))
{
infos.Add(new StatsisLib.UserInfo()
{
GroupName = gName,
InTime = paramss[3],
Name = paramss[1],
Num = paramss[2],
Remark = "1.4"
});
}
}
});
int index = 0;
DataService.QHXEntities DBContext = new DataService.QHXEntities();
foreach (var item in infos)
{
var s = DBContext.UserInfo.FirstOrDefault(x => x.Id.ToString() == item.Num);
if (s == null)
{
Console.WriteLine("缺少：{0}", item.Num);
index = DBContext.UserInfo.Count(y => y.GroupName == item.GroupName) + 1;
s = new DataService.UserInfo()
{
Id = int.Parse(item.Num),
GroupName = item.GroupName,
Name = item.Name,
OrderIndex = index,
InTime = item.InTime,
IsShield = 0,
Remark = item.Remark,
IsDel = 0
};
DBContext.UserInfo.Add(s);
}
else if (s.GroupName != item.GroupName)
{
Console.WriteLine("对不上：{0},{1}=>{2}", item.Num, s.GroupName, item.GroupName);
s.GroupName = item.GroupName;
}
s.InTime = item.InTime;
}
DBContext.SaveChanges();
}