public void Execute(IJobExecutionContext context)
{
Console.WriteLine(" ************ 开始执行南航项目：访客撤控 ： " + DateTime.Now);
var db = new EFContext();
var dateTime = DateTime.Now;
var ApplyList = db.Set <VisitorApply>().Where(p => dateTime > p.VisitEndTime && p.SurveyStatus == "0" && p.DhId != null).ToList();
foreach (var apply in ApplyList)
{
// 闸机Id列表
var zjids = db.Set <Relevance>().Where(p => p.SecondKey == apply.BuildingId && p.Name == Relation.GateBuilding).Select(p => p.FirstKey).ToList();
var channelIds = db.Set <Gate>().Where(t => zjids.Contains(t.Id)).Select(p => p.DeviceNumber + "$7$0$0").ToArray();
var ResultStr = DHAccount.CancelSurvey(channelIds, apply.DhId);
var jo = ResultStr.Parse2JObject();
if (jo.Value <bool>("success"))
{
apply.SurveyStatus = "1";
Console.WriteLine("撤控成功：" + ResultStr + " DhId = " + apply.DhId);
}
else
{
Console.WriteLine("撤控失败：" + ResultStr + " DhId = " + apply.DhId);
}
if (apply.VisitType == "1")
{
Console.WriteLine("校外访客删除：" + DHAccount.PUSH_DH_DELETE_PERSON(new string[] { apply.DhId }));
}
}
db.SaveChanges();
db.Dispose();
}
public static void process()
{
Console.WriteLine("------------批量同步11栋和12栋学生数据，到12栋1楼101室");
//批量同步11栋和12栋学生数据，到12栋1楼101室
var model = new NHModel();
var stuList = model.StudentInfoes.Where(p => p.studentBuildingId.Contains("12栋") || p.studentBuildingId.Contains("11栋")).Select(p => new PersonMoudle
{
orgId = "org001",
code = p.studentNo,
idCode = p.certificateNo,
name = p.studentName,
roleId = "student001", //teacher001
sex = 1,
colleageCode = "55f67dcc42a5426fb0670d58dda22a5b", //默认分院
dormitoryCode = "fe8a5225be5f43478d0dd0c85da5dd1d", //楼栋 例如： 11栋
dormitoryFloor = "8e447843bc8c4e92b9ffdf777047d20d", //楼层 例如：3楼
dormitoryRoom = "20c70f65b54b4f96851e26343678c4ec", //宿舍号 例如：312
photoUrl = p.ImgUri
}).ToList();
foreach (var person in stuList)
{
try
{
Console.WriteLine(person.name);
var d = DHAccount.PUSH_DH_ADD_PERSON(person);
Console.WriteLine(d.ToString());
}catch (Exception e)
{
Console.WriteLine(e);
}
}
Console.WriteLine("-------------已退出");
}
public object FindPerson(string idCode)
{
//查询人员信息 大华
var personMoudleTest = new PersonMoudle();
personMoudleTest.idCode = idCode;
personMoudleTest.roleId = "temp";
personMoudleTest.code = null;
return(DHAccount.SELECT_DH_PERSON(personMoudleTest));
}
public string TempSurvey(string PicUrl, string idCode, string name)
{
string[] str = { "1000004$7$0$0", "1000009$7$0$0", "1000013$7$0$0", "1000002$7$0$0", "1000010$7$0$0", "1000000$7$0$0", "1000012$7$0$0", "1000008$7$0$0", "1000011$7$0$0", "1000003$7$0$0" };
var survey = new SurveyMoudle();
survey.channelId = str;
survey.code = "";
survey.name = name;
survey.sex = 1;
survey.idCode = idCode;
survey.photoBase64 = GetImageBase64Str.ImageBase64Str(PicUrl);;
survey.initialTime = "2019-05-30 00:00:00";
survey.expireTime = "2019-05-30 23:59:59";
return(DHAccount.TempSurvey(survey));
}
public object F_DH_TEST(string name, string pname, int level)
{
//推送人员信息至大华
var personMoudle = new PersonMoudle();
personMoudle.id = 0;
personMoudle.orgId = "org001";
personMoudle.code = "888888";
personMoudle.idCode = "360421199311144020";
personMoudle.name = "Refuse12";
personMoudle.roleId = "student001"; //teacher001
personMoudle.sex = 1;
personMoudle.dormitoryName = "1栋"; //默认分院
personMoudle.dormitoryFloorName = "1栋1层"; //楼层 例如：3层
personMoudle.dormitoryRoomName = "1栋104"; //宿舍号 例如：312
personMoudle.photoUrl = "http://localhost:8080/file/5.jpg";
return(DHAccount.PUSH_DH_ADD_PERSON(personMoudle));
}
public string OpenDoor(int type, string channelId)
{
return(DHAccount.OpenDoor(type, channelId));
}
public string CancelSurvey(string personId)
{
string[] str = { "1000004$7$0$0", "1000009$7$0$0", "1000013$7$0$0", "1000002$7$0$0", "1000010$7$0$0", "1000000$7$0$0", "1000012$7$0$0", "1000008$7$0$0", "1000011$7$0$0", "1000003$7$0$0" };
return(DHAccount.CancelSurvey(str, personId));
}
public object DeletePerson()
{
return(DHAccount.PUSH_DH_DELETE_PERSON(new string[] { "133475" }));
}