public string AddArea(string id, string areaId, string areaTypeId, string areaName, string parentId, string zip, string createUserId) { #region 构造要新增的对象 if (string.IsNullOrEmpty(id) || id == Guid.Empty.ToString()) { id = Guid.NewGuid().ToString(); } Area area = new Area(); area.Id = id; area.AreaId = areaId; area.AreaTypeId = areaTypeId; area.AreaName = areaName; area.ParentId = parentId; area.Zip = zip; area.CreateDate = DateTime.Now; area.CreateUserId = createUserId; area.LastUpdateDate = DateTime.Now; area.LastUpdateUserId = createUserId; #endregion #region 执行SQL以创建对象 AreaManager manager = new AreaManager(); string sqlCreate = manager.GetCreateSql(area); using (DbOperator dbOperator = new DbOperator(ConnString)) { try { dbOperator.BeginTran(); dbOperator.ExecSql(sqlCreate); dbOperator.CommintTran(); return id; } catch (Exception ex) { dbOperator.RollbackTran(); throw new FacadeException("新增区域发生异常 - ", ex); } } #endregion }
public void UpdateArea(string areaId, string areaTypeId, string areaName, string parentId, string zip, string updateUserId) { #region 构造要修改的对象 Area area = new Area(); area.AreaTypeId = areaTypeId; area.AreaName = areaName; area.ParentId = parentId; area.Zip = zip; area.LastUpdateDate = DateTime.Now; area.LastUpdateUserId = updateUserId; #endregion #region 执行SQL以修改对象 AreaManager manager = new AreaManager(); string sqlUpdate = manager.GetUpdateSql(area); sqlUpdate += string.Format("WHERE [AreaId] = N'{0}'", areaTypeId); using (DbOperator dbOperator = new DbOperator(ConnString)) { try { dbOperator.BeginTran(); dbOperator.ExecSql(sqlUpdate); dbOperator.CommintTran(); } catch (Exception ex) { dbOperator.RollbackTran(); throw new FacadeException("修改区域发生异常 - ", ex); } } #endregion }