/// <summary>
/// 根据用户账号和密码实现用户登录
/// </summary>
/// <param name="objsaleperson">包含用户账号和密码的对象</param>
/// <returns>返回包含用户 账号 密码名称的用户对象或者空</returns>
public SalePerson UserLogin(SalePerson objsaleperson)
{
string sql = "select SPName from SalesPerson where SalesPersonId=@SalesPersonId ";
sql += " and LoginPwd=@LoginPwd";
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@SalesPersonId", objsaleperson.SalesPersonId),
new SqlParameter("@LoginPwd", objsaleperson.LoginPwd)
};
var result = SQLHelp.GetSingleResult(sql, parameters);
if (result == null)
{
return(null); //如果不正确返回为NULL
}
else
{
objsaleperson.SPName = result.ToString();
return(objsaleperson);
}
}
/// <summary>
/// 添加登录日志
/// </summary>
/// <param name="info"></param>
/// <returns>返回日志编号</returns>
public int WriteLog(LoginLog info)
{
string sql = "insert into LoginLogs(LoginId,SPName,ServerName) ";
sql += "values(@LoginId,@SPName,@ServerName);select @@identity";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@LoginId", info.LoginId),
new SqlParameter("@SPName", info.SPName),
new SqlParameter("@ServerName", info.ServerName)
};
try
{
return(Convert.ToInt32(SQLHelp.GetSingleResult(sql, param)));
}
catch (SqlException ex)
{
throw new Exception("应用程序与数据库连接出错，具体内容： " + ex.Message);
}
catch (Exception ex)
{
throw ex;
}
}
