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); } }
/// <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)); }
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; }
/// <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; }