/// <summary>
/// free pass 등록을 위한 직원 정보 가져오기
/// </summary>
/// <param name="upnid"></param>
/// <returns></returns>
///
public List <FreePassUserInfo> selectEmployeeForfreepass(String ename)
{
log.Debug(@"=================START selectEmployeeForfreepass=================");
log.Debug(@"name = " + ename);
List <FreePassUserInfo> list = new List <FreePassUserInfo>();
StringBuilder sql_select = new StringBuilder();
sql_select.Append(@"
SELECT a.UPNID,a.displayName,b.dep_name
FROM GCM.dbo.UserInfo_MTB a ,GCM.dbo.DEPART_MTB b
WHERE a.department=b.dep_code
AND a.reg_type = '9'
AND a.displayName like '" + ename + "%'");
//Execute the query against the database
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_select.ToString(), null))
{
// Scroll through the results
while (rdr.Read())
{
FreePassUserInfo obj = new FreePassUserInfo();
obj = bindEmployeeForFreePass(rdr, obj);
list.Add(obj);
}
}
log.Debug(@"=================END listEmployee=================");
return(list);
}
// 2011-08-22-김민우
/// <summary>
/// RecordSet 과 Model Match
/// </summary>
/// <param name="rdr"></param>
/// <param name="obj"></param>
/// <returns></returns>
private FreePassUserInfo bindEmployeeForFreePass(SqlDataReader rdr, FreePassUserInfo obj)
{
obj.Upnid = rdr.GetString(0);
obj.DisplayName = rdr.GetString(1);
obj.Dep_name = rdr.GetString(2);
return(obj);
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
FreePassUserInfo obj = (FreePassUserInfo)e.Row.DataItem;
e.Row.Cells[0].Text = obj.Upnid;
e.Row.Cells[1].Text = obj.DisplayName;
e.Row.Cells[2].Text = obj.Dep_name;
e.Row.Cells[3].Text = "<a href='#;' onclick=\"javascript:confirmInsert('inputFreePass.aspx?step=1&Upnid=" + obj.Upnid + "');\">";
e.Row.Cells[3].Text += "<img src='/COMS/images/icon/write.gif'></a>";
}
}
