/// <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));
}
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="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)); //考核类型编号
}
}
/// <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));
}
