public VenueHostHandler() { userDA = UserDA.getInstance(); addressDA = AddressDA.getInstance(); venueHostDA = VenueHostDA.getInstance(); branchDA = BranchDA.GetInstance(); }
/// <summary> /// 创建Company信息 /// </summary> public static int InsertCompany(Company entity) { CheckCompany(entity, true); entity.SysNo = CompanyDA.InsertCompany(entity); AddressDA.CreateRootAddress(entity.SysNo); return(entity.SysNo); }
//Will be only one instance public static AddressDA getInstance() { if (instance == null) { instance = new AddressDA(); } return(instance); }
public static void EditAddress(Address entity) { CheckAddress(entity); if (entity.SysNo > 0) { var o = AddressDA.LoadAddress(entity.SysNo); if (o == null || o.CompanySysNo != entity.CompanySysNo) { return; } Address parent = o.ParentSysNo.GetValueOrDefault() <= 0 ? null : AddressDA.LoadAddress(o.ParentSysNo.Value); entity.PathName = entity.Name; if (parent != null) { string parentPathName = parent.PathName; if (parent.ParentSysNo.GetValueOrDefault() == 0) { parentPathName = parent.Name; } entity.PathName = parentPathName + ">" + entity.Name; // entity.AreaSysNo = 0; } entity.ParentSysNo = o.ParentSysNo; AddressDA.UpdateAddress(entity); } else { string code = ""; int parentSysNo = entity.ParentSysNo.GetValueOrDefault(); string beginAddressCode = AddressDA.GetChildrenMaxCode(entity.CompanySysNo, parentSysNo); Address parent = parentSysNo <= 0 ? null : AddressDA.LoadAddress(parentSysNo); if (parentSysNo > 0 && (parent == null || parent.CompanySysNo != entity.CompanySysNo)) { throw new BusinessException("父级节点不存在,请选择正确的父级节点。"); } if (string.IsNullOrWhiteSpace(beginAddressCode)) { code = parent == null ? "10" : (parent.Code + "00"); } else { code = GenerateCode(beginAddressCode, beginAddressCode.Length, 3); } entity.Code = code; entity.PathName = entity.Name; if (parent != null) { string parentPathName = parent.PathName; if (parent.ParentSysNo.GetValueOrDefault() == 0) { parentPathName = parent.Name; } entity.PathName = parentPathName + ">" + entity.Name; // entity.AreaSysNo = 0; } entity.SysNo = AddressDA.InsertAddress(entity); } }
/// <summary> /// 更新Company信息 /// </summary> public static void UpdateCompany(Company entity) { CheckCompany(entity, false); Company company = CompanyDA.LoadCompany(entity.SysNo); if (company == null) { throw new BusinessException("查找不到企业"); } CompanyDA.UpdateCompany(entity); AddressDA.CreateRootAddress(entity.SysNo); }
public static void InsertAddressManager(List <int> users, string code, int companySysNo) { using (ITransaction transaction = TransactionManager.Create()) { AddressDA.DeleteAddressManagerByCode(code, companySysNo); if (users != null && users.Count > 0) { AddressDA.InsertAddressManager(users, code, companySysNo); } transaction.Complete(); } }
public static void EditAddress(Address entity) { CheckAddress(entity); if (entity.SysNo > 0) { AddressDA.UpdateAddress(entity); } else { AddressDA.InsertAddress(entity); } }
/// <summary> /// 删除Address信息 /// </summary> public static bool DeleteAddress(int companySysNo, int sysNo, bool isDeleteMoreNode = true) { Address addInfo = AddressDA.LoadAddress(sysNo); if (addInfo == null) { return(true); } if (companySysNo > 0 && addInfo.CompanySysNo != companySysNo) { return(true); } return(AddressDA.DeleteAddress(sysNo, isDeleteMoreNode)); }
[HttpPost] //Insert to Database public IHttpActionResult Post([FromBody] Contact postContact) { ContactDA.read(); if (postContact != null) { Country country = null; bool storeData = true; foreach (var item in CountryDA.CtryList) { if (Convert.ToString(item.CountryName).ToLower() == postContact.Address.Country.CountryName.ToLower()) { country = item; storeData = false; } } if (storeData) { country = new Country(); country.CountryName = postContact.Address.Country.CountryName; country.CountryCode = postContact.Address.Country.CountryCode; //=============================================== //DATA ACCESS METHOD CountryDA.insert(country); //=============================================== } Address a = new Address(postContact.Address.AddressST, postContact.Address.City, postContact.Address.State, postContact.Address.ZipCode, country.CountryID, country); AddressDA.insert(a); Contact con = new Contact( postContact.FName, postContact.LName, postContact.Age, postContact.Gender, postContact.Email, a.AddressID, postContact.PhoneNumber, a); ContactDA.insert(con); return(Ok("Contact Added.")); } else { return(BadRequest()); } }
public static SmokeMap GetAddressMapSmokes(int companySysNo, int addressId) { var model = new SmokeMap(); model.AddressNo = addressId; model.AddressMaps = AddressMapDA.QueryAddressMapList(new AddressMapFilter { AddressSysNo = addressId, PageSize = 100000 }).data; //标记点分两种 烟感器 和 下级地址 model.Smokes = new List <AddressMapMarker>(); model.Markers = new List <AddressMapMarker>(); var smokes = SmokeDetectorDA.GetSmokeDetectorByAddressSysNo(companySysNo, new List <int> { addressId }); if (smokes != null) { smokes.ForEach(a => { model.Smokes.Add(new AddressMapMarker { SysNo = a.SysNo, Name = string.IsNullOrEmpty(a.Position) ? a.Code : a.Position, Type = AddressMapMarkerType.SmokeDetector, }); }); } var address = AddressDA.GetTopLevelChildren(addressId); if (address != null) { address.ForEach(a => { model.Smokes.Add(new AddressMapMarker { SysNo = a.SysNo, Name = a.Name, Type = AddressMapMarkerType.Address, }); }); } return(model); }
private static void BuildAddSaveChildrenAddress(List <Address> pAddList, AddressNamePattern childPattern, int userSysNo, string userName) { if (childPattern == null) { return; } foreach (var p in pAddList) { if (p.SysNo < 1) { continue; } //p.EditUserName 中暂存了子节点最大的编码 List <Address> addList = BuildAddress(childPattern, p, p.EditUserName); AddressDA.InsertAddress(p.CompanySysNo, p.SysNo, ref addList, userSysNo, userName); if (childPattern.ChildPattern != null) { childPattern.ChildPattern.CompanySysNo = childPattern.CompanySysNo; } BuildAddSaveChildrenAddress(addList, childPattern.ChildPattern, userSysNo, userName); } }
/// <summary> /// 更新Address信息 /// </summary> public static void UpdateAddress(Address entity) { CheckAddress(entity); AddressDA.UpdateAddress(entity); }
public static string GenerateInvoiceExcelReport(ExternalInvoice inv, int currentUserClientId, string subFolder, bool deleteWorkDir, ref string alert) { //Output Table - contains all types of usage var usage = inv.Usage; // point to template files string fileName = Utility.GetRequiredAppSetting("Invoice_Template"); string templatePath = GetTemplatePath(fileName); string workPathDir = GetWorkPath(currentUserClientId); if (!string.IsNullOrEmpty(subFolder)) { workPathDir = Path.Combine(workPathDir, subFolder); } // Delete old work files // need to check and see if any old files are left behind // remember, WorkDir always includes the ClientID if (!Directory.Exists(GetWorkPath(currentUserClientId))) { Directory.CreateDirectory(GetWorkPath(currentUserClientId)); } if (deleteWorkDir) { ClearWorkDirectory(GetWorkPath(currentUserClientId)); } // this is (possibly) a sub folder of WorkDir // if subFolder is empty then subPath is the same as ExcelUtility.WorkPath and we already checked to see if that exists if (!string.IsNullOrEmpty(subFolder)) { if (!Directory.Exists(workPathDir)) { Directory.CreateDirectory(workPathDir); } } // Write to excel int attempts = 0; string orgName = inv.Header.OrgName; string acctName = inv.Header.AccountName; string workFileName = EnsureFileNameIsValid(orgName + " (" + acctName + ") " + inv.StartDate.ToString("yyyy-MM") + Path.GetExtension(fileName)); string workFilePath = Path.Combine(workPathDir, workFileName); string errmsg = string.Empty; while (!File.Exists(workFilePath) && attempts < 10) { try { File.Copy(templatePath, workFilePath, true); } catch (Exception ex) { //I only care about the last one errmsg = ex.Message; } attempts += 1; } if (File.Exists(workFilePath)) { using (var mgr = NewExcelManager()) { mgr.OpenWorkbook(workFilePath); mgr.SetActiveWorksheet("Invoice"); //show invoice date mgr.SetCellTextValue("F4", DateTime.Now.ToString("MMMM dd, yyyy")); DataTable dtAddress = AddressDA.GetAddressByAccountID(inv.Header.AccountID); foreach (DataRow drAddr in dtAddress.Rows) { int startRow = (drAddr.Field <string>("AddrType") == "Billing") ? 7 : 13; mgr.SetCellTextValue($"C{startRow}", inv.Header.OrgName); mgr.SetCellTextValue($"C{startRow + 1}", drAddr.Field <string>("InternalAddress")); mgr.SetCellTextValue($"C{startRow + 2}", drAddr.Field <string>("StrAddress1")); mgr.SetCellTextValue($"C{startRow + 3}", drAddr.Field <string>("StrAddress2")); mgr.SetCellTextValue($"C{startRow + 4}", drAddr.Field <string>("City") + ", " + drAddr.Field <string>("State") + " " + drAddr.Field <string>("Zip")); } //invoice number that needs to be entered mgr.SetCellTextValue("E12", inv.Header.InvoiceNumber); mgr.SetCellTextValue("I14", inv.Header.DeptRef); //now print charges int r = 21; double totalCharge = usage.Sum(x => x.Cost); foreach (var item in usage) { if (item.Cost != 0) { mgr.SetCellTextValue($"C{r}", inv.StartDate.ToString("MM/yyyy")); mgr.SetCellTextValue($"D{r}", item.Description.Replace("'", "''")); mgr.SetCellNumberValue($"H{r}", item.Quantity); mgr.SetCellNumberValue($"I{r}", item.Cost); r += 1; } } mgr.SaveAs(workFilePath); } } else { alert = "Unable to create Excel file, copying template failed: " + errmsg; workFilePath = string.Empty; } return(workFilePath); }
public static void CreateRootAddress(int companySysNo) { AddressDA.CreateRootAddress(companySysNo); }
public ActionResult AddSmokeDetector(SmokeDetector entity) { long deviceCode = 0; long.TryParse(entity.Code, out deviceCode); if (deviceCode <= 0) { return(Json(new AjaxResult() { Success = false, Message = "请扫描正确的设备二维码。" })); } //if (curentUser.UserType != UserType.Installer) //{ // return Json(new AjaxResult() { Success = false, Message = "您不是管理员,请绑定管理员账号。" }); //} //if ((entity.AddressSysNo == null || entity.AddressSysNo <= 0) && (entity.Memo == "" || entity.Memo == null)) //{ // return Json(new AjaxResult() { Success = false, Message = "请选择详细地址或者填写备注。" }); //} if ((!entity.AddressSysNo.HasValue || entity.AddressSysNo <= 0) && string.IsNullOrWhiteSpace(entity.Position)) { return(Json(new AjaxResult() { Success = false, Message = "请选择地址或填写设备具体位置。" })); } Address address = AddressDA.LoadAddress(entity.AddressSysNo.GetValueOrDefault()); if (address == null) { return(Json(new AjaxResult() { Success = false, Message = "位置信息错误,请重新选择后再试。" })); } entity.AddressCode = address.Code; entity.AddressName = address.PathName; if ((address.ParentSysNo == 0 || address.ParentSysNo == null) && (address.PathName == "" || address.PathName == null)) { entity.AddressName = address.Name; } entity.Status = SmokeDetectorStatus.Offline; if (curentUser.UserType == UserType.Installer) { entity.InstallerSysNo = curentUser.ManagerSysNo; } else { entity.InstallerSysNo = -curentUser.UserSysNo; } entity.InstallerName = HttpUtility.UrlDecode(curentUser.UserID); entity.InUserSysNo = curentUser.UserSysNo; entity.InUserName = HttpUtility.UrlDecode(curentUser.UserID); SmokeDetector smoke = SmokeDetectorServices.IsUniquenessCode(entity.Code); SystemUserService service = new SystemUserService(); SystemUser systemuser = service.LoadSystemUser(curentUser.ManagerSysNo.GetValueOrDefault(), ConstValue.ApplicationID); if (systemuser == null) { UserMgr.Logout(); return(Json(new AjaxResult() { Success = false, Message = "登录超时,请退出公众号重新进入。" })); } //if (smoke != null && smoke.CompanySysNo != systemuser.MasterSysNo) //{ // return Json(new AjaxResult() { Success = false, Message = "设备已安装,不能再安装。" }); //} //else if (smoke != null) { if (smoke.Status == SmokeDetectorStatus.Delete) { entity.Status = SmokeDetectorStatus.Offline; } else { entity.Status = smoke.Status; if (smoke.InstallerSysNo <= 0) { if (smoke.InstallerSysNo != -curentUser.UserSysNo) { return(Json(new AjaxResult() { Success = false, Message = "设备已安装,不能再安装。" })); } } else { if (!(smoke.CompanySysNo == systemuser.MasterSysNo && curentUser.UserType == UserType.Installer)) { return(Json(new AjaxResult() { Success = false, Message = "设备已安装,不能再安装。" })); } } }; CreateDeviceRequest reques = new CreateDeviceRequest() { IMei = entity.Code, IMsi = entity.Code, Desc = "测试设备", IsOnLine = 1, Observe = 1, Protocol = "LWM2M", Title = entity.Code, Tags = entity.Code + "," + entity.Code }; CreateDeviceResponse result = ONENETService.CreateDevice(reques); if (result.IsSuccess) { entity.DeviceId = result.DeviceId; } else { entity.DeviceId = smoke.DeviceId; } entity.SysNo = smoke.SysNo; SmokeDetectorServices.UpdateSmokeDetector(entity); if (curentUser.UserType != UserType.Installer) { Logger.WriteLog("Code:" + entity.Code); BindingDevicesApi(entity.Code); } return(Json(new AjaxResult() { Success = true, Message = "修改成功!" })); //} //else //{ // return Json(new AjaxResult() { Success = false, Message = "系统异常!" }); //} } else { CreateDeviceRequest reques = new CreateDeviceRequest() { IMei = entity.Code, IMsi = entity.Code, Desc = "测试设备", IsOnLine = 1, Observe = 1, Protocol = "LWM2M", Title = entity.Code, Tags = entity.Code + "," + entity.Code }; CreateDeviceResponse result = ONENETService.CreateDevice(reques); if (result.IsSuccess) { entity.DeviceId = result.DeviceId; } int i = SmokeDetectorServices.InsertSmokeDetector(entity); SmokeDetectorStatusLog statusLog = new SmokeDetectorStatusLog() { Status = entity.Status, BeginTime = DateTimeHelper.GetTimeZoneNow(), ReceivedJsonData = "", SmokeDetectorCode = entity.Code }; if (curentUser.UserType != UserType.Installer) { Logger.WriteLog("Code:" + entity.Code); BindingDevicesApi(entity.Code); } return(Json(new AjaxResult() { Success = true, Message = "添加成功!" })); } }
public static List <AddressManager> LoadAddressManagerByCode(string code, int companySysNo) { return(AddressDA.LoadAddressManagerByCode(code, companySysNo)); }
public static bool CreateAddress(AddressNamePattern pattern, int userSysNo, string userName, out string message) { message = null; bool result = CheckAddressPattern(pattern, out message); if (!result) { return(false); } int companySysNo = pattern.CompanySysNo; if (companySysNo <= 0) { message = "客户信息不存在,请选择客户后再创建地址信息。"; return(false); } object locker = GetCompanyAddressCreateLockerByKey(companySysNo); lock (locker) { if (CompanyAddressCreateCount.ContainsKey(companySysNo)) { CompanyAddressCreateCount[companySysNo] = CompanyAddressCreateCount[companySysNo] + 1; } else { CompanyAddressCreateCount.Add(companySysNo, 1); } try { Address parent = AddressDA.LoadAddress(pattern.ParentSysNo); if (parent == null || parent.CompanySysNo != companySysNo) { message = "按规则创建地址时,请指定父级地址。如果是根地址,则只能单个创建。"; return(false); } string beginAddressCode = AddressDA.GetChildrenMaxCode(companySysNo, pattern.ParentSysNo); List <Address> addList = BuildAddress(pattern, parent, beginAddressCode); AddressDA.InsertAddress(companySysNo, pattern.ParentSysNo, ref addList, userSysNo, userName); if (pattern.ChildPattern != null) { pattern.ChildPattern.CompanySysNo = companySysNo; } Task task = new Task(() => { var aList = addList; var p = pattern.ChildPattern; var uno = userSysNo; var uname = userName; BuildAddSaveChildrenAddress(aList, p, uno, uname); }); task.Start(); } finally { CompanyAddressCreateCount[companySysNo] = CompanyAddressCreateCount[companySysNo] - 1; } } return(true); }
/// <summary> /// 加载客户除楼和房间号地址信息 /// </summary> /// <param name="companuSysNo"></param> /// <returns></returns> public static List <Address> LoadCompanyAddress(int companySysNo) { return(AddressDA.LoadCompanyAddress(companySysNo)); }
public static List <MapDataAddress> GetMapDataAddress(int companySysNo) { return(AddressDA.GetMapDataAddress(companySysNo)); }
/// <summary> /// 分页查询Address信息 /// </summary> public static QueryResult <Address> QueryAddressList(AddressFilter filter) { return(AddressDA.QueryAddressList(filter)); }
/// <summary> /// 根据Code获取地址树 /// </summary> /// <param name="addressCode"></param> /// <param name="companySysNo"></param> /// <returns></returns> public static List <Address> LoadAddressByAddressCode(string addressCode, int companySysNo) { return(AddressDA.LoadAddressByAddressCode(addressCode, companySysNo)); }
/// <summary> /// 查询地址下级 /// </summary> /// <param name="companySysNo"></param> /// <param name="code"></param> /// <returns></returns> public static List <Address> LoadSubsetAddressByAddressSysNo(int companySysNo, int addressSysNo) { return(AddressDA.LoadSubsetAddressByAddressSysNo(companySysNo, addressSysNo)); }
/// <summary> /// 加载Address信息 /// </summary> public static Address LoadAddress(int sysNo) { return(AddressDA.LoadAddress(sysNo)); }
/// <summary> /// 创建Address信息 /// </summary> public static int InsertAddress(Address entity) { CheckAddress(entity); return(AddressDA.InsertAddress(entity)); }
/// <summary> /// 删除Address信息 /// </summary> public static void DeleteAddress(int sysNo, bool isDeleteMoreNode = true) { AddressDA.DeleteAddress(sysNo, isDeleteMoreNode); }
public ParticipantHandler() { userDA = UserDA.getInstance(); addressDA = AddressDA.getInstance(); participantDA = ParticipantDA.getInstance(); }