/// <summary>
/// 流程完成时
/// 结束审核时，需要回调写入到表里，调用相应的事件
/// 若成功可以执行完成的处理
/// </summary>
/// <param name="workFlowCurrentEntity">当前审批流程</param>
/// <returns>成功失败</returns>
public override bool OnAuditComplete(BaseWorkFlowCurrentEntity workFlowCurrentEntity)
{
// 审核通过后，需要把有效状态修改过来
BaseWorkFlowCurrentManager workFlowCurrentManager = new BaseWorkFlowCurrentManager(this.UserInfo);
//string objectId = workFlowCurrentManager.GetObject(workFlowCurrentEntity.Id).ObjectId;
string objectId = workFlowCurrentEntity.ObjectId;
if (!string.IsNullOrEmpty(objectId))
{
// 这里写自己的方法(审核 过程中的回调),完成审核时
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.BusinessDbType, BaseSystemInfo.BusinessDbConnection))
{
dbHelper.Open();
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
switch (workFlowCurrentEntity.CategoryCode)
{
case "PuTongCaiGouDan":
case "GuoNeiCaiGouHeTong":
case "PutongCaiGouDanDGM":
case "PutongCaiGouDanManager":
sqlBuilder.BeginUpdate("WL物品申购");
sqlBuilder.SetValue("AuditStatus", AuditStatus.AuditComplete.ToString());
sqlBuilder.SetValue("审核", 1);
sqlBuilder.SetDBNow("审核日期");
sqlBuilder.SetValue("审核员", BaseSystemInfo.UserInfo.Code);
sqlBuilder.SetWhere("申请单号", objectId);
sqlBuilder.EndUpdate();
break;
case "YuanFuCaiLiaoShenQingDan":
sqlBuilder.BeginUpdate("WL部门物品申购");
sqlBuilder.SetValue("AuditStatus", AuditStatus.AuditComplete.ToString());
sqlBuilder.SetValue("审核", 1);
sqlBuilder.SetValue("总审核", 1);
sqlBuilder.SetDBNow("审核日期");
sqlBuilder.SetDBNow("总审核日期");
sqlBuilder.SetValue("审核员", BaseSystemInfo.UserInfo.Code);
sqlBuilder.SetWhere("申购单号", objectId);
sqlBuilder.EndUpdate();
break;
case "MoJuCaiGouHeTongP":
case "MoJuCaiGouHeTongGM":
sqlBuilder.BeginUpdate("GCMJ模具申请");
sqlBuilder.SetValue("AuditStatus", AuditStatus.AuditComplete.ToString());
sqlBuilder.SetValue("审核", 1);
sqlBuilder.SetWhere("申请单号", objectId);
sqlBuilder.EndUpdate();
break;
}
dbHelper.Close();
}
}
// 若还需要有其他处理，就这后面继续处理
return(true);
}
/// <summary>
/// (点退回时)当审核退回时
/// </summary>
/// <param name="workFlowCurrentEntity">当前审批流</param>
/// <returns>成功失败</returns>
public override bool OnAuditReject(BaseWorkFlowCurrentEntity workFlowCurrentEntity)
{
string objectId = workFlowCurrentEntity.ObjectId;
if (!string.IsNullOrEmpty(objectId))
{
// 这里写自己的方法(审核 过程中的回调),退回审核时
IDbHelper dbHelper = new DotNet.Utilities.SqlHelper(BaseSystemInfo.BusinessDbConnection);
dbHelper.Open();
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
//sqlBuilder.BeginUpdate("WL物品申购");
//sqlBuilder.SetDBNow("审核日期");
//sqlBuilder.SetValue("审核员", BaseSystemInfo.UserInfo.Code);
//sqlBuilder.SetValue("AuditStatus", AuditStatus.AuditReject.ToString());
//sqlBuilder.SetWhere("申请单号", objectId);
//sqlBuilder.EndUpdate();
switch (workFlowCurrentEntity.CategoryCode)
{
case "PuTongCaiGouDan":
case "GuoNeiCaiGouHeTong":
case "PutongCaiGouDanDGM":
case "PutongCaiGouDanManager":
sqlBuilder.BeginUpdate("WL物品申购");
sqlBuilder.SetDBNow("审核日期");
sqlBuilder.SetValue("审核员", BaseSystemInfo.UserInfo.Code);
sqlBuilder.SetValue("AuditStatus", AuditStatus.AuditReject.ToString());
sqlBuilder.SetWhere("申请单号", objectId);
sqlBuilder.EndUpdate();
break;
case "YuanFuCaiLiaoShenQingDan":
sqlBuilder.BeginUpdate("WL部门物品申购");
sqlBuilder.SetValue("AuditStatus", AuditStatus.AuditReject.ToString());
sqlBuilder.SetWhere("申购单号", objectId);
sqlBuilder.EndUpdate();
break;
case "MoJuCaiGouHeTongP":
case "MoJuCaiGouHeTongGM":
sqlBuilder.BeginUpdate("GCMJ模具申请");
sqlBuilder.SetValue("AuditStatus", AuditStatus.AuditReject.ToString());
sqlBuilder.SetWhere("申请单号", objectId);
sqlBuilder.EndUpdate();
break;
}
dbHelper.Close();
}
return(true);
}
/// <summary>
/// 设置对象，若不存在就增加，有存在就更新
/// </summary>
/// <param name="entity">实体</param>
/// <returns>更新、添加成功？</returns>
public bool SetObject(BaseUserContactEntity entity)
{
bool result = false;
// 若有主键就是先更新，没主键就是添加
if (!string.IsNullOrEmpty(entity.Id))
{
result = this.Update(entity) > 0;
// 若不存在，就是添加的意思
if (!result)
{
// 更新不成功表示没数据，需要添加数据，这时候要注意主键不能出错
result = !string.IsNullOrEmpty(this.Add(entity));
}
}
else
{
// 若没有主键就是添加数据
result = !string.IsNullOrEmpty(this.Add(entity));
}
// 2016-01-20 吉日嘎拉， 用户的联系方式修改后，要把用户的修改时间也修改，这样才会同步下载用户的信息，用户的联系方式
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(BaseUserEntity.TableName);
sqlBuilder.SetDBNow(BaseUserEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseUserEntity.FieldId, entity.Id);
sqlBuilder.EndUpdate();
return(result);
}
/// <summary>
/// 解除手机认证帮定
/// </summary>
/// <param name="userInfo">用户</param>
/// <returns>影响行数</returns>
public int RemoveMobileBinding(string mobile)
{
int result = 0;
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetNull(BaseUserContactEntity.FieldMobile);
sqlBuilder.SetWhere(BaseUserContactEntity.FieldMobile, mobile);
result = sqlBuilder.EndUpdate();
/*
* // 把主库的数据库认证也去掉
* string connectionString = ConfigurationHelper.AppSettings("K8Connection", BaseSystemInfo.EncryptDbConnection);
* if (!string.IsNullOrEmpty(connectionString))
* {
* IDbHelper dbHelper = DbHelperFactory.GetHelper(CurrentDbType.Oracle, connectionString);
* string commandText = string.Format(@"UPDATE TAB_USER
* SET Mobile = null
* WHERE Id = {0} "
* , dbHelper.GetParameter("Mobile"));
* dbHelper.ExecuteNonQuery(commandText, new IDbDataParameter[] {
* dbHelper.MakeParameter("Mobile", mobile)
* });
* }
*/
return(result);
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public int UpdateObject(BaseOrganizeEntity entity)
{
int result = 0;
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetObject(sqlBuilder, entity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseOrganizeEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseOrganizeEntity.FieldModifiedBy, UserInfo.RealName);
}
// 若有修改时间标示，那就按修改时间来，不是按最新的时间来
if (entity.ModifiedOn.HasValue)
{
sqlBuilder.SetValue(BaseOrganizeEntity.FieldModifiedOn, entity.ModifiedOn.Value);
}
else
{
sqlBuilder.SetDBNow(BaseOrganizeEntity.FieldModifiedOn);
}
sqlBuilder.SetWhere(BaseOrganizeEntity.FieldId, entity.Id);
result = sqlBuilder.EndUpdate();
return(result);
}
//
// 重置序列(暂不考虑并发问题)
//
#region public int Reset(string[] ids) 批量重置
/// <summary>
/// 批量重置
/// </summary>
/// <param name="ids">主键数组</param>
/// <returns>影响行数</returns>
public int Reset(string[] ids)
{
int returnValue = 0;
BaseSequenceEntity sequenceEntity = null;
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
for (int i = 0; i < ids.Length; i++)
{
if (ids[i].Length > 0)
{
// 若有相应的表，那就把序列号都计算好
sequenceEntity = this.GetEntity(ids[i]);
string commandText = string.Format(@" UPDATE BaseSequence
SET Sequence = (SELECT MAX(SortCode) + 1 AS MaxSortCode FROM {0})
, Reduction = ( SELECT MIN(SortCode) -1 AS MinSortCode FROM {0})
WHERE FullName = '{0}' ", sequenceEntity.FullName);
try
{
this.ExecuteNonQuery(commandText);
}
catch
{
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetValue(BaseSequenceEntity.FieldSequence, this.DefaultSequence);
sqlBuilder.SetValue(BaseSequenceEntity.FieldReduction, this.DefaultReduction);
sqlBuilder.SetWhere(BaseSequenceEntity.FieldId, ids[i]);
returnValue += sqlBuilder.EndUpdate();
}
}
}
return(returnValue);
}
/// <summary>
/// 批量更新通讯地址
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="result">数据表</param>
/// <returns>影响行数</returns>
public int BatchUpdateAddress(BaseUserInfo userInfo, DataTable dt)
{
int result = 0;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) =>
{
// 这里是只更新部分字段的例子
foreach (DataRow dr in dt.Rows)
{
var sqlBuilder = new SQLBuilder(dbHelper);
sqlBuilder.BeginUpdate(BaseStaffEntity.TableName);
// 这里是界面上显示的字段，需要更新的字段
sqlBuilder.SetValue(BaseStaffEntity.FieldOfficePhone, dr[BaseStaffEntity.FieldOfficePhone].ToString());
sqlBuilder.SetValue(BaseStaffEntity.FieldExtension, dr[BaseStaffEntity.FieldExtension].ToString());
sqlBuilder.SetValue(BaseStaffEntity.FieldMobile, dr[BaseStaffEntity.FieldMobile].ToString());
sqlBuilder.SetValue(BaseStaffEntity.FieldShortNumber, dr[BaseStaffEntity.FieldShortNumber].ToString());
sqlBuilder.SetValue(BaseStaffEntity.FieldEmail, dr[BaseStaffEntity.FieldEmail].ToString());
sqlBuilder.SetValue(BaseStaffEntity.FieldQQ, dr[BaseStaffEntity.FieldQQ].ToString());
sqlBuilder.SetValue(BaseStaffEntity.FieldDescription, dr[BaseStaffEntity.FieldDescription].ToString());
sqlBuilder.SetWhere(BaseStaffEntity.FieldId, dr[BaseStaffEntity.FieldId].ToString());
result += sqlBuilder.EndUpdate();
}
});
return(result);
}
public int Update(string id, string folderId, string fileName, string description, bool enabled, out string statusCode)
{
statusCode = string.Empty;
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetValue(BaseFileEntity.FieldFolderId, folderId);
sqlBuilder.SetValue(BaseFileEntity.FieldFileName, fileName);
sqlBuilder.SetValue(BaseFileEntity.FieldEnabled, enabled);
sqlBuilder.SetValue(BaseFileEntity.FieldDescription, description);
sqlBuilder.SetValue(BaseFileEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseFileEntity.FieldModifiedBy, UserInfo.RealName);
sqlBuilder.SetDBNow(BaseFileEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseFileEntity.FieldId, id);
int returnValue = sqlBuilder.EndUpdate();
if (returnValue > 0)
{
statusCode = StatusCode.OKUpdate.ToString();
}
else
{
statusCode = StatusCode.ErrorDeleted.ToString();
}
return(returnValue);
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public int UpdateObject(TAB_USERPOPEDOMEntity entity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetObject(sqlBuilder, entity);
sqlBuilder.SetWhere(this.PrimaryKey, entity.MENU_GUID);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新降序序列
/// </summary>
/// <param name="fullName">序列名称</param>
/// <returns>影响行数</returns>
protected int UpdateReduction(string fullName)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetFormula(BaseSequenceEntity.FieldReduction, BaseSequenceEntity.FieldReduction + " - " + BaseSequenceEntity.FieldStep);
sqlBuilder.SetWhere(BaseSequenceEntity.FieldFullName, fullName);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新处理状态
/// </summary>
/// <param name="id">评论主键</param>
/// <param name="worked">处理状态</param>
/// <returns>影响行数</returns>
public int ChageWorked(IDbHelper dbHelper, string id, bool worked)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
// sqlBuilder.SetValue(BaseCommentEntity.FieldWorked, worked ? 1 : -1);
sqlBuilder.SetWhere(BaseCommentEntity.FieldId, id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public int UpdateEntity(BaseContactTargetEntity entity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(BaseContactTargetEntity.TableName);
this.SetEntity(sqlBuilder, entity);
sqlBuilder.SetWhere(BaseContactTargetEntity.FieldId, entity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public int UpdateObject(BaseExportDataEntity entity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetObject(sqlBuilder, entity);
sqlBuilder.SetWhere(this.PrimaryKey, entity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public int UpdateObject(BaseOrganizeLogOnEntity entity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetObject(sqlBuilder, entity);
sqlBuilder.SetDBNow(BaseOrganizeLogOnEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseOrganizeLogOnEntity.FieldId, entity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public int UpdateObject(BaseMessageRecentEntity entity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetObject(sqlBuilder, entity);
sqlBuilder.SetDBNow(BaseMessageRecentEntity.FieldModifiedOn);
sqlBuilder.SetWhere(this.PrimaryKey, entity.Id);
return(sqlBuilder.EndUpdate());
}
private int UpdateReadCount(string id)
{
// 阅读次数要加一
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetFormula(BaseNewsEntity.FieldReadCount, BaseNewsEntity.FieldReadCount + " + 1 ");
sqlBuilder.SetWhere(BaseNewsEntity.FieldId, id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新升序序列
/// </summary>
/// <param name="fullName">序列名称</param>
/// <param name="sequenceCount">序列个数</param>
/// <returns>影响行数</returns>
protected int UpdateSequence(string fullName, int sequenceCount)
{
// 更新数据库里的值
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetFormula(BaseSequenceEntity.FieldSequence, BaseSequenceEntity.FieldSequence + " + " + sequenceCount.ToString() + " * " + BaseSequenceEntity.FieldStep);
sqlBuilder.SetWhere(BaseSequenceEntity.FieldFullName, fullName);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="workReportEntity">实体</param>
/// <returns>影响行数</returns>
public int UpdateEntity(BaseWorkReportEntity workReportEntity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(BaseWorkReportTable.TableName);
this.SetEntity(sqlBuilder, workReportEntity);
sqlBuilder.SetValue(BaseWorkReportTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetDBNow(BaseWorkReportTable.FieldModifiedOn);
sqlBuilder.SetWhere(BaseWorkReportTable.FieldId, workReportEntity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="dbHelper">数据库连接</param>
/// <param name="tableName">目标表名</param>
/// <param name="name">主键</param>
/// <param name="value">主键值</param>
/// <param name="targetField">更新字段</param>
/// <param name="targetValue">更新值</param>
/// <returns>影响行数</returns>
public static int UpdateRecord(IDbHelper dbHelper, string tableName, string name, string value, string targetField, object targetValue)
{
int result = 0;
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
sqlBuilder.BeginUpdate(tableName);
sqlBuilder.SetValue(targetField, targetValue);
sqlBuilder.SetWhere(name, value);
result = sqlBuilder.EndUpdate();
return(result);
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="noteEntity">实体对象</param>
/// <returns>影响行数</returns>
public int UpdateEntity(BaseNoteEntity noteEntity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetEntity(sqlBuilder, noteEntity);
sqlBuilder.SetValue(BaseNoteEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetDBNow(BaseNoteEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseNoteEntity.FieldId, noteEntity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 重置访问情况
/// </summary>
/// <param name="id">主键</param>
/// <returns>影响行数</returns>
private int ResetVisitInfo(string id)
{
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetNull(BaseUserLogOnEntity.FieldFirstVisit);
sqlBuilder.SetNull(BaseUserLogOnEntity.FieldPreviousVisit);
sqlBuilder.SetNull(BaseUserLogOnEntity.FieldLastVisit);
sqlBuilder.SetValue(BaseUserLogOnEntity.FieldLogOnCount, 0);
sqlBuilder.SetWhere(BaseUserLogOnEntity.FieldId, id);
return(sqlBuilder.EndUpdate());
}
public int Read(string id)
{
int result = 0;
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
// 增加阅读次数
sqlBuilder.SetFormula(BaseNewsEntity.FieldReadCount, BaseNewsEntity.FieldReadCount + " + 1");
sqlBuilder.SetWhere(BaseNewsEntity.FieldId, id);
result = sqlBuilder.EndUpdate();
return(result);
}
/// <summary>
/// 用户角色关系是否有模块权限
/// </summary>
/// <param name="roleId">角色主键</param>
/// <param name="permissionItemCode">权限编号</param>
/// <returns>有角色权限</returns>
public bool CheckPermissionByRole(string roleId, string permissionItemCode)
{
BasePermissionItemManager permissionItemManager = new BasePermissionItemManager(DbHelper, UserInfo);
string permissionItemId = permissionItemManager.GetProperty(new KeyValuePair <string, object>(BasePermissionItemEntity.FieldCode, permissionItemCode), BasePermissionItemEntity.FieldId);
// 判断当前判断的权限是否存在，否则很容易出现前台设置了权限，后台没此项权限
// 需要自动的能把前台判断过的权限，都记录到后台来
#if (DEBUG)
if (String.IsNullOrEmpty(permissionItemId))
{
BasePermissionItemEntity permissionItemEntity = new BasePermissionItemEntity();
permissionItemEntity.Code = permissionItemCode;
permissionItemEntity.FullName = permissionItemCode;
permissionItemEntity.ParentId = string.Empty;
permissionItemEntity.IsScope = 0;
permissionItemEntity.AllowDelete = 1;
permissionItemEntity.AllowEdit = 1;
permissionItemEntity.DeletionStateCode = 0;
permissionItemEntity.Enabled = 1;
// 这里是防止主键重复？
// permissionEntity.ID = BaseBusinessLogic.NewGuid();
permissionItemManager.AddEntity(permissionItemEntity);
}
else
{
// 更新最后一次访问日期，设置为当前服务器日期
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetDBNow(BasePermissionItemEntity.FieldLastCall);
sqlBuilder.SetWhere(BasePermissionItemEntity.FieldId, permissionItemId);
sqlBuilder.EndUpdate();
}
#endif
if (string.IsNullOrEmpty(permissionItemId))
{
return(false);
}
string sqlQuery = " SELECT COUNT(*) "
+ " FROM " + this.CurrentTableName
+ " WHERE " + "(" + BasePermissionEntity.FieldResourceCategory + " = '" + BaseRoleEntity.TableName + "') "
+ " AND (" + BasePermissionEntity.FieldEnabled + " = 1) "
+ " AND (" + BasePermissionEntity.FieldResourceId + " = '" + roleId + "' ) "
+ " AND (" + BasePermissionEntity.FieldPermissionItemId + " = '" + permissionItemId + "') ";
int rowCount = 0;
object returnObject = DbHelper.ExecuteScalar(sqlQuery);
if (returnObject != null)
{
rowCount = int.Parse(returnObject.ToString());
}
return(rowCount > 0);
}
//
// 设置属性部分
//
#region public static int SetProperty(IDbHelper dbHelper, string tableName, List<KeyValuePair<string, object>> whereParameters, List<KeyValuePair<string, object>> parameters) 设置属性
/// <summary>
/// 设置属性
/// </summary>
/// <param name="dbHelper">数据库连接</param>
/// <param name="tableName">目标表名</param>
/// <param name="whereParameters">条件字段,条件值</param>
/// <param name="parameters">更新字段,更新值</param>
/// <returns>影响行数</returns>
public static int SetProperty(IDbHelper dbHelper, string tableName, List <KeyValuePair <string, object> > whereParameters, List <KeyValuePair <string, object> > parameters)
{
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
sqlBuilder.BeginUpdate(tableName);
foreach (var parameter in parameters)
{
sqlBuilder.SetValue(parameter.Key, parameter.Value);
}
sqlBuilder.SetWhere(whereParameters);
// sqlBuilder.SetDBNow(FieldModifiedOn);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 离开时的日志记录
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="logId">日志主键</param>
public void WriteExit(BaseUserInfo userInfo, string logId)
{
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) =>
{
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
sqlBuilder.BeginUpdate(BaseLogEntity.TableName);
// sqlBuilder.SetDBNow(BaseLogEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseLogEntity.FieldId, logId);
sqlBuilder.EndUpdate();
});
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public int UpdateObject(BaseMessageEntity entity)
{
int result = 0;
var sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetObject(sqlBuilder, entity);
sqlBuilder.SetWhere(BaseMessageEntity.FieldId, entity.Id);
result = sqlBuilder.EndUpdate();
return(result);
}
/// <summary>
/// 替换当前步骤中的人员
/// </summary>
/// <param name="oldUserId">原来的工号</param>
/// <param name="newUserId">新的工号</param>
/// <returns>影响行数</returns>
public int ReplaceUser(string oldUserId, string newUserId)
{
BaseUserManager userManager = new BaseUserManager(this.UserInfo);
BaseUserEntity newUserEntity = userManager.GetObject(newUserId);
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetValue(BaseWorkFlowCurrentEntity.FieldToUserId, newUserEntity.Id);
sqlBuilder.SetValue(BaseWorkFlowCurrentEntity.FieldToUserRealName, newUserEntity.RealName);
sqlBuilder.SetValue(BaseWorkFlowCurrentEntity.FieldToDepartmentId, newUserEntity.DepartmentId);
sqlBuilder.SetValue(BaseWorkFlowCurrentEntity.FieldToDepartmentName, newUserEntity.DepartmentName);
sqlBuilder.SetWhere(BaseWorkFlowCurrentEntity.FieldToUserId, oldUserId, "OldUserId");
return(sqlBuilder.EndUpdate());
}
public int UpdateFile(string id, string fileName, string contents)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetValue(BaseNewsEntity.FieldTitle, fileName);
sqlBuilder.SetValue(BaseNewsEntity.FieldContents, contents);
sqlBuilder.SetValue(BaseNewsEntity.FieldFileSize, contents.Length);
sqlBuilder.SetValue(BaseNewsEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseNewsEntity.FieldModifiedBy, UserInfo.RealName);
sqlBuilder.SetDBNow(BaseNewsEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseNewsEntity.FieldId, id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public int UpdateObject(BaseRoleEntity entity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetObject(sqlBuilder, entity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseRoleEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseRoleEntity.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseRoleEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseRoleEntity.FieldId, entity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="baseWorkFlowBillTemplateEntity">实体</param>
public int UpdateEntity(BaseWorkFlowBillTemplateEntity baseWorkFlowBillTemplateEntity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetEntity(sqlBuilder, baseWorkFlowBillTemplateEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseWorkFlowBillTemplateEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseWorkFlowBillTemplateEntity.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseWorkFlowBillTemplateEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseWorkFlowBillTemplateEntity.FieldId, baseWorkFlowBillTemplateEntity.Id);
return(sqlBuilder.EndUpdate());
}
