/// <summary> /// 用户信息更新或者插入 /// </summary> /// <param name="model">用户信息</param> /// <returns>更新成功与否</returns> public static bool ModifyUserInfo(UserInfoModel model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 model.CompanyCD = userInfo.CompanyCD; //定义返回变量 bool isSucc = false; //获取登陆用户ID string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID; //待修改 //string loginUserID = "admin"; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //操作日志 LogInfoModel logModel = InitLogInfo(model.UserID); if (model.IsInsert) { try { //设置操作日志类型 新建 logModel.ObjectName = ConstUtil.CODING_RULE_TABLE_UserInfo;//操作对象 logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //执行插入操作 isSucc = UserInfoDBHelper.ModifyUserInfo(model, loginUserID); ; } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } } else { try { //设置操作日志类型 修改 logModel.ObjectName = ConstUtil.CODING_RULE_TABLE_UserInfo;//操作对象 logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //执行更新操作 isSucc = UserInfoDBHelper.ModifyUserInfo(model, loginUserID); ; } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } } //更新成功时,删除原来文件 if (isSucc) { logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; } //更新不成功 else { //设置操作成功标识 logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; } //登陆日志 LogDBHelper.InsertLog(logModel); return isSucc; }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="userID">用户ID</param> /// <param name="companyCD">公司代码</param> /// <returns>用户信息</returns> public static DataTable GetUserInfo(UserInfoModel model, int pageIndex, int pageCount, string OrderBy, ref int totalCount) { //SQL拼写 string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; string sql = "select ISNULL(IsHardValidate,1) AS IsHardValidate, isnull(UserID,'')as UserID,'' as UserName,isnull(IsRoot,0) as IsRoot,isnull(LastLoginTime,'') as LastLoginTime," + " isnull( CONVERT(CHAR(19), OpenDate, 120),'') as OpenDate ," + " isnull( CONVERT(CHAR(10), CloseDate, 23),'') as CloseDate ," + "Case WHEN LockFlag = '1' THEN '是' ELSE '否' END AS LockFlag ,Case WHEN UsedStatus = '1' THEN '启用' ELSE '停用' END AS UsedStatus,isnull( CONVERT(CHAR(19), ModifiedDate, 120),'') as ModifiedDate,ModifiedUserID,isnull(remark,'')as remark FROM officedba.UserInfo WHERE CompanyCD = '" + companyCD + "' and IsRoot!='1'"; if (!string.IsNullOrEmpty(model.UserID)) { sql += " AND UserID LIKE @UserID"; } if (!string.IsNullOrEmpty(model.LockFlag)) { if (model.LockFlag == "1") { sql += " AND LockFlag = '1'"; } else { sql += " AND LockFlag = '0'"; } } if (model.EmployeeID != 0) { sql += " AND EmployeeID = @EmployeeID"; } //开始时间输入的场合,添加为条件 if (model.OpenDate != null && model.CloseDate != null) { sql += " AND OpenDate >= @OpenDate AND CloseDate<=@CloseDate "; } else { if (model.OpenDate != null) { sql += " AND OpenDate=@OpenDate"; } //结束时间输入的场合,添加为条件 if (model.CloseDate != null) { sql += " AND CloseDate=@CloseDate"; } } if (model.IsHardValidate != null) { if (model.IsHardValidate == "1") sql += " AND ( IsHardValidate='1' OR IsHardValidate IS NULL )"; else sql += "AND IsHardValidate='0' "; } SqlParameter[] param = new SqlParameter[5]; param[0] = SqlHelper.GetParameter("@CompanyCD", companyCD); param[1] = SqlHelper.GetParameter("@UserID", "%" + model.UserID + "%"); param[2] = SqlHelper.GetParameter("@EmployeeID", model.EmployeeID); param[3] = SqlHelper.GetParameter("@OpenDate", model.OpenDate == null ? SqlDateTime.Null : SqlDateTime.Parse(model.OpenDate.ToString())); param[4] = SqlHelper.GetParameter("@CloseDate", model.CloseDate == null ? SqlDateTime.Null : SqlDateTime.Parse(model.CloseDate.ToString())); DataTable dt = SqlHelper.CreateSqlByPageExcuteSql(sql.ToString(), pageIndex, pageCount, OrderBy, param, ref totalCount); return dt; }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="userID">用户ID</param> /// <param name="companyCD">公司代码</param> /// <returns>用户信息</returns> public static DataTable GetUserInfo(UserInfoModel model, int pageIndex, int pageCount, string OrderBy, ref int totalCount) { return UserInfoDBHelper.GetUserInfo(model,pageIndex, pageCount, OrderBy, ref totalCount); }
/// <summary> /// 用户信息更新或者插入 /// </summary> /// <param name="model">用户信息</param> /// <param name="loginUserID">登陆系统的用户ID</param> /// <returns>更新成功与否</returns> public static bool ModifyUserInfo(UserInfoModel model, string loginUserID) { //SQL拼写 StringBuilder sql = new StringBuilder(); //追加的场合 if (model.IsInsert) { sql.AppendLine("INSERT INTO officedba.UserInfo"); sql.AppendLine(" (CompanyCD "); sql.AppendLine(" ,UserID "); // sql.AppendLine(" ,UserName "); sql.AppendLine(" ,password "); sql.AppendLine(" ,LockFlag "); sql.AppendLine(" ,EmployeeID "); sql.AppendLine(" ,UsedStatus "); sql.AppendLine(" ,OpenDate "); sql.AppendLine(" ,CloseDate "); sql.AppendLine(" ,ModifiedDate "); sql.AppendLine(" ,ModifiedUserID "); sql.AppendLine(" ,remark "); sql.AppendLine(",IsHardValidate)"); sql.AppendLine("VALUES "); sql.AppendLine(" (@CompanyCD "); sql.AppendLine(" ,@UserID "); // sql.AppendLine(" ,@UserName "); sql.AppendLine(" ,@password "); sql.AppendLine(" ,@LockFlag "); sql.AppendLine(" ,@EmployeeID "); sql.AppendLine(" ,@UsedStatus "); sql.AppendLine(" ,@OpenDate "); sql.AppendLine(" ,@CloseDate "); sql.AppendLine(" ,@ModifiedDate "); sql.AppendLine(" ,@ModifiedUserID"); sql.AppendLine(" ,@remark "); sql.AppendLine(",@IsHardValidate)"); } //更新的场合 else { sql.AppendLine("UPDATE officedba.UserInfo "); sql.AppendLine("SET "); // sql.AppendLine(" UserName = @UserName "); sql.AppendLine(" LockFlag = @LockFlag "); sql.AppendLine(" ,EmployeeID = @EmployeeID "); sql.AppendLine(" ,UsedStatus = @UsedStatus "); sql.AppendLine(" ,OpenDate = @OpenDate "); sql.AppendLine(" ,CloseDate = @CloseDate "); sql.AppendLine(" ,ModifiedDate = @ModifiedDate "); sql.AppendLine(" ,ModifiedUserID = @ModifiedUserID"); sql.AppendLine(" ,remark = @remark ,IsHardValidate=@IsHardValidate "); sql.AppendLine("WHERE "); sql.AppendLine(" UserID = @UserID "); sql.AppendLine(" AND CompanyCD = @CompanyCD "); } //设置参数 SqlParameter[] param; if (model.IsInsert){ param = new SqlParameter[12]; } else { param = new SqlParameter[11]; } param[0] = SqlHelper.GetParameter("@UserID", model.UserID); param[1] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD); // param[2] = SqlHelper.GetParameter("@UserName", model.UserName); param[2] = SqlHelper.GetParameter("@LockFlag", model.LockFlag); param[3] = SqlHelper.GetParameter("@OpenDate", model.OpenDate == null ? SqlDateTime.Null : SqlDateTime.Parse(model.OpenDate.ToString())); param[4] = SqlHelper.GetParameter("@CloseDate", model.CloseDate == null ? SqlDateTime.Null : SqlDateTime.Parse(model.CloseDate.ToString())); param[5] = SqlHelper.GetParameter("@ModifiedDate", DateTime.Now); param[6] = SqlHelper.GetParameter("@ModifiedUserID", loginUserID); param[7] = SqlHelper.GetParameter("@remark", model.Remark); param[8] = SqlHelper.GetParameter("@UsedStatus", model.UsedStatus); param[9] = SqlHelper.GetParameter("@EmployeeID", model.EmployeeID==null ?SqlInt32.Null :SqlInt32.Parse(model.EmployeeID .ToString())); param[10] = SqlHelper.GetParameter("@IsHardValidate", model.IsHardValidate); if (model.IsInsert) { param[11] = SqlHelper.GetParameter("@password", model.Password); } SqlHelper.ExecuteTransSql(sql.ToString(), param); return SqlHelper.Result.OprateCount > 0 ? true : false; }