protected void btnImport_Click(object sender, ImageClickEventArgs e) { PerformanceTemplateEmpModel searchModel = new PerformanceTemplateEmpModel(); searchModel.EmployeeID = txtSearchEmployeeID.Value ; searchModel.ScoreEmployee = txtSearchScoreEmployee.Value ; //设置查询条件 //要素名称 /// searchModel.ElemName = context.Request.QueryString["ElemName"]; //启用状态 /// searchModel.UsedStatus = context.Request.QueryString["UsedStatus"]; //查询数据 DataTable dtData = PerformanceTemplateEmpBus.SearchFlowInfo(searchModel); if (!string.IsNullOrEmpty(txtSearchTemplateName.Value .Trim ())) { dtData = GetNewDataTable(dtData, "TemplateName like '%" + txtSearchTemplateName.Value .Trim () + "%'"); } //导出标题 string headerTitle = "被考评人员|模板名称|考核步骤|考评人"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "EmployeeName|TemplateName|StepName|ScoreEmployee"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dtData, header, field, "人员考核流程设置"); }
public static DataTable GetEmployeeInfo(PerformanceTemplateEmpModel model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //获取公司代码 model.CompanyCD = userInfo.CompanyCD; //执行查询 return PerformanceTemplateEmpDBHelper.GetEmployeeInfo (model); }
/// <summary> /// 查询模板库和模板流程库获取模板和模板相关的指标、指标顺序、权重信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static DataTable SearchFlowInfo(PerformanceTemplateEmpModel model) { //查询SQL拼写 StringBuilder searchSql = new StringBuilder(); searchSql.AppendLine("select a.TemplateNo,a.EmployeeID,a.ID,ISNULL(a.StepName,'') as StepName, ISNULL(b.EmployeeName,'') as ScoreEmployee,ISNULL(c.EmployeeName,'') as EmployeeName,ISNULL(d.Title,'') as TemplateName,isnull(Convert(varchar(100),a.ModifiedDate,23),'') AS ModifiedDate from officedba.PerformanceTemplateEmp a left outer join officedba.EmployeeInfo b on b.CompanyCD=a.CompanyCD and a.ScoreEmployee=b.ID left outer join officedba.EmployeeInfo c on c.CompanyCD=a.CompanyCD and a.EmployeeID=c.ID left outer join officedba.PerformanceTemplate d on a.CompanyCD=d.CompanyCD and a.TemplateNo=d.TemplateNo where a.CompanyCD = @CompanyCD "); if ( !string .IsNullOrEmpty (model.EmployeeID)) { searchSql.AppendLine("and a.EmployeeID=@EmployeeID"); } if (!string .IsNullOrEmpty (model.ScoreEmployee)) { searchSql.AppendLine("and a.ScoreEmployee=@ScoreEmployee"); } //定义查询的命令 SqlCommand comm = new SqlCommand(); //添加公司代码参数 if (model.EmployeeID != "") { comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", model.EmployeeID )); } if (model.ScoreEmployee != "") { comm.Parameters.Add(SqlHelper.GetParameterFromString("@ScoreEmployee", model.ScoreEmployee)); } comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD )); //l //启用状态 //指定命令的SQL文 comm.CommandText = searchSql.ToString(); //执行查询 return SqlHelper.ExecuteSearch(comm); }
/// <summary> /// 根据员工编号和公司代码获取该员工信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static DataTable GetEmployeeInfo(PerformanceTemplateEmpModel model) { #region 查询语句 //查询SQL拼写 StringBuilder searchSql = new StringBuilder(); searchSql.AppendLine("select a.StepNo,a.Rate,a.ScoreEmployee,a.TemplateNo, a.EmployeeID,a.ID,ISNULL(a.StepName,'') as StepName, ISNULL(b.EmployeeName,'') as ScoreEmployeeName,ISNULL(c.EmployeeName,'') as EmployeeName,ISNULL(d.Title,'') as TemplateName,ISNULL(a.remark,'') as remark from officedba.PerformanceTemplateEmp a left outer join officedba.EmployeeInfo b on b.CompanyCD=a.CompanyCD and a.ScoreEmployee=b.ID left outer join officedba.EmployeeInfo c on c.CompanyCD=a.CompanyCD and a.EmployeeID=c.ID left outer join officedba.PerformanceTemplate d on a.CompanyCD=d.CompanyCD and a.TemplateNo=d.TemplateNo where a.CompanyCD = @CompanyCD and a.TemplateNo=@TemplateNo and a.EmployeeID=@EmployeeID "); #endregion //定义查询的命令 SqlCommand comm = new SqlCommand(); //添加公司代码参数 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", model.EmployeeID )); comm.Parameters.Add(SqlHelper.GetParameterFromString("@TemplateNo", model.TemplateNo )); //l //启用状态 //指定命令的SQL文 comm.CommandText = searchSql.ToString(); //执行查询 return SqlHelper.ExecuteSearch(comm); }
/// <summary> /// 保存基本参数 /// </summary> /// <param name="comm"></param> /// <param name="model"></param> private static void SetSaveParameter(SqlCommand comm, PerformanceTemplateEmpModel model) { //设置参数 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@TemplateNo", model.TemplateNo )); //类型名称 comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", model.EmployeeID )); //创建人 comm.Parameters.Add(SqlHelper.GetParameterFromString("@StepNo", model.StepNo )); //启用状态 comm.Parameters.Add(SqlHelper.GetParameterFromString("@StepName", model.StepName )); //更新用户ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@Rate", model.Rate )); //更新用户ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@ScoreEmployee", model.ScoreEmployee )); //更新用户ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@remark", model.remark )); //更新用户ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID )); //更新用户ID if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag )) { comm.Parameters.Add(SqlHelper.GetParameterFromString("@ID", model.ID )); //考核类型编号 } }