/// <summary>
/// 根据岗位获取有意向人员
/// </summary>
/// <param name="job"></param>
/// <returns></returns>
public string GetJobUser(string job)
{
string userList = "";
try
{
//存储过程名
string strSQL = "Job_GetUserList";
//参数
DbCommand cmd = db.GetStoredProcCommand(strSQL);
db.AddInParameter(cmd, "@Job", DbType.String, job);
DataTable dt = db.ExecuteDataSet(cmd).Tables[0];
userList = dt.Rows.Count.ToString() + "位有该岗位意向,具体如下:";
foreach (DataRow dr in dt.Rows)
{
userList += dr["姓名"]+",";
}
return userList;
}
catch (Exception ex)
{
return null;
}
return userList;
}