/// <summary>
/// Get Nodes By Device Id.
/// </summary>
public List <NodeInfo> GetNodes(int devId)
{
SqlParameter[] parms = { new SqlParameter("@AIType", SqlDbType.Int),
new SqlParameter("@AOType", SqlDbType.Int),
new SqlParameter("@DIType", SqlDbType.Int),
new SqlParameter("@DOType", SqlDbType.Int),
new SqlParameter("@DevID", SqlDbType.Int) };
parms[0].Value = (Int32)EnmNodeType.Aic;
parms[1].Value = (Int32)EnmNodeType.Aoc;
parms[2].Value = (Int32)EnmNodeType.Dic;
parms[3].Value = (Int32)EnmNodeType.Doc;
parms[4].Value = devId;
var nodes = new List <NodeInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_ND_GetNodes, parms)) {
while (rdr.Read())
{
var node = new NodeInfo();
node.DevID = ComUtility.DBNullInt32Handler(rdr["DevID"]);
node.RtuID = ComUtility.DBNullInt32Handler(rdr["RtuID"]);
node.DotID = ComUtility.DBNullInt32Handler(rdr["DotID"]);
node.NodeID = ComUtility.DBNullInt32Handler(rdr["NodeID"]);
node.NodeType = ComUtility.DBNullNodeTypeHandler(rdr["NodeType"]);
node.NodeName = ComUtility.DBNullStringHandler(rdr["NodeName"]);
node.NodeDesc = ComUtility.DBNullStringHandler(rdr["NodeDesc"]);
node.Remark = ComUtility.DBNullStringHandler(rdr["Remark"]);
node.AuxSet = ComUtility.DBNullStringHandler(rdr["AuxSet"]);
node.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
node.Value = ComUtility.DBNullFloatHandler(rdr["Value"]);
node.Status = ComUtility.DBNullStateHandler(rdr["Status"]);
node.DateTime = ComUtility.DBNullDateTimeHandler(rdr["DateTime"]);
node.UpdateTime = ComUtility.DBNullDateTimeHandler(rdr["UpdateTime"]);
nodes.Add(node);
}
}
return(nodes);
}
/// <summary>
/// Get role departments.
/// </summary>
/// <param name="roleId">role id</param>
/// <returns>role departments</returns>
public List <DepartmentInfo> GetRoleDepartments(Guid roleId)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier) };
parms[0].Value = ComUtility.DBNullSuperChecker(roleId);
var departments = new List <DepartmentInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_MS_GetRoleDepartments, parms)) {
while (rdr.Read())
{
var department = new DepartmentInfo();
department.ID = ComUtility.DBNullInt64Handler(rdr["ID"]);
department.DepId = ComUtility.DBNullStringHandler(rdr["DepId"]);
department.DepName = ComUtility.DBNullStringHandler(rdr["DepName"]);
department.LastDepId = ComUtility.DBNullStringHandler(rdr["LastDepId"]);
department.Comment = ComUtility.DBNullStringHandler(rdr["Comment"]);
department.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
departments.Add(department);
}
}
return(departments);
}
/// <summary>
/// Get Client Users
/// </summary>
/// <param name="uId">UID</param>
/// <returns>Client Users</returns>
public List <ClientUserInfo> GetClientUsers(String uId)
{
SqlParameter[] parms = { new SqlParameter("@UID", SqlDbType.VarChar, 20) };
parms[0].Value = uId;
var users = new List <ClientUserInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_MS_GetClientUsers, parms)) {
while (rdr.Read())
{
var user = new ClientUserInfo();
user.ID = ComUtility.DBNullInt32Handler(rdr["ID"]);
user.ClientName = ComUtility.DBNullStringHandler(rdr["ClientName"]);
user.UID = ComUtility.DBNullStringHandler(rdr["UID"]);
user.Pwd = ComUtility.DBNullStringHandler(rdr["PWD"]);
user.OpLevel = ComUtility.DBNullInt32Handler(rdr["OpLevel"]);
user.PortVer = ComUtility.DBNullInt32Handler(rdr["PortVer"]);
user.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
users.Add(user);
}
}
return(users);
}
/// <summary>
/// Get role with authorizations by the specified id.
/// </summary>
/// <param name="roleId">role id</param>
/// <returns>the specified role.</returns>
public RoleInfo GetRoleWithAuthorizations(Guid roleId)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier) };
parms[0].Value = roleId;
RoleInfo role = null;
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_MS_GetRole, parms)) {
if (rdr.Read())
{
role = new RoleInfo();
role.RoleID = ComUtility.DBNullGuidHandler(rdr["RoleId"]);
role.RoleName = ComUtility.DBNullStringHandler(rdr["RoleName"]);
role.Comment = ComUtility.DBNullStringHandler(rdr["Comment"]);
role.LastRoleID = ComUtility.DBNullGuidHandler(rdr["LastRoleId"]);
role.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
role.Authorizations = GetRoleAuthorizations(role.RoleID);
role.Nodes = GetRoleNodes(role.RoleID);
role.Departments = GetRoleDepartments(role.RoleID);
}
}
return(role);
}
/// <summary>
/// Get Out Employees By Role Id.
/// </summary>
/// <param name="roleId">role id</param>
/// <returns>Out Employees</returns>
public List <OutEmployeeInfo> GetOutEmployees(Guid roleId)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier) };
parms[0].Value = ComUtility.DBNullSuperChecker(roleId);
var employees = new List <OutEmployeeInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_EE_GetOutEmployees, parms)) {
while (rdr.Read())
{
var employee = new OutEmployeeInfo();
employee.ID = ComUtility.DBNullInt64Handler(rdr["ID"]);
employee.EmpId = ComUtility.DBNullStringHandler(rdr["EmpId"]);
employee.EmpName = ComUtility.DBNullStringHandler(rdr["EmpName"]);
employee.Sex = ComUtility.DBNullStringHandler(rdr["Sex"]);
employee.CardId = ComUtility.DBNullStringHandler(rdr["CardId"]);
employee.CardAddress = ComUtility.DBNullStringHandler(rdr["CardAddress"]);
employee.CardIssue = ComUtility.DBNullStringHandler(rdr["CardIssue"]);
employee.Hometown = ComUtility.DBNullStringHandler(rdr["Hometown"]);
employee.CompanyName = ComUtility.DBNullStringHandler(rdr["CompanyName"]);
employee.ProjectName = ComUtility.DBNullStringHandler(rdr["ProjectName"]);
employee.OfficePhone = ComUtility.DBNullStringHandler(rdr["OfficePhone"]);
employee.MobilePhone = ComUtility.DBNullStringHandler(rdr["MobilePhone"]);
employee.Email = ComUtility.DBNullStringHandler(rdr["Email"]);
employee.Comment = ComUtility.DBNullStringHandler(rdr["Comment"]);
employee.DepId = ComUtility.DBNullStringHandler(rdr["DepId"]);
employee.DepName = ComUtility.DBNullStringHandler(rdr["DepName"]);
employee.ParentEmpId = ComUtility.DBNullStringHandler(rdr["ParentEmpId"]);
employee.ParentEmpName = ComUtility.DBNullStringHandler(rdr["ParentEmpName"]);
employee.Photo = ComUtility.DBNullBytesHandler(rdr["Photo"]);
employee.PhotoLayout = ComUtility.DBNullInt32Handler(rdr["PhotoLayout"]);
employee.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
employees.Add(employee);
}
}
return(employees);
}
/// <summary>
/// Get users which belong to the specified role.
/// </summary>
/// <param name="roleId">role id</param>
/// <returns>users information.</returns>
public List <UserInfo> GetUsers(Guid roleId)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier) };
parms[0].Value = roleId;
var users = new List <UserInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_MS_GetUsersByRoleId, parms)) {
while (rdr.Read())
{
var user = new UserInfo();
user.Role = new RoleInfo();
user.Role.RoleID = ComUtility.DBNullGuidHandler(rdr["RoleId"]);
user.Role.RoleName = ComUtility.DBNullStringHandler(rdr["RoleName"]);
user.UserID = ComUtility.DBNullGuidHandler(rdr["UserId"]);
user.UserName = ComUtility.DBNullStringHandler(rdr["UserName"]);
user.RemarkName = ComUtility.DBNullStringHandler(rdr["RemarkName"]);
user.Password = ComUtility.DBNullStringHandler(rdr["Password"]);
user.PasswordFormat = ComUtility.DBNullPasswordFormatHandler(rdr["PasswordFormat"]);
user.PasswordSalt = ComUtility.DBNullStringHandler(rdr["PasswordSalt"]);
user.MobilePhone = ComUtility.DBNullStringHandler(rdr["MobilePhone"]);
user.Email = ComUtility.DBNullStringHandler(rdr["Email"]);
user.CreateDate = ComUtility.DBNullDateTimeHandler(rdr["CreateDate"]);
user.LimitDate = ComUtility.DBNullDateTimeHandler(rdr["LimitDate"]);
user.LastLoginDate = ComUtility.DBNullDateTimeHandler(rdr["LastLoginDate"]);
user.LastPasswordChangedDate = ComUtility.DBNullDateTimeHandler(rdr["LastPasswordChangedDate"]);
user.FailedPasswordAttemptCount = ComUtility.DBNullInt32Handler(rdr["FailedPasswordAttemptCount"]);
user.FailedPasswordDate = ComUtility.DBNullDateTimeHandler(rdr["FailedPasswordDate"]);
user.IsLockedOut = ComUtility.DBNullBooleanHandler(rdr["IsLockedOut"]);
user.LastLockoutDate = ComUtility.DBNullDateTimeHandler(rdr["LastLockoutDate"]);
user.Comment = ComUtility.DBNullStringHandler(rdr["Comment"]);
user.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
users.Add(user);
}
}
return(users);
}
/// <summary>
/// Get Out Employee By The Specified ID.
/// </summary>
/// <param name="EmpId">Employee ID</param>
/// <returns>The Specified Out Employee</returns>
public OutEmployeeInfo GetOutEmployee(String EmpId)
{
SqlParameter[] parms = { new SqlParameter("@EmpId", SqlDbType.VarChar, 50) };
parms[0].Value = EmpId;
OutEmployeeInfo employee = null;
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_EE_GetOutEmployee, parms)) {
if (rdr.Read())
{
employee = new OutEmployeeInfo();
employee.ID = ComUtility.DBNullInt64Handler(rdr["ID"]);
employee.EmpId = ComUtility.DBNullStringHandler(rdr["EmpId"]);
employee.EmpName = ComUtility.DBNullStringHandler(rdr["EmpName"]);
employee.Sex = ComUtility.DBNullStringHandler(rdr["Sex"]);
employee.CardId = ComUtility.DBNullStringHandler(rdr["CardId"]);
employee.CardAddress = ComUtility.DBNullStringHandler(rdr["CardAddress"]);
employee.CardIssue = ComUtility.DBNullStringHandler(rdr["CardIssue"]);
employee.Hometown = ComUtility.DBNullStringHandler(rdr["Hometown"]);
employee.CompanyName = ComUtility.DBNullStringHandler(rdr["CompanyName"]);
employee.ProjectName = ComUtility.DBNullStringHandler(rdr["ProjectName"]);
employee.OfficePhone = ComUtility.DBNullStringHandler(rdr["OfficePhone"]);
employee.MobilePhone = ComUtility.DBNullStringHandler(rdr["MobilePhone"]);
employee.Email = ComUtility.DBNullStringHandler(rdr["Email"]);
employee.Comment = ComUtility.DBNullStringHandler(rdr["Comment"]);
employee.DepId = ComUtility.DBNullStringHandler(rdr["DepId"]);
employee.DepName = ComUtility.DBNullStringHandler(rdr["DepName"]);
employee.ParentEmpId = ComUtility.DBNullStringHandler(rdr["ParentEmpId"]);
employee.ParentEmpName = ComUtility.DBNullStringHandler(rdr["ParentEmpName"]);
employee.Photo = ComUtility.DBNullBytesHandler(rdr["Photo"]);
employee.PhotoLayout = ComUtility.DBNullInt32Handler(rdr["PhotoLayout"]);
employee.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(employee);
}
/// <summary>
/// Get user by the specified name.
/// </summary>
/// <param name="userName">user name</param>
/// <returns>user information.</returns>
public UserInfo GetUser(String userName)
{
SqlParameter[] parms = { new SqlParameter("@UserName", SqlDbType.VarChar, 50) };
parms[0].Value = ComUtility.DBNullStringChecker(userName);
UserInfo user = null;
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_MS_GetUserByName, parms)) {
if (rdr.Read())
{
user = new UserInfo();
user.Role = new RoleInfo();
user.Role.RoleID = ComUtility.DBNullGuidHandler(rdr["RoleId"]);
user.Role.RoleName = ComUtility.DBNullStringHandler(rdr["RoleName"]);
user.UserID = ComUtility.DBNullGuidHandler(rdr["UserId"]);
user.UserName = ComUtility.DBNullStringHandler(rdr["UserName"]);
user.RemarkName = ComUtility.DBNullStringHandler(rdr["RemarkName"]);
user.Password = ComUtility.DBNullStringHandler(rdr["Password"]);
user.PasswordFormat = ComUtility.DBNullPasswordFormatHandler(rdr["PasswordFormat"]);
user.PasswordSalt = ComUtility.DBNullStringHandler(rdr["PasswordSalt"]);
user.MobilePhone = ComUtility.DBNullStringHandler(rdr["MobilePhone"]);
user.Email = ComUtility.DBNullStringHandler(rdr["Email"]);
user.CreateDate = ComUtility.DBNullDateTimeHandler(rdr["CreateDate"]);
user.LimitDate = ComUtility.DBNullDateTimeHandler(rdr["LimitDate"]);
user.LastLoginDate = ComUtility.DBNullDateTimeHandler(rdr["LastLoginDate"]);
user.LastPasswordChangedDate = ComUtility.DBNullDateTimeHandler(rdr["LastPasswordChangedDate"]);
user.FailedPasswordAttemptCount = ComUtility.DBNullInt32Handler(rdr["FailedPasswordAttemptCount"]);
user.FailedPasswordDate = ComUtility.DBNullDateTimeHandler(rdr["FailedPasswordDate"]);
user.IsLockedOut = ComUtility.DBNullBooleanHandler(rdr["IsLockedOut"]);
user.LastLockoutDate = ComUtility.DBNullDateTimeHandler(rdr["LastLockoutDate"]);
user.Comment = ComUtility.DBNullStringHandler(rdr["Comment"]);
user.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(user);
}
