public int AddKPIEvaluate(KPIEvaluateInfo kpiEvaluate) { SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@userId", SqlDbType.Int), new SqlParameter("@postId", SqlDbType.Int), new SqlParameter("@kPIId", SqlDbType.Int), new SqlParameter("@scorse", SqlDbType.Float), new SqlParameter("@rate", SqlDbType.Int), new SqlParameter("@state", SqlDbType.Int), //new SqlParameter("@evaluateDate", SqlDbType.NVarChar), new SqlParameter("@evaluateNameId", SqlDbType.Int), new SqlParameter("@evaluateUserId", SqlDbType.Int) }; pt[0].Value = kpiEvaluate.UserId; pt[1].Value = kpiEvaluate.PostId; pt[2].Value = kpiEvaluate.KPIId; pt[3].Value = kpiEvaluate.Scorse; pt[4].Value = kpiEvaluate.Rate; pt[5].Value = kpiEvaluate.State; //pt[6].Value = kpiEvaluate.EvaluateDate; pt[6].Value = kpiEvaluate.EvaluateNameId; pt[7].Value = kpiEvaluate.EvaluateUserId; return(Convert.ToInt32(ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddKPIEvaluate", pt))); }
public KPIEvaluateInfo ReadKPIEvaluate(int id) { SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.NVarChar) }; pt[0].Value = id; KPIEvaluateInfo info = new KPIEvaluateInfo(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadKPIEvaluate", pt)) { if (dr.Read()) { info.ID = int.Parse(dr["ID"].ToString()); info.UserId = int.Parse(dr["ParentId"].ToString()); info.PostId = int.Parse(dr["PostId"].ToString()); info.KPIId = int.Parse(dr["KPIId"].ToString()); info.Scorse = float.Parse(dr["Scorse"].ToString()); info.Rate = int.Parse(dr["Rate"].ToString()); info.State = int.Parse(dr["State"].ToString()); info.EvaluateDate = dr["EvaluateDate"].ToString(); info.EvaluateNameId = int.Parse(dr["EvaluateNameId"].ToString()); info.AddDate = Convert.ToDateTime(dr["AddDate"].ToString()); info.EvaluateUserId = int.Parse(dr["EvaluateUserId"].ToString()); } } return(info); }
public void PrepareModel(SqlDataReader dr, List <KPIEvaluateInfo> kpiEvaluateList) { while (dr.Read()) { KPIEvaluateInfo info = new KPIEvaluateInfo(); { info.ID = int.Parse(dr["ID"].ToString()); info.UserId = int.Parse(dr["UserId"].ToString()); info.PostId = int.Parse(dr["PostId"].ToString()); info.KPIId = int.Parse(dr["KPIId"].ToString()); info.Scorse = float.Parse(dr["Scorse"].ToString()); info.Rate = int.Parse(dr["Rate"].ToString()); info.State = int.Parse(dr["State"].ToString()); info.EvaluateDate = dr["EvaluateDate"].ToString(); info.EvaluateNameId = int.Parse(dr["EvaluateNameId"].ToString()); info.AddDate = Convert.ToDateTime(dr["AddDate"].ToString()); info.EvaluateUserId = int.Parse(dr["EvaluateUserId"].ToString()); } kpiEvaluateList.Add(info); } }
public void UpdateKPIEvaluate(KPIEvaluateInfo kpiEvaluate) { SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@scorse", SqlDbType.Float), new SqlParameter("@rate", SqlDbType.Int), new SqlParameter("@state", SqlDbType.Int), //new SqlParameter("@evaluateDate", SqlDbType.NVarChar), new SqlParameter("@evaluateNameId", SqlDbType.Int), new SqlParameter("@evaluateUserId", SqlDbType.Int) }; pt[0].Value = kpiEvaluate.ID; pt[1].Value = kpiEvaluate.Scorse; pt[2].Value = kpiEvaluate.Rate; pt[3].Value = kpiEvaluate.State; //pt[4].Value = kpiEvaluate.EvaluateDate; pt[4].Value = kpiEvaluate.EvaluateNameId; pt[5].Value = kpiEvaluate.EvaluateUserId; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateKPIEvaluate", pt); }
public List <KPIEvaluateInfo> SearchFixedKPIEvaluateList(KPIEvaluateSearchInfo kpiEvaluateSearch) { MssqlCondition mssqlCondition = new MssqlCondition(); this.PrepareCondition(mssqlCondition, kpiEvaluateSearch); List <KPIEvaluateInfo> kpiEvaluateList = new List <KPIEvaluateInfo>(); SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar) }; pt[0].Value = mssqlCondition.ToString(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchFixedKPIEvaluateList", pt)) { while (dr.Read()) { KPIEvaluateInfo info = new KPIEvaluateInfo(); { info.KPIId = int.Parse(dr["KPIId"].ToString()); info.Rate = int.Parse(dr["Rate"].ToString()); } kpiEvaluateList.Add(info); } } return(kpiEvaluateList); }
public static void UpdateKPIEvaluate(KPIEvaluateInfo kpiEvaluate) { dal.UpdateKPIEvaluate(kpiEvaluate); }
public static int AddKPIEvaluate(KPIEvaluateInfo kpiEvaluate) { return(dal.AddKPIEvaluate(kpiEvaluate)); }
protected override void PageLoad() { base.PageLoad(); base.Title = "添加KPI指标"; base.CheckUserPower("AddEvaluate", PowerCheckType.Single); if (companyID <= 0) { companyID = base.UserCompanyID; } string tempKPI = string.Empty; //临时指标ID string fixedKPI = string.Empty; //永久指标ID //获取岗位ID后,加载岗位KPI列表 if (Action == "step1") { if (userId == int.MinValue) { userName = RequestHelper.GetForm <string>("UserName"); UserSearchInfo user = new UserSearchInfo(); user.EqualRealName = userName; user.InCompanyID = companyID.ToString(); List <UserInfo> userList = UserBLL.SearchUserList(user); if (userList.Count > 0) { userId = userList[0].ID; } else { ScriptHelper.Alert("找不到此用户"); } } workPostId = RequestHelper.GetForm <int>("PostId"); evaluateNameId = RequestHelper.GetForm <int>("EvaluationName"); //获取UserId值 if (workPostId > 0) { KPISearchInfo kpiSearch = new KPISearchInfo(); kpiSearch.IdStr = WorkingPostBLL.ReadWorkingPostView(workPostId).KPIContent; if (!string.IsNullOrEmpty(kpiSearch.IdStr)) { List <KPIInfo> kpiList = KPIBLL.SearchKPIList(kpiSearch); List <KPIInfo> tempList1 = new List <KPIInfo>(); List <KPIInfo> tempList2 = new List <KPIInfo>(); List <KPIInfo> tempList3 = new List <KPIInfo>(); foreach (KPIInfo info in kpiList) { if (info.Type == KPIType.Fixed) { if (string.IsNullOrEmpty(fixedKPI)) { fixedKPI = info.ID.ToString(); } else { fixedKPI = fixedKPI + "," + info.ID.ToString(); } } else { if (string.IsNullOrEmpty(tempKPI)) { tempKPI = info.ID.ToString(); } else { tempKPI = tempKPI + "," + info.ID.ToString(); } } switch (info.ParentId) { case 1: tempList1.Add(info); break; case 2: tempList2.Add(info); break; case 3: tempList3.Add(info); break; } } int i = 1; foreach (KPIInfo info in tempList1) { trHtml.AppendLine("<tr>"); if (i == 1) { trHtml.AppendLine(" <td rowspan=\"" + tempList1.Count + "\" class=\"indicator_name\">" + KPIBLL.ReadKPI(info.ParentId).Name + "</td>"); } if (info.Type == KPIType.Fixed) { trHtml.AppendLine(" <td class=\"forever\">" + EnumHelper.ReadEnumChineseName <KPIType>((int)info.Type) + "</td>"); } else { trHtml.AppendLine(" <td>" + EnumHelper.ReadEnumChineseName <KPIType>((int)info.Type) + "</td>"); } trHtml.AppendLine(" <td class=\"evaluation_content\" data-id=\"" + info.ID + "\">" + i.ToString() + "." + info.Name + "</td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine("</tr>"); i++; } i = 1; foreach (KPIInfo info in tempList2) { trHtml.AppendLine("<tr>"); if (i == 1) { trHtml.AppendLine(" <td rowspan=\"" + tempList2.Count + "\" class=\"indicator_name\">" + KPIBLL.ReadKPI(info.ParentId).Name + "</td>"); } if (info.Type == KPIType.Fixed) { trHtml.AppendLine(" <td class=\"forever\">" + EnumHelper.ReadEnumChineseName <KPIType>((int)info.Type) + "</td>"); } else { trHtml.AppendLine(" <td>" + EnumHelper.ReadEnumChineseName <KPIType>((int)info.Type) + "</td>"); } trHtml.AppendLine(" <td class=\"evaluation_content\" data-id=\"" + info.ID + "\">" + i.ToString() + "." + info.Name + "</td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine("</tr>"); i++; } i = 1; foreach (KPIInfo info in tempList3) { trHtml.AppendLine("<tr>"); if (i == 1) { trHtml.AppendLine(" <td rowspan=\"" + tempList3.Count + "\" class=\"indicator_name\">" + KPIBLL.ReadKPI(info.ParentId).Name + "</td>"); } if (info.Type == KPIType.Fixed) { trHtml.AppendLine(" <td class=\"forever\">" + EnumHelper.ReadEnumChineseName <KPIType>((int)info.Type) + "</td>"); } else { trHtml.AppendLine(" <td>" + EnumHelper.ReadEnumChineseName <KPIType>((int)info.Type) + "</td>"); } trHtml.AppendLine(" <td class=\"evaluation_content\" data-id=\"" + info.ID + "\">" + i.ToString() + "." + info.Name + "</td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine(" <td class=\"schedule\"></td>"); trHtml.AppendLine("</tr>"); i++; } } } if (userId > 0) { KPIEvaluateSearchInfo kpiEvaluate = new KPIEvaluateSearchInfo(); kpiEvaluate.UserId = userId.ToString(); kpiEvaluate.EvaluateNameId = evaluateNameId; kpiEvaluate.PostId = workPostId.ToString(); //取得临时指标的值 if (!string.IsNullOrEmpty(tempKPI)) { kpiEvaluate.KPIdStr = tempKPI; foreach (KPIEvaluateInfo info in KPIEvaluateBLL.SearchKPIEvaluateList(kpiEvaluate)) { if (string.IsNullOrEmpty(kpiIdStr)) { kpiIdStr = info.KPIId + ":" + info.Rate; } else { kpiIdStr = kpiIdStr + "," + info.KPIId + ":" + info.Rate; } } } //取得永久指标的值 if (!string.IsNullOrEmpty(fixedKPI)) { kpiEvaluate.KPIdStr = fixedKPI; List <KPIEvaluateInfo> fixedKPIEValuateList = KPIEvaluateBLL.SearchKPIEvaluateList(kpiEvaluate); //如果临时指标和永久指标的记录都为空的话,则为新增评估,调取永久指标记录 if (string.IsNullOrEmpty(kpiIdStr) && fixedKPIEValuateList.Count <= 0) { kpiEvaluate.EvaluateNameId = int.MinValue; kpiEvaluate.PostId = string.Empty; //所有岗位的评估记录都有效(包括已删除岗位的评估记录) fixedKPIEValuateList = KPIEvaluateBLL.SearchFixedKPIEvaluateList(kpiEvaluate); } foreach (KPIEvaluateInfo info in fixedKPIEValuateList)//BLLKPIEvaluate.SearchFixedKPIEvaluateList(kpiEvaluate) { if (string.IsNullOrEmpty(kpiIdStr)) { kpiIdStr = info.KPIId + ":" + info.Rate; } else { kpiIdStr = kpiIdStr + "," + info.KPIId + ":" + info.Rate; } } } } } else if (Action == "step2") { kpiIdStr = RequestHelper.GetForm <string>("kpiidstr"); //workPostId = RequestHelper.GetForm<int>("PostId"); string alertMessage = ShopLanguage.ReadLanguage("AddOK"); base.CheckUserPower("AddEvaluate", PowerCheckType.Single); if (!string.IsNullOrEmpty(kpiIdStr)) { KPIEvaluateBLL.DeleteKPIEvaluate(userId, workPostId, evaluateNameId); foreach (string item in kpiIdStr.Split(',')) { KPIEvaluateInfo kpiEvaluate = new KPIEvaluateInfo(); kpiEvaluate.KPIId = int.Parse(item.Split(':')[0]); kpiEvaluate.Scorse = float.Parse(item.Split(':')[1]); kpiEvaluate.UserId = userId; //kpiEvaluate.EvaluateDate = evaluateDate; kpiEvaluate.EvaluateNameId = evaluateNameId; kpiEvaluate.PostId = workPostId; kpiEvaluate.Rate = int.Parse(item.Split(':')[1]); int id = KPIEvaluateBLL.AddKPIEvaluate(kpiEvaluate); AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("AddRecord"), ShopLanguage.ReadLanguage("Evaluate"), id); } } ScriptHelper.Alert(alertMessage, "EvaluateAdd.aspx"); } }