/// <summary>
/// 查詢帳號
/// </summary>
/// <param name="UserID">工號</param>
/// <param name="Psw">密碼</param>
private DataTable QueryEmp(string UserID, string Psw, string DBName)
{
IO_DB IO = new IO_DB();
F_Check ck = new F_Check();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
long lonPsw = ck.PasswdValue(Psw);
string SqlCom = @"Select S_empd_id,N_empd_name,S_empd_autgid
From dbo.employee_data
Where S_empd_id=@S_empd_id
And L_empd_psword=@L_empd_psword";
Hashtable hs = new Hashtable();
hs.Add("@S_empd_id", UserID);
hs.Add("@L_empd_psword", lonPsw);
ds = IO.SqlQuery(DBName, SqlCom, hs);
dt = ds.Tables[0];
return(dt);
}
