private void ExportItemInfoItem(XWPFTable tb)
{
int i = 0;
decimal totalScore = 0;
List <string> mergework = new List <string>(); //用于合并单元格
List <AssessActivityItem> AssessActivityItemList = new List <AssessActivityItem>();
AssessActivityItemList.AddRange(_AssessActivity.ItsAssessActivityPaper.SubmitInfoes[_SubmitInfoIndex].
ItsAssessActivityItems);
foreach (ItemClassficationEmnu c in AssessUtility.GetAllItemClassficationEmnu())
{
if (c == ItemClassficationEmnu._360)
{
continue;
}
int j = 0; //重复项数量
foreach (AssessActivityItem item in AssessActivityItemList)
{
if (item.AssessTemplateItemType == AssessTemplateItemType.Option && item.Classfication == c)
{
if (j == 0)
{
SetText(tb, i + 1, 0, string.Format("{0}考评", AssessUtility.ClassficationToString(item.Classfication)));
}
SetText(tb, i + 1, 1, item.Question);
int gradecellindex = item.Grade < 6 ? Convert.ToInt32(item.Grade) : Convert.ToInt32(item.Grade) / 20;
SetText(tb, i + 1, gradecellindex + 1, Convert.ToInt32(item.Grade).ToString());
SetText(tb, i + 1, 7, string.Format("{0}%", Convert.ToInt32(item.Weight * 100)));
totalScore += Convert.ToInt32(item.Grade) * item.Weight;
i++;
j++;
}
}
if (j > 1)
{
mergework.Add(string.Format("{0}:{1}", 1 + i - j, i));
}
}
_ItemCount = _ItemCount > 0 ? _ItemCount : 1;
SetText(tb, i + 1, 1, totalScore.ToString());
MergeCellsHorizontal(tb, 0, 2, 6);
SetText(tb, 0, 2, "评定（很差→很好）", ParagraphAlignment.CENTER);
MergeCellsHorizontal(tb, i + 1, 1, 7);
SetText(tb, i + 1, 0, "总评分");
//合并单元格
for (int k = mergework.Count - 1; k >= 0; k--)
{
string[] s = mergework[k].Split(':');
int start = Convert.ToInt32(s[0]);
int end = Convert.ToInt32(s[1]);
MergeCellsVertically(tb, 0, start, end);
}
}
public void InitView(bool ispostback, string itemId)
{
_View.Message = "";
_View.ItemMessage5 = "";
_View.ItemMessage4 = "";
_View.ItemMessage3 = "";
_View.ItemMessage2 = "";
_View.ItemMessage1 = "";
_View.QestionNullMessage = "";
_View.RangeError = "";
_View.FormulaError = "";
_View.PageTitle = "绩效考核项详情";
if (!int.TryParse(itemId, out _TemplateItemID))
{
_View.Message = "<span class='fontred'>初始错误</span>";
return;
}
_View.ReadOnly = true;
if (!ispostback)
{
_View.ClassficationSource = AssessUtility.GetItemClassfication();
AssessTemplateItem item = _IAssessManagementFacade.GetTemplateItemById(_TemplateItemID);
_View.AssessTemplateItemType = (int)item.AssessTemplateItemType;
_View.ItemOperateType = item.ItsOperateType;
_View.Question = item.Question;
_View.ClassficationId = item.Classfication.ToString();
_View.Description = item.Description;
string[] options = item.Option.Split('/');
switch (_View.AssessTemplateItemType)
{
case 0:
_View.Option5 = options[0];
_View.Option4 = options[1];
_View.Option3 = options[2];
_View.Option2 = options[3];
_View.Option1 = options[4];
break;
case 2:
_View.MinRange = options[0];
_View.MaxRange = options[1];
break;
case 3:
_View.Formula = item.Option;
break;
}
_View.Description = item.Description;
}
}
public void ExecuteEvent(object sender, EventArgs e)
{
try
{
ItemClassficationEmnu itemClassfication = AssessUtility.GetChoosedItemClassfication(_View.ItemClassfication);
_View.TemplateItems = _IAssessManagementFacade.GetTemplateItemsByConditon(_View.Question, _View.OperateType, itemClassfication, _View.SelectedAssessTemplateItemType);
_View.Message =
"<span class='font14b'>共查到 </span>"
+ "<span class='fontred'>" + _View.TemplateItems.Count + "</span>"
+ "<span class='font14b'> 个绩效考核项</span>";
}
catch (Exception ex)
{
_View.Message = "<span class='fontred'>" + ex.Message + "</span>";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string formula = Request.QueryString["formula"];
string ans = string.Empty;
try
{
AssessUtility.CheckFormula(formula);
}
catch
{
ans = "error";
}
Response.Write(ans);
Response.End();
}
/// <summary>
/// 分类界面显示
/// </summary>
/// <returns></returns>
private void DisplayItem()
{
foreach (GridViewRow row in grvitemlist.Rows)
{
CheckBox chbType = (CheckBox)row.FindControl("chbType");
chbType.Enabled = false;
if (chbType.Text == "HR")
{
chbType.Checked = true;
chbType.Text = "";
}
else
{
chbType.Text = "";
}
Label lblType = (Label)row.FindControl("lblType");
lblType.Text = AssessUtility.GetChoosedItemClassficationName(lblType.Text);
}
}
private static bool VaildeFormula(bool iRet, IAddTemplateItemView view)
{
if (string.IsNullOrEmpty(view.Formula))
{
view.FormulaError = "不能为空";
iRet = false;
}
else
{
try
{
AssessUtility.CheckFormula(view.Formula);
}
catch
{
view.FormulaError = "公式错误";
iRet = false;
}
}
return(iRet);
}
private void GetData()
{
_View.ItemClassficationSource = AssessUtility.GetItemClassfication();
}
public static ItemClassficationEmnu GetChoosedItemClassfication(string classfication)
{
return(AssessUtility.GetChoosedItemClassfication(classfication));
}
public static Dictionary <string, string> GetItemClassficationEnum()
{
return(AssessUtility.GetItemClassfication());
}
private void ExportItemInfo(XWPFTable tb)
{
int i = 0;
decimal totalScore = 0;
List <string> mergework = new List <string>(); //用于合并单元格
List <AssessActivityItem> AssessActivityItemList = new List <AssessActivityItem>();
AssessActivityItemList.AddRange(_AssessActivity.ItsAssessActivityPaper.SubmitInfoes[_SubmitInfoManageIndex].
ItsAssessActivityItems);
AssessActivityItemList.AddRange(_AssessActivity.ItsAssessActivityPaper.SubmitInfoes[_SubmitInfoHrIndex].
ItsAssessActivityItems);
MergeCellsHorizontal(tb, 0, 2, 6);
foreach (ItemClassficationEmnu c in AssessUtility.GetAllItemClassficationEmnu())
{
int j = 0; //重复项数量
foreach (
AssessActivityItem item in AssessActivityItemList)
{
if (item.AssessTemplateItemType == AssessTemplateItemType.Option && item.Classfication == c)
{
if (j == 0)
{
SetText(tb, i + 1, 0, string.Format("{0}考评", AssessUtility.ClassficationToString(item.Classfication)), ParagraphAlignment.CENTER);
}
SetText(tb, i + 1, 1, item.Question, ParagraphAlignment.CENTER);
int gradecellindex = item.Grade < 6 ? Convert.ToInt32(item.Grade) : Convert.ToInt32(item.Grade) / 20;
SetText(tb, i + 1, gradecellindex + 1, Convert.ToInt32(item.Grade).ToString());
SetText(tb, i + 1, 7, string.Format("{0}%", Convert.ToInt32(item.Weight * 100)));
totalScore += Convert.ToInt32(item.Grade) * item.Weight;
i++;
j++;
}
}
if (j > 1)
{
mergework.Add(string.Format("{0}:{1}", 1 + i - j, i));
}
}
_ItemCount = _ItemCount > 0 ? _ItemCount : 1;
SetText(tb, _ItemCount + 1, 0, "总评分");
SetText(tb, _ItemCount + 1, 1, totalScore.ToString());
MergeCellsHorizontal(tb, _ItemCount + 1, 1, 7);
SetText(tb, 0, 2, "评定（很差→很好）", ParagraphAlignment.CENTER);
SetText(tb, _ItemCount + 2, 0, "目前工资");
SetText(tb, _ItemCount + 2, 1, _AssessActivity.ItsAssessActivityPaper.SubmitInfoes[_SubmitInfoHrIndex].SalaryNow.ToString());
SetText(tb, _ItemCount + 2, 3, _AssessActivity.AssessCharacterType == AssessCharacterType.ProbationII ? "转正后工资" : "调薪工资");
SetText(tb, _ItemCount + 2, 5, _AssessActivity.ItsAssessActivityPaper.SubmitInfoes[_SubmitInfoCEOIndex].SalaryChange.ToString());
MergeCellsHorizontal(tb, _ItemCount + 2, 1, 2);
MergeCellsHorizontal(tb, _ItemCount + 2, 3, 4);
MergeCellsHorizontal(tb, _ItemCount + 2, 5, 7);
foreach (SubmitInfo info in _AssessActivity.ItsAssessActivityPaper.SubmitInfoes)
{
if (info.SubmitInfoType.Id == SubmitInfoType.ManagerAssess.Id)
{
AddComment(tb, 0, info, "用人部门意见");
}
else if (info.SubmitInfoType.Id == SubmitInfoType.Approve.Id)
{
AddComment(tb, 2, info, "总经理意见");
}
else if (info.SubmitInfoType.Id == SubmitInfoType.SummarizeCommment.Id)
{
AddComment(tb, 5, info, "人力资源部意见");
}
}
MergeCellsHorizontal(tb, _ItemCount + 3, 0, 1);
MergeCellsHorizontal(tb, _ItemCount + 4, 0, 1);
MergeCellsHorizontal(tb, _ItemCount + 5, 0, 1);
MergeCellsHorizontal(tb, _ItemCount + 3, 2, 4);
MergeCellsHorizontal(tb, _ItemCount + 4, 2, 4);
MergeCellsHorizontal(tb, _ItemCount + 5, 2, 4);
MergeCellsHorizontal(tb, _ItemCount + 3, 5, 7);
MergeCellsHorizontal(tb, _ItemCount + 4, 5, 7);
MergeCellsHorizontal(tb, _ItemCount + 5, 5, 7);
//合并单元格
for (int k = mergework.Count - 1; k >= 0; k--)
{
string[] s = mergework[k].Split(':');
int start = Convert.ToInt32(s[0]);
int end = Convert.ToInt32(s[1]);
MergeCellsVertically(tb, 0, start, end);
}
}
