/// <summary>
///新增黑白名单
/// </summary>
/// <param name="requesPayCheck"></param>
/// <returns></returns>
public APIResultBase GetBackWhiteCarInfo(NanFangUnionModel carInfo)
{
APIResultBase <NanFangUnionModel> apiBaseResult = new APIResultBase <NanFangUnionModel>();
apiBaseResult.code = "0";
apiBaseResult.msg = "";
BlackWhiteListModel blackWhiteModel = new BlackWhiteListModel();
blackWhiteModel.PlateNumber = carInfo.PlatNumber;
blackWhiteModel.BlackWhiteType = 3;
blackWhiteModel.StartDate = carInfo.StartTime;
blackWhiteModel.EndDate = carInfo.EndTime;
if (carInfo.CheckoutFlag == "0")
{
blackWhiteModel.Reason = "在场";
}
else
{
blackWhiteModel.Reason = "离场";
}
blackWhiteModel.Remark = carInfo.RoomNo;
JielinkApi jieLinApi = new JielinkApi();
APIResultBase <BlackWhiteListModel> result = jieLinApi.AddBackWhiteList(blackWhiteModel);
if (result.code != "0")
{
apiBaseResult.code = "1";
apiBaseResult.msg = "失败！";
}
return(apiBaseResult);
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
string roomID = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString().Trim();
string carPlateNumber = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text.ToString().Trim();
string starTime = ((TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text.ToString().Trim();
string endTime = ((TextBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[0]).Text.ToString().Trim();
string remark = ((TextBox)GridView1.Rows[e.RowIndex].Cells[7].Controls[0]).Text.ToString().Trim();
//向JieLink+平台发送
BlackWhiteListModel blackWhiteCar = new BlackWhiteListModel();
blackWhiteCar.PlateNumber = carPlateNumber;
blackWhiteCar.BlackWhiteType = 3;
blackWhiteCar.StartDate = starTime;
blackWhiteCar.EndDate = endTime;
blackWhiteCar.Reason = "";
blackWhiteCar.Remark = remark;
JielinkApi jieLinApi = new JielinkApi();
APIResultBase <BlackWhiteListModel> result = jieLinApi.AddBackWhiteList(blackWhiteCar);
if (result.code == "0")
{
string strUpdate = "update tb_cars set RoomID='" + roomID + "',CarPlateNumber='" + carPlateNumber + "',StarTime='" + starTime + "',EndTime='" + endTime + "',Remark='" + remark + "' where ID=" + id;
//连接数据库，执行更新语句
MySqlConnection con = new MySqlConnection(connectionString);
MySqlCommand cmd = new MySqlCommand(strUpdate, con);
try
{
con.Open();
cmd.ExecuteNonQuery();
this.lbResult.Text = "更新记录成功！";
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
}
else
{
this.lbResult.Text = "更新失败！";
}
GridView1.EditIndex = -1;
Bind(txtRoomID.Text.Trim());
}
protected void btnAddCar_Click(object sender, EventArgs e)
{
string strRoomID = txtRoomID.Text;
string strPlateNumber = txtPlateNumber.Text;
string strStarTime = Request["starTime"].ToString();
string strEndTime = Request["endTime"].ToString();
string strRemark = txtRemark.Text;
if (string.IsNullOrEmpty(strStarTime))
{
this.lbTips.Text = "请填入住时间！";
return;
}
if (string.IsNullOrEmpty(strEndTime))
{
this.lbTips.Text = "请填写结束时间！";
return;
}
//向JieLink+平台发送
BlackWhiteListModel blackWhiteCar = new BlackWhiteListModel();
blackWhiteCar.PlateNumber = strPlateNumber;
blackWhiteCar.BlackWhiteType = 3;
blackWhiteCar.StartDate = strStarTime;
blackWhiteCar.EndDate = strEndTime;
blackWhiteCar.Reason = "";
blackWhiteCar.Remark = strRemark;
JielinkApi jieLinApi = new JielinkApi();
APIResultBase <BlackWhiteListModel> result = jieLinApi.AddBackWhiteList(blackWhiteCar);
if (result.code == "0")
{
//下发成功，则插入记录到数据库
MySqlConnection con = new MySqlConnection(connectionString);
string strCmd = "insert into tb_cars(RoomID,CarPlateNumber,StarTime,EndTime,Remark) values('" + strRoomID + "','" + strPlateNumber + "','" + strStarTime + "','" + strEndTime + "','" + strRemark + "');";
try
{
MySqlCommand cmd = new MySqlCommand(strCmd, con);
con.Open();
cmd.ExecuteNonQuery();
Bind(); //重新绑定数据，就可以查看刚插入的记录了
//清空Panel中TextBox控件内容
foreach (Control c in Panel1.Controls)
{
if (c is TextBox)
{
(c as TextBox).Text = "";
}
}
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
}
else
{
lbTips.Text = "下发信息失败！";
}
}
private void button_SyncFix_Click(object sender, EventArgs e)
{
try
{
JielinkApi jielinkApi = new JielinkApi();
ParkWhiteListBLL parkWhiteBll = new ParkWhiteListBLL();
FixSyncPlateBLL fixSyncPlateBLL = new FixSyncPlateBLL();
ICollection <VehicleInfoDb> IVehicleInfoDb = parkWhiteBll.GetDBParkWhiteList();
ICollection <VehicleInfoDb> IVehicleInfoDbAll = parkWhiteBll.GetAll();
ICollection <FixPersonModel> IFixPersonModelAll = fixSyncPlateBLL.GetPerson();
int ideleteCount = 0;
if (IFixPersonModelAll != null)
{
LogHelper.Info("===============jielink总用户数：[" + IFixPersonModelAll.Count + "]====================");
}
if (IVehicleInfoDbAll != null)
{
LogHelper.Info("===============同步总用户数：[" + IVehicleInfoDbAll.Count + "]====================");
}
List <FixPersonModel> LDeletePerson = new List <FixPersonModel>();
if (IFixPersonModelAll != null)
{
foreach (FixPersonModel item in IFixPersonModelAll)
{
VehicleInfoDb ve = IVehicleInfoDbAll.Where(p => p.PersonId == item.PGUID.ToString()).FirstOrDefault();
if (ve == null)
{
LDeletePerson.Add(item);
}
}
}
if (LDeletePerson != null && LDeletePerson.Count > 0)
{
LogHelper.Info("===============jielink需注销的用户数：[" + LDeletePerson.Count + "]====================");
foreach (FixPersonModel item in LDeletePerson)
{
ideleteCount++;
try
{
LogHelper.Info("===============序号[" + ideleteCount + "]开始执行=============");
VehicleInfoDb ve = IVehicleInfoDbAll.Where(p => p.PersonId == item.PGUID.ToString()).FirstOrDefault();
if (ve == null)
{
LogHelper.Info("===============序号[" + ideleteCount + "],车牌[" + item.PersonName + "],PersonId为[" + item.PGUID.ToString() + "],开始注销人员====================");
PersonModel personmodel = new PersonModel();
personmodel.personId = item.PGUID.ToString();
if (jielinkApi.DeletePerson(personmodel))
{
LogHelper.Info("===============序号[" + ideleteCount + "],车牌[" + item.PersonName + "],PersonId为[" + item.PGUID.ToString() + "],注销人员成功====================");
}
}
}
catch (Exception ex)
{
LogHelper.Error("==========异常注销错误：序号[" + ideleteCount + "],车牌[" + item.PersonName + "],PersonId为[" + item.PGUID.ToString() + "]：" + ex.ToString());
}
}
LogHelper.Info("===============全部异常注销完成====================");
}
int iSyncCount = 0;
if (IVehicleInfoDbAll != null && IVehicleInfoDbAll.Count > 0)
{
LogHelper.Info("===============同步总用户数：[" + IVehicleInfoDbAll.Count + "]====================");
foreach (VehicleInfoDb item in IVehicleInfoDbAll)
{
iSyncCount++;
try
{
LogHelper.Info("===============序号[" + iSyncCount + "]开始执行,车牌[" + item.vehicleNo + "]=============");
if (!string.IsNullOrWhiteSpace(item.PersonId))
{
FixPersonModel fixPerson = IFixPersonModelAll.Where(p => item.PersonId == p.PGUID.ToString()).FirstOrDefault();
if (fixPerson == null)
{
//正常应该不会有这种情况.暂不处理
LogHelper.Info("===============序号[" + iSyncCount + "]车牌[" + item.vehicleNo + "]PersonID[" + item.PersonId + "]在jielink中不存在=============");
}
else
{
if (item.yn == "0")//合法车
{
bool updateFlag = false;
if (fixPerson.IsIssueCard != 1)
{
updateFlag = true;
LogHelper.Info("===============序号[" + iSyncCount + "]车牌[" + item.vehicleNo + "],PersonId为[" + item.PersonId + "],开始重新绑定车辆====================");
VehicleModel vehicleModel = new VehicleModel();
vehicleModel.personId = item.PersonId;
vehicleModel.plateNumber = item.vehicleNo;
vehicleModel.vehicleStatus = 1;
vehicleModel = jielinkApi.VehicleBind(vehicleModel);
if (vehicleModel != null)
{
item.BindCar = 1;
LogHelper.Info("===============序号[" + iSyncCount + "]车牌[" + item.vehicleNo + "],PersonId为[" + item.PersonId + "],绑定车辆成功====================");
}
else
{
item.BindCar = 0;
LogHelper.Info("===============序号[" + iSyncCount + "]车牌[" + item.vehicleNo + "],PersonId为[" + item.PersonId + "],绑定车辆失败返回NULL====================");
}
}
if (fixPerson.IsParkService != 1)
{
updateFlag = true;
try
{
LogHelper.Info("===============序号[" + iSyncCount + "]车牌[" + item.vehicleNo + "],PersonId为[" + item.PersonId + "],开始开通车场服务====================");
ParkServiceModel parkService = new ParkServiceModel();
parkService.carNumber = 1;
parkService.personId = item.PersonId;
DateTime dtNow = DateTime.Now;
parkService.startTime = dtNow.ToShortDateString();
parkService.endTime = dtNow.AddYears(19).ToShortDateString();
parkService.setmealNo = 50;
parkService = jielinkApi.EnableParkService(parkService);
if (parkService != null)
{
item.ParkServiceId = parkService.parkServiceId;
}
else
{
LogHelper.Error("===============序号[" + iSyncCount + "]车牌[" + item.vehicleNo + "],PersonId为[" + item.PersonId + "]开通车场服务错误,返回NULL");
}
}
catch (Exception ex)
{
LogHelper.Error("===============序号[" + iSyncCount + "]车牌[" + item.vehicleNo + "],PersonId为[" + item.PersonId + "]开通车场服务错误", ex);
}
}
if (updateFlag)
{
parkWhiteBll.Update(item);
}
}
else
{
bool updateFlag = false;
if (fixPerson.IsIssueCard != 1)
{
updateFlag = true;
LogHelper.Info("===============序号[" + iSyncCount + "]车牌[" + item.vehicleNo + "],PersonId为[" + item.PersonId + "],开始重新绑定车辆====================");
VehicleModel vehicleModel = new VehicleModel();
vehicleModel.personId = item.PersonId;
vehicleModel.plateNumber = item.vehicleNo;
vehicleModel.vehicleStatus = 1;
vehicleModel = jielinkApi.VehicleBind(vehicleModel);
if (vehicleModel != null)
{
item.BindCar = 1;
LogHelper.Info("===============序号[" + iSyncCount + "]车牌[" + item.vehicleNo + "],PersonId为[" + item.PersonId + "],绑定车辆成功====================");
}
else
{
item.BindCar = 0;
LogHelper.Info("===============序号[" + iSyncCount + "]车牌[" + item.vehicleNo + "],PersonId为[" + item.PersonId + "],绑定车辆失败返回NULL====================");
}
}
if (fixPerson.IsParkService == 1)
{
updateFlag = true;
try
{
LogHelper.Info("===============序号[" + iSyncCount + "]车牌[" + item.vehicleNo + "],PersonId为[" + item.PersonId + "],开始注销车场服务====================");
ParkServiceModel parkService1 = new ParkServiceModel();
parkService1.parkServiceId = item.ParkServiceId;
bool result = jielinkApi.StopParkService(parkService1);
if (result)
{
item.ParkServiceId = "";
}
else
{
LogHelper.Error("===============序号[" + iSyncCount + "]车牌[" + item.vehicleNo + "],PersonId为[" + item.PersonId + "]注销车场服务错误,返回NULL");
}
}
catch (Exception ex)
{
LogHelper.Error("===============序号[" + iSyncCount + "]车牌[" + item.vehicleNo + "],PersonId为[" + item.PersonId + "]注销车场服务错误", ex);
}
}
if (updateFlag)
{
parkWhiteBll.Update(item);
}
}
}
}
else
{
}
}
catch (Exception ex)
{
}
}
LogHelper.Info("===============全部同步修复完成====================");
}
}
catch (Exception ex)
{
LogHelper.Error("同步错误,", ex);
}
}
