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