/// <summary>
/// 获取指定id任务数据
/// </summary>
/// <param name="TaskID">任务id</param>
/// <returns>任务数据</returns>
public static TaskLogUtil GetLogById(string LogID)
{
return(SQLHelper.Single <TaskLogUtil>(
@"SELECT p_Tasklog.*,p_Task.TaskName FROM dbo.p_Tasklog
LEFT JOIN dbo.p_Task ON dbo.p_Task.TaskID = p_Tasklog.TaskId WHERE LogID=@LogID", new { LogID = LogID }));
}
/// <summary>
/// 获取指定id任务数据
/// </summary>
/// <param name="TaskID">任务id</param>
/// <returns>任务数据</returns>
public static TaskUtil GetById(string TaskID)
{
return(SQLHelper.Single <TaskUtil>("SELECT * FROM p_Task WHERE TaskID=@TaskID", new { TaskID = TaskID }));
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="UserGUID">用户GUID</param>
/// <returns>用户信息</returns>
public UserAccount GetUserInfo(string UserGUID)
{
string strSQL = "SELECT * from p_User WHERE UserGUID = @UserGUID limit 1 offset 0";
return(SQLHelper.Single <UserAccount>(strSQL, new { UserGUID = UserGUID }));
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="UserCode">用户Code</param>
/// <param name="Password">密码</param>
/// <returns>用户信息</returns>
public UserAccount GetUserInfo(string UserCode, string Password)
{
string strSQL = "SELECT * from p_User WHERE UserCode = @UserCode and Password=@Password limit 1 offset 0";
return(SQLHelper.Single <UserAccount>(strSQL, new { UserCode = UserCode, Password = Password }));
}
/// <summary>
/// 通过消息GUID获取消息数据
/// </summary>
/// <param name="MessageGuid">消息GUID</param>
/// <returns>消息</returns>
public static Message GetMessageById(Guid MessageGuid)
{
return(SQLHelper.Single <Message>("SELECT * FROM dbo.p_Message WHERE MessageGuid=@MessageGuid", new { MessageGuid = MessageGuid }));
}
