Exemplo n.º 1
0
 /// <summary>
 /// 设置实体
 /// </summary>
 /// <param name="sqlBuilder">SQL语句生成器</param>
 /// <param name="piOrganizeEntity">实体</param>
 private void SetEntity(SQLBuilder sqlBuilder, PiOrganizeEntity piOrganizeEntity)
 {
     sqlBuilder.SetValue(PiOrganizeTable.FieldParentId, piOrganizeEntity.ParentId);
     sqlBuilder.SetValue(PiOrganizeTable.FieldCode, piOrganizeEntity.Code);
     sqlBuilder.SetValue(PiOrganizeTable.FieldShortName, piOrganizeEntity.ShortName);
     sqlBuilder.SetValue(PiOrganizeTable.FieldFullName, piOrganizeEntity.FullName);
     sqlBuilder.SetValue(PiOrganizeTable.FieldCategory, piOrganizeEntity.Category);
     sqlBuilder.SetValue(PiOrganizeTable.FieldOuterPhone, piOrganizeEntity.OuterPhone);
     sqlBuilder.SetValue(PiOrganizeTable.FieldInnerPhone, piOrganizeEntity.InnerPhone);
     sqlBuilder.SetValue(PiOrganizeTable.FieldFax, piOrganizeEntity.Fax);
     sqlBuilder.SetValue(PiOrganizeTable.FieldPostalcode, piOrganizeEntity.Postalcode);
     sqlBuilder.SetValue(PiOrganizeTable.FieldAddress, piOrganizeEntity.Address);
     sqlBuilder.SetValue(PiOrganizeTable.FieldWeb, piOrganizeEntity.Web);
     sqlBuilder.SetValue(PiOrganizeTable.FieldManagerId, piOrganizeEntity.ManagerId);
     sqlBuilder.SetValue(PiOrganizeTable.FieldManager, piOrganizeEntity.Manager);
     sqlBuilder.SetValue(PiOrganizeTable.FieldLayer, piOrganizeEntity.Layer);
     sqlBuilder.SetValue(PiOrganizeTable.FieldAssistantManagerId, piOrganizeEntity.AssistantManagerId);
     sqlBuilder.SetValue(PiOrganizeTable.FieldAssistantManager, piOrganizeEntity.AssistantManager);
     sqlBuilder.SetValue(PiOrganizeTable.FieldIsInnerOrganize, piOrganizeEntity.IsInnerOrganize);
     sqlBuilder.SetValue(PiOrganizeTable.FieldEnabled, piOrganizeEntity.Enabled);
     sqlBuilder.SetValue(PiOrganizeTable.FieldBank, piOrganizeEntity.Bank);
     sqlBuilder.SetValue(PiOrganizeTable.FieldBankAccount, piOrganizeEntity.BankAccount);
     sqlBuilder.SetValue(PiOrganizeTable.FieldSortCode, piOrganizeEntity.SortCode);
     sqlBuilder.SetValue(PiOrganizeTable.FieldDescription, piOrganizeEntity.Description);
     sqlBuilder.SetValue(PiOrganizeTable.FieldModifiedUserId, piOrganizeEntity.ModifiedUserId);
     sqlBuilder.SetValue(PiOrganizeTable.FieldModifiedBy, piOrganizeEntity.ModifiedBy);
 }
Exemplo n.º 2
0
        /// <summary>
        /// 更新实体
        /// </summary>
        /// <param name="piOrganizeEntity">实体</param>
        public int UpdateEntity(PiOrganizeEntity piOrganizeEntity)
        {
            SQLBuilder sqlBuilder = new SQLBuilder(DBProvider);

            sqlBuilder.BeginUpdate(this.CurrentTableName);
            this.SetEntity(sqlBuilder, piOrganizeEntity);
            sqlBuilder.SetDBNow(PiOrganizeTable.FieldModifiedOn);
            sqlBuilder.SetWhere(PiOrganizeTable.FieldId, piOrganizeEntity.Id);
            return(sqlBuilder.EndUpdate());
        }
Exemplo n.º 3
0
        /// <summary>
        /// 取得实体
        /// </summary>
        /// <param name="userInfo">用户</param>
        /// <param name="id">主鍵</param>
        /// <returns>实体</returns>
        public PiOrganizeEntity GetEntity(UserInfo userInfo, string id)
        {
            PiOrganizeEntity entity = null;
            var parameter           = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.OrganizeService_GetEntity);

            ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider =>
            {
                var manager = new PiOrganizeManager(dbProvider, userInfo);
                entity      = manager.GetEntity(id);
            });
            return(entity);
        }
        public DataTable GetFullNameDepartment(DataTable dataTable)
        {
            foreach (DataRow dr in dataTable.Rows)
            {
                //PiOrganizeEntity subCompanyNameEntity = RDIFrameworkService.Instance.OrganizeService.GetEntity(UserInfo, dr[PiOrganizeTable.FieldParentId].ToString());
                //dr[PiOrganizeTable.FieldFullName] = subCompanyNameEntity.FullName.ToString() + "--" + dr[PiOrganizeTable.FieldFullName].ToString();
                //PiOrganizeEntity companyEntity = RDIFrameworkService.Instance.OrganizeService.GetEntity(UserInfo, subCompanyNameEntity.ParentId.ToString());
                //dr[PiOrganizeTable.FieldFullName] = companyEntity.FullName.ToString() + "--" + dr[PiOrganizeTable.FieldFullName].ToString();

                PiOrganizeEntity subCompanyNameEntity = GetEntity(dr[PiOrganizeTable.FieldParentId].ToString());
                dr[PiOrganizeTable.FieldFullName] = subCompanyNameEntity.FullName + "--" + dr[PiOrganizeTable.FieldFullName].ToString();
                PiOrganizeEntity companyEntity = GetEntity(subCompanyNameEntity.ParentId);
                dr[PiOrganizeTable.FieldFullName] = companyEntity.FullName + "--" + dr[PiOrganizeTable.FieldFullName].ToString();
            }
            return(dataTable);
        }
Exemplo n.º 5
0
        /// <summary>
        /// 更新实体
        /// </summary>
        /// <param name="userInfo">用户</param>
        /// <param name="entity">实体</param>
        /// <param name="statusMessage">返回狀態訊息</param>
        /// <returns>影响的行数</returns>
        public int Update(UserInfo userInfo, PiOrganizeEntity entity, out string statusMessage)
        {
            int    returnValue   = 0;
            string returnCode    = string.Empty;
            string returnMessage = string.Empty;
            var    parameter     = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.OrganizeService_Update);

            ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider =>
            {
                var manager   = new PiOrganizeManager(dbProvider, userInfo);
                returnValue   = manager.Update(entity, out returnCode);
                returnMessage = manager.GetStateMessage(returnCode);
            });
            statusMessage = returnMessage;
            return(returnValue);
        }
        public override int BatchSave(DataTable dataTable)
        {
            int returnValue = 0;
            PiOrganizeEntity organizeEntity = new PiOrganizeEntity();

            foreach (DataRow dataRow in dataTable.Rows)
            {
                // 删除状态
                if (dataRow.RowState == DataRowState.Deleted)
                {
                    string id = dataRow[PiOrganizeTable.FieldId, DataRowVersion.Original].ToString();
                    if (id.Length > 0)
                    {
                        returnValue += this.DeleteEntity(id);
                    }
                }
                // 被修改过
                if (dataRow.RowState == DataRowState.Modified)
                {
                    string id = dataRow[PiOrganizeTable.FieldId, DataRowVersion.Original].ToString();
                    if (id.Length > 0)
                    {
                        organizeEntity.GetFrom(dataRow);
                        returnValue += this.UpdateEntity(organizeEntity);
                    }
                }
                // 添加状态
                if (dataRow.RowState == DataRowState.Added)
                {
                    organizeEntity.GetFrom(dataRow);
                    returnValue += !string.IsNullOrEmpty(this.AddEntity(organizeEntity)) ? 1 : 0;
                }
                if (dataRow.RowState == DataRowState.Unchanged)
                {
                    continue;
                }
                if (dataRow.RowState == DataRowState.Detached)
                {
                    continue;
                }
            }
            return(returnValue);
        }
Exemplo n.º 7
0
        public int Update(PiOrganizeEntity organizeEntity, out string statusCode)
        {
            int returnValue = 0;

            string[] names  = { PiOrganizeTable.FieldParentId, PiOrganizeTable.FieldFullName, PiOrganizeTable.FieldDeleteMark };
            Object[] values = { organizeEntity.ParentId, organizeEntity.FullName, 0 };

            if (this.Exists(names, values, organizeEntity.Id))
            {
                // 名称已重复
                statusCode = StatusCode.ErrorNameExist.ToString();
            }
            else
            {
                // 检查编号是否重复
                names  = new string[] { PiOrganizeTable.FieldCode, PiOrganizeTable.FieldDeleteMark };
                values = new object[] { organizeEntity.Code, 0 };

                if (organizeEntity.Code.Length > 0 && this.Exists(names, values, organizeEntity.Id))
                {
                    // 编号已重复
                    statusCode = StatusCode.ErrorCodeExist.ToString();
                }
                else
                {
                    // 1:更新部门的信息
                    returnValue = this.UpdateEntity(organizeEntity);
                    // 2:更新组织机构时,同步更新用户表的公司、分公司、部门、子部门、工作组
                    var userManager = new PiUserManager(this.DBProvider, this.UserInfo);
                    userManager.SetProperty(new KeyValuePair <string, object>(PiUserTable.FieldCompanyId, organizeEntity.Id), new KeyValuePair <string, object>(PiUserTable.FieldCompanyName, organizeEntity.FullName));
                    userManager.SetProperty(new KeyValuePair <string, object>(PiUserTable.FieldSubCompanyId, organizeEntity.Id), new KeyValuePair <string, object>(PiUserTable.FieldSubCompanyName, organizeEntity.FullName));
                    userManager.SetProperty(new KeyValuePair <string, object>(PiUserTable.FieldDepartmentId, organizeEntity.Id), new KeyValuePair <string, object>(PiUserTable.FieldDepartmentName, organizeEntity.FullName));
                    userManager.SetProperty(new KeyValuePair <string, object>(PiUserTable.FieldSubDepartmentId, organizeEntity.Id), new KeyValuePair <string, object>(PiUserTable.FieldSubDepartmentName, organizeEntity.FullName));
                    userManager.SetProperty(new KeyValuePair <string, object>(PiUserTable.FieldWorkgroupId, organizeEntity.Id), new KeyValuePair <string, object>(PiUserTable.FieldWorkgroupName, organizeEntity.FullName));

                    statusCode = returnValue == 1 ? StatusCode.OKUpdate.ToString() : StatusCode.ErrorChanged.ToString();
                }
            }
            return(returnValue);
        }
Exemplo n.º 8
0
        public string AddEntity(PiOrganizeEntity entity)
        {
            string statusCode = string.Empty;

            return(this.AddEntity(entity, out statusCode));
        }
Exemplo n.º 9
0
        /// <summary>
        /// 添加实体
        /// </summary>
        /// <param name="piOrganizeEntity">实体</param>
        public string AddEntity(PiOrganizeEntity piOrganizeEntity, out string statusCode)
        {
            string sequence = string.Empty;

            statusCode = string.Empty;
            string[] names  = new string[] { PiOrganizeTable.FieldParentId, PiOrganizeTable.FieldFullName, PiOrganizeTable.FieldDeleteMark };
            object[] values = new object[] { piOrganizeEntity.ParentId, piOrganizeEntity.FullName, piOrganizeEntity.DeleteMark };
            if (this.Exists(names, values))
            {
                // 名称已重复
                statusCode = StatusCode.ErrorNameExist.ToString();
            }
            else
            {
                if (piOrganizeEntity.SortCode == null || piOrganizeEntity.SortCode == 0)
                {
                    CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
                    sequence = sequenceManager.GetSequence(this.CurrentTableName, sequenceManager.DefaultSequence);
                    piOrganizeEntity.SortCode = int.Parse(sequence);
                }
                this.Identity = false;
                SQLBuilder sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
                sqlBuilder.BeginInsert(this.CurrentTableName, PiOrganizeTable.FieldId);
                if (!this.Identity)
                {
                    if (String.IsNullOrEmpty(piOrganizeEntity.Id))
                    {
                        sequence            = BusinessLogic.NewGuid();
                        piOrganizeEntity.Id = sequence;
                    }
                    sqlBuilder.SetValue(PiOrganizeTable.FieldId, piOrganizeEntity.Id);
                }
                else
                {
                    if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
                    {
                        if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
                        {
                            sqlBuilder.SetFormula(PiOrganizeTable.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
                        }
                        if (DBProvider.CurrentDbType == CurrentDbType.DB2)
                        {
                            sqlBuilder.SetFormula(PiOrganizeTable.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
                        }
                    }
                    else
                    {
                        if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
                        {
                            if (piOrganizeEntity.Id == null)
                            {
                                if (string.IsNullOrEmpty(sequence))
                                {
                                    CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
                                    sequence = sequenceManager.GetSequence(this.CurrentTableName);
                                }
                                piOrganizeEntity.Id = sequence;
                            }
                            sqlBuilder.SetValue(PiOrganizeTable.FieldId, piOrganizeEntity.Id);
                        }
                    }
                }
                this.SetEntity(sqlBuilder, piOrganizeEntity);
                //if (UserInfo != null)
                //{
                //    sqlBuilder.SetValue(PiOrganizeTable.FieldCreateUserId, UserInfo.Id);
                //    sqlBuilder.SetValue(PiOrganizeTable.FieldCreateBy, UserInfo.RealName);
                //}
                sqlBuilder.SetDBNow(PiOrganizeTable.FieldCreateOn);
                sqlBuilder.SetDBNow(PiOrganizeTable.FieldModifiedOn);
                if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access))
                {
                    sequence = sqlBuilder.EndInsert().ToString();
                    // 运行成功
                    statusCode = StatusCode.OKAdd.ToString();
                }
                else
                {
                    sqlBuilder.EndInsert();
                    // 运行成功
                    statusCode = StatusCode.OKAdd.ToString();
                }
            }
            return(sequence);
        }