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