/// <summary> /// 删除日常管理考核得分数据 /// </summary> /// <param name="ManagementScore">日常管理考核得分实体</param> /// <returns>删除的数据行数</returns> public int DeleteManagementScore(ManagementScoreEntity ManagementScore) { string SqlText = @"DELETE FROM KPI_ManagementScore WHERE PersonID=@PersonID AND CheckDate=@CheckDate AND TagID=@TagID "; return(m_DataAccess.ExecuteNonQuery(CommandType.Text, SqlText, GetParameters(ManagementScore))); }
/// <summary> /// 更新日常管理考核得分数据 /// </summary> /// <param name="ManagementScore">日常管理考核得分实体</param> /// <returns>更新的数据行数</returns> private int UpdateManagementScore(ManagementScoreEntity ManagementScore) { string SqlText = @"Update KPI_ManagementScore Set Shift=@Shift, Score=@Score, IsValid=@IsValid,TagScore=@TagScor , Rate=@Rate Where PersonID = @PersonID and CheckDate = @CheckDate and TagID = @TagID "; return(m_DataAccess.ExecuteNonQuery(CommandType.Text, SqlText, GetParameters(ManagementScore))); }
/// <summary> /// 新增日常管理考核得分数据 /// </summary> /// <param name="ManagementScore">日常管理考核得分实体</param> /// <returns>新增的数据行数</returns> private int AddManagementScore(ManagementScoreEntity ManagementScore) { string SqlText = @"Insert KPI_ManagementScore (PersonID,CheckDate,Shift,TagID,Score,IsValid, TagScore,Rate) Values (@PersonID,@CheckDate,@Shift,@TagID,@Score,@IsValid, @TagScore,@Rate) "; return(m_DataAccess.ExecuteNonQuery(CommandType.Text, SqlText, GetParameters(ManagementScore))); }
/// <summary> /// 保存日常管理考核得分数据 /// </summary> /// <param name="ManagementScore">日常管理考核得分实体</param> /// <returns>成功保存的行数</returns> public int SaveManagementScore(ManagementScoreEntity ManagementScore) { int Result = 0; if (Exists(ManagementScore)) { Result = UpdateManagementScore(ManagementScore); } else { Result = AddManagementScore(ManagementScore); } return(Result); }
/// <summary> /// 获取日常管理考核得分数据 /// </summary> /// <param name="PersonID">个人编码</param> /// <param name="CheckDate">考核日期</param> /// <param name="TagID">指标编码</param> /// <returns>日常管理考核得分实体</returns> public ManagementScoreEntity GetManagementScore(string PersonID, DateTime CheckDate, string TagID) { string SqlText = @"SELECT * FROM KPI_ManagementScore WHERE PersonID=@PersonID AND CheckDate=@CheckDate AND TagID=@TagID "; IDbDataParameter[] Parameters = new SqlParameter[] { new SqlParameter("@PersonID", SqlDbType.VarChar), new SqlParameter("@CheckDate", SqlDbType.Date), new SqlParameter("@TagID", SqlDbType.VarChar) }; Parameters[0].Value = PersonID; Parameters[1].Value = CheckDate; Parameters[2].Value = TagID; ManagementScoreEntity Result = null; using (IDataReader DataReader = m_DataAccess.ExecuteReader(CommandType.Text, SqlText, Parameters)) { Result = DataReader.FillEntity <ManagementScoreEntity>(); }; return(Result); }
public void RaiseCallbackEvent(string eventArgument) { String Action = eventArgument.Split(',')[0].Split('=')[1]; String Argument = eventArgument.Split(',')[1].Split('=')[1]; if (Action == "InputTags") { KPI_InputTagDal InputTagDataAccess = new KPI_InputTagDal(); List <InputTagEntity> InputTags = InputTagDataAccess.GetInputTags(Argument); var Result = new { Action = Action, data = InputTags.Select(p => new { InputID = p.InputID, InputDesc = p.InputDesc }).ToList() }; m_CallbackResult = JsonConvert.SerializeObject(Result); } if (Action == "InitialPerson") { List <ManagementScoreEntity> List = new List <ManagementScoreEntity>(); ManagementScoreEntity Entity; for (int i = 0; i < 10; i++) { Entity = new ManagementScoreEntity { Rate = 80.0m, Shift = 1, PersonName = "韩娜", PositionName = "值长" }; List.Add(Entity); } var Result = new { Action = Action, data = List }; m_CallbackResult = JsonConvert.SerializeObject(Result); } }
private IDbDataParameter[] GetParameters(ManagementScoreEntity ManagementScore) { IDbDataParameter[] Parameters = new SqlParameter[] { new SqlParameter("@PersonID", SqlDbType.VarChar), new SqlParameter("@CheckDate", SqlDbType.Date), new SqlParameter("@Shift", SqlDbType.Int), new SqlParameter("@TagID", SqlDbType.VarChar), new SqlParameter("@Score", SqlDbType.Decimal), new SqlParameter("@IsValid", SqlDbType.Bit), new SqlParameter("@TagScore", SqlDbType.Decimal), new SqlParameter("@Rate", SqlDbType.Decimal) }; Parameters[0].Value = ManagementScore.PersonID; Parameters[1].Value = ManagementScore.CheckDate; Parameters[2].Value = ManagementScore.Shift; Parameters[3].Value = ManagementScore.TagID; Parameters[4].Value = ManagementScore.Score; Parameters[5].Value = ManagementScore.IsValid; Parameters[6].Value = ManagementScore.TagScore; Parameters[7].Value = ManagementScore.Rate; return(Parameters); }
/// <summary> /// 判断日常管理考核得分数据是否存在 /// </summary> /// <param name="ManagementScore">日常管理考核得分实体</param> /// <returns>数据存在则返回true否则返回false</returns> private bool Exists(ManagementScoreEntity ManagementScore) { string SqlText = @"SELECT COUNT(PersonID) FROM KPI_ManagementScore WHERE PersonID=@PersonID AND CheckDate=@CheckDate AND TagID=@TagID "; return((int)m_DataAccess.ExecuteScalar(SqlText, GetParameters(ManagementScore)) > 0); }