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, "添加失败！"));
}
