Ejemplo n.º 1
0
        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
        }
Ejemplo n.º 2
0
        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
        }