/// <summary>
/// 寫入log
/// </summary>
/// <param name="strDB"></param>
/// <param name="sqlcom"></param>
/// <param name="Prm"></param>
public void SqlCarOperateLog(string Sysno, string Action, int Defqty, int Actqty)
{
string cmdstring = @"Insert Into CarSystem.dbo.CaroperateLog(UserID,UserIP,Project,Sysno,Action,Defqty,Actqty)
values (@UserID,@UserIP,@Project,@Sysno,@Action,@Defqty,@Actqty)";
Hashtable ht_Param = new Hashtable();
ht_Param.Add("@UserID", UserInf.UserID);
ht_Param.Add("@UserIP", UserInf.IP);
ht_Param.Add("@Project", this.Name);
ht_Param.Add("@Sysno", Sysno);
ht_Param.Add("@Action", Action);
ht_Param.Add("@Defqty", Defqty);
ht_Param.Add("@Actqty", Actqty);
IO.SqlQuery(Login_Server, cmdstring, ht_Param);
reclog.ExLog("00", "Login");
}
/// <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);
}
