public static DataTable SearchCheckElemInfo(PerformanceTaskModel model)
{
#region 查询语句
//查询SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT ID, ");
searchSql.AppendLine(" TaskNo ");
searchSql.AppendLine(" ,ISNULL(Title, '') AS Title ");
searchSql.AppendLine(" FROM ");
searchSql.AppendLine(" officedba.PerformanceTask ");
searchSql.AppendLine(" WHERE ");
searchSql.AppendLine(" CompanyCD = @CompanyCD ");
// searchSql.AppendLine(" and UsedStatus = @UsedStatus ");
#endregion
//定义查询的命令
SqlCommand comm = new SqlCommand();
//添加公司代码参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
// comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", "1"));
//l
//启用状态
//指定命令的SQL文
comm.CommandText = searchSql.ToString();
//执行查询
return SqlHelper.ExecuteSearch(comm);
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
PerformanceTaskModel searchModel = new PerformanceTaskModel();
searchModel.TaskNo = txtSearchTask.Text.Trim();
//启用状态
searchModel.Title = inptSearchTitle.Value.Trim();
if (selSearchTaskFlag .Value != "0")
searchModel.TaskFlag = selSearchTaskFlag.Value;
//启用状态]
string TaskNum = Request.Form["selSearchTaskNum"].ToString();
if (TaskNum != "0")
searchModel.TaskNum = TaskNum;
string TaskYear = Request.Form["selSearchTaskYear"].ToString();
if (TaskYear != "0")
searchModel.TaskDate = TaskYear;
//查询数据
DataTable dtData = PerformanceTaskWorkBus.SearchTaskInfo(searchModel);
//导出标题
string headerTitle = "任务编号|任务主题|考核期间类型|考核周期|开始日期|结束日期";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "TaskNo|Title|TaskFlag|TaskNum|StartDate|EndDate";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dtData, header, field, "考核任务列表");
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
PerformanceTaskModel searchModel = new PerformanceTaskModel();
string selSearchTaskFlag = Request.Form["selSearchTaskFlag"].ToString();
if (selSearchTaskFlag != "0")
searchModel.TaskFlag = selSearchTaskFlag;//考核期间类型
string taskNo = txtTaskTitle.Attributes["title"];
if (!string.IsNullOrEmpty(taskNo))
searchModel.TaskNo = taskNo;//考核任务编号
string SelPerType = Request.Form["SelPerType"].ToString();
if (SelPerType != "0")
searchModel.CompleteDate = SelPerType;//考核类型
if (selSearchTaskFlag != "4" && selSearchTaskFlag != "5")
{
string selSearchTaskNum = Request.Form["selSearchTaskNum"].ToString();
if (selSearchTaskNum != "0")
searchModel.TaskNum = selSearchTaskNum;//考核期间
}
string SelLevelType = Request.Form["SelLevelType"].ToString();
if (SelLevelType != "0")
searchModel.Summaryer = SelLevelType;//考核等级
string SelAdviceType = Request.Form["SelAdviceType"].ToString();
if (SelAdviceType != "0")
searchModel.Title = SelAdviceType;//考核建议
string selSearchTaskYear = Request.Form["selSearchTaskYear"].ToString();
if (selSearchTaskYear != "0")
searchModel.TaskDate = selSearchTaskYear;//考核建议
if (!string.IsNullOrEmpty(txtDeptID.Value ))
{
searchModel.EditFlag = txtDeptID.Value ;//部门
}
searchModel.CompanyCD = userInfo.CompanyCD;
//查询数据
DataTable dtData = PerformanceQueryBus.SearchStaticsInfo(searchModel);
//导出标题
string headerTitle = "部门|任务主题|考核期间类型|考核期间|考核等级|考核建议|人数";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "DeptName|Title|TaskFlag|TaskNum|LevelType|AdviceType|CountPerson";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dtData, header, field, "考核统计列表");
}
/// <summary>
/// 建议等级统计
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static DataTable SearchDetailsInfoByLA(PerformanceTaskModel model)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//获取公司代码
model.CompanyCD = userInfo.CompanyCD;
//执行查询
return PerformanceQueryDBHelper.SearchDetailsInfoByLA(model);
}
public static DataTable SearchSurmmaryInfo(PerformanceTaskModel model)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//获取公司代码
model.CompanyCD = userInfo.CompanyCD;
//执行查询
return PerformanceSummaryDBHelper.SearchSurmmaryInfo(model);
}
public void DataBindToTaskNo()
{
PerformanceTaskModel searchModel = new PerformanceTaskModel();
DataTable dtData = PerformanceQueryBus.SearchRectCheckElemInfo(searchModel);
this.ddlTestNo.DataSource = dtData;
ddlTestNo.DataTextField = "Title";
ddlTestNo.DataValueField = "TaskNo";
ddlTestNo.DataBind();
ddlTestNo.Items.Add(new System.Web.UI.WebControls.ListItem("--请选择--", "0"));
ddlTestNo.SelectedValue = "0";
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
PerformanceTaskModel searchModel = new PerformanceTaskModel();
string selSearchTaskFlag = Request.Form["selSearchTaskFlag"].ToString();
if (selSearchTaskFlag != "0")
searchModel.TaskFlag = selSearchTaskFlag;//考核期间类型
string taskNo = txtTaskTitle.Attributes["title"];
if (!string.IsNullOrEmpty(taskNo))
searchModel.TaskNo = taskNo;//考核任务编号
string SelPerType = Request.Form["SelPerType"].ToString();
if (SelPerType != "0")
searchModel.CompleteDate = SelPerType;//考核类型
if (selSearchTaskFlag != "4" && selSearchTaskFlag != "5")
{
string selSearchTaskNum = Request.Form["selSearchTaskNum"].ToString();
if (selSearchTaskNum != "0")
searchModel.TaskNum = selSearchTaskNum;//考核期间
}
string SelLevelType = Request.Form["SelLevelType"].ToString();
if (SelLevelType != "0")
searchModel.Summaryer = SelLevelType;//考核等级
string SelAdviceType = Request.Form["SelAdviceType"].ToString();
if (SelAdviceType != "0")
searchModel.Title = SelAdviceType;//考核建议
string selSearchTaskYear = Request.Form["selSearchTaskYear"].ToString();
if (selSearchTaskYear != "0")
searchModel.TaskDate = selSearchTaskYear;//考核建议
if (!string.IsNullOrEmpty(txtSearchEmployee.Value ))
searchModel.EditFlag = txtSearchEmployee.Value ;//被考核人
searchModel.CompanyCD = userInfo.CompanyCD;
//查询数据
DataTable dtData = PerformanceQueryBus.SearchScoreInfo(searchModel);
//导出标题
string headerTitle = "被考核人|任务主题|考核期间类型|考核期间|考核模板|考核总得分|累计扣分|累计加分|实际得分|考核等级|考核建议|总评人|总评时间|确认时间";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "passEmployeeID|Title|TaskFlag|TaskNum|templateName|TotalScore|KillScore|AddScore|RealScore|LevelType|AdviceType|EvaluaterName|EvaluateDate|SignDate";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dtData, header, field, "考核查询列表");
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
PerformanceTaskModel searchModel = new PerformanceTaskModel();
searchModel.TaskNo = txtSearchTask.Value.Trim();
//启用状态
searchModel.Title = inptSearchTitle.Value.Trim();
string selSearchTaskFlag = Request.Form["selSearchTaskFlag"].ToString();
if (selSearchTaskFlag != "0")
searchModel.TaskFlag = selSearchTaskFlag;
//启用状态
string selSearchTaskNum = Request.Form["selSearchTaskNum"].ToString();
if (selSearchTaskNum != "0")
searchModel.TaskNum = selSearchTaskNum;
string selTaskStatus = Request.Form["selTaskStatus"].ToString();
if (selTaskStatus != "0")
searchModel.Status = selTaskStatus;
string selSearchTaskYear = Request.Form["selSearchTaskYear"].ToString();
if (selSearchTaskYear != "0")
searchModel.TaskDate = selSearchTaskYear;
searchModel.EditFlag = txtSearchScoreEmployee.Value;
//查询数据
DataTable dtData = PerformanceSummaryBus.SearchSurmmaryInfo(searchModel);
//导出标题
string headerTitle = "被考核人|任务编号|任务主题|考核期间类型|考核期间|考核模板|考核总得分|累计扣分|累计加分|实际得分|考核等级|考核建议|总评人|总评时间";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "passEmployeeName|TaskNo|Title|TaskFlag|TaskNum|templateName|TotalScore|KillScore|AddScore|RealScore|LevelType|AdviceType|EvaluaterName|EvaluateDate";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dtData, header, field, "考核总评");
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
PerformanceTaskModel searchModel = new PerformanceTaskModel();
searchModel.TaskFlag = Request.Form["selSearchTaskFlag"].ToString();
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
searchModel.EditFlag = userInfo.EmployeeID.ToString();
searchModel.CompanyCD = userInfo.CompanyCD;
//查询数据
DataTable dtData = PerformanceSummaryBus.SearchSurmmaryCheckInfo(searchModel);
//导出标题
string headerTitle = "被考核人|任务主题|考核期间类型|考核期间|考核模板|考核总得分|累计扣分|累计加分|实际得分|考核等级|考核建议|总评人|总评时间|确认时间";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "passEmployeeName|Title|TaskFlag|TaskNum|templateName|TotalScore|KillScore|AddScore|RealScore|LevelType|AdviceType|EvaluaterName|EvaluateDate|SignDate";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dtData, header, field, "员工确认");
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
PerformanceTaskModel searchModel = new PerformanceTaskModel();
searchModel.TaskNo = txtSearchTask.Value.Trim();
//启用状态
searchModel.Title = inptSearchTitle.Value.Trim();
string selSearchTaskFlag = Request.Form["selSearchTaskFlag"].ToString();
if (selSearchTaskFlag != "0")
searchModel.TaskFlag = selSearchTaskFlag;
string selSearchTaskNum = Request.Form["selSearchTaskNum"].ToString();
//启用状态
if (selSearchTaskNum != "0")
searchModel.TaskNum = selSearchTaskNum;
string selSearchTaskYear = Request.Form["selSearchTaskYear"].ToString();
if (selSearchTaskYear != "0")
searchModel.TaskDate = selSearchTaskYear;
//查询数据
DataTable dtData = PerformanceSummaryBus.SearchTaskInfo(searchModel);
//导出标题
string headerTitle = "任务编号|任务主题|考核期间类型|考核期间|考核开始日期|考核结束日期|任务状态|创建人|创建时间|汇总人|汇总日期";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "TaskNo|Title|TaskFlag|TaskNum|StartDate|EndDate|Status|Creator|CreateDate|Summaryer|SummaryDate";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dtData, header, field, "评分汇总");
}
public static DataTable SearchScoreInfo(PerformanceTaskModel model)
{
#region 查询语句
//查询SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT ");
searchSql.AppendLine(" CASE when a.TaskFlag='1' then '月考核'");
searchSql.AppendLine(" when a.TaskFlag='2' then '季考核'");
searchSql.AppendLine(" when a.TaskFlag='3' then '半年考核'");
searchSql.AppendLine(" when a.TaskFlag='4' then '年考核'");
searchSql.AppendLine(" when a.TaskFlag='5' then '临时考核'");
searchSql.AppendLine(" when a.TaskFlag is null then ''");
searchSql.AppendLine(" end as TaskFlag");
searchSql.AppendLine(" ,a.ID , d.TemplateNo ");
searchSql.AppendLine(" ,CASE when a.taskflag='2' and a.TaskNum='1' then a.TaskDate+'年第一季度'");
searchSql.AppendLine(" when a.taskflag='2' and a.TaskNum='2' then a.TaskDate+'年第二季度'");
searchSql.AppendLine(" when a.taskflag='2' and a.TaskNum='3' then a.TaskDate+'年第三季度'");
searchSql.AppendLine(" when a.taskflag='2' and a.TaskNum='4' then a.TaskDate+'年第四季度'");
searchSql.AppendLine(" when a.taskflag='3' and a.TaskNum='1' then a.TaskDate+'年上半年'");
searchSql.AppendLine(" when a.taskflag='3' and a.TaskNum='2' then a.TaskDate+'年下半年'");
searchSql.AppendLine(" when a.taskflag='1' then a.TaskDate+'年'+cast(a.TaskNum as varchar)+'月' ");
searchSql.AppendLine(" when a.taskflag='4' then a.TaskDate+'年'+isnull(cast(a.TaskNum as varchar),'') ");
searchSql.AppendLine(" when a.taskflag='5' then cast(a.TaskNum as varchar) ");
searchSql.AppendLine(" when a.taskflag is null then ''");
searchSql.AppendLine(" end as TaskNum , ");
searchSql.AppendLine(" CASE when d.AdviceType='1' then '不做处理'");
searchSql.AppendLine(" when d.AdviceType='2' then '调整薪资'");
searchSql.AppendLine(" when d.AdviceType='3' then '晋升'");
searchSql.AppendLine(" when d.AdviceType='4' then '调职'");
searchSql.AppendLine(" when d.AdviceType='5' then '辅导'");
searchSql.AppendLine(" when d.AdviceType='6' then '培训'");
searchSql.AppendLine(" when d.AdviceType='7' then '辞退'");
searchSql.AppendLine(" when d.AdviceType is null then ''");
searchSql.AppendLine(" end as AdviceType ");
searchSql.AppendLine(" ,CASE when d.LevelType='1' then '达到要求'");
searchSql.AppendLine(" when d.LevelType='2' then '超过要求'");
searchSql.AppendLine(" when d.LevelType='3' then '表现突出'");
searchSql.AppendLine(" when d.LevelType='4' then '需要改进'");
searchSql.AppendLine(" when d.LevelType='5' then '不合格'");
searchSql.AppendLine(" when d.LevelType is null then ''");
searchSql.AppendLine(" end as LevelType ");
searchSql.AppendLine(" ,isnull( d.RealScore,'') as RealScore ");
searchSql.AppendLine(" ,isnull( d.KillScore,'') as KillScore ");
searchSql.AppendLine(" ,isnull( d.AddScore,'') as AddScore ");
searchSql.AppendLine(" ,isnull( d.TotalScore,'') as TotalScore ");
searchSql.AppendLine(" ,a.TaskNo, pt.TypeName");
searchSql.AppendLine(" , ISNULL( CONVERT(VARCHAR(10), d.SignDate,21),'') as SignDate");
searchSql.AppendLine(" , ISNULL( CONVERT(VARCHAR(10), a.SummaryDate,21),'') as SummaryDate");
searchSql.AppendLine(" , ISNULL( CONVERT(VARCHAR(10), a.CreateDate ,21),'') as CreateDate");
searchSql.AppendLine(" , ISNULL( CONVERT(VARCHAR(10), d.EvaluateDate ,21),'') as EvaluateDate");
searchSql.AppendLine(" , ISNULL( CONVERT(VARCHAR(10), a.TaskDate ,21),'') as TaskDate");
searchSql.AppendLine(" ,a.TaskFlag ");
searchSql.AppendLine(" ,isnull( a.Title,'') as Title ");
searchSql.AppendLine(" ,a.TaskNo ,isnull( h.DeptName,'') as DeptName ");
searchSql.AppendLine(" ,CASE when a.status='1' then '待评分'");
searchSql.AppendLine(" when a.status='2' then '待总评'");
searchSql.AppendLine(" when a.status='3' then '已完成'");
searchSql.AppendLine("when a.Status='4' then '待汇总'");
searchSql.AppendLine(" when a.status IS null then ' '");
searchSql.AppendLine(" end as Status ");
searchSql.AppendLine(" , isnull( b.EmployeeName,'') as Creator , isnull( c.EmployeeName,'') as Summaryer ,isnull( e.EmployeeName,'') as passEmployeeName,d.EmployeeID as passEmployeeID,isnull( f.EmployeeName,'') as EvaluaterName, isnull( g.Title,'') as templateName ");
searchSql.AppendLine(" FROM officedba.PerformanceTask a left outer join officedba.EmployeeInfo b on b.CompanyCD=a.CompanyCD and a.Creator=b.ID left outer join officedba.EmployeeInfo c on c.CompanyCD=a.CompanyCD and a.Summaryer=c.ID left outer join officedba.PerformanceSummary d on d.CompanyCD=a.CompanyCD and a.TaskNo=d.TaskNo left outer join officedba.EmployeeInfo e on e.CompanyCD=a.CompanyCD and d.EmployeeID=e.ID left outer join officedba.EmployeeInfo f on f.CompanyCD=a.CompanyCD and d.Evaluater=f.ID left outer join officedba.PerformanceTemplate g on g.CompanyCD=a.CompanyCD and d.TemplateNo= g.TemplateNo");
searchSql.AppendLine(" left outer join officedba.DeptInfo h");
searchSql.AppendLine(" on h.CompanyCD=a.CompanyCD and e.deptID=h.ID");
searchSql.AppendLine(" left outer join officedba.PerformanceType pt");
searchSql.AppendLine(" on pt.CompanyCD=a.CompanyCD and g.TypeID=pt.ID");
searchSql.AppendLine(" WHERE a.CompanyCD = @CompanyCD and a.Status='3' ");
#endregion
//定义查询的命令
SqlCommand comm = new SqlCommand();
//添加公司代码参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
if (!string.IsNullOrEmpty(model.EndDate))//部门
{
searchSql.AppendLine(" AND e.deptID=@deptID ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@deptID", model.EndDate));
}
if (!string.IsNullOrEmpty(model.EditFlag))//被考核人
{
searchSql.AppendLine(" AND d.EmployeeID=@EmployeeID ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", model.EditFlag));
}
if (!string.IsNullOrEmpty(model.TaskNo ))//考核任务编号
{
searchSql.AppendLine(" AND a.TaskNo=@TaskNo ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNo", model.TaskNo));
}
if (!string.IsNullOrEmpty(model.TaskDate))//考核任务编号
{
searchSql.AppendLine(" AND a.TaskDate=@TaskDate ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskDate", model.TaskDate ));
}
if (!string.IsNullOrEmpty(model.CompleteDate))//考核类型
{
searchSql.AppendLine(" AND g.TypeID=@TypeID ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TypeID", model.CompleteDate));
}
if (!string.IsNullOrEmpty(model.TaskNum))//考核期间
{
searchSql.AppendLine(" AND a.TaskNum=@TaskNum ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNum", model.TaskNum));
}
if (!string.IsNullOrEmpty(model.Summaryer))//考核等级
{
searchSql.AppendLine(" AND d.LevelType=@LevelType ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@LevelType", model.Summaryer));
}
if (!string.IsNullOrEmpty(model.Title))//考核建议
{
searchSql.AppendLine(" AND d.AdviceType=@AdviceType ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AdviceType", model.Title));
}
if (!string.IsNullOrEmpty(model.TaskFlag))//考核期间类型
{
searchSql.AppendLine(" AND a.TaskFlag=@TaskFlag ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskFlag", model.TaskFlag));
}
//启用状态
//指定命令的SQL文
comm.CommandText = searchSql.ToString();
//执行查询
return SqlHelper.ExecuteSearch(comm);
}
public static bool GatherInfo(PerformanceTaskModel model, IList<PerformanceSummaryModel> modleSummaryList)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//定义返回变量
bool isSucc = false;
//操作日志
LogInfoModel logModel = InitLogInfo(model.TaskNo);
try
{
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//执行更新操作
/// isSucc = PerformanceTaskDBHelper.UpdatePerTaskInfo(model, modellist, modleSummaryList);
if (PerformanceSummaryDBHelper.UpdateTaskStatusInfo(model))
{
if (PerformanceSummaryDBHelper.UpdatePerSummaryInfo(modleSummaryList))
{
isSucc = true;
}
else
{
isSucc = false;
}
}
else
{
isSucc = false;
}
}
catch (Exception ex)
{
//输出系统日志
WriteSystemLog(userInfo, ex);
}
//更新成功时
if (isSucc)
{
//设置操作成功标识
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
//更新不成功
else
{
//设置操作成功标识
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
//登陆日志
LogDBHelper.InsertLog(logModel);
return isSucc;
}
public static DataTable SearchDetailsInfoByLA(PerformanceTaskModel model)
{
#region 查询语句
//查询SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT ");
searchSql.AppendLine(" CASE when d.AdviceType='1' then '不做处理'");
searchSql.AppendLine(" when d.AdviceType='2' then '调整薪资'");
searchSql.AppendLine(" when d.AdviceType='3' then '晋升'");
searchSql.AppendLine(" when d.AdviceType='4' then '调职'");
searchSql.AppendLine(" when d.AdviceType='5' then '辅导'");
searchSql.AppendLine(" when d.AdviceType='6' then '培训'");
searchSql.AppendLine(" when d.AdviceType='7' then '辞退'");
searchSql.AppendLine(" when d.AdviceType is null then ''");
searchSql.AppendLine(" end as LevelType ");
searchSql.AppendLine(" ,count( e.deptID) as ID ,d.AdviceType as typeID ");
searchSql.AppendLine(" FROM officedba.PerformanceTask a left outer join ");
searchSql.AppendLine(" officedba.EmployeeInfo b");
searchSql.AppendLine(" on b.CompanyCD=a.CompanyCD and a.Creator=b.ID ");
searchSql.AppendLine(" left outer join officedba.EmployeeInfo c ");
searchSql.AppendLine(" on c.CompanyCD=a.CompanyCD and a.Summaryer=c.ID");
searchSql.AppendLine(" left outer join officedba.PerformanceSummary d ");
searchSql.AppendLine(" on d.CompanyCD=a.CompanyCD and a.TaskNo=d.TaskNo ");
searchSql.AppendLine(" left outer join officedba.EmployeeInfo e");
searchSql.AppendLine(" on e.CompanyCD =a.CompanyCD and d.EmployeeID=e.ID ");
searchSql.AppendLine(" left outer join officedba.EmployeeInfo f ");
searchSql.AppendLine(" on f.CompanyCD =a.CompanyCD and d.Evaluater=f.ID ");
searchSql.AppendLine(" left outer join officedba.PerformanceTemplate g");
searchSql.AppendLine(" on g.CompanyCD=a.CompanyCD and d.TemplateNo= g.TemplateNo");
searchSql.AppendLine(" left outer join officedba.DeptInfo h");
searchSql.AppendLine(" on h.CompanyCD =a.CompanyCD and e.deptID=h.ID");
searchSql.AppendLine(" where a.CompanyCD=@CompanyCD and a.Status='3'");
#endregion
//定义查询的命令
SqlCommand comm = new SqlCommand();
//添加公司代码参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
if (!string.IsNullOrEmpty(model.EditFlag))//被考核人
{
searchSql.AppendLine(" AND e.DeptID=@DeptID ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptID", model.EditFlag));
}
if (!string.IsNullOrEmpty(model.TaskNo))//考核任务编号
{
searchSql.AppendLine(" AND a.TaskNo=@TaskNo ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNo", model.TaskNo));
}
if (!string.IsNullOrEmpty(model.CompleteDate))//考核类型
{
searchSql.AppendLine(" AND g.TypeID=@TypeID ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TypeID", model.CompleteDate));
}
if (!string.IsNullOrEmpty(model.TaskNum))//考核期间
{
searchSql.AppendLine(" AND a.TaskNum=@TaskNum ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNum", model.TaskNum));
}
if (!string.IsNullOrEmpty(model.Summaryer))//考核等级
{
searchSql.AppendLine(" AND d.LevelType=@LevelType ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@LevelType", model.Summaryer));
}
if (!string.IsNullOrEmpty(model.Title))//考核建议
{
searchSql.AppendLine(" AND d.AdviceType=@AdviceType ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AdviceType", model.Title));
}
if (!string.IsNullOrEmpty(model.TaskDate))//考核建议
{
searchSql.AppendLine(" AND a.TaskDate=@TaskDate ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskDate", model.TaskDate));
}
if (!string.IsNullOrEmpty(model.TaskFlag))//考核期间类型
{
searchSql.AppendLine(" AND a.TaskFlag=@TaskFlag ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskFlag", model.TaskFlag));
}
if (!string.IsNullOrEmpty(model.SummaryDate))//部门
{
searchSql.AppendLine(" AND e.deptID=@deptID ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@deptID", model.SummaryDate));
}
// e.deptID,g.TypeID,a.TaskNo,a.taskflag,a.TaskNum,
searchSql.AppendLine(" group by d.AdviceType order by ID desc");
//启用状态
//指定命令的SQL文
comm.CommandText = searchSql.ToString();
//执行查询
return SqlHelper.ExecuteSearch(comm);
}
public static DataTable SearchTaskInfo(PerformanceTaskModel model)
{
#region 查询语句
//查询SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT ");
searchSql.AppendLine(" ID ");
if (model.TaskFlag == "1")
{
searchSql.AppendLine(" ,CASE TaskNum ");
searchSql.AppendLine(" WHEN '1' THEN '1月' ");
searchSql.AppendLine(" WHEN '2' THEN '2月' ");
searchSql.AppendLine(" WHEN '3' THEN '3月' ");
searchSql.AppendLine(" WHEN '4' THEN '4月' ");
searchSql.AppendLine(" WHEN '5' THEN '5月' ");
searchSql.AppendLine(" WHEN '6' THEN '6月' ");
searchSql.AppendLine(" WHEN '7' THEN '7月' ");
searchSql.AppendLine(" WHEN '8' THEN '8月' ");
searchSql.AppendLine(" WHEN '9' THEN '9月' ");
searchSql.AppendLine(" WHEN '10' THEN '10月' ");
searchSql.AppendLine(" WHEN '11' THEN '12月' ");
searchSql.AppendLine(" WHEN '12' THEN '12月' ");
searchSql.AppendLine(" ELSE '' ");
searchSql.AppendLine(" END AS TaskNum ");
}
if (model.TaskFlag == "2")
{
searchSql.AppendLine(" ,CASE TaskNum ");
searchSql.AppendLine(" WHEN '1' THEN TaskDate+'第一季度' ");
searchSql.AppendLine(" WHEN '2' THEN TaskDate+'第二季度' ");
searchSql.AppendLine(" WHEN '3' THEN TaskDate+'第三季度' ");
searchSql.AppendLine(" WHEN '4' THEN TaskDate+'第四季度' ");
searchSql.AppendLine(" ELSE '' ");
searchSql.AppendLine(" END AS TaskNum ");
}
if (model.TaskFlag == "3")
{
searchSql.AppendLine(" ,CASE TaskNum ");
searchSql.AppendLine(" WHEN '1' THEN TaskDate+'上半年' ");
searchSql.AppendLine(" WHEN '2' THEN TaskDate+'下半年' ");
searchSql.AppendLine(" ELSE '' ");
searchSql.AppendLine(" END AS TaskNum ");
}
if (model.TaskFlag == "4" || model.TaskFlag == "5")
{
searchSql.AppendLine(" ,TaskNum ");
}
searchSql.AppendLine(" ,StartDate ");
searchSql.AppendLine(" ,EndDate ");
searchSql.AppendLine(" ,TaskFlag ");
searchSql.AppendLine(" ,Title ");
searchSql.AppendLine(" ,TaskNo ");
searchSql.AppendLine(" ,TaskDate ");
searchSql.AppendLine(" FROM officedba.PerformanceTask ");
searchSql.AppendLine(" WHERE CompanyCD = @CompanyCD ");
#endregion
//定义查询的命令
SqlCommand comm = new SqlCommand();
//添加公司代码参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
//l
if (!string.IsNullOrEmpty(model.TaskNo))
{
searchSql.AppendLine(" AND TaskNo = @TaskNo ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNo", model.TaskNo));
}
if (!string.IsNullOrEmpty(model.TaskFlag))
{
searchSql.AppendLine(" AND TaskFlag = @TaskFlag ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskFlag", model.TaskFlag));
}
if (model.TaskFlag != "4" || model.TaskFlag != "5")
{
if (!string.IsNullOrEmpty(model.TaskNum))
{
searchSql.AppendLine(" AND TaskNum = @TaskNum ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNum", model.TaskNum));
}
}
if (!string.IsNullOrEmpty(model.Title))
{
searchSql.AppendLine(" AND Title LIKE @Title ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Title", "%" + model.Title + "%"));
}
//启用状态
//指定命令的SQL文
comm.CommandText = searchSql.ToString();
//执行查询
return SqlHelper.ExecuteSearch(comm);
}
public static DataTable SearchStaticsInfo(PerformanceTaskModel model)
{
#region 查询语句
//查询SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT isnull(e.deptID,'') as deptID,a.taskNo, Isnull( a.Title,'') as Title, ");
searchSql.AppendLine(" CASE when a.TaskFlag='1' then '月考核'");
searchSql.AppendLine(" when a.TaskFlag='2' then '季考核'");
searchSql.AppendLine(" when a.TaskFlag='3' then '半年考核'");
searchSql.AppendLine(" when a.TaskFlag='4' then '年考核'");
searchSql.AppendLine(" when a.TaskFlag='5' then '临时考核'");
searchSql.AppendLine(" when a.TaskFlag is null then ''");
searchSql.AppendLine(" end as TaskFlag ");
searchSql.AppendLine(" ,CASE when a.taskflag='2' and a.TaskNum='1' then a.TaskDate+'年第一季度'");
searchSql.AppendLine(" when a.taskflag='2' and a.TaskNum='2' then a.TaskDate+'年第二季度'");
searchSql.AppendLine(" when a.taskflag='2' and a.TaskNum='3' then a.TaskDate+'年第三季度'");
searchSql.AppendLine(" when a.taskflag='2' and a.TaskNum='4' then a.TaskDate+'年第四季度'");
searchSql.AppendLine(" when a.taskflag='3' and a.TaskNum='1' then a.TaskDate+'年上半年'");
searchSql.AppendLine(" when a.taskflag='3' and a.TaskNum='2' then a.TaskDate+'年下半年'");
searchSql.AppendLine(" when a.taskflag='1' then a.TaskDate+'年'+cast(a.TaskNum as varchar)+'月' ");
searchSql.AppendLine(" when a.taskflag='4' then a.TaskDate+'年'+isnull(cast(a.TaskNum as varchar),'') ");
searchSql.AppendLine(" when a.taskflag='5' then cast(a.TaskNum as varchar) ");
searchSql.AppendLine(" when a.taskflag is null then ''");
searchSql.AppendLine(" end as TaskNum ");
searchSql.AppendLine(" ,CASE when d.LevelType='1' then '达到要求'");
searchSql.AppendLine(" when d.LevelType='2' then '超过要求'");
searchSql.AppendLine(" when d.LevelType='3' then '表现突出'");
searchSql.AppendLine(" when d.LevelType='4' then '需要改进'");
searchSql.AppendLine(" when d.LevelType='5' then '不合格'");
searchSql.AppendLine(" when d.LevelType is null then ''");
searchSql.AppendLine(" end as LevelType ,");
searchSql.AppendLine(" CASE when d.AdviceType='1' then '不做处理'");
searchSql.AppendLine(" when d.AdviceType='2' then '调整薪资'");
searchSql.AppendLine(" when d.AdviceType='3' then '晋升'");
searchSql.AppendLine(" when d.AdviceType='4' then '调职'");
searchSql.AppendLine(" when d.AdviceType='5' then '辅导'");
searchSql.AppendLine(" when d.AdviceType='6' then '培训'");
searchSql.AppendLine(" when d.AdviceType='7' then '辞退'");
searchSql.AppendLine(" when d.AdviceType is null then ''");
searchSql.AppendLine(" end as AdviceType ,isnull( h.DeptName,'') as DeptName ");
searchSql.AppendLine(" ,count( e.deptID) as CountPerson ");
searchSql.AppendLine(" FROM officedba.PerformanceTask a left outer join ");
searchSql.AppendLine(" officedba.EmployeeInfo b");
searchSql.AppendLine(" on b.CompanyCD=a.CompanyCD and a.Creator=b.ID ");
searchSql.AppendLine(" left outer join officedba.EmployeeInfo c ");
searchSql.AppendLine(" on c.CompanyCD=a.CompanyCD and a.Summaryer=c.ID");
searchSql.AppendLine(" left outer join officedba.PerformanceSummary d ");
searchSql.AppendLine(" on d.CompanyCD=a.CompanyCD and a.TaskNo=d.TaskNo ");
searchSql.AppendLine(" left outer join officedba.EmployeeInfo e");
searchSql.AppendLine(" on e.CompanyCD=a.CompanyCD and d.EmployeeID=e.ID ");
searchSql.AppendLine(" left outer join officedba.EmployeeInfo f ");
searchSql.AppendLine(" on f.CompanyCD=a.CompanyCD and d.Evaluater=f.ID ");
searchSql.AppendLine(" left outer join officedba.PerformanceTemplate g");
searchSql.AppendLine(" on g.CompanyCD=a.CompanyCD and d.TemplateNo= g.TemplateNo");
searchSql.AppendLine(" left outer join officedba.DeptInfo h");
searchSql.AppendLine(" on h.CompanyCD=a.CompanyCD and e.deptID=h.ID");
searchSql.AppendLine(" where a.CompanyCD=@CompanyCD and a.Status='3'");
#endregion
//定义查询的命令
SqlCommand comm = new SqlCommand();
//添加公司代码参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
if (!string.IsNullOrEmpty(model.EditFlag))//被考核人
{
searchSql.AppendLine(" AND e.DeptID=@DeptID ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptID", model.EditFlag));
}
if (!string.IsNullOrEmpty(model.TaskNo ))//考核任务编号
{
searchSql.AppendLine(" AND a.TaskNo=@TaskNo ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNo", model.TaskNo));
}
if (!string.IsNullOrEmpty(model.CompleteDate))//考核类型
{
searchSql.AppendLine(" AND g.TypeID=@TypeID ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TypeID", model.CompleteDate));
}
if (!string.IsNullOrEmpty(model.TaskNum))//考核期间
{
searchSql.AppendLine(" AND a.TaskNum=@TaskNum ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNum", model.TaskNum));
}
if (!string.IsNullOrEmpty(model.Summaryer))//考核等级
{
searchSql.AppendLine(" AND d.LevelType=@LevelType ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@LevelType", model.Summaryer));
}
if (!string.IsNullOrEmpty(model.Title))//考核建议
{
searchSql.AppendLine(" AND d.AdviceType=@AdviceType ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AdviceType", model.Title));
}
if (!string.IsNullOrEmpty(model.TaskDate ))//考核建议
{
searchSql.AppendLine(" AND a.TaskDate=@TaskDate ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskDate", model.TaskDate ));
}
if (!string.IsNullOrEmpty(model.TaskFlag))//考核期间类型
{
searchSql.AppendLine(" AND a.TaskFlag=@TaskFlag ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskFlag", model.TaskFlag));
}
searchSql.AppendLine(" group by e.deptID,a.TaskNo,a.taskflag,a.TaskNum,d.LevelType,d.AdviceType,a.TaskDate,h.DeptName,a.title");
//启用状态
//指定命令的SQL文
comm.CommandText = searchSql.ToString();
//执行查询
return SqlHelper.ExecuteSearch(comm);
}
protected void btnOutWord_Click(object sender, EventArgs e)
{
string titleNamee = "考核查询";
HttpResponse resp;
resp = Page.Response;
resp.ContentEncoding = System.Text.Encoding.Default;
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
PerformanceTaskModel searchModel = new PerformanceTaskModel();
if (Request.QueryString["TaskFlag"] != "0")
searchModel.TaskFlag = Request.QueryString["TaskFlag"];//考核期间类型
if (!string.IsNullOrEmpty(Request.QueryString["TaskNo"]))
searchModel.TaskNo = Request.QueryString["TaskNo"];//考核任务编号
if (Request.QueryString["PerTypeID"] != "0")
searchModel.CompleteDate = Request.QueryString["PerTypeID"];//考核类型
if (Request.QueryString["TaskFlag"] != "4" && Request.QueryString["TaskFlag"] != "5")
{
if (Request.QueryString["TaskNum"] != "0")
searchModel.TaskNum = Request.QueryString["TaskNum"];//考核期间
}
if (Request.QueryString["LevelType"] != "0")
searchModel.Summaryer = Request.QueryString["LevelType"];//考核等级
if (Request.QueryString["AdviceType"] != "0")
searchModel.Title = Request.QueryString["AdviceType"];//考核建议
if (Request.QueryString["TaskDate"] != "0")
searchModel.TaskDate = Request.QueryString["TaskDate"];//考核建议
if (!string.IsNullOrEmpty(Request.QueryString["EmployeeID"]))
searchModel.EditFlag = Request.QueryString["EmployeeID"];//被考核人
searchModel.CompanyCD = userInfo.CompanyCD;
//查询数据
DataTable dt = PerformanceQueryBus.SearchScoreInfo(searchModel);
string OutFile = titleNamee + ".xls";
resp.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(System.Text.Encoding.UTF8.GetBytes(OutFile)));
string ls_item = "";
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += titleNamee + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(13);
resp.Write(ls_item);
ls_item = "";
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(13);
resp.Write(ls_item);
ls_item = "";
int i = 0;
ls_item += "被考核人" + Convert.ToChar(9);
ls_item += "任务主题" + Convert.ToChar(9);
ls_item += "考核期间类型" + Convert.ToChar(9);
ls_item += "考核期间" + Convert.ToChar(9);
ls_item += "考核模板" + Convert.ToChar(9);
ls_item += "考核总得分" + Convert.ToChar(9);
ls_item += "累计扣分" + Convert.ToChar(9);
ls_item += "累计加分" + Convert.ToChar(9);
ls_item += "实际得分" + Convert.ToChar(9);
ls_item += "考核等级" + Convert.ToChar(9);
ls_item += "考核建议" + Convert.ToChar(9);
ls_item += "总评人" + Convert.ToChar(9);
ls_item += "总评时间" + Convert.ToChar(9);
ls_item += "确认时间" + Convert.ToChar(13);
resp.Write(ls_item);
ls_item = "";
for (i = 0; i < dt.Rows.Count; i++)
{
ls_item += dt.Rows[i]["passEmployeeName"].ToString() + Convert.ToChar(9);
ls_item += dt.Rows[i]["Title"].ToString() + Convert.ToChar(9);
ls_item += dt.Rows[i]["TaskFlag"].ToString() + Convert.ToChar(9);
ls_item += dt.Rows[i]["TaskNum"].ToString() + Convert.ToChar(9);
ls_item += dt.Rows[i]["templateName"].ToString() + Convert.ToChar(9);
ls_item += dt.Rows[i]["TotalScore"].ToString() + Convert.ToChar(9);
ls_item += dt.Rows[i]["KillScore"].ToString() + Convert.ToChar(9);
ls_item += dt.Rows[i]["AddScore"].ToString() + Convert.ToChar(9);
ls_item += dt.Rows[i]["RealScore"].ToString() + Convert.ToChar(9);
ls_item += dt.Rows[i]["LevelType"].ToString() + Convert.ToChar(9);
ls_item += dt.Rows[i]["AdviceType"].ToString() + Convert.ToChar(9);
ls_item += dt.Rows[i]["EvaluaterName"].ToString() + Convert.ToChar(9);
ls_item += dt.Rows[i]["EvaluateDate"].ToString() + Convert.ToChar(9);
ls_item += dt.Rows[i]["SignDate"].ToString() + Convert.ToChar(13);
resp.Write(ls_item);
ls_item = "";
}
ls_item = "";
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(13);
resp.Write(ls_item);
ls_item = "";
ls_item += "制表人:" + Convert.ToChar(9);
ls_item += ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "打印日期：" + Convert.ToChar(9);
ls_item += DateTime.Now.ToString("yyyy-MM-dd") + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(9);
ls_item += "" + Convert.ToChar(13);
resp.Write(ls_item);
resp.End();
}
protected string GetSource()
{
int defaultCount = Convert.ToInt32(this.linesPerPage.Value);
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
PerformanceTaskModel searchModel = new PerformanceTaskModel();
if (Request.QueryString["TaskFlag"] != "0")
searchModel.TaskFlag = Request.QueryString["TaskFlag"];//考核期间类型
if (!string.IsNullOrEmpty(Request.QueryString["TaskNo"]))
searchModel.TaskNo = Request.QueryString["TaskNo"];//考核任务编号
if (Request.QueryString["PerTypeID"] != "0")
searchModel.CompleteDate = Request.QueryString["PerTypeID"];//考核类型
if (Request.QueryString["TaskFlag"] != "4" && Request.QueryString["TaskFlag"] != "5")
{
if (Request.QueryString["TaskNum"] != "0")
searchModel.TaskNum = Request.QueryString["TaskNum"];//考核期间
}
if (Request.QueryString["LevelType"] != "0")
searchModel.Summaryer = Request.QueryString["LevelType"];//考核等级
if (Request.QueryString["AdviceType"] != "0")
searchModel.Title = Request.QueryString["AdviceType"];//考核建议
if (Request.QueryString["TaskDate"] != "0")
searchModel.TaskDate = Request.QueryString["TaskDate"];//考核建议
if (!string.IsNullOrEmpty(Request.QueryString["EmployeeID"]))
searchModel.EditFlag = Request.QueryString["EmployeeID"];//被考核人
searchModel.CompanyCD = userInfo.CompanyCD;
//查询数据
DataTable dt = PerformanceQueryBus.SearchScoreInfo(searchModel);
StringBuilder htmlStr = new StringBuilder();
htmlStr.Append("\r\t <table width=\"95%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" valign=\"top\" align=\"center\"><tr align=\"center\"><td width=\"95%\" align=\"center\" valign=\"top\"><table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
//表头开始（在打印预览中每页都有）****************************************************************
htmlStr.Append("\r\t <thead style=\"display:table-header-group;font-weight:bold\">");
htmlStr.Append("\r\t <tr><td colspan=\"15\">");
htmlStr.Append("\r\t <table width=\"98%\" height=\"40\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\">");
htmlStr.Append("\r\t <tr>");
htmlStr.Append("\r\t <td align=\"center\" class=\"pS\" valign=\"middle\"><strong> " + "考核查询" + " </strong></td>");
htmlStr.Append("\r\t </tr></table>");
//htmlStr.Append("\r\t <table width=\"98%\" height=\"25px\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
//htmlStr.Append("\r\t <tr><td align=\"left\" style=\"height: 25px;\" class=\"td\" colspan=\"2\">部门");
//htmlStr.Append("\r\t </td></a>");
//htmlStr.Append("\r\t <tr><td align=\"left\" style=\"height: 25px;\" class=\"td\" colspan=\"2\">");
//htmlStr.Append("\r\t </td><td align=\"right\" style=\"height: 25px;\" class=\"td\" colspan=\"4\">币种：" + curryName + "");
//htmlStr.Append("\r\t </td>");
//htmlStr.Append("\r\t </tr></table>");
//htmlStr.Append("\r\t </td></tr>");
htmlStr.Append("<tr>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=\"td1\" style=\"height: 25px\">被考核人</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=\"td1\" style=\"height: 25px\">任务主题</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=\"td1\" style=\"height: 25px\">考核期间类型</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=\"td1\" style=\"height: 25px\">考核期间</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=\"td1\" style=\"height: 25px\">考核模板</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=\"td1\" style=\"height: 25px\">考核总得分</td>");
htmlStr.Append("\r\t <td width=\"4%\" align=\"center\" class=\"td1\" style=\"height: 25px\">累计扣分</td>");
htmlStr.Append("\r\t <td width=\"4%\" align=\"center\" class=\"td1\" style=\"height: 25px\">累计加分</td>");
htmlStr.Append("\r\t <td width=\"4%\" align=\"center\" class=\"td1\" style=\"height: 25px\">实际得分</td>");
htmlStr.Append("\r\t <td width=\"4%\" align=\"center\" class=\"td4\" style=\"height: 25px\">考核等级</td>");
htmlStr.Append("\r\t <td width=\"4%\" align=\"center\" class=\"td4\" style=\"height: 25px\">考核建议</td>");
htmlStr.Append("\r\t <td width=\"3%\" align=\"center\" class=\"td4\" style=\"height: 25px\">总评人</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=\"td4\" style=\"height: 25px\">总评时间</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=\"td4\" style=\"height: 25px\">确认时间</td>");
htmlStr.Append("\r\t </tr></thead>");
//表头结束（在打印预览中每页都有）****************************************************************
//循环列表开始（<input id="linesPerPage" type="hidden" value="4" /> value值控制每输出value行打印预览自动分页）******************************
htmlStr.Append("\r\t <tbody bgcolor=\"white\" id=\"show\"");
if (dt.Rows.Count >= defaultCount)
{
int count = dt.Rows.Count / defaultCount;
int count1 = dt.Rows.Count % defaultCount;
int falcount = count * defaultCount;
if (count1 != 0)
{
falcount = (count + 1) * defaultCount;
}
for (int i = 0; i < falcount; i++)
{
//控制表格的样式
string className = (i + 1) % defaultCount == 0 ? "class=td5" : "class=td4";
string className1 = (i + 1) % defaultCount == 0 ? "class=td3" : "class=td1";
if (i < dt.Rows.Count)
{
htmlStr.Append("\r\t <tr >");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["passEmployeeName"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["Title"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["TaskFlag"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"left\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["TaskNum"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"left\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["templateName"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"right\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["TotalScore"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"right\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["KillScore"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"right\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["AddScore"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"right\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["RealScore"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["LevelType"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["AdviceType"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["EvaluaterName"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["EvaluateDate"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> " + dt.Rows[i]["SignDate"].ToString()+ "</td>");
htmlStr.Append("\r\t <td width=\"15%\" align=\"left\" ");
htmlStr.Append("\r\t " + className + "");
//htmlStr.Append("\r\t style=\"height: 25px\"> " + dt.Rows[i]["EndAmount"].ToString() + "</td>");
htmlStr.Append("\r\t </tr>");
}
else
{
htmlStr.Append("\r\t <tr >");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" " + className1 + " style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" ");
htmlStr.Append("\r\t " + className + "");
htmlStr.Append("\r\t style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t </tr>");
}
}
}
else
{
for (int j = 0; j < dt.Rows.Count; j++)
{
htmlStr.Append("\r\t <tr >");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td1 style=\"height: 25px\"> " + dt.Rows[j]["passEmployeeName"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\"class=td1 style=\"height: 25px\"> " + dt.Rows[j]["Title"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td1 style=\"height: 25px\"> " + dt.Rows[j]["TaskFlag"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"left\" class=td1 style=\"height: 25px\"> " + dt.Rows[j]["TaskNum"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"left\" class=td1 style=\"height: 25px\"> " + dt.Rows[j]["templateName"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"right\" class=td1 style=\"height: 25px\"> " + dt.Rows[j]["TotalScore"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"right\" class=td1 style=\"height: 25px\"> " + dt.Rows[j]["KillScore"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"right\" class=td1 style=\"height: 25px\"> " + dt.Rows[j]["AddScore"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"right\" class=td1 style=\"height: 25px\"> " + dt.Rows[j]["RealScore"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td1 style=\"height: 25px\"> " + dt.Rows[j]["LevelType"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td1 style=\"height: 25px\"> " + dt.Rows[j]["AdviceType"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td1 style=\"height: 25px\"> " + dt.Rows[j]["EvaluaterName"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td1 style=\"height: 25px\"> " + dt.Rows[j]["EvaluateDate"].ToString() + "</td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> " + dt.Rows[j]["SignDate"].ToString() + "</td>");
//htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" ");
//htmlStr.Append("\r\t class=td4");
//htmlStr.Append("\r\t style=\"height: 25px\"> " + dt.Rows[j]["SignDate"].ToString() + "</td>");
htmlStr.Append("\r\t </tr>");
}
for (int k = 0; k < defaultCount - dt.Rows.Count; k++)
{
htmlStr.Append("\r\t <tr>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td1 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td1 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td1 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td1 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td1 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td1 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td1 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td4 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t </tr>");
if (k == (defaultCount - dt.Rows.Count - 1))
{
htmlStr.Append("\r\t <tr>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td3 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td3 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td3 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td3 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td3 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td3 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td3 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t <td width=\"5%\" align=\"center\" class=td5 style=\"height: 25px\"> </td>");
htmlStr.Append("\r\t </tr>");
}
}
}
//循环列表结束（<input id="linesPerPage" type="hidden" value="4" /> value值控制每输出value行打印预览自动分页）******************************
//表尾开始（在打印预览中每页都有）****************************************************************
htmlStr.Append("\r\t </tbody>");
htmlStr.Append("\r\t <tfoot class='noprint2' style=\"display:table-footer-group;font-weight:bold\">");
htmlStr.Append("\r\t <tr><td align=\"left\" class=\"noprint2\" style=\"float:left\">制表:" + ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName + "</td>");
htmlStr.Append("\r\t <td align=\"right\" style=\"height: 23px\" class=\"noprint2\" colspan=\"11\" >打印日期：" + DateTime.Now.ToString("yyyy-MM-dd") + "");
htmlStr.Append("\r\t </td>");
htmlStr.Append("\r\t </td></tr></tfoot>");
//表尾结束（在打印预览中每页都有）****************************************************************
htmlStr.Append("\r\t </table></td></tr></table>");
return htmlStr.ToString();
}
public static DataTable SearchTaskInfo(PerformanceTaskModel model)
{
#region 查询语句
//查询SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT ");
searchSql.AppendLine(" CASE when a.TaskFlag='1' then '月考核'");
searchSql.AppendLine(" when a.TaskFlag='2' then '季考核'");
searchSql.AppendLine(" when a.TaskFlag='3' then '半年考核'");
searchSql.AppendLine(" when a.TaskFlag='4' then '年考核'");
searchSql.AppendLine(" when a.TaskFlag='5' then '临时考核'");
searchSql.AppendLine(" when a.TaskFlag is null then ''");
searchSql.AppendLine(" end as TaskFlag");
searchSql.AppendLine(" ,a.ID , ");
searchSql.AppendLine(" CASE when a.taskflag='2' and a.TaskNum='1' then a.TaskDate+'年第一季度'");
searchSql.AppendLine(" when a.taskflag='2' and a.TaskNum='2' then a.TaskDate+'年第二季度'");
searchSql.AppendLine(" when a.taskflag='2' and a.TaskNum='3' then a.TaskDate+'年第三季度'");
searchSql.AppendLine(" when a.taskflag='2' and a.TaskNum='4' then a.TaskDate+'年第四季度'");
searchSql.AppendLine(" when a.taskflag='3' and a.TaskNum='1' then a.TaskDate+'年上半年'");
searchSql.AppendLine(" when a.taskflag='3' and a.TaskNum='2' then a.TaskDate+'年下半年'");
searchSql.AppendLine(" when a.taskflag='1' then a.TaskDate+'年'+cast(a.TaskNum as varchar)+'月' ");
searchSql.AppendLine(" when a.taskflag='4' then a.TaskDate+'年'+isnull(cast(a.TaskNum as varchar),'') ");
searchSql.AppendLine(" when a.taskflag='5' then cast(a.TaskNum as varchar) ");
searchSql.AppendLine(" when a.taskflag is null then ''");
searchSql.AppendLine(" end as TaskNum ");
searchSql.AppendLine(" , ISNULL( CONVERT(VARCHAR(10), a.StartDate ,21),'') as StartDate");
searchSql.AppendLine(" , ISNULL( CONVERT(VARCHAR(10), a.EndDate ,21),'') as EndDate");
searchSql.AppendLine(" ,a.TaskNo ");
searchSql.AppendLine(" ,a.TaskFlag ");
searchSql.AppendLine(" ,isnull( a.Title,'') as Title ");
searchSql.AppendLine(" ,a.TaskNo ");
searchSql.AppendLine(" , ISNULL( CONVERT(VARCHAR(10), a.TaskDate ,21),'') as TaskDate");
searchSql.AppendLine(" , ISNULL( CONVERT(VARCHAR(10), a.CreateDate ,21),'') as CreateDate");
searchSql.AppendLine(" , ISNULL( CONVERT(VARCHAR(10), a.SummaryDate ,21),'') as SummaryDate");
searchSql.AppendLine(" ,CASE when a.status='1' then '待评分'");
searchSql.AppendLine(" when a.status='2' then '待总评'");
searchSql.AppendLine(" when a.status='3' then '已完成'");
searchSql.AppendLine(" when a.status='4' then '待汇总'");
searchSql.AppendLine(" when a.status IS null then ' '");
searchSql.AppendLine(" end as Status ");
searchSql.AppendLine(" , isnull(b.EmployeeName,'') as Creator , isnull( c.EmployeeName,'') as Summaryer ");
searchSql.AppendLine(" FROM officedba.PerformanceTask a left outer join officedba.EmployeeInfo b on b.CompanyCD=a.CompanyCD and a.Creator=b.ID left outer join officedba.EmployeeInfo c on c.CompanyCD=a.CompanyCD and a.Summaryer=c.ID ");
searchSql.AppendLine(" WHERE a.CompanyCD = @CompanyCD and a.status='4' ");
#endregion
//定义查询的命令
SqlCommand comm = new SqlCommand();
//添加公司代码参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
//l
if (!string.IsNullOrEmpty(model.TaskNo ))
{
searchSql.AppendLine(" AND a.TaskNo like @TaskNo ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNo", "%" + model.TaskNo + "%" ));
}
if (!string.IsNullOrEmpty(model.TaskDate))
{
searchSql.AppendLine(" AND a.TaskDate = @TaskDate ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskDate", model.TaskDate));
}
if (!string.IsNullOrEmpty(model.TaskFlag ))
{
searchSql.AppendLine(" AND a.TaskFlag = @TaskFlag ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskFlag", model.TaskFlag));
}
if (model.TaskFlag != "4" || model.TaskFlag != "5")
{
if (!string.IsNullOrEmpty(model.TaskNum))
{
searchSql.AppendLine(" AND a.TaskNum = @TaskNum ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNum", model.TaskNum));
}
}
if (!string.IsNullOrEmpty(model.Title ))
{
searchSql.AppendLine(" AND a.Title LIKE @Title ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Title", "%" + model.Title + "%"));
}
//启用状态
//指定命令的SQL文
comm.CommandText = searchSql.ToString();
//执行查询
return SqlHelper.ExecuteSearch(comm);
}
/// <summary>
/// 绩效考核按建议分布明细
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="DeptID"></param>
/// <param name="pageIndex"></param>
/// <param name="pageCount"></param>
/// <param name="ord"></param>
/// <param name="TotalCount"></param>
/// <returns></returns>
public static DataTable PerformanceDetailsByLAPrintSelect(PerformanceTaskModel model, int pageIndex, int pageCount, string ord, ref int totalCount)
{
try
{
#region 查询语句
//查询SQL拼写 TaskFlag
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT ");
searchSql.AppendLine(" CASE when d.AdviceType='1' then '不做处理'");
searchSql.AppendLine(" when d.AdviceType='2' then '调整薪资'");
searchSql.AppendLine(" when d.AdviceType='3' then '晋升'");
searchSql.AppendLine(" when d.AdviceType='4' then '调职'");
searchSql.AppendLine(" when d.AdviceType='5' then '辅导'");
searchSql.AppendLine(" when d.AdviceType='6' then '培训'");
searchSql.AppendLine(" when d.AdviceType='7' then '辞退'");
searchSql.AppendLine(" when d.AdviceType is null then ''");
searchSql.AppendLine(" end as LevelType ");
searchSql.AppendLine(" , CASE when a.TaskFlag='1' then '月考核'");
searchSql.AppendLine(" when a.TaskFlag='2' then '季考核'");
searchSql.AppendLine(" when a.TaskFlag='3' then '半年考核'");
searchSql.AppendLine(" when a.TaskFlag='4' then '年考核'");
searchSql.AppendLine(" when a.TaskFlag is null then ''");
searchSql.AppendLine(" end as FlagName ");
searchSql.AppendLine(" ,isnull(e.employeename,'')as EmployeeName");
searchSql.AppendLine(" ,isnull(h.deptname,'')as DeptName");
searchSql.AppendLine(" ,d.EmployeeID");
searchSql.AppendLine(" ,isnull(a.TaskNo,'' ) as TaskNo");
searchSql.AppendLine(" ,isnull(a.Title,'' ) as Title ");
searchSql.AppendLine(" FROM officedba.PerformanceTask a left outer join ");
searchSql.AppendLine(" officedba.EmployeeInfo b");
searchSql.AppendLine(" on b.CompanyCD=a.CompanyCD and a.Creator=b.ID ");
searchSql.AppendLine(" left outer join officedba.EmployeeInfo c ");
searchSql.AppendLine(" on c.CompanyCD=a.CompanyCD and a.Summaryer=c.ID");
searchSql.AppendLine(" left outer join officedba.PerformanceSummary d ");
searchSql.AppendLine(" on d.CompanyCD=a.CompanyCD and a.TaskNo=d.TaskNo");
searchSql.AppendLine(" left outer join officedba.EmployeeInfo e");
searchSql.AppendLine(" on e.CompanyCD=a.CompanyCD and d.EmployeeID=e.ID ");
searchSql.AppendLine(" left outer join officedba.EmployeeInfo f ");
searchSql.AppendLine(" on f.CompanyCD=a.CompanyCD and d.Evaluater=f.ID ");
searchSql.AppendLine(" left outer join officedba.PerformanceTemplate g");
searchSql.AppendLine(" on g.CompanyCD=a.CompanyCD and d.TemplateNo= g.TemplateNo");
searchSql.AppendLine(" left outer join officedba.DeptInfo h");
searchSql.AppendLine(" on h.CompanyCD=a.CompanyCD and e.deptID=h.ID");
searchSql.AppendLine(" where a.CompanyCD=@CompanyCD and a.Status='3'");
#endregion
//定义查询的命令
SqlCommand comm = new SqlCommand();
//添加公司代码参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
if (!string.IsNullOrEmpty(model.EditFlag))//被考核人
{
searchSql.AppendLine(" AND e.DeptID=@DeptID ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptID", model.EditFlag));
}
if (!string.IsNullOrEmpty(model.TaskNo))//考核任务编号
{
searchSql.AppendLine(" AND a.TaskNo=@TaskNo ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNo", model.TaskNo));
}
if (!string.IsNullOrEmpty(model.CompleteDate))//考核类型
{
searchSql.AppendLine(" AND g.TypeID=@TypeID ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TypeID", model.CompleteDate));
}
if (!string.IsNullOrEmpty(model.TaskNum))//考核期间
{
searchSql.AppendLine(" AND a.TaskNum=@TaskNum ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNum", model.TaskNum));
}
if (!string.IsNullOrEmpty(model.Summaryer))//考核等级
{
searchSql.AppendLine(" AND d.LevelType=@LevelType ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@LevelType", model.Summaryer));
}
if (!string.IsNullOrEmpty(model.Title))//考核建议
{
searchSql.AppendLine(" AND d.AdviceType=@AdviceType ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AdviceType", model.Title));
}
if (!string.IsNullOrEmpty(model.TaskDate))//考核建议
{
searchSql.AppendLine(" AND a.TaskDate=@TaskDate ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskDate", model.TaskDate));
}
if (!string.IsNullOrEmpty(model.TaskFlag))//考核期间类型
{
searchSql.AppendLine(" AND a.TaskFlag=@TaskFlag ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskFlag", model.TaskFlag));
}
if (!string.IsNullOrEmpty(model.SummaryDate))//部门
{
searchSql.AppendLine(" AND e.deptID=@deptID ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@deptID", model.SummaryDate));
}
//指定命令的SQL文
comm.CommandText = searchSql.ToString();
return SqlHelper.PagerWithCommand(comm, pageIndex, pageCount, ord, ref totalCount);
}
catch (Exception ex)
{
string sss = ex.Message;
return null;
}
}
/// <summary>
/// 绩效考核按等级分布明细
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="DeptID"></param>
/// <param name="pageIndex"></param>
/// <param name="pageCount"></param>
/// <param name="ord"></param>
/// <param name="TotalCount"></param>
/// <returns></returns>
public static DataTable PerformanceDetailsByLAPrintSelect(PerformanceTaskModel model, int pageIndex, int pageCount, string ord, ref int totalCount)
{
return HumanReportDBHelper.PerformanceDetailsByLAPrintSelect(model, pageIndex, pageCount, ord, ref totalCount);
}
public void Search()
{
ReportDocument oRpt = new ReportDocument();
if (chkType1.Checked)
{
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/PerformanceStaticByLA.rpt"));
}
if (chkType2.Checked)
{
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/PerformanceStaticByLABing.rpt"));
}
if (chkType3.Checked)
{
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/PerformanceStaticByLAZhe.rpt"));
}
// SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息，参数一：用户名；参数二：密码；参数三：服务器；参数四：数据库名
CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.PerformanceSummary"));
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
PerformanceTaskModel searchModel = new PerformanceTaskModel();
if (ddlDeptName.SelectedValue != "0" && ddlDeptName.SelectedIndex != -1)//部门
{
searchModel.SummaryDate = ddlDeptName.SelectedValue;
}
if (ddlTaskFlag.SelectedIndex != 0)
searchModel.TaskFlag = ddlTaskFlag.SelectedValue;//考核期间类型
if (ddlTestNo.SelectedValue != "0" && ddlTestNo.SelectedIndex != -1)
searchModel.TaskNo = ddlTestNo.SelectedValue; //考核任务编号
if (this.ddlPerType.SelectedValue != "0" && ddlPerType.SelectedIndex != -1)
searchModel.CompleteDate = this.ddlPerType.SelectedValue;//考核类型
if (ddlTaskFlag.SelectedValue != "4" && ddlTaskFlag.SelectedValue != "5")
{
if (this.ddlTaskNum.SelectedValue != "0" && ddlTaskNum.SelectedIndex != -1)
searchModel.TaskNum = ddlTaskNum.SelectedValue;//考核期间
}
if (this.ddlLevelType.SelectedIndex != 0)
searchModel.Summaryer = ddlLevelType.SelectedValue;//考核等级
// if (Request.QueryString["AdviceType"] != "0")
// searchModel.Title = Request.QueryString["AdviceType"];//考核建议
if (this.ddlTaskYear.SelectedIndex != 0 && this.ddlTaskYear.SelectedIndex != -1)
searchModel.TaskDate = ddlTaskYear.SelectedValue;//考核建议
// if (!string.IsNullOrEmpty(Request.QueryString["EmployeeID"]))
// searchModel.EditFlag = Request.QueryString["EmployeeID"];//被考核人
searchModel.CompanyCD = userInfo.CompanyCD;
//查询数据
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "" + "\"";
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "" + "\"";
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskFlag"].Text = "\"" + "" + "\"";
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskNum"].Text = "\"" + "考核期间:" + "全部" + "\"";
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\"";
DataTable dtData = PerformanceQueryBus.SearchDetailsInfoByLA (searchModel);
if (ddlDeptName.SelectedValue != "0" && ddlDeptName.SelectedIndex != -1)
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "部门:" + ddlDeptName.Items[ddlDeptName.SelectedIndex].Text + "\"";
}
else
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "部门:" + "全部" + "\"";
}
if (this.ddlPerType.SelectedValue != "0" && ddlPerType.SelectedIndex != -1)
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "考核类型:" + ddlPerType.Items[ddlPerType.SelectedIndex].Text + "\"";
}
else
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "考核类型:" + "全部" + "\"";
}
if (ddlTaskFlag.SelectedIndex != 0)
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskFlag"].Text = "\"" + "考核期间类型:" + ddlTaskFlag.Items[ddlTaskFlag.SelectedIndex].Text + "\"";
}
else
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskFlag"].Text = "\"" + "考核期间类型:" + "全部" + "\"";
}
if (ddlTaskFlag.SelectedValue != "4" && ddlTaskFlag.SelectedValue != "5")
{
if (this.ddlTaskNum.SelectedValue != "0" && ddlTaskNum.SelectedIndex != -1)
{
if (this.ddlTaskYear.SelectedIndex != 0 && this.ddlTaskYear.SelectedIndex != -1)
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskNum"].Text = "\"" + "考核期间:" + ddlTaskYear.Items[ddlTaskYear.SelectedIndex].Text + ddlTaskNum.Items[ddlTaskNum.SelectedIndex].Text + "\"";
}
else
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskNum"].Text = "\"" + "考核期间:" + "所有年份" + ddlTaskNum.Items[ddlTaskNum.SelectedIndex].Text + "\"";
}
}
}
else
{
if (this.ddlTaskYear.SelectedIndex != 0 && this.ddlTaskYear.SelectedIndex != -1)
{
CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["taskNum"].Text = "\"" + ddlTaskYear.Items[ddlTaskYear.SelectedIndex].Text + "\"";
}
}
CrystalReportSource1.ReportDocument.SetDataSource(dtData);
CrystalReportSource1.DataBind();
// CrystalReportViewer1是水晶报表浏览器，下面是给该浏览器赋上对像
CrystalReportViewer1.ReportSource = CrystalReportSource1;
// CrystalReportViewer1.DataBind();
}
public static bool UpdateTaskStatusInfo(PerformanceTaskModel model)
{
#region 插入SQL拼写
StringBuilder insertSql = new StringBuilder();
insertSql.AppendLine("update officedba.PerformanceTask ");
insertSql.AppendLine(" set Status=@Status ");
if (!string.IsNullOrEmpty(model.Summaryer))
{
insertSql.AppendLine(" ,Summaryer=@Summaryer ");
insertSql.AppendLine(" ,SummaryDate=getdate() ");
insertSql.AppendLine(" ,CompleteDate=getdate() ");
}
insertSql.AppendLine(" ,ModifiedUserID=@ModifiedUserID ");
insertSql.AppendLine(" ,ModifiedDate=getdate() ");
insertSql.AppendLine("where CompanyCD=@CompanyCD and TaskNo=@TaskNo ");
#endregion
//定义插入基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = insertSql.ToString();
//设置保存的参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNo", model.TaskNo)); //类型名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TemplateNo", model.Status )); //创建人
if (!string.IsNullOrEmpty(model.Summaryer))
{
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Summaryer", model.Summaryer)); //启用状态
}
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID)); //启用
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Status", model.Status )); //启用状态
//添加返回参数
// comm.Parameters.Add(SqlHelper.GetOutputParameter("@ElemID", SqlDbType.Int));
//执行插入操作
bool isSucc = SqlHelper.ExecuteTransWithCommand(comm);
return isSucc;
}
/// <summary>
/// 保存评分项目信息
/// </summary>
/// <param name="model"> 评分项目实体</param>
/// <returns></returns>
public static bool SaveProTaskInfo(PerformanceTaskModel model, IList<PerformanceScoreModel> modellist, IList<PerformanceSummaryModel> modleSummaryList)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
model.CompanyCD = userInfo.CompanyCD;
//设置最后修改者
model.ModifiedUserID = userInfo.UserID;
//定义返回变量
bool isSucc = false;
//操作日志
LogInfoModel logModel = InitLogInfo(model.TaskNo );
//更新
if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag))
{
try
{
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//执行更新操作
isSucc = PerformanceTaskDBHelper.UpdatePerTaskInfo(model, modellist, modleSummaryList);
}
catch (Exception ex)
{
//输出系统日志
WriteSystemLog(userInfo, ex);
}
}
//插入
else
{
try
{
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//执行插入操作
isSucc = PerformanceTaskDBHelper .InsertPerTaskInfo (model);
if (isSucc)
{
if (PerformanceTaskDBHelper.InsertPerScoreInfo(modellist))
{
if (PerformanceTaskDBHelper.InsertPerSummaryInfo(modleSummaryList))
{
isSucc = true;
}
else
{ return false; }
}
else
{
isSucc= false;
}
}
else
{
isSucc= false;
}
logModel.ObjectID = model.TaskNo ;
}
catch (Exception ex)
{
//输出系统日志
WriteSystemLog(userInfo, ex);
}
}
//更新成功时
if (isSucc)
{
//设置操作成功标识
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
//更新不成功
else
{
//设置操作成功标识
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
//登陆日志
LogDBHelper.InsertLog(logModel);
return isSucc;
}
/// <summary>
/// 批插入考核任务表信息
/// </summary>
/// <param name="modeList"></param>
/// <returns></returns>
public static bool InsertPerTaskInfo(PerformanceTaskModel model)
{
#region 插入SQL拼写
StringBuilder insertSql = new StringBuilder();
insertSql.AppendLine("INSERT INTO officedba.PerformanceTask ");
insertSql.AppendLine(" (CompanyCD ");
insertSql.AppendLine(" ,TaskNo ");
insertSql.AppendLine(" ,Title ");
insertSql.AppendLine(" ,TaskFlag ");
insertSql.AppendLine(" ,TaskDate ");
insertSql.AppendLine(" ,TaskNum ");
insertSql.AppendLine(" ,StartDate ");
insertSql.AppendLine(" ,EndDate ");
insertSql.AppendLine(" ,Status ");
insertSql.AppendLine(" ,CreateDate ");
insertSql.AppendLine(" ,Remark ");
insertSql.AppendLine(" ,Creator) ");
insertSql.AppendLine(" VALUES ");
insertSql.AppendLine(" (@CompanyCD ");
insertSql.AppendLine(" ,@TaskNo ");
insertSql.AppendLine(" ,@Title ");
insertSql.AppendLine(" ,@TaskFlag ");
insertSql.AppendLine(" ,@TaskDate ");
insertSql.AppendLine(" ,@TaskNum ");
insertSql.AppendLine(" ,@StartDate ");
insertSql.AppendLine(" ,@EndDate ");
insertSql.AppendLine(" ,@Status ");
insertSql.AppendLine(" ,getdate() ");
insertSql.AppendLine(" ,@Remark ");
insertSql.AppendLine(" ,@Creator) ");
// insertSql.AppendLine(" set @ElemID= @@IDENTITY ");
#endregion
//定义插入基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = insertSql.ToString();
//设置保存的参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD )); //公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNo", model.TaskNo )); //类型名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Title", model.Title )); //创建人
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskFlag", model.TaskFlag )); //启用状态
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskDate", model.TaskDate )); //更新用户ID
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNum", model.TaskNum )); //更新用户ID
comm.Parameters.Add(SqlHelper.GetParameterFromString("@StartDate", model.StartDate )); //更新用户ID
comm.Parameters.Add(SqlHelper.GetParameterFromString("@EndDate", model.EndDate )); //更新用户ID
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Status", model.Status )); //更新用户ID
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark )); //更新用户ID
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Creator", model.Creator )); //更新用户ID
//添加返回参数
// comm.Parameters.Add(SqlHelper.GetOutputParameter("@ElemID", SqlDbType.Int));
//执行插入操作
bool isSucc = SqlHelper.ExecuteTransWithCommand(comm);
return isSucc;
}
public static DataTable SearchTaskInfo(PerformanceTaskModel model)
{
#region 查询语句
//查询SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT isnull( Convert(varchar(100),ModifiedDate,23),'') AS ModifiedDate, ");
searchSql.AppendLine(" ID ,CASE when taskflag='2' and TaskNum='1' then TaskDate+'年第一季度'");
searchSql.AppendLine(" when taskflag='2' and TaskNum='2' then TaskDate+'年第二季度'");
searchSql.AppendLine(" when taskflag='2' and TaskNum='3' then TaskDate+'年第三季度'");
searchSql.AppendLine(" when taskflag='2' and TaskNum='4' then TaskDate+'年第四季度'");
searchSql.AppendLine(" when taskflag='3' and TaskNum='1' then TaskDate+'年上半年'");
searchSql.AppendLine(" when taskflag='3' and TaskNum='2' then TaskDate+'年下半年'");
searchSql.AppendLine(" when taskflag='1' then TaskDate+'年'+cast(TaskNum as varchar)+'月' ");
searchSql.AppendLine(" when taskflag='4' then TaskDate+'年'+isnull( cast(TaskNum as varchar),'') ");
searchSql.AppendLine(" when taskflag='5' then isnull(cast(TaskNum as varchar),'') ");
searchSql.AppendLine(" when taskflag is null then ''");
searchSql.AppendLine(" end as TaskNum ");
searchSql.AppendLine(" , ISNULL( CONVERT(VARCHAR(10), StartDate,21),'') as StartDate");
searchSql.AppendLine(" , ISNULL( CONVERT(VARCHAR(10), EndDate,21),'') as EndDate");
searchSql.AppendLine(" , ISNULL( CONVERT(VARCHAR(10), TaskDate,21),'') as TaskDate");
searchSql.AppendLine(" ,CASE when TaskFlag='1' then '月考核'");
searchSql.AppendLine(" when TaskFlag='2' then '季考核'");
searchSql.AppendLine(" when TaskFlag='3' then '半年考核'");
searchSql.AppendLine(" when TaskFlag='4' then '年考核'");
searchSql.AppendLine(" when TaskFlag='5' then '临时考核'");
searchSql.AppendLine(" when TaskFlag is null then ''");
searchSql.AppendLine(" end as TaskFlag ");
searchSql.AppendLine(" ,isnull( Title,'') as Title ");
searchSql.AppendLine(" ,TaskNo ");
searchSql.AppendLine(" FROM officedba.PerformanceTask ");
searchSql.AppendLine(" WHERE CompanyCD = @CompanyCD ");
#endregion
//定义查询的命令
SqlCommand comm = new SqlCommand();
//添加公司代码参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
//l
if (!string.IsNullOrEmpty(model.TaskNo ))
{
searchSql.AppendLine(" AND TaskNo like @TaskNo ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNo","%" + model.TaskNo + "%"));
}
if (!string.IsNullOrEmpty(model.TaskFlag ))
{
searchSql.AppendLine(" AND TaskFlag = @TaskFlag ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskFlag", model.TaskFlag));
}
if (model.TaskFlag != "4" || model.TaskFlag != "5")
{
if (!string.IsNullOrEmpty(model.TaskNum))
{
searchSql.AppendLine(" AND TaskNum = @TaskNum ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNum", model.TaskNum));
}
}
if (!string.IsNullOrEmpty(model.TaskDate ))
{
searchSql.AppendLine(" AND TaskDate =@TaskDate ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskDate", model .TaskDate ));
}
if (!string.IsNullOrEmpty(model.Title ))
{
searchSql.AppendLine(" AND Title LIKE @Title ");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Title", "%" + model.Title + "%"));
}
//启用状态
//指定命令的SQL文
comm.CommandText = searchSql.ToString();
//执行查询
return SqlHelper.ExecuteSearch(comm);
}
/// <summary>
/// 批插入模板信息
/// </summary>
/// <param name="modeList"></param>
/// <returns></returns>
public static bool UpdatePerTaskInfo(PerformanceTaskModel model, IList<PerformanceScoreModel> modeList, IList<PerformanceSummaryModel> modleSummaryList)
{
#region 插入SQL拼写
StringBuilder insertSql = new StringBuilder();
insertSql.AppendLine("update officedba.PerformanceTask ");
insertSql.AppendLine(" set Title=@Title ");
insertSql.AppendLine(" ,TaskFlag=@TaskFlag ");
insertSql.AppendLine(" ,TaskDate=@TaskDate ");
insertSql.AppendLine(" ,TaskNum=@TaskNum ");
insertSql.AppendLine(" ,StartDate=@StartDate ");
insertSql.AppendLine(" ,EndDate=@EndDate ");
insertSql.AppendLine(" ,ModifiedDate=getdate() ");
insertSql.AppendLine(" ,ModifiedUserID=@ModifiedUserID ");
insertSql.AppendLine(" ,Remark=@Remark where CompanyCD=@CompanyCD and TaskNo=@TaskNo ");
// insertSql.AppendLine(" set @ElemID= @@IDENTITY ");
#endregion
//定义插入基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = insertSql.ToString();
//设置保存的参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNo", model.TaskNo)); //类型名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Title", model.Title)); //创建人
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskFlag", model.TaskFlag)); //启用状态
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskDate", model.TaskDate)); //更新用户ID
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TaskNum", model.TaskNum)); //更新用户ID
comm.Parameters.Add(SqlHelper.GetParameterFromString("@StartDate", model.StartDate)); //更新用户ID
comm.Parameters.Add(SqlHelper.GetParameterFromString("@EndDate", model.EndDate)); //更新用户ID
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark)); //更新用户ID
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID)); //更新用户ID
//添加返回参数
// comm.Parameters.Add(SqlHelper.GetOutputParameter("@ElemID", SqlDbType.Int));
//执行插入操作
bool isSucc = SqlHelper.ExecuteTransWithCommand(comm);
if (isSucc)
{
if (DeleteByTaskNo(model.TaskNo, model.CompanyCD))
{
if (InsertPerScoreInfo(modeList))
{
isSucc = true;
}
else
{
isSucc = false;
}
}
else
{
isSucc = false;
}
if (DeleteByTaskNoInSummary(model.TaskNo, model.CompanyCD))
{
if (InsertPerSummaryInfo(modleSummaryList))
{
isSucc = true;
}
else
{
isSucc = false;
}
}
else
{
isSucc = false;
}
}
else
{ isSucc = false; }
return isSucc;
}
