/// <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);
