/// <summary> /// 修改部门提成 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool UpdateInputDepatmentRoyalty(InputDepatmentRoyaltyModel model) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //登陆日志 try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.DeptID); logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; succ = InputDepatmentRoyaltyDBHelper.UpdateInputDepatmentRoyalty(model); if (!succ) logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; else logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; LogDBHelper.InsertLog(logModel); return succ; } catch (Exception) { return false; throw; } }
/// <summary> /// 插入部门提成 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool InsertInputDepatmentRoyalty(InputDepatmentRoyaltyModel model) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //登陆日志 try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.DeptID); logModel.Element = ConstUtil.LOG_PROCESS_INSERT; succ = InputDepatmentRoyaltyDBHelper.InsertInputDepatmentRoyalty(model); if (!succ) logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; else logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; LogDBHelper.InsertLog(logModel); return succ; } catch (Exception ex) { WriteSystemLog(userInfo, ex); return false; } }
/// <summary> /// 修改部门提成 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool UpdateInputDepatmentRoyalty(InputDepatmentRoyaltyModel model) { StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.InputDepatmentRoyalty "); sql.AppendLine(" SET "); sql.AppendLine(" BusinessMoney = @BusinessMoney "); sql.AppendLine(" ,CreateTime = @CreateTime "); sql.AppendLine(" ,ModifiedDate = @ModifiedDate "); sql.AppendLine(" ,ModifiedUserID = @ModifiedUserID "); sql.AppendLine(" WHERE ID=@ID "); //设置参数 SqlParameter[] param = new SqlParameter[5]; int i = 0; param[i++] = SqlHelper.GetParameter("@BusinessMoney", model.BusinessMoney); param[i++] = SqlHelper.GetParameter("@ID", model.ID); param[i++] = SqlHelper.GetParameter("@CreateTime", model.CreateTime); param[i++] = SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now); param[i++] = SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID); SqlHelper.ExecuteTransSql(sql.ToString(), param); return SqlHelper.Result.OprateCount > 0 ? true : false; }
/// <summary> /// 插入部门提成 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool InsertInputDepatmentRoyalty(InputDepatmentRoyaltyModel model) { StringBuilder sql = new StringBuilder(); sql.AppendLine("INSERT INTO officedba.InputDepatmentRoyalty"); sql.AppendLine(" (CompanyCD "); sql.AppendLine(" ,DeptID "); sql.AppendLine(" ,BusinessMoney "); sql.AppendLine(" ,CreateTime "); sql.AppendLine(" ,ModifiedDate "); sql.AppendLine(" ,ModifiedUserID) "); sql.AppendLine(" VALUES "); sql.AppendLine(" (@CompanyCD "); sql.AppendLine(" ,@DeptID "); sql.AppendLine(" ,@BusinessMoney "); sql.AppendLine(" ,@CreateTime "); sql.AppendLine(" ,@ModifiedDate "); sql.AppendLine(" ,@ModifiedUserID) "); //设置参数 SqlParameter[] param = new SqlParameter[6]; int i = 0; param[i++] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD); param[i++] = SqlHelper.GetParameter("@DeptID", model.DeptID); param[i++] = SqlHelper.GetParameter("@BusinessMoney", model.BusinessMoney); param[i++] = SqlHelper.GetParameter("@CreateTime", model.CreateTime); param[i++] = SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now); param[i++] = SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID); SqlHelper.ExecuteTransSql(sql.ToString(), param); return SqlHelper.Result.OprateCount > 0 ? true : false; }