protected override void PageLoad()
{
base.PageLoad();
base.Title = "ÆÀ¹ÀÃû³ÆÁбí";
string Action = RequestHelper.GetQueryString <string>("Action");
if (Action == "Delete")
{
base.CheckUserPower("DeleteEvaluateName", PowerCheckType.Single);
string selectID = RequestHelper.GetQueryString <string>("SelectID");
if (!string.IsNullOrEmpty(selectID))
{
EvaluateNameBLL.DeleteEvaluateName(selectID);
AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("DeleteRecord"), ShopLanguage.ReadLanguage("EvaluateName"), selectID);
ScriptHelper.Alert(ShopLanguage.ReadLanguage("DeleteOK"), Request.UrlReferrer.ToString());
}
}
base.CheckUserPower("ReadEvaluateName", PowerCheckType.Single);
EvaluateNameInfo evaluateName = new EvaluateNameInfo();
evaluateName.CompanyIdCondition = base.UserCompanyID.ToString();
EvaluateNameList = EvaluateNameBLL.SearchEvaluateNameList(evaluateName, base.CurrentPage, base.PageSize, ref this.Count);
base.BindPageControl(ref base.CommonPager);
}
public static string GetEvaluateNameListHtml(string companyID, int evaluateNameId)
{
Dictionary <int, string> companyNameDic = new Dictionary <int, string>();
StringBuilder evaluateNameList = new StringBuilder();
EvaluateNameInfo evaluateName = new EvaluateNameInfo();
evaluateName.CompanyIdCondition = companyID;
evaluateNameList.Append("<option value=\"\">ÇëÑ¡ÔñÆÀ¹ÀÃû³Æ</option>");
foreach (EvaluateNameInfo info in EvaluateNameBLL.SearchEvaluateNameList(evaluateName))
{
evaluateNameList.Append("<option value=\"" + info.ID + "\"");
if (evaluateNameId == info.ID)
{
evaluateNameList.Append(" selected");
}
evaluateNameList.Append(">" + info.EvaluateName);
if (info.CompanyId != Cookies.User.GetCompanyID(true))
{
if (!companyNameDic.ContainsKey(info.CompanyId))
{
string companyName = CompanyBLL.ReadCompany(info.CompanyId).CompanySimpleName;
companyNameDic.Add(info.CompanyId, companyName);
}
evaluateNameList.Append("[" + companyNameDic[info.CompanyId] + "]");
}
evaluateNameList.Append("</option>");
}
return(evaluateNameList.ToString());
}
protected override void PageLoad()
{
base.PageLoad();
base.Title = "Ìí¼ÓÆÀ¹ÀÃû³Æ";
base.CheckUserPower("AddEvaluateName,UpdateEvaluateName", PowerCheckType.OR);
if (ID > 0)
{
EvaluateName = EvaluateNameBLL.ReadEvaluateName(ID);
}
}
public List <EvaluateNameInfo> SearchEvaluateNameList(EvaluateNameInfo evaluateName)
{
MssqlCondition mssqlCondition = new MssqlCondition();
this.PrepareCondition(mssqlCondition, evaluateName);
List <EvaluateNameInfo> evaluateNameList = new List <EvaluateNameInfo>();
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar) };
pt[0].Value = mssqlCondition.ToString();
using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchEvaluateNameList", pt))
{
this.PrepareModel(dr, evaluateNameList);
}
return(evaluateNameList);
}
public void PrepareModel(SqlDataReader dr, List <EvaluateNameInfo> evaluateNameList)
{
while (dr.Read())
{
EvaluateNameInfo info = new EvaluateNameInfo();
{
info.ID = int.Parse(dr["ID"].ToString());
info.EvaluateName = dr["EvaluateName"].ToString();
info.StartDate = dr["StartDate"].ToString();
info.EndDate = dr["EndDate"].ToString();
info.Date = dr["Date"].ToString();
info.CompanyId = int.Parse(dr["CompanyId"].ToString());
info.State = int.Parse(dr["State"].ToString());
}
evaluateNameList.Add(info);
}
}
public int AddEvaluateName(EvaluateNameInfo evaluateName)
{
SqlParameter[] pt = new SqlParameter[] {
new SqlParameter("@evaluateName", SqlDbType.NVarChar),
new SqlParameter("@startDate", SqlDbType.DateTime),
new SqlParameter("@endDate", SqlDbType.DateTime),
new SqlParameter("@companyId", SqlDbType.Int),
new SqlParameter("@state", SqlDbType.Int)
};
pt[0].Value = evaluateName.EvaluateName;
pt[1].Value = evaluateName.StartDate;
pt[2].Value = evaluateName.EndDate;
pt[3].Value = evaluateName.CompanyId;
pt[4].Value = evaluateName.State;
return(Convert.ToInt32(ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddEvaluateName", pt)));
}
public void UpdateEvaluateName(EvaluateNameInfo evaluateName)
{
SqlParameter[] pt = new SqlParameter[] {
new SqlParameter("@id", SqlDbType.Int),
new SqlParameter("@evaluateName", SqlDbType.NVarChar),
new SqlParameter("@startDate", SqlDbType.DateTime),
new SqlParameter("@endDate", SqlDbType.DateTime),
new SqlParameter("@companyId", SqlDbType.Int),
new SqlParameter("@state", SqlDbType.Int)
};
pt[0].Value = evaluateName.ID;
pt[1].Value = evaluateName.EvaluateName;
pt[2].Value = evaluateName.StartDate;
pt[3].Value = evaluateName.EndDate;
pt[4].Value = evaluateName.CompanyId;
pt[5].Value = evaluateName.State;
ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateEvaluateName", pt);
}
public List <EvaluateNameInfo> SearchEvaluateNameList(EvaluateNameInfo evaluateName, int currentPage, int pageSize, ref int count)
{
List <EvaluateNameInfo> evaluateNameList = new List <EvaluateNameInfo>();
ShopMssqlPagerClass class2 = new ShopMssqlPagerClass();
class2.TableName = ShopMssqlHelper.TablePrefix + "EvaluateName";
class2.Fields = "[Id],[EvaluateName],CONVERT(varchar(100), [StartDate], 23) as [StartDate],CONVERT(varchar(100), [EndDate], 23) as [EndDate],CONVERT(varchar(100), [Date], 23) as [Date],[CompanyId],[State]";
class2.CurrentPage = currentPage;
class2.PageSize = pageSize;
class2.OrderField = "[ID]";
class2.OrderType = OrderType.Desc;
this.PrepareCondition(class2.MssqlCondition, evaluateName);
class2.Count = count;
count = class2.Count;
using (SqlDataReader dr = class2.ExecuteReader())
{
this.PrepareModel(dr, evaluateNameList);
}
return(evaluateNameList);
}
public EvaluateNameInfo ReadEvaluateName(int id)
{
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.NVarChar) };
pt[0].Value = id;
EvaluateNameInfo info = new EvaluateNameInfo();
using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadEvaluateName", pt))
{
if (dr.Read())
{
info.ID = int.Parse(dr["ID"].ToString());
info.EvaluateName = dr["EvaluateName"].ToString();
info.StartDate = dr["StartDate"].ToString();
info.EndDate = dr["EndDate"].ToString();
info.Date = dr["Date"].ToString();
info.CompanyId = int.Parse(dr["CompanyId"].ToString());
info.State = int.Parse(dr["State"].ToString());
}
}
return(info);
}
protected override void PageLoad()
{
base.PageLoad();
base.Title = "综合能力评估";
base.CheckUserPower("ReadTPRReport", PowerCheckType.Single);
action = Request["Action"];
if (action == "Detail")
{
evaluateNameId = RequestHelper.GetQueryString <int>("EvaluateNameId");
evaluateType = RequestHelper.GetQueryString <int>("EvaluateType");
}
companyIDString = base.UserCompanyID.ToString();
if (companyID == 0)
{
companyIDString = base.SonCompanyID;
}
else if (companyID > 0)
{
companyIDString = companyID.ToString();
}
if (!base.ExistsSonCompany)
{
companyID = base.UserCompanyID;
}
if (!string.IsNullOrEmpty(action))
{
KPISearchInfo kpiSearch = new KPISearchInfo();
kpiSearch.ParentId = evaluateType.ToString();
kpiSearch.CompanyID = CompanyBLL.SystemCompanyId.ToString() + "," + companyID.ToString();
List <KPIInfo> kpiList = KPIBLL.SearchKPIList(kpiSearch);
string kpiStr = string.Empty;
//定义KPIId数组
ArrayList IdArray = new ArrayList();
if (kpiList.Count > 0)
{
string[,] kpiArray = new string[kpiList.Count, 3];
foreach (KPIInfo info in kpiList)
{
IdArray.Add(info.ID);
if (string.IsNullOrEmpty(kpiStr))
{
kpiStr = info.ID.ToString();
}
else
{
kpiStr += "," + info.ID;
}
int i = IdArray.IndexOf(info.ID);
kpiArray[i, 0] = info.ID.ToString();
kpiArray[i, 1] = info.Name;
kpiArray[i, 2] = info.EvaluateInfo;
}
KPIEvaluateSearchInfo kpiEvaluate = new KPIEvaluateSearchInfo();
if (action == "Search" && string.IsNullOrEmpty(userIdStr))
{
//UserSearchInfo userSearch = new UserSearchInfo();
//userSearch.InCompanyID = base.UserCompanyID.ToString();
//userIdStr = UserBLL.ReadUserIdStr(UserBLL.SearchUserList(userSearch));
if (postID > 0 || !string.IsNullOrEmpty(companyIDString))
{
kpiEvaluate.Condition = "[UserID] in (select id from [_User] where [Status]!=" + (int)UserState.Del;
if (postID > 0)
{
kpiEvaluate.Condition += " And [WorkingPostID] in (" + postID.ToString() + ")";
}
if (!string.IsNullOrEmpty(companyIDString))
{
kpiEvaluate.Condition += " And [CompanyId] in (" + companyIDString + ")";
}
kpiEvaluate.Condition += ")";
}
}
else
{
user = UserBLL.ReadUser(int.Parse(userIdStr));
evaluateName = EvaluateNameBLL.ReadEvaluateName(evaluateNameId);
kpiEvaluate.UserId = userIdStr;
}
kpiEvaluate.EvaluateNameId = evaluateNameId;
kpiEvaluate.KPIdStr = kpiStr;
List <KPIEvaluateInfo> kpiEvaluateList = KPIEvaluateBLL.SearchKPIEvaluateList(kpiEvaluate);
ArrayList userIdArray = new ArrayList();//new ArrayList(userIdStr.Split(','));
if (kpiEvaluateList.Count > 0)
{
foreach (KPIEvaluateInfo info in kpiEvaluateList)
{
if (!userIdArray.Contains(info.UserId))
{
userIdArray.Add(info.UserId);
}
}
}
string[, ,] dataArray = new string[kpiList.Count + 1, userIdArray.Count, 4];
//评估人数组
ArrayList evaluateUserIdArray = new ArrayList();
if (kpiEvaluateList.Count > 0)
{
foreach (KPIEvaluateInfo info in kpiEvaluateList)
{
if (!evaluateUserIdArray.Contains(info.EvaluateUserId))
{
evaluateUserIdArray.Add(info.EvaluateUserId);
}
dataArray[IdArray.IndexOf(info.KPIId), userIdArray.IndexOf(info.UserId), evaluateUserIdArray.IndexOf(info.EvaluateUserId)] = info.Scorse.ToString();
}
}
if (action != "Detail")//companyID >= 0
{
tableContent.Append("<tr><th class=\"project\">项目</th><th class=\"content\">内容</th>");
foreach (int item in userIdArray)
{
tableContent.Append("<th class=\"roll\"><a href=\"?Action=Detail&UserId=" + item + "&EvaluateNameId=" + evaluateNameId + "&EvaluateType=" + evaluateType + "\">" + UserBLL.ReadUser(item).RealName + "</a></th>");
}
for (int i = 0; i < dataArray.GetLength(0) - 1; i++)
{
tableContent.Append("<tr><td>" + kpiArray[i, 1] + "</td><td>" + kpiArray[i, 2] + "</td>");
for (int j = 0; j < userIdArray.Count; j++)
{
double totalScore = 0;
int num = 0;
for (int k = 0; k < 4; k++)
{
if (!string.IsNullOrEmpty(dataArray[i, j, k]) || dataArray[i, j, k] != null)
{
totalScore += double.Parse(dataArray[i, j, k]);
num++;
}
}
if (totalScore == 0)
{
tableContent.Append("<td> </td>");
}
else
{
tableContent.Append("<td>" + Math.Round((totalScore / num), 1) + "</td>");
if (string.IsNullOrEmpty(dataArray[dataArray.GetLength(0) - 1, j, 0]) || dataArray[dataArray.GetLength(0) - 1, j, 0] == null)
{
dataArray[dataArray.GetLength(0) - 1, j, 0] = Math.Round((totalScore / num), 1).ToString();
}
else
{
dataArray[dataArray.GetLength(0) - 1, j, 0] = (double.Parse(dataArray[dataArray.GetLength(0) - 1, j, 0]) + Math.Round((totalScore / num), 1)).ToString();
}
}
}
tableContent.Append("</tr>");
}
tableContent.Append("<tr class=\"count\"><td colspan=\"2\">合计</td>");
for (int j = 0; j < userIdArray.Count; j++)
{
//员工综合能力评估合计要除以2
if (evaluateType == 530)
{
tableContent.Append("<td>" + Math.Round(double.Parse(dataArray[dataArray.GetLength(0) - 1, j, 0]) / 2, 1) + "</td>");
}
else
{
tableContent.Append("<td>" + dataArray[dataArray.GetLength(0) - 1, j, 0] + "</td>");
}
}
tableContent.Append("</tr>");
}
else
{
tableContent.Append("<tr><th class=\"project\">项目</th><th class=\"content\">内容</th>");
foreach (int item in evaluateUserIdArray)
{
tableContent.Append("<th class=\"roll\">评估" + (evaluateUserIdArray.IndexOf(item) + 1) + "</th>");
}
tableContent.Append("<th class=\"average\">平均分</th></tr>");
for (int i = 0; i < dataArray.GetLength(0) - 1; i++)
{
tableContent.Append("<tr><td>" + kpiArray[i, 1] + "</td><td>" + kpiArray[i, 2] + "</td>");
double totalScore = 0;
int num = 0;
for (int j = evaluateUserIdArray.Count - 1; j >= 0; j--)//for (int j = 0; j < evaluateUserIdArray.Count; j++)
{
if (dataArray[i, 0, j] != null)
{
tableContent.Append("<td>" + dataArray[i, 0, j] + "</td>");
totalScore += double.Parse(dataArray[i, 0, j]);
num++;
if (string.IsNullOrEmpty(dataArray[dataArray.GetLength(0) - 1, 0, j]) || dataArray[dataArray.GetLength(0) - 1, 0, j] == null)
{
dataArray[dataArray.GetLength(0) - 1, 0, j] = dataArray[i, 0, j];
}
else
{
dataArray[dataArray.GetLength(0) - 1, 0, j] = (double.Parse(dataArray[dataArray.GetLength(0) - 1, 0, j]) + double.Parse(dataArray[i, 0, j])).ToString();
}
}
else
{
tableContent.Append("<td> </td>");
}
}
if (num == 0)
{
tableContent.Append("<td> </td>");
}
else
{
tableContent.Append("<td>" + Math.Round((totalScore / num), 1) + "</td></tr>");
}
}
//员工综合能力评估合计要除以2
if (evaluateType == 530)
{
tableContent.Append("<tr class=\"count\"><td colspan=\"2\">合计（总分200，除2后取得分数）</td>");
for (int j = evaluateUserIdArray.Count - 1; j >= 0; j--)
{
tableContent.Append("<td>" + Math.Round(double.Parse(dataArray[dataArray.GetLength(0) - 1, 0, j]) / 2, 1) + "</td>");
}
}
else
{
tableContent.Append("<tr class=\"count\"><td colspan=\"2\">合计</td>");
for (int j = evaluateUserIdArray.Count - 1; j >= 0; j--)
{
tableContent.Append("<td>" + Math.Round(double.Parse(dataArray[dataArray.GetLength(0) - 1, 0, j]), 1) + "</td>");
}
}
tableContent.Append("<td> </td></tr>");
}
}
}
}
public void PrepareCondition(MssqlCondition mssqlCondition, EvaluateNameInfo evaluateName)
{
mssqlCondition.Add("[CompanyId]", evaluateName.CompanyIdCondition, ConditionType.In);
mssqlCondition.Add("[State]", evaluateName.State, ConditionType.Equal);
}
public static List <EvaluateNameInfo> SearchEvaluateNameList(EvaluateNameInfo evaluateName, int currentPage, int pageSize, ref int count)
{
return(dal.SearchEvaluateNameList(evaluateName, currentPage, pageSize, ref count));
}
public static List <EvaluateNameInfo> SearchEvaluateNameList(EvaluateNameInfo evaluateName)
{
return(dal.SearchEvaluateNameList(evaluateName));
}
public static void UpdateEvaluateName(EvaluateNameInfo evaluateName)
{
dal.UpdateEvaluateName(evaluateName);
}
public static int AddEvaluateName(EvaluateNameInfo evaluateName)
{
return(dal.AddEvaluateName(evaluateName));
}
