/// <summary> /// 转换数据,将实体类保存到数据表 /// </summary> private BaseOrganizeEntity GetEntity() { BaseOrganizeEntity entity = new BaseOrganizeEntity(); if (string.IsNullOrEmpty(this.ucParent.SelectedId)) { entity.ParentId = null; } else { entity.ParentId = this.ucParent.SelectedId; } entity.Code = this.txtCode.Text; entity.FullName = this.txtFullName.Text; entity.ShortName = this.txtShortName.Text; entity.Category = this.cmbCategory.SelectedValue.ToString(); entity.OuterPhone = this.txtOuterPhone.Text; entity.InnerPhone = this.txtInnerPhone.Text; entity.Fax = this.txtFax.Text; entity.Postalcode = this.txtPostalcode.Text; entity.Address = this.txtAddress.Text; entity.Web = this.txtWeb.Text; entity.Enabled = this.chkEnabled.Checked ? 1 : 0; entity.IsInnerOrganize = this.chkIsInnerOrganize.Checked ? 1 : 0; entity.Description = this.txtDescription.Text; entity.DeletionStateCode = 0; return(entity); }
public int Update(BaseOrganizeEntity organizeEntity, out string statusCode) { int returnValue = 0; // 检查是否已被其他人修改 //if (DbLogic.IsModifed(DbHelper, BaseOrganizeEntity.TableName, organizeEntity.Id, organizeEntity.ModifiedUserId, organizeEntity.ModifiedOn)) //{ // // 数据已经被修改 // statusCode = StatusCode.ErrorChanged.ToString(); //} //else //{ List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseOrganizeEntity.FieldParentId, organizeEntity.ParentId)); parameters.Add(new KeyValuePair <string, object>(BaseOrganizeEntity.FieldFullName, organizeEntity.FullName)); parameters.Add(new KeyValuePair <string, object>(BaseOrganizeEntity.FieldDeletionStateCode, 0)); if (this.Exists(parameters, organizeEntity.Id)) { // 名称已重复 statusCode = StatusCode.ErrorNameExist.ToString(); } else { // 检查编号是否重复 parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseOrganizeEntity.FieldCode, organizeEntity.Code)); parameters.Add(new KeyValuePair <string, object>(BaseOrganizeEntity.FieldDeletionStateCode, 0)); if (organizeEntity.Code.Length > 0 && this.Exists(parameters, organizeEntity.Id)) { // 编号已重复 statusCode = StatusCode.ErrorCodeExist.ToString(); } else { // 1:更新部门的信息 returnValue = this.UpdateEntity(organizeEntity); // 2:组织机构修改时,用户表的公司,部门,工作组数据给同步更新。 BaseUserManager userManager = new BaseUserManager(this.DbHelper, this.UserInfo); userManager.SetProperty(new KeyValuePair <string, object>(BaseUserEntity.FieldCompanyId, organizeEntity.Id), new KeyValuePair <string, object>(BaseUserEntity.FieldCompanyName, organizeEntity.FullName)); userManager.SetProperty(new KeyValuePair <string, object>(BaseUserEntity.FieldDepartmentId, organizeEntity.Id), new KeyValuePair <string, object>(BaseUserEntity.FieldDepartmentName, organizeEntity.FullName)); userManager.SetProperty(new KeyValuePair <string, object>(BaseUserEntity.FieldWorkgroupId, organizeEntity.Id), new KeyValuePair <string, object>(BaseUserEntity.FieldWorkgroupName, organizeEntity.FullName)); // 03:组织机构修改时,文件夹同步更新 BaseFolderManager folderManager = new BaseFolderManager(this.DbHelper, this.UserInfo); folderManager.SetProperty(new KeyValuePair <string, object>(BaseFolderEntity.FieldFolderName, organizeEntity.FullName), new KeyValuePair <string, object>(BaseFolderEntity.FieldId, organizeEntity.Id)); if (returnValue == 1) { statusCode = StatusCode.OKUpdate.ToString(); } else { statusCode = StatusCode.ErrorDeleted.ToString(); } } } //} return(returnValue); }
public string Add(BaseOrganizeEntity organizeEntity, out string statusCode) { string returnValue = string.Empty; // 检查是否重复 List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseOrganizeEntity.FieldParentId, organizeEntity.ParentId)); parameters.Add(new KeyValuePair <string, object>(BaseOrganizeEntity.FieldFullName, organizeEntity.FullName)); parameters.Add(new KeyValuePair <string, object>(BaseOrganizeEntity.FieldDeletionStateCode, 0)); //注意Access 的时候,类型不匹配,会出错故此将 ID 传入 if (BaseSystemInfo.UserCenterDbType == DbTypes.Access) { if (this.Exists(parameters, organizeEntity.Id)) { // 名称已重复 statusCode = StatusCode.ErrorNameExist.ToString(); } else { parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseOrganizeEntity.FieldCode, organizeEntity.Code)); parameters.Add(new KeyValuePair <string, object>(BaseOrganizeEntity.FieldDeletionStateCode, 0)); if (organizeEntity.Code.Length > 0 && this.Exists(parameters)) { // 编号已重复 statusCode = StatusCode.ErrorCodeExist.ToString(); } else { returnValue = this.AddEntity(organizeEntity); // 运行成功 statusCode = StatusCode.OKAdd.ToString(); } } } else if (this.Exists(parameters)) { // 名称已重复 statusCode = StatusCode.ErrorNameExist.ToString(); } else { parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseOrganizeEntity.FieldCode, organizeEntity.Code)); parameters.Add(new KeyValuePair <string, object>(BaseOrganizeEntity.FieldDeletionStateCode, 0)); if (organizeEntity.Code.Length > 0 && this.Exists(parameters)) { // 编号已重复 statusCode = StatusCode.ErrorCodeExist.ToString(); } else { returnValue = this.AddEntity(organizeEntity); // 运行成功 statusCode = StatusCode.OKAdd.ToString(); } } return(returnValue); }
private void btnLikeAdd_Click(object sender, EventArgs e) { BaseOrganizeEntity entity = GetEntity(); entity.Id = null; FrmOrganizeAdd frmOrganizeAdd = new FrmOrganizeAdd(entity); frmOrganizeAdd.ShowDialog(); }
/// <summary> /// 添加 /// </summary> /// <returns>添加成功</returns> private bool AddEntity() { bool returnValue = false; // 设置鼠标繁忙状态,并保留原先的状态 Cursor holdCursor = this.Cursor; this.Cursor = Cursors.WaitCursor; // 转换数据 BaseOrganizeEntity organizeEntity = this.GetEntity(); string statusCode = string.Empty; string statusMessage = string.Empty; this.EntityId = DotNetService.Instance.OrganizeService.Add(UserInfo, organizeEntity, out statusCode, out statusMessage); this.FullName = this.txtFullName.Text; if (statusCode == StatusCode.OKAdd.ToString()) { if (this.Owner != null) { if (this.Owner is FrmOrganizeAdmin) { ((FrmOrganizeAdmin)this.Owner).FormOnLoad(); } } if (BaseSystemInfo.ShowInformation) { // 添加成功,进行提示 MessageBox.Show(statusMessage, AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information); } returnValue = true; } else { MessageBox.Show(statusMessage, AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information); // 是否名称重复了,提高友善性 if (statusCode == StatusCode.ErrorNameExist.ToString()) { this.txtFullName.SelectAll(); this.txtFullName.Focus(); } else { // 是否编号重复了,提高友善性 if (statusCode == StatusCode.ErrorCodeExist.ToString()) { this.txtCode.SelectAll(); this.txtCode.Focus(); } } } // 设置鼠标默认状态,原来的光标状态 this.Cursor = holdCursor; return(returnValue); }
private int UpdataAuditStatr(string id, string categoryCode, string categoryFullName, string objectId, string objectFullName, string auditIdea, BaseWorkFlowStepEntity workFlowStepEntity) { BaseWorkFlowCurrentEntity workFlowCurrentEntity = this.GetEntity(id); workFlowCurrentEntity.CategoryCode = categoryCode; workFlowCurrentEntity.CategoryFullName = categoryFullName; workFlowCurrentEntity.ObjectId = objectId; workFlowCurrentEntity.ObjectFullName = objectFullName; workFlowCurrentEntity.WorkFlowId = workFlowStepEntity.WorkFlowId; workFlowCurrentEntity.ActivityId = workFlowStepEntity.Id; workFlowCurrentEntity.SendDate = DateTime.Now; workFlowCurrentEntity.AuditDate = DateTime.Now; workFlowCurrentEntity.AuditStatus = AuditStatus.StartAudit.ToString(); workFlowCurrentEntity.AuditStatusName = AuditStatus.StartAudit.ToDescription(); // 是否提交给组织机构审批 if (!string.IsNullOrEmpty(workFlowStepEntity.AuditDepartmentId)) { workFlowCurrentEntity.ToDepartmentId = workFlowStepEntity.AuditDepartmentId; workFlowCurrentEntity.ToDepartmentName = workFlowStepEntity.AuditDepartmentName; } // 是否提交给角色审批 if (!string.IsNullOrEmpty(workFlowStepEntity.AuditRoleId)) { workFlowCurrentEntity.ToDepartmentId = workFlowStepEntity.AuditRoleId; workFlowCurrentEntity.ToDepartmentName = workFlowStepEntity.AuditRoleRealName; } // 是否提交给用户审批 if (!string.IsNullOrEmpty(workFlowStepEntity.AuditUserId)) { BaseUserManager userManager = new BaseUserManager(UserInfo); BaseUserEntity userEntity = userManager.GetEntity(workFlowStepEntity.AuditUserId); workFlowCurrentEntity.ToUserId = workFlowStepEntity.AuditUserId; workFlowCurrentEntity.ToUserRealName = userEntity.RealName; // TODO 用户的部门信息需要处理 if (!string.IsNullOrEmpty(userEntity.DepartmentId)) { BaseOrganizeManager organizeManager = new BaseOrganizeManager(UserInfo); BaseOrganizeEntity organizeEntity = organizeManager.GetEntity(userEntity.DepartmentId); workFlowCurrentEntity.ToDepartmentId = userEntity.DepartmentId; workFlowCurrentEntity.ToDepartmentName = organizeEntity.FullName; } } // 当前审核人的信息写入当前工作流 // workFlowCurrentEntity.AuditUserId = this.UserInfo.Id; // workFlowCurrentEntity.AuditUserCode = this.UserInfo.Code; // workFlowCurrentEntity.AuditUserRealName = this.UserInfo.RealName; workFlowCurrentEntity.AuditIdea = auditIdea; workFlowCurrentEntity.AuditDate = DateTime.Now; return(this.UpdateEntity(workFlowCurrentEntity)); }
public string AddByDetail(string parentId, string code, string fullName, string category, string outerPhone, string innerPhone, string fax, bool enabled, out string statusCode) { BaseOrganizeEntity organizeEntity = new BaseOrganizeEntity(); organizeEntity.ParentId = parentId; organizeEntity.Code = code; organizeEntity.FullName = fullName; organizeEntity.Category = category; organizeEntity.OuterPhone = outerPhone; organizeEntity.InnerPhone = innerPhone; organizeEntity.Fax = fax; organizeEntity.Enabled = enabled ? 1 : 0; return(this.Add(organizeEntity, out statusCode)); }
/// <summary> /// 加载窗体 /// </summary> public override void FormOnLoad() { // 组织机构信息 this.organizeEntity = DotNetService.Instance.OrganizeService.GetEntity(UserInfo, this.EntityId); // 绑定下拉筐数据 this.BindItemDetails(); // 显示内容 this.ShowEntity(); // 获取岗位信息 this.GetRoleUser(); // 设置焦点 this.ActiveControl = this.txtFullName; this.txtCode.Focus(); }
/// <summary> /// 更新实体 /// </summary> /// <param name="organizeEntity">实体</param> public int UpdateEntity(BaseOrganizeEntity organizeEntity) { SQLBuilder sqlBuilder = new SQLBuilder(DbHelper); sqlBuilder.BeginUpdate(this.CurrentTableName); this.SetEntity(sqlBuilder, organizeEntity); if (UserInfo != null) { sqlBuilder.SetValue(BaseOrganizeEntity.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(BaseOrganizeEntity.FieldModifiedBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseOrganizeEntity.FieldModifiedOn); sqlBuilder.SetWhere(BaseOrganizeEntity.FieldId, organizeEntity.Id); return(sqlBuilder.EndUpdate()); }
/// <summary> /// 显示内容 /// </summary> public override void ShowEntity() { if (string.IsNullOrEmpty(this.EntityId)) { return; } staffEntity = DotNetService.Instance.StaffService.GetEntity(UserInfo, this.EntityId); userEntity = DotNetService.Instance.UserService.GetEntity(UserInfo, staffEntity.UserId.ToString()); // 将类转显示到页面 this.txtRealName.Tag = staffEntity.Id; this.txtRealName.Text = staffEntity.RealName; this.txtCompany.Tag = staffEntity.CompanyId; if (staffEntity.CompanyId != null) { BaseOrganizeEntity organizeEntity = DotNetService.Instance.OrganizeService.GetEntity(this.UserInfo, staffEntity.CompanyId); this.txtCompany.Text = organizeEntity.FullName; } this.txtDepartment.Tag = staffEntity.DepartmentId; if (staffEntity.DepartmentId != null) { BaseOrganizeEntity organizeEntity = DotNetService.Instance.OrganizeService.GetEntity(this.UserInfo, staffEntity.DepartmentId); this.txtDepartment.Text = organizeEntity.FullName; } this.txtDuty.Tag = staffEntity.DutyId; if (staffEntity.DutyId != null) { BaseItemDetailsEntity itemDetailsEntity = DotNetService.Instance.ItemDetailsService.GetEntity(this.UserInfo, "ItemsDuty", staffEntity.DutyId.ToString()); this.txtDuty.Text = itemDetailsEntity.ItemName; } this.txtOfficeTel.Text = staffEntity.OfficePhone; this.txtMobile.Text = staffEntity.Mobile; this.txtShortNumber.Text = staffEntity.ShortNumber; this.txtOICQ.Text = staffEntity.OICQ; this.txtEmail.Text = staffEntity.Email; this.txtDescription.Text = staffEntity.Description; this.txtSignature.Text = userEntity.Signature; // 获取图片部分,显示图片部分 string fileId = DotNetService.Instance.ParameterService.GetParameter(UserInfo, "Staff", staffEntity.Id.ToString(), "StaffPictureId"); if (!String.IsNullOrEmpty(fileId)) { this.ucPicture.PictureId = fileId; } this.btnSave.Enabled = false; this.txtOfficeTel.Focus(); }
/// <summary> /// 更新组织机构 /// </summary> /// <param name="userInfo">用户</param> /// <param name="organizeEntity">实体</param> /// <param name="statusCode">状态码</param> /// <param name="statusMessage">状态信息</param> /// <returns>影响行数</returns> public int Update(BaseUserInfo userInfo, BaseOrganizeEntity organizeEntity, out string statusCode, out string statusMessage) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif statusCode = string.Empty; statusMessage = string.Empty; int returnValue = 0; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); BaseOrganizeManager organizeManager = new BaseOrganizeManager(dbHelper, userInfo); returnValue = organizeManager.Update(organizeEntity, out statusCode); statusMessage = organizeManager.GetStateMessage(statusCode); BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.OrganizeService_Update, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(returnValue); }
public override int BatchSave(DataTable dataTable) { int returnValue = 0; BaseOrganizeEntity organizeEntity = new BaseOrganizeEntity(); foreach (DataRow dataRow in dataTable.Rows) { // 删除状态 if (dataRow.RowState == DataRowState.Deleted) { string id = dataRow[BaseOrganizeEntity.FieldId, DataRowVersion.Original].ToString(); if (id.Length > 0) { returnValue += this.DeleteEntity(id); } } // 被修改过 if (dataRow.RowState == DataRowState.Modified) { string id = dataRow[BaseOrganizeEntity.FieldId, DataRowVersion.Original].ToString(); if (id.Length > 0) { organizeEntity.GetFrom(dataRow); returnValue += this.UpdateEntity(organizeEntity); } } // 添加状态 if (dataRow.RowState == DataRowState.Added) { organizeEntity.GetFrom(dataRow); returnValue += this.AddEntity(organizeEntity).Length > 0 ? 1 : 0; } if (dataRow.RowState == DataRowState.Unchanged) { continue; } if (dataRow.RowState == DataRowState.Detached) { continue; } } return(returnValue); }
/// <summary> /// 获取实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主键</param> /// <returns>实体</returns> public BaseOrganizeEntity GetEntity(BaseUserInfo userInfo, string id) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) BaseSystemInfo.IsAuthorized(userInfo); #endif BaseOrganizeEntity organizeEntity = null; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); BaseOrganizeManager organizeManager = new BaseOrganizeManager(dbHelper, userInfo); organizeEntity = organizeManager.GetEntity(id); BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.OrganizeService_GetEntity, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(organizeEntity); }
/// <summary> /// 设置实体 /// </summary> /// <param name="organizeEntity">实体</param> private void SetEntity(SQLBuilder sqlBuilder, BaseOrganizeEntity organizeEntity) { sqlBuilder.SetValue(BaseOrganizeEntity.FieldParentId, organizeEntity.ParentId); sqlBuilder.SetValue(BaseOrganizeEntity.FieldCode, organizeEntity.Code); sqlBuilder.SetValue(BaseOrganizeEntity.FieldShortName, organizeEntity.ShortName); sqlBuilder.SetValue(BaseOrganizeEntity.FieldFullName, organizeEntity.FullName); sqlBuilder.SetValue(BaseOrganizeEntity.FieldCategory, organizeEntity.Category); sqlBuilder.SetValue(BaseOrganizeEntity.FieldOuterPhone, organizeEntity.OuterPhone); sqlBuilder.SetValue(BaseOrganizeEntity.FieldInnerPhone, organizeEntity.InnerPhone); sqlBuilder.SetValue(BaseOrganizeEntity.FieldFax, organizeEntity.Fax); sqlBuilder.SetValue(BaseOrganizeEntity.FieldPostalcode, organizeEntity.Postalcode); sqlBuilder.SetValue(BaseOrganizeEntity.FieldAddress, organizeEntity.Address); sqlBuilder.SetValue(BaseOrganizeEntity.FieldWeb, organizeEntity.Web); sqlBuilder.SetValue(BaseOrganizeEntity.FieldIsInnerOrganize, organizeEntity.IsInnerOrganize); sqlBuilder.SetValue(BaseOrganizeEntity.FieldBank, organizeEntity.Bank); sqlBuilder.SetValue(BaseOrganizeEntity.FieldBankAccount, organizeEntity.BankAccount); sqlBuilder.SetValue(BaseOrganizeEntity.FieldDeletionStateCode, organizeEntity.DeletionStateCode); sqlBuilder.SetValue(BaseOrganizeEntity.FieldEnabled, organizeEntity.Enabled); sqlBuilder.SetValue(BaseOrganizeEntity.FieldSortCode, organizeEntity.SortCode); sqlBuilder.SetValue(BaseOrganizeEntity.FieldDescription, organizeEntity.Description); SetEntityExpand(sqlBuilder, organizeEntity); }
/// <summary> /// 获取实体 /// </summary> /// <param name="id">主键</param> public BaseOrganizeEntity GetEntity(string id) { BaseOrganizeEntity organizeEntity = new BaseOrganizeEntity(this.GetDataTable(new KeyValuePair <string, object>(BaseOrganizeEntity.FieldId, id))); return(organizeEntity); }
/// <summary> /// 设置实体 /// </summary> /// <param name="organizeEntity">实体</param> partial void SetEntityExpand(SQLBuilder sqlBuilder, BaseOrganizeEntity organizeEntity) { sqlBuilder.SetValue(BaseOrganizeEntity.FieldLayer, organizeEntity.Layer); }
/// <summary> /// 添加实体 /// </summary> /// <param name="organizeEntity">实体</param> public string AddEntity(BaseOrganizeEntity organizeEntity) { string sequence = string.Empty; if (organizeEntity.SortCode == 0) { BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); organizeEntity.SortCode = int.Parse(sequence); } SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId); sqlBuilder.BeginInsert(this.CurrentTableName, BaseOrganizeEntity.FieldId); if (!this.Identity) { sqlBuilder.SetValue(BaseOrganizeEntity.FieldId, organizeEntity.Id); } else { if (!this.ReturnId && (DbHelper.CurrentDbType == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.DB2)) { if (DbHelper.CurrentDbType == DbTypes.Oracle) { sqlBuilder.SetFormula(BaseOrganizeEntity.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL "); } if (DbHelper.CurrentDbType == DbTypes.DB2) { sqlBuilder.SetFormula(BaseOrganizeEntity.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper()); } } else { if (this.Identity && (DbHelper.CurrentDbType == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.DB2)) { if (organizeEntity.Id == null) { if (string.IsNullOrEmpty(sequence)) { BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); } organizeEntity.Id = int.Parse(sequence); } sqlBuilder.SetValue(BaseOrganizeEntity.FieldId, organizeEntity.Id); } } } this.SetEntity(sqlBuilder, organizeEntity); if (UserInfo != null) { sqlBuilder.SetValue(BaseOrganizeEntity.FieldCreateUserId, UserInfo.Id); sqlBuilder.SetValue(BaseOrganizeEntity.FieldCreateBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseOrganizeEntity.FieldCreateOn); if (UserInfo != null) { sqlBuilder.SetValue(BaseOrganizeEntity.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(BaseOrganizeEntity.FieldModifiedBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseOrganizeEntity.FieldModifiedOn); if (DbHelper.CurrentDbType == DbTypes.SqlServer && this.Identity) { sequence = sqlBuilder.EndInsert().ToString(); } else { sqlBuilder.EndInsert(); } return(sequence); }
/// <summary> /// 更新 /// </summary> /// <param name="organizeEntity">实体</param> public int Update(BaseOrganizeEntity organizeEntity) { return(this.UpdateEntity(organizeEntity)); }
public FrmOrganizeAdd(BaseOrganizeEntity entity) : this() { this.organizeEntity = entity; }
/// <summary> /// 添加 /// </summary> /// <param name="organizeEntity">实体</param> /// <returns>主键</returns> public string Add(BaseOrganizeEntity organizeEntity) { return(this.AddEntity(organizeEntity)); }
/// <summary> /// 下个流程发送给谁 /// </summary> /// <param name="id">当前主键</param> /// <returns>影响行数</returns> private int StepAuditTransmit(string currentId, string workFlowCategory, string sendToId, string auditIdea) { BaseWorkFlowCurrentEntity workFlowCurrentEntity = this.GetEntity(currentId); // 1.记录当前的审核时间、审核人信息 workFlowCurrentEntity.ToDepartmentId = this.UserInfo.DepartmentId; workFlowCurrentEntity.ToDepartmentName = this.UserInfo.DepartmentName; workFlowCurrentEntity.ToUserId = this.UserInfo.Id; workFlowCurrentEntity.ToUserRealName = this.UserInfo.RealName; workFlowCurrentEntity.AuditStatus = AuditStatus.Transmit.ToString(); workFlowCurrentEntity.AuditStatusName = AuditStatus.Transmit.ToDescription(); // 2.记录审核日志 this.AddHistory(workFlowCurrentEntity); // 3.上一个审核结束了,新的审核又开始了,更新待审核情况 workFlowCurrentEntity.AuditUserId = this.UserInfo.Id; workFlowCurrentEntity.AuditUserRealName = this.UserInfo.RealName; workFlowCurrentEntity.AuditDate = DateTime.Now; workFlowCurrentEntity.AuditIdea = auditIdea; // 是否提交给部门审批 if (workFlowCategory.Equals("ByOrganize")) { BaseOrganizeManager organizeManager = new BaseOrganizeManager(UserInfo); BaseOrganizeEntity organizeEntity = organizeManager.GetEntity(sendToId); // 设置审批部门主键 workFlowCurrentEntity.ToDepartmentId = sendToId; // 设置审批部门名称 workFlowCurrentEntity.ToDepartmentName = organizeEntity.FullName; } // 是否提交给角色审批 if (workFlowCategory.Equals("ByRole")) { BaseRoleManager roleManger = new BaseRoleManager(this.UserInfo); BaseRoleEntity roleEntity = roleManger.GetEntity(sendToId); // 设置审批角色主键 workFlowCurrentEntity.ToRoleId = sendToId; // 设置审批角色名称 workFlowCurrentEntity.ToRoleRealName = roleEntity.RealName; } // 是否提交给用户审批 if (workFlowCategory.Equals("ByUser")) { BaseUserManager userManager = new BaseUserManager(UserInfo); BaseUserEntity userEntity = userManager.GetEntity(sendToId); // 设置审批用户主键 workFlowCurrentEntity.ToUserId = sendToId; // 设置审批用户名称 workFlowCurrentEntity.ToUserRealName = userEntity.RealName; // TODO 用户的部门信息需要处理 if (!string.IsNullOrEmpty(userEntity.DepartmentId)) { BaseOrganizeManager organizeManager = new BaseOrganizeManager(UserInfo); BaseOrganizeEntity organizeEntity = organizeManager.GetEntity(userEntity.DepartmentId); workFlowCurrentEntity.ToDepartmentId = userEntity.DepartmentId; workFlowCurrentEntity.ToDepartmentName = organizeEntity.FullName; } } workFlowCurrentEntity.AuditStatus = AuditStatus.WaitForAudit.ToString(); workFlowCurrentEntity.AuditStatusName = AuditStatus.WaitForAudit.ToDescription(); // 当前审核人的信息写入当前工作流 workFlowCurrentEntity.Enabled = 0; workFlowCurrentEntity.DeletionStateCode = 0; return(this.UpdateEntity(workFlowCurrentEntity)); }
/// <summary> /// 添加 /// </summary> /// <param name="organizeEntity">实体</param> /// <param name="identity">自增量方式</param> /// <param name="returnId">返回主鍵</param> /// <returns>主键</returns> public string Add(BaseOrganizeEntity organizeEntity, bool identity, bool returnId) { this.Identity = identity; this.ReturnId = returnId; return(this.AddEntity(organizeEntity)); }
partial void SetEntityExpand(SQLBuilder sqlBuilder, BaseOrganizeEntity organizeEntity);