/// <summary> /// 添加员工绩效上报表 /// </summary> /// <param name="error"></param> /// <returns></returns> public static bool AddPerformanceReviewLogManager(Model.PerformanceReviewLog performancereviewlog, ref string error) { if (IsExit(performancereviewlog.Year, performancereviewlog.Month, performancereviewlog.PerformanceReviewItem, performancereviewlog.Name)) { error = "已存在的员工绩效信息,请重新填写!"; return(false); } if (string.IsNullOrEmpty(performancereviewlog.Year) || string.IsNullOrEmpty(performancereviewlog.Month) || string.IsNullOrEmpty(performancereviewlog.PerformanceReviewItem) || string.IsNullOrEmpty(performancereviewlog.RowNumber.ToString()) || string.IsNullOrEmpty(performancereviewlog.FullScore.ToString()) || string.IsNullOrEmpty(performancereviewlog.Deduction.ToString()) || string.IsNullOrEmpty(performancereviewlog.Score.ToString()) || string.IsNullOrEmpty(performancereviewlog.Description) || string.IsNullOrEmpty(performancereviewlog.StatMode.ToString()) || string.IsNullOrEmpty(performancereviewlog.Name.ToString())) { error = "员工绩效信息不完整!"; return(false); } string sql = string.Format(@" insert into PerformanceReviewLog (Year,Month,PerformanceReviewItem,RowNumber,FullScore,Deduction,Score,Description,StatMode,Remark,Name) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')", performancereviewlog.Year, performancereviewlog.Month, performancereviewlog.PerformanceReviewItem, performancereviewlog.RowNumber, performancereviewlog.FullScore, performancereviewlog.Deduction, performancereviewlog.Score, performancereviewlog.Description, performancereviewlog.StatMode, performancereviewlog.Remark, performancereviewlog.Name); return(SqlHelper.ExecuteSql(sql, ref error)); }
/// <summary> /// 修改考员工绩效上报表 /// </summary> /// <param name="error"></param> /// <returns></returns> public static bool EditPerformanceReviewLogManager(Model.PerformanceReviewLog performancereviewlog, ref string error, string Year, string Month, string PerformanceReviewItem, string Name) { if (string.IsNullOrEmpty(performancereviewlog.Year) || string.IsNullOrEmpty(performancereviewlog.Month) || string.IsNullOrEmpty(performancereviewlog.PerformanceReviewItem) || string.IsNullOrEmpty(performancereviewlog.RowNumber.ToString()) || string.IsNullOrEmpty(performancereviewlog.FullScore.ToString()) || string.IsNullOrEmpty(performancereviewlog.Deduction.ToString()) || string.IsNullOrEmpty(performancereviewlog.Score.ToString()) || string.IsNullOrEmpty(performancereviewlog.Name.ToString())) { error = "员工绩效信息不完整!"; return(false); } string sql = string.Format(@" update PerformanceReviewLog set RowNumber={0},FullScore={1},Deduction={2},Score={3},Description='{4}',StatMode='{5}',Remark='{6}' where Year='{7}' and Month='{8}' and PerformanceReviewItem='{9}' and Name='{10}'", performancereviewlog.RowNumber, performancereviewlog.FullScore, performancereviewlog.Deduction, performancereviewlog.Score, performancereviewlog.Description, performancereviewlog.StatMode, performancereviewlog.Remark, Year, Month, PerformanceReviewItem, performancereviewlog.Name); return(SqlHelper.ExecuteSql(sql, ref error)); }