/// <summary>
/// 保存时基本信息参数设置
/// </summary>
/// <param name="comm">命令</param>
/// <param name="model">考核类型信息</param>
private static void SetSaveParameter(SqlCommand comm, PerformanceElemModel model)
{
//设置参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ElemNo", model.ElemNo)); //指标编号
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ElemName", model.ElemName)); //指标名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ScoreRules", model.ScoreRules)); //评分细则
comm.Parameters.Add(SqlHelper.GetParameterFromString("@StandardScore", model.StandardScore.ToString())); //标准分
comm.Parameters.Add(SqlHelper.GetParameterFromString("@MinScore", model.MinScore.ToString())); //评分最小值
comm.Parameters.Add(SqlHelper.GetParameterFromString("@MaxScore", model.MaxScore.ToString())); //评分最大值
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AsseStandard", model.AsseStandard)); //评分标准
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AsseFrom", model.AsseFrom)); //评分来源(如业绩)
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark)); //备注
comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus)); //启用状态
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID)); //更新用户ID
if (!(string.IsNullOrEmpty(model.ParentElemNo)))
{
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ParentElemNo", model.ParentElemNo)); //更新用户ID
}
/// if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag))
// {
// comm.Parameters.Add(SqlHelper.GetParameterFromString("@ID", model.ID )); //指标类型编号
// }
}
/// <summary>
/// 插入一个评分项目
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool InsertPerformanceElem(PerformanceElemModel model)
{
#region 插入SQL拼写
StringBuilder insertSql = new StringBuilder();
insertSql.AppendLine("INSERT INTO officedba.PerformanceElem ");
insertSql.AppendLine(" (CompanyCD ");
insertSql.AppendLine(" ,ElemNo ");
insertSql.AppendLine(" ,ElemName ");
if (!(string.IsNullOrEmpty(model.ParentElemNo)))
{
insertSql.AppendLine(" ,ParentElemNo ");
}
insertSql.AppendLine(" ,ScoreRules ");
insertSql.AppendLine(" ,StandardScore ");
insertSql.AppendLine(" ,MinScore ");
insertSql.AppendLine(" ,MaxScore ");
insertSql.AppendLine(" ,AsseStandard ");
insertSql.AppendLine(" ,AsseFrom ");
insertSql.AppendLine(" ,Remark ");
insertSql.AppendLine(" ,UsedStatus ");
insertSql.AppendLine(" ,ModifiedDate ");
insertSql.AppendLine(" ,ModifiedUserID ) ");
insertSql.AppendLine(" VALUES ");
insertSql.AppendLine(" (@CompanyCD ");
insertSql.AppendLine(" ,@ElemNo ");
insertSql.AppendLine(" ,@ElemName ");
if (!(string.IsNullOrEmpty(model.ParentElemNo)))
{
insertSql.AppendLine(" ,@ParentElemNo ");
}
insertSql.AppendLine(" ,@ScoreRules ");
insertSql.AppendLine(" ,@StandardScore ");
insertSql.AppendLine(" ,@MinScore ");
insertSql.AppendLine(" ,@MaxScore ");
insertSql.AppendLine(" ,@AsseStandard ");
insertSql.AppendLine(" ,@AsseFrom ");
insertSql.AppendLine(" ,@Remark ");
insertSql.AppendLine(" ,@UsedStatus ");
insertSql.AppendLine(" ,getdate() ");
insertSql.AppendLine(" ,@ModifiedUserID) ");
insertSql.AppendLine(" set @ElemID= @@IDENTITY ");
#endregion
//定义插入基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = insertSql.ToString();
//设置保存的参数
SetSaveParameter(comm, model);
//添加返回参数
comm.Parameters.Add(SqlHelper.GetOutputParameter("@ElemID", SqlDbType.Int));
//执行插入操作
bool isSucc = SqlHelper.ExecuteTransWithCommand(comm);
//设置ID
model.ID = comm.Parameters["@ElemID"].Value.ToString();
//返回更新结果
return(isSucc);
}
/// <summary>
/// 查询考核类型信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static DataTable SearchRectCheckElemInfo(PerformanceElemModel model)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//获取公司代码
model.CompanyCD = userInfo.CompanyCD;
//执行查询
return(PerformanceElemDBHelper.SearchCheckElemInfo(model));
}
/// <summary>
/// 更新一个指标项目
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdatePerformanceElem(PerformanceElemModel model)
{
StringBuilder updateSql = new StringBuilder();
updateSql.AppendLine(" UPDATE officedba.PerformanceElem ");
updateSql.AppendLine(" SET ElemName = @ElemName ");
updateSql.AppendLine(" ,ScoreRules = @ScoreRules ");
updateSql.AppendLine(" ,StandardScore = @StandardScore ");
updateSql.AppendLine(" ,MinScore = @MinScore ");
updateSql.AppendLine(" ,MaxScore = @MaxScore ");
updateSql.AppendLine(" ,AsseStandard = @AsseStandard ");
updateSql.AppendLine(" ,AsseFrom = @AsseFrom ");
updateSql.AppendLine(" ,Remark = @Remark ");
updateSql.AppendLine(" ,UsedStatus = @UsedStatus ");
updateSql.AppendLine(" ,ModifiedUserID = @ModifiedUserID ");
updateSql.AppendLine(" ,ModifiedDate = getdate() ");
updateSql.AppendLine(" WHERE ");
updateSql.AppendLine(" CompanyCD = @CompanyCD and ID = @ElemNo ");
//定义更新基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = updateSql.ToString();
//设置保存的参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ElemNo", model.ID)); //指标编号
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ElemName", model.ElemName)); //指标名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ScoreRules", model.ScoreRules)); //评分细则
comm.Parameters.Add(SqlHelper.GetParameterFromString("@StandardScore", model.StandardScore.ToString())); //标准分
comm.Parameters.Add(SqlHelper.GetParameterFromString("@MinScore", model.MinScore.ToString())); //评分最小值
comm.Parameters.Add(SqlHelper.GetParameterFromString("@MaxScore", model.MaxScore.ToString())); //评分最大值
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AsseStandard", model.AsseStandard)); //评分标准
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AsseFrom", model.AsseFrom)); //评分来源(如业绩)
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark)); //备注
comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus)); //启用状态
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID)); //更新用户ID
// if (!(string.IsNullOrEmpty(model.ParentElemNo)))
// {
// comm.Parameters.Add(SqlHelper.GetParameterFromString("@ParentElemNo", model.ParentElemNo)); //更新用户ID
//}
// comm.Parameters.Add(SqlHelper.GetParameterFromString("@ParentElemNo", model.ParentElemNo));
//执行插入操作并返回更新结果
return(SqlHelper.ExecuteTransWithCommand(comm));
}
/// <summary>
/// 完成搜索
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static DataTable SearchCheckElemInfo(PerformanceElemModel model)
{
#region 查询语句
//查询SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT ");
searchSql.AppendLine(" ID ");
searchSql.AppendLine(" ,ISNULL(ElemName, '') AS ElemName ");
searchSql.AppendLine(" ,CASE UsedStatus ");
searchSql.AppendLine(" WHEN '0' THEN '停用' ");
searchSql.AppendLine(" WHEN '1' THEN '启用' ");
searchSql.AppendLine(" ELSE '' ");
searchSql.AppendLine(" END AS UsedStatusName ");
searchSql.AppendLine(" ,MaxScore-MinScore AS ScoreArrange ");
searchSql.AppendLine(" ,StandardScore ");
searchSql.AppendLine(" ,isnull(AsseStandard,'') asAsseStandard ");
searchSql.AppendLine(" ,isnull(AsseFrom,'') as AsseFrom ");
searchSql.AppendLine(" ,isnull(Remark,'') as Remark ");
searchSql.AppendLine(" FROM ");
searchSql.AppendLine(" officedba.PerformanceElem ");
searchSql.AppendLine(" WHERE ");
searchSql.AppendLine(" CompanyCD = @CompanyCD ");
#endregion
//定义查询的命令
SqlCommand comm = new SqlCommand();
//添加公司代码参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
//l
if (!string.IsNullOrEmpty(model.ElemName))
{
searchSql.AppendLine(" AND ElemName LIKE @ElemName ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ElemName", "%" + model.ElemName + "%"));
}
//启用状态
if (!string.IsNullOrEmpty(model.UsedStatus))
{
searchSql.AppendLine(" AND UsedStatus = @UsedStatus ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus));
}
//指定命令的SQL文
comm.CommandText = searchSql.ToString();
//执行查询
return(SqlHelper.ExecuteSearch(comm));
}
/// <summary>
/// 保存评分项目信息
/// </summary>
/// <param name="model"> 评分项目实体</param>
/// <returns></returns>
public static bool SaveRectCheckElemInfo(PerformanceElemModel model)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
model.CompanyCD = userInfo.CompanyCD;
//设置最后修改者
model.ModifiedUserID = userInfo.UserID;
//定义返回变量
bool isSucc = false;
//操作日志
LogInfoModel logModel = InitLogInfo(model.ID);
//更新
if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag))
{
try
{
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//执行更新操作
isSucc = PerformanceElemDBHelper.UpdatePerformanceElem(model);
}
catch (Exception ex)
{
//输出系统日志
WriteSystemLog(userInfo, ex);
}
}
//插入
else
{
try
{
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//执行插入操作
isSucc = PerformanceElemDBHelper.InsertPerformanceElem(model);
logModel.ObjectID = model.ID;
}
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);
}
