/// <summary>
/// 添加考核心标准维护表
/// </summary>
/// <param name="error"></param>
/// <returns></returns>
public static bool AddPerformanceReviewStandardManager(Model.PerformanceReviewStandard performancereviewstandard, ref string error)
{
if (IsExit(performancereviewstandard.StandardName, performancereviewstandard.PerformanceReviewItem))
{
error = "已存在的标准考核名称或考核项目，请重新填写！";
return false;
}
if (string.IsNullOrEmpty(performancereviewstandard.StandardName) || string.IsNullOrEmpty(performancereviewstandard.PerformanceReviewItem)
|| string.IsNullOrEmpty(performancereviewstandard.Description) || string.IsNullOrEmpty(performancereviewstandard.FullScore.ToString())
|| string.IsNullOrEmpty(performancereviewstandard.StatMode.ToString()) || string.IsNullOrEmpty(performancereviewstandard.RowNumber.ToString()))
{
error = "核心标准维护信息不完整！";
return false;
}
string sql = string.Format(@" insert into PerformanceReviewStandard (StandardName,PerformanceReviewItem,RowNumber,FullScore,Description,StatMode,Remark,Type) values
('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", performancereviewstandard.StandardName,
performancereviewstandard.PerformanceReviewItem, performancereviewstandard.RowNumber, performancereviewstandard.FullScore, performancereviewstandard.Description, performancereviewstandard.StatMode,
performancereviewstandard.Remark, performancereviewstandard.Type);
return SqlHelper.ExecuteSql(sql, ref error);
}
/// <summary>
/// 修改考核心标准维护表
/// </summary>
/// <param name="error"></param>
/// <returns></returns>
public static bool EditPerformanceReviewStandardManager(Model.PerformanceReviewStandard performancereviewstandard, ref string error, string StandardName, string PerformanceReviewItem)
{
//if (IsExit(performancereviewstandard.StandardName, performancereviewstandard.PerformanceReviewItem))
//{
// error = "已存在的标准考核名称或考核项目，请重新填写！";
// return false;
//}
if (string.IsNullOrEmpty(performancereviewstandard.StandardName) || string.IsNullOrEmpty(performancereviewstandard.PerformanceReviewItem)
|| string.IsNullOrEmpty(performancereviewstandard.Description) || string.IsNullOrEmpty(performancereviewstandard.FullScore.ToString())
|| string.IsNullOrEmpty(performancereviewstandard.StatMode.ToString()) || string.IsNullOrEmpty(performancereviewstandard.RowNumber.ToString()))
{
error = "核心标准维护信息不完整！";
return false;
}
string sql = string.Format(@" update PerformanceReviewStandard
set RowNumber={0},FullScore={1},Description='{2}',StatMode={3},Remark='{4}',Type='{7}'
where StandardName='{5}' and PerformanceReviewItem='{6}'",
performancereviewstandard.RowNumber, performancereviewstandard.FullScore, performancereviewstandard.Description, performancereviewstandard.StatMode,
performancereviewstandard.Remark, StandardName, PerformanceReviewItem,
performancereviewstandard.Type);
return SqlHelper.ExecuteSql(sql, ref error);
}
