/// <summary> /// 增加岗亭信息 /// </summary> /// <param name="AreaID"></param> /// <returns></returns> public static ParkBox GetParkBox(string AreaID) { ParkBox model = new ParkBox(); model.AreaID = AreaID; model.BoxID = GuidGenerator.GetGuidString(); model.BoxName = "收费岗亭"; model.BoxNo = "0001"; model.DataStatus = DataStatus.Normal; model.HaveUpdate = 3; model.IsCenterPayment = YesOrNo.No; model.LastUpdateTime = DateTime.Now; string hostName = Dns.GetHostName(); //获取本机名 IPHostEntry localhost = Dns.GetHostByName(hostName); //方法已过期,可以获取IPv4的地址 if (localhost.AddressList.Length > 0) { model.ComputerIP = localhost.AddressList[0].ToString(); } else { model.ComputerIP = "127.0.0.1"; } return(model); }
public bool Update(ParkBox model) { using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("update ParkBox set BoxNo=@BoxNo,BoxName=@BoxName,ComputerIP=@ComputerIP,AreaID=@AreaID,Remark=@Remark"); strSql.Append(",IsCenterPayment=@IsCenterPayment,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate,IsOnLine=@IsOnLine,ProxyNo=@ProxyNo where BoxID=@BoxID"); dbOperator.ClearParameters(); dbOperator.AddParameter("BoxID", model.BoxID); dbOperator.AddParameter("BoxNo", model.BoxNo); dbOperator.AddParameter("BoxName", model.BoxName); dbOperator.AddParameter("ComputerIP", model.ComputerIP); dbOperator.AddParameter("AreaID", model.AreaID); dbOperator.AddParameter("Remark", model.Remark); dbOperator.AddParameter("IsCenterPayment", (int)model.IsCenterPayment); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("IsOnLine", model.IsOnLine); dbOperator.AddParameter("ProxyNo", model.ProxyNo); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }
public bool Add(ParkBox model) { using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ParkBox(BoxID,BoxNo,BoxName,ComputerIP,AreaID,Remark,DataStatus,HaveUpdate,LastUpdateTime,IsCenterPayment)"); strSql.Append(" values(@BoxID,@BoxNo,@BoxName,@ComputerIP,@AreaID,@Remark,@DataStatus,@HaveUpdate,@LastUpdateTime,@IsCenterPayment)"); dbOperator.ClearParameters(); dbOperator.AddParameter("BoxID", model.BoxID); dbOperator.AddParameter("BoxNo", model.BoxNo); dbOperator.AddParameter("BoxName", model.BoxName); dbOperator.AddParameter("ComputerIP", model.ComputerIP); dbOperator.AddParameter("AreaID", model.AreaID); dbOperator.AddParameter("Remark", model.Remark); dbOperator.AddParameter("IsCenterPayment", (int)model.IsCenterPayment); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("DataStatus", (int)model.DataStatus); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }
public JsonResult DownloadQRCode(string gateId, int size) { try { List <int> dics = new List <int>(); dics.Add(258); dics.Add(344); dics.Add(430); dics.Add(860); dics.Add(1280); List <string> imgs = new List <string>(); ParkGate gate = ParkGateServices.QueryByRecordId(gateId); if (gate == null) { throw new MyException("获取通道信息失败"); } BaseCompany company = CompanyServices.QueryByBoxID(gate.BoxID); if (company == null) { throw new MyException("获取单位信息失败"); } ParkBox box = ParkBoxServices.QueryByRecordId(gate.BoxID); if (box == null) { throw new MyException("获取岗亭信息失败"); } ParkArea area = ParkAreaServices.QueryByRecordId(box.AreaID); if (area == null) { throw new MyException("获取区域信息失败"); } BaseParkinfo parking = ParkingServices.QueryParkingByParkingID(area.PKID); if (parking == null) { throw new MyException("获取车场信息失败"); } string content = string.Format("{0}/qrl/scio_ix_pid={1}^io={2}", SystemDefaultConfig.SystemDomain, parking.PKID, gate.GateID); foreach (var item in dics) { string parkingName = string.Format("{0}_{1}_{2}_{3}_{4}", parking.PKName, area.AreaName, box.BoxName, gate.GateName, item); string result = QRCodeServices.GenerateQRCode(company.CPID, content, item, parkingName); imgs.Add(item.ToString() + "|" + result); } return(Json(MyResult.Success("", imgs))); } catch (MyException ex) { return(Json(MyResult.Error(ex.Message))); } catch (Exception ex) { ExceptionsServices.AddExceptions(ex, "下载二维码失败"); return(Json(MyResult.Error("下载二维码失败"))); } }
public JsonResult SaveEdit(ParkBox model) { try { bool result = false; if (string.IsNullOrWhiteSpace(model.BoxID)) { result = ParkBoxServices.Add(model); if (!result) { throw new MyException("添加失败"); } return(Json(MyResult.Success())); } else { result = ParkBoxServices.Update(model); if (!result) { throw new MyException("修改失败"); } return(Json(MyResult.Success())); } } catch (MyException ex) { return(Json(MyResult.Error(ex.Message))); } catch (Exception ex) { ExceptionsServices.AddExceptions(ex, "保存岗亭信息失败"); return(Json(MyResult.Error("保存岗亭信息失败"))); } }
public static bool Update(ParkBox model) { if (model == null) { throw new ArgumentNullException("model"); } IParkBox factory = ParkBoxFactory.GetFactory(); bool result = factory.Update(model); if (result) { OperateLogServices.AddOperateLog <ParkBox>(model, OperateType.Update); } return(result); }
public static bool Add(ParkBox model) { if (model == null) { throw new ArgumentNullException("model"); } model.BoxID = GuidGenerator.GetGuid().ToString(); IParkBox factory = ParkBoxFactory.GetFactory(); bool result = factory.Add(model); if (result) { OperateLogServices.AddOperateLog <ParkBox>(model, OperateType.Add); } return(result); }
private string GetParkingId(string pid, string bid, string gid) { try { if (!string.IsNullOrWhiteSpace(pid)) { return(pid); } if (!string.IsNullOrWhiteSpace(bid)) { ParkBox box = ParkBoxServices.QueryByRecordId(bid); if (box != null) { ParkArea area = ParkAreaServices.QueryByRecordId(box.AreaID); if (area != null) { return(area.PKID); } } } if (!string.IsNullOrWhiteSpace(gid)) { ParkGate gate = ParkGateServices.QueryByRecordId(gid); if (gate != null) { ParkBox box = ParkBoxServices.QueryByRecordId(gate.BoxID); if (box != null) { ParkArea area = ParkAreaServices.QueryByRecordId(box.AreaID); if (area != null) { return(area.PKID); } } } } } catch (Exception ex) { ExceptionsServices.AddExceptionToDbAndTxt("QRCodeParkPayment", "GetParkingId方法处理异常", ex, LogFrom.WeiXin); } return(string.Empty); }
private static bool AddDefaultParkDeviceParam(string gateId, string deviceId, string deviceNo, DbOperator dbOperator) { ParkGate gate = ParkGateServices.QueryByRecordId(gateId); ParkBox box = ParkBoxServices.QueryByRecordId(gate.BoxID); ParkArea area = ParkAreaServices.QueryByRecordId(box.AreaID); ParkDeviceParam param = CreateDefualtParam(deviceId, int.Parse(deviceNo), area.CarbitNum, (int)gate.IoState); IParkDevice factory = ParkDeviceFactory.GetFactory(); ParkDeviceParam deviceParam = factory.QueryParkDeviceParamByDevID(param.DevID); if (deviceParam != null) { throw new MyException("设备编号不能重复"); } bool result = factory.AddParam(param, dbOperator); if (!result) { throw new MyException("添加设备默认参数失败"); } return(result); }
/// <summary> /// 系统初始化默认单位CS /// </summary> public static bool InitSystemDefaultCompanyCS(string VName, string CPName, string userno, string pwd, string systemmodelpath) { try { ICompany factory = CompanyFactory.GetFactory(); using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { try { dbOperator.BeginTransaction(); BaseCompany compamy = GetCompanyModel(); compamy.CPName = CPName; compamy.UserAccount = userno; compamy.UserPassword = pwd; bool result = factory.Add(compamy, dbOperator); if (!result) { throw new MyException("添加默认单位失败"); } BaseVillage village = GetVillage(compamy.CPID); village.VName = VName; result = VillageServices.AddVillageDefaultUser(village, dbOperator); if (!result) { throw new MyException("添加默认小区失败"); } result = SysUserServices.AddCompanyDefaultUserCS(compamy, village, dbOperator, systemmodelpath); if (!result) { throw new MyException("添加默认用户失败"); } BaseParkinfo parkinfo = GetParkinfo(village.VID); result = ParkingServices.AddParkinfoDefault(parkinfo, dbOperator); if (!result) { throw new MyException("添加默认车场失败"); } dbOperator.CommitTransaction(); ParkArea area = GetParkArea(parkinfo.PKID); result = ParkAreaServices.AddDefualt(area); if (result) { ParkBox box = GetParkBox(area.AreaID); result = ParkBoxServices.AddDefault(box); if (result) { result = ParkGateServices.AddDefault(GetParkGate(box.BoxID, 1)); result = ParkGateServices.AddDefault(GetParkGate(box.BoxID, 2)); } } } catch (Exception ex) { dbOperator.RollbackTransaction(); throw; } } } catch (Exception ex) { ExceptionsServices.AddExceptions(ex, "添加系统默认单用户失败"); return(false); } return(true); }