public ActionResult SubmitForm(AreaEntity areaEntity, string keyValue) { AreaEntity parentEntity = areaApp.GetForm(areaEntity.F_ParentId); if (parentEntity != null) { areaEntity.F_Layers = parentEntity.F_Layers + 1; } else { areaEntity.F_Layers = 0; } areaApp.SubmitForm(areaEntity, keyValue); return(Success("操作成功。")); }
/// <summary> /// 保存区域表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="areaEntity">区域实体</param> /// <returns></returns> public void SaveForm(string keyValue, AreaEntity areaEntity) { if (!string.IsNullOrEmpty(keyValue)) { areaEntity.Modify(keyValue); this.BaseRepository().Update(areaEntity); } else { areaEntity.Create(); this.BaseRepository().Insert(areaEntity); } CacheFactory.GetCacheInstance().RemoveCache("__AreaCache"); }
private void btnArea_Click(object sender, EventArgs e) { int xSize = int.Parse(txtX.Text); int ySize = int.Parse(txtY.Text); if (xSize <= 0 || ySize <= 0) { MessageBox.Show("Alan ölçüleri 0 dan büyük bir değer olmalıdır."); return; } areaEntity = null; robotEntity = null; areaEntity = AreaEntity.CreateInstance(xSize, ySize); areaEntity.DrawArea(this.grpArea); }
public async Task SaveForm(AreaEntity entity) { if (entity.Id.IsNullOrZero()) { await entity.Create(); await this.BaseRepository().Insert <AreaEntity>(entity); } else { await entity.Modify(); await this.BaseRepository().Update <AreaEntity>(entity); } }
public HttpResponseMessage Put([FromBody] AreaEntity AreaEntity) { try { if (AreaEntity.AreaId > 0) { var result = _Area.UpdateArea(AreaEntity.AreaId, AreaEntity); return(Request.CreateResponse(HttpStatusCode.OK, result)); } } catch { throw new ApiDataException(1000, "Area not found", HttpStatusCode.NotFound); } return(Request.CreateResponse(HttpStatusCode.InternalServerError, "InternalServerError")); }
public Dictionary <int, AreaEntity> GetProvinces() { string sSql = " SELECT * FROM dbo.Area WHERE ProvinceSysNo IS NULL AND Status='0' ORDER BY SysNo "; DataTable areaDT = SqlHelper.ExecuteDataSet(AppConfig.Conn_IPP, sSql).Tables[0]; DataRow[] provinceRows = areaDT.Select(" ProvinceSysNo IS NULL AND Status=" + (int)AppEnum.BiStatus.Valid); Dictionary <int, AreaEntity> provinceDic = new Dictionary <int, AreaEntity>(); foreach (DataRow dr in provinceRows) { AreaEntity item = new AreaEntity(); Map(item, dr); provinceDic.Add(item.SysNo, item); } return(provinceDic); }
public Dictionary <int, AreaEntity> GetCitiesByProvinceSysNo(int provinceSysNo) { string sSql = " SELECT * FROM dbo.Area WHERE ProvinceSysNo=" + provinceSysNo + " AND CitySysNo IS NULL ORDER BY SysNo "; DataTable areaDT = SqlHelper.ExecuteDataSet(AppConfig.Conn_IPP, sSql).Tables[0]; DataRow[] cityRows = areaDT.Select(" ProvinceSysNo=" + provinceSysNo + " AND CitySysNo IS NULL"); Dictionary <int, AreaEntity> cityDic = new Dictionary <int, AreaEntity>(); foreach (DataRow dr in cityRows) { AreaEntity item = new AreaEntity(); Map(item, dr); cityDic.Add(item.SysNo, item); } return(cityDic); }
public Dictionary <int, AreaEntity> GetZonesByDistrictSysNo(int disctrictSysNo) { string sSql = " SELECT * FROM dbo.Area WHERE DistrictSysNo=" + disctrictSysNo + " AND Status='0' ORDER BY SysNo "; DataTable areaDT = SqlHelper.ExecuteDataSet(AppConfig.Conn_IPP, sSql).Tables[0]; DataRow[] zoneRows = areaDT.Select(" DistrictSysNo=" + disctrictSysNo + " AND Status=" + (int)AppEnum.BiStatus.Valid); Dictionary <int, AreaEntity> zoneDic = new Dictionary <int, AreaEntity>(); foreach (DataRow dr in zoneRows) { AreaEntity item = new AreaEntity(); Map(item, dr); zoneDic.Add(item.SysNo, item); } return(zoneDic); }
protected void btnSavePopup_Click(object sender, EventArgs e) { if (ddlRegion.SelectedValue == string.Empty) { ProcessDatabaseReply("A Region must be selected", "", AdminMappingEnum.OpsArea, lblMessage); return; } var ae = new AreaEntity { Id = int.Parse(hfAreaId.Value), RegionId = int.Parse(ddlRegion.SelectedValue), AreaName = tbAreaName.Text, Active = cbActive.Checked }; SaveDataToDataBase(ae); }
/// <summary> /// 保存区域表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="{">区域实体</param> /// <returns></returns> public void SaveForm(string keyValue, AreaEntity areaEntity) { if (!string.IsNullOrEmpty(keyValue)) { areaEntity.Modify(keyValue); Base_Area area = Base_Area.SingleOrDefault("where AreaId=@0", keyValue); area = EntityConvertTools.CopyToModel <AreaEntity, Base_Area>(areaEntity, area); area.AreaId = keyValue; area.Update(); } else { areaEntity.Create(); Base_Area area = EntityConvertTools.CopyToModel <AreaEntity, Base_Area>(areaEntity, null); area.Insert(); } }
public void SubmitForm(AreaEntity areaEntity, string keyValue) { if (!string.IsNullOrEmpty(keyValue)) { areaEntity.Modify(keyValue); service.Update(areaEntity); //添加日志 LogHelp.logHelp.WriteDbLog(true, "修改区域信息=>" + areaEntity.FullName, Enums.DbLogType.Update, "区域管理"); } else { areaEntity.Create(); service.Insert(areaEntity); //添加日志 LogHelp.logHelp.WriteDbLog(true, "添加区域信息=>" + areaEntity.FullName, Enums.DbLogType.Create, "区域管理"); } }
public async Task <IActionResult> SubmitForm([FromBody] BaseSubmitInput <AreaDto> input) { AreaEntity entity = null; if (input.KeyValue.IsEmpty()) { entity = _mapper.Map <AreaEntity>(input.Entity); } else { entity = await _areaApp.GetForm(input.KeyValue); } entity.CheckArgumentIsNull(nameof(entity)); await _areaApp.SubmitForm(entity, input.Entity); return(Success("操作成功。")); }
private void SaveArea() { CommonBLL commonBll = new CommonBLL(); IArea area = new AreaEntity(); string message = string.Empty; BuildAreaEntity(area); message = commonBll.SaveArea(area, _userId); if (message == string.Empty) { Response.Redirect("~/Security/ManageArea.aspx"); } else { GeneralFunctions.RegisterAlertScript(this, message); } }
/// <summary> /// 得到运费 /// </summary> /// <returns></returns> public virtual void SetFreight(Domain.Entities.Member.AddressEntity address, AreaEntity area, decimal payAmount) { if (Freight == null || Product == null || address == null) { return; } var freightCalculator = new FreightCalculatorEntity { Area = area, Province = address.Province, City = address.City, County = address.County, PayAmount = payAmount, Count = Count }; Freight.Set(freightCalculator); }
public GetAreaListResultEntity Post(GetAreaListRequestModel req) { Logger.LogDebug("GetAreaList Request:" + JsonHelper.SerializeObject(req), "GetAreaListController", "Post"); GetAreaListResultEntity ret = new GetAreaListResultEntity() { Code = 0, ErrMsg = "", AreaList = new List <AreaEntity>() }; try { bool cityNameIsEmtpy = string.IsNullOrEmpty(req.CityName); var _hs = new List <Area>(); if (cityNameIsEmtpy) { _hs = _areaBLL.GetModels(a => a.ID > 0).ToList(); } else { _hs = _areaBLL.GetModels(a => a.CityName == req.CityName).ToList(); } if (_hs != null && _hs.Count > 0) { _hs.ForEach(a => { var areaInfo = new AreaEntity(); areaInfo.ID = a.ID; areaInfo.Name = a.Name; areaInfo.CityName = a.CityName; ret.AreaList.Add(areaInfo); }); } } catch (Exception ex) { Logger.LogException("获取区域列表时发生异常!", "GetAreaListController", "Post", ex); ret.Code = 999; ret.ErrMsg = ex.Message; } return(ret); }
public ActionResult SubmitForm(AreaEntity areaEntity, string keyValue) { var module = new ModuleApp().GetList().Where(a => a.F_Layers == 1 && a.F_EnCode == moduleName).FirstOrDefault(); var moduleitem = new ModuleApp().GetList().Where(a => a.F_Layers > 1 && a.F_EnCode == className.Substring(0, className.Length - 10)).FirstOrDefault(); LogEntity logEntity; if (string.IsNullOrEmpty(keyValue)) { areaEntity.F_DeleteMark = false; logEntity = new LogEntity(module.F_FullName, moduleitem.F_FullName, DbLogType.Create.ToString()); logEntity.F_Description += DbLogType.Create.ToDescription(); } else { logEntity = new LogEntity(module.F_FullName, moduleitem.F_FullName, DbLogType.Update.ToString()); logEntity.F_Description += DbLogType.Update.ToDescription(); logEntity.F_KeyValue = keyValue; } if (areaEntity.F_ParentId == "0") { areaEntity.F_Layers = 1; } else { areaEntity.F_Layers = areaApp.GetForm(areaEntity.F_ParentId).F_Layers + 1; } try { logEntity.F_Account = OperatorProvider.Provider.GetCurrent().UserCode; logEntity.F_NickName = OperatorProvider.Provider.GetCurrent().UserName; areaApp.SubmitForm(areaEntity, keyValue); logEntity.F_Description += "操作成功"; new LogApp().WriteDbLog(logEntity); return(Success("操作成功。")); } catch (Exception ex) { logEntity.F_Result = false; logEntity.F_Description += "操作失败," + ex.Message; new LogApp().WriteDbLog(logEntity); return(Error(ex.Message)); } }
/// <summary> /// 添加或编辑区域 /// </summary> /// <param name="entity"></param> /// <param name="isNew">添加或编辑</param> /// <returns></returns> public bool SaveUpdateArea(AreaEntity entity, bool isNew) { try { #region 请求数据 System.Text.StringBuilder loStr = new System.Text.StringBuilder(); loStr.Append("arCode=").Append(entity.Code).Append("&"); loStr.Append("arName=").Append(entity.Name).Append("&"); loStr.Append("id=").Append(entity.ID); string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_SaveUpdateArea); if (string.IsNullOrEmpty(jsonQuery)) { MsgBox.Warn(WebWork.RESULT_NULL); //LogHelper.InfoLog(WebWork.RESULT_NULL); return(false); } #endregion #region 正常错误处理 Sucess bill = JsonConvert.DeserializeObject <Sucess>(jsonQuery); if (bill == null) { MsgBox.Warn(WebWork.JSON_DATA_NULL); return(false); } if (bill.flag != 0) { MsgBox.Warn(bill.error); return(false); } #endregion return(true); } catch (Exception ex) { MsgBox.Err(ex.Message); } return(false); }
public static void Delete(AreaEntity entity) { try { string query; query = $@"UPDATE area SET is_activo = 0, WHERE id = @Id"; using (var db = new MySqlConnection(Conexion.CadenaDeConexion)) { db.Query <int>(query, new { Id = entity.Id }); } } catch (Exception) { throw; } }
public Task <int> SubmitForm(AreaEntity areaEntity, string keyValue) { var claimsIdentity = _httpContext.HttpContext.User.Identity as ClaimsIdentity; claimsIdentity.CheckArgumentIsNull(nameof(claimsIdentity)); var claim = claimsIdentity?.FindFirst(t => t.Type.Equals(ClaimTypes.NameIdentifier)); if (!string.IsNullOrEmpty(keyValue)) { areaEntity.Modify(keyValue); areaEntity.F_LastModifyUserId = claim?.Value; return(_service.UpdateAsync(areaEntity)); } else { areaEntity.Create(); areaEntity.F_CreatorUserId = claim?.Value; return(_service.InsertAsync(areaEntity)); } }
public Task <int> SubmitForm <TDto>(AreaEntity entity, TDto dto) where TDto : class { var claimsIdentity = _httpContext.HttpContext.User.Identity as ClaimsIdentity; claimsIdentity.CheckArgumentIsNull(nameof(claimsIdentity)); var claim = claimsIdentity?.FindFirst(t => t.Type.Equals(ClaimTypes.NameIdentifier)); if (!string.IsNullOrEmpty(entity.F_Id)) { entity.Modify(entity.F_Id); entity.F_LastModifyUserId = claim?.Value; return(_service.UpdateAsync(entity, dto)); } else { entity.Create(); entity.F_CreatorUserId = claim?.Value; return(_service.InsertAsync(entity)); } }
public static void Update(AreaEntity entity) { try { string query; query = $@"UPDATE area SET nombre = @Nombre WHERE id = @Id"; using (var db = new MySqlConnection(Conexion.CadenaDeConexion)) { db.Query <int>(query, new { Nombre = entity.Nombre, Id = entity.Id }); } } catch (Exception) { throw; } }
public void TestInitialize() { area = new AreaEntity { Id = 1, Name = "Limpieza", Topics = new List <TopicEntity>() }; topic = new TopicEntity { Id = 1, Name = "Contenedores de basura", AreaEntityId = 1, RequestTypes = new List <TypeReqEntity>() }; type = new TypeReqEntity { Id = 1, Name = "Roto", AdditionalFields = new List <AdditionalFieldEntity>(), TopicEntityId = 1 }; unitOfWork = new Mock <IUnitOfWork>(); areaRepository = new Mock <IRepository <AreaEntity> >(); topicRepository = new Mock <IRepository <TopicEntity> >(); typeRepository = new Mock <IRepository <TypeReqEntity> >(); unitOfWork.Setup(u => u.AreaRepository).Returns(areaRepository.Object); unitOfWork.Setup(u => u.TopicRepository).Returns(topicRepository.Object); unitOfWork.Setup(u => u.TypeReqRepository).Returns(typeRepository.Object); var configuration = new Mock <IConfiguration>(); configuration.Setup(c => c["DataImport:Path"]).Returns(".\\Assemblies\\DataImport"); areaLogic = new AreaLogic(unitOfWork.Object); topicLogic = new TopicLogic(unitOfWork.Object); typeLogic = new TypeReqLogic(unitOfWork.Object); importLogic = new ImportLogic(unitOfWork.Object, configuration.Object, areaLogic, topicLogic, typeLogic); }
/// <summary> /// 操作区域信息 /// </summary> /// <param name="areaEntity"></param> /// <param name="keyValue"></param> public void SubmitForm(AreaEntity areaEntity, string keyValue) { if (!string.IsNullOrEmpty(keyValue))//编辑区域信息 { areaEntity.Modify(keyValue); ResultClass <int> _ret = service.Update(areaEntity); if (!_ret.Result) { throw new Exception(_ret.ErrorMessage); } } else//新增区域信息 { areaEntity.Create(); ResultClass <int> _ret = service.Insert(areaEntity); if (!_ret.Result) { throw new Exception(_ret.ErrorMessage); } } }
public static List <IArea> GetAreaByLocation(int locId) { string strExecution = "[common].[uspGetAreaByLocation]"; List <IArea> lstArea = new List <IArea>(); using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddIntegerParam("@LocId", locId); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { IArea area = new AreaEntity(reader); lstArea.Add(area); } reader.Close(); } return(lstArea); }
/// <summary> /// 保存行政区域 /// </summary> /// <param name="model">信息体</param> /// <returns></returns> public bool SubmitModule(AreaEntity model) { //保存失败 if (model == null) { return(false); } if (!string.IsNullOrEmpty(model.Sid) && model.Sid.Length > 32) { AreaEntity moduleEntity = _service.GetSingle(model.Sid); if (moduleEntity != null) { model.CreateDate = moduleEntity.CreateDate; model.EditDate = DateTime.Now; model.IsDelete = moduleEntity.IsDelete; } } _service.SaveFrom(model); return(true); }
public async Task <ActionResult> SubmitForm(AreaEntity areaEntity, string keyValue) { if (areaEntity.F_ParentId == "0") { areaEntity.F_Layers = 1; } else { areaEntity.F_Layers = (await _areaService.GetForm(areaEntity.F_ParentId)).F_Layers + 1; } try { await _areaService.SubmitForm(areaEntity, keyValue); return(await Success("操作成功。", "", keyValue)); } catch (Exception ex) { return(await Error(ex.Message, "", keyValue)); } }
/// <summary> /// 类别面包屑格式-类别名称 /// </summary> /// <param name="area">类别</param> /// <param name="separator">分隔符号</param> /// <returns>面包屑格式</returns> public virtual string GetFormattedBreadCrumb(AreaEntity area, List <AreaEntity> areList, string separator = ">>") { if (area == null) { throw new ArgumentNullException("element"); } string result = string.Empty; var alreadyProcessedElementIds = new List <string>() { }; Stopwatch sw = new Stopwatch(); sw.Start(); while (area != null && //not null // !area.Deleted && //not deleted !alreadyProcessedElementIds.Contains(area.AreaUUID)) //prevent circular references { if (String.IsNullOrEmpty(result)) { result = area.ChineseName; } else { result = string.Format("{0} {1} {2}", area.ChineseName, separator, result); } alreadyProcessedElementIds.Add(area.AreaUUID); if (area.AreaType == 9) { break; } area = areList.Find(a => a.Code == area.ParentCode); } sw.Stop(); var roomTotal = sw.ElapsedMilliseconds; return(result); }
private string GetXml(AreaEntity entity) { var flag = entity.SyncVersion == 0 ? "C" : "U"; //增|删|改,C|D|U if (entity.Deleted) { flag = "D"; } var xmlBuilder = new StringBuilder("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); xmlBuilder.Append("<Tpp2Fpp>"); xmlBuilder.Append("<ReqHeader>"); xmlBuilder.AppendFormat("<ReqSeqNo>{0}</ReqSeqNo>", Utils.MakeRndName()); xmlBuilder.AppendFormat("<ReqSPID>{0}</ReqSPID>", DESHelper.Encrypt3Des(Constant.LkbAccount, Constant.DescKeyBytes)); xmlBuilder.AppendFormat("<ReqCode>{0}</ReqCode>", DESHelper.Encrypt3Des(Constant.LkbPassword, Constant.DescKeyBytes)); xmlBuilder.Append("</ReqHeader>"); xmlBuilder.Append("<ReqBody>"); xmlBuilder.Append("<area>"); xmlBuilder.AppendFormat("<uuid>{0}</uuid>", entity.AreaUUID); xmlBuilder.AppendFormat("<cusr>{0}</cusr>", Constant.LkbAccount); xmlBuilder.AppendFormat("<state>{0}</state>", entity.Status); xmlBuilder.AppendFormat("<cdate>{0}</cdate>", entity.CreateTime.ToString("yyyyMMddHHmmss")); xmlBuilder.AppendFormat("<udate>{0}</udate>", entity.UpdateTime.ToString("yyyyMMddHHmmss")); xmlBuilder.AppendFormat("<order>{0}</order>", entity.OrderID); xmlBuilder.AppendFormat("<code>{0}</code>", entity.Code); xmlBuilder.AppendFormat("<cname>{0}</cname>", entity.ChineseName); xmlBuilder.AppendFormat("<ename>{0}</ename>", entity.EnglishName); xmlBuilder.AppendFormat("<areacode>{0}</areacode>", entity.AreaCode); xmlBuilder.AppendFormat("<type>{0}</type>", entity.AreaType); xmlBuilder.AppendFormat("<remark>{0}</remark>", entity.Remark); xmlBuilder.AppendFormat("<keycode>{0}</keycode>", entity.KeyCode); xmlBuilder.AppendFormat("<keycode1>{0}</keycode1>", entity.KeyCode1); xmlBuilder.AppendFormat("<ifparent>{0}</ifparent>", entity.IsParent); xmlBuilder.AppendFormat("<flag>{0}</flag>", flag); xmlBuilder.Append("</area>"); xmlBuilder.Append("</ReqBody> "); xmlBuilder.Append("</Tpp2Fpp> "); return(xmlBuilder.ToString()); }
public static int Add(AreaEntity entity) { try { string query; query = $@" INSERT INTO area ( empresa_id, usuario_id, nombre, fecha_de_registro, is_activo ) VALUES ( @EmpresaId, @UsuarioId, @Nombre, NOW(), 1 ); SELECT LAST_INSERT_ID();"; using (var db = new MySqlConnection(Conexion.CadenaDeConexion)) { entity.Id = db.Query <int>(query, new { EmpresaId = entity.EmpresaId, UsuarioId = entity.UsuarioId, Nombre = entity.Nombre }).FirstOrDefault(); } return(entity.Id); } catch (Exception) { throw; } }
public ActionResult Edit(AreaDto model) { var resultModel = new RespResultCountViewModel(); try { if (string.IsNullOrEmpty(model.AreaId)) { resultModel.code = -1; resultModel.msg = "修改失败!,原因:AreaId是空"; return(Ok(resultModel)); } if (model.ParentId == null) { model.ParentId = "0"; } AreaEntity areaEntity = _mapper.Map <AreaEntity>(model); areaEntity.ModifyDate = DateTime.Now; areaEntity.ModifyUserId = User.GetCurrentUserId(); areaEntity.ModifyUserName = User.GetCurrentUserName(); bool result = _areaService.Update(areaEntity); if (result) { resultModel.code = 0; resultModel.msg = "修改成功"; } else { resultModel.code = -1; resultModel.msg = "修改失败!原因:根据主键没有找到要处理的数据"; } return(Ok(resultModel)); } catch (Exception ex) { resultModel.code = -1; resultModel.msg = "修改失败!原因:" + ex.ToString(); return(Ok(resultModel)); } }
public HttpResponseMessage Post([FromBody]AreaModel model) { AreaEntity father = null; if (model.Parent != null && model.Parent.Id > 0) { father = _areaService.GetAreaById(model.Parent.Id); } var entity = new AreaEntity { CodeId = model.Codeid, AddDate = DateTime.Now, //Parent = model.Parent, Parent = father, Name = model.Name, }; if (_areaService.Create(entity).Id > 0) { return PageHelper.toJson(PageHelper.ReturnValue(true, "添加成功!")); } return PageHelper.toJson(PageHelper.ReturnValue(false, "添加失败!")); }