private void readUserActivityTypes(ITUser user, XStorageConnection con)
{
XDbCommand cmd = con.CreateCommand();
cmd.CommandText = @"
SELECT at.ObjectID, at.Name, at.Code, at.AccountRelated, at.FolderType, at.StartDate, at.EndDate
FROM dbo.SystemUser_ActivityTypes su_at WITH (nolock)
JOIN dbo.ActivityType at WITH (nolock) ON su_at.Value = at.ObjectID
WHERE su_at.ObjectID = @ObjectID
UNION
SELECT at.ObjectID, at.Name, at.Code, at.AccountRelated, at.FolderType, at.StartDate, at.EndDate
FROM dbo.SystemUser_SystemRoles su_sr WITH (nolock)
JOIN dbo.SystemRole_ActivityTypes sr_at WITH (nolock) ON su_sr.Value = sr_at.ObjectID
JOIN dbo.ActivityType at WITH (nolock) ON sr_at.Value = at.ObjectID
WHERE su_sr.ObjectID = @ObjectID
" ;
cmd.Parameters.Add("ObjectID", DbType.Guid, ParameterDirection.Input, false, user.SystemUserID);
using (IXDataReader reader = cmd.ExecuteXReader())
{
user.ActivityTypes = new Hashtable();
while (reader.Read())
{
DomainObject_ActivityType xobj = new DomainObject_ActivityType();
xobj.ObjectID = reader.GetGuid(reader.GetOrdinal("ObjectID"));
xobj.Name = reader.GetString(reader.GetOrdinal("Name"));
xobj.Code = reader.GetString(reader.GetOrdinal("Code"));
xobj.AccountRelated = reader.GetBoolean(reader.GetOrdinal("AccountRelated"));
xobj.FolderType = (FolderTypeFlags)reader.GetInt16(reader.GetOrdinal("FolderType"));
xobj.StartDate = reader.GetDateTime(reader.GetOrdinal("StartDate"));
if (!reader.IsDBNull(reader.GetOrdinal("EndDate")))
{
xobj.EndDate = reader.GetDateTime(reader.GetOrdinal("EndDate"));
}
user.ActivityTypes.Add(xobj.ObjectID, xobj);
}
}
}
internal static bool fillEmployeeInfoSection(XMenuSection sec, Guid EmployeeID, XStorageConnection cn)
{
using (XDbCommand cmd = cn.CreateCommand(
"SELECT " +
" emp.EMail, emp.Phone, emp.PhoneExt, p.Name AS PositionName, o.Home "+
"FROM Employee emp " +
" LEFT JOIN Position p ON emp.Position = p.ObjectID "+
" JOIN Organization o ON emp.Organization = o.ObjectID "+
"WHERE emp.ObjectID = @ObjectID"
))
{
cmd.Parameters.Add("ObjectID", DbType.Guid, ParameterDirection.Input, false, EmployeeID);
bool bIsHome;
string sEMail = null;
string sPhone = null;
string sPhoneExt = null;
string sPositionName = null;
using (IXDataReader reader = cmd.ExecuteXReader())
{
if (reader.Read())
{
bIsHome = reader.GetBoolean(reader.GetOrdinal("Home"));
if (!reader.IsDBNull(reader.GetOrdinal("EMail")))
{
sEMail = reader.GetString(reader.GetOrdinal("EMail"));
}
if (!reader.IsDBNull(reader.GetOrdinal("Phone")))
{
sPhone = reader.GetString(reader.GetOrdinal("Phone"));
}
if (!reader.IsDBNull(reader.GetOrdinal("PhoneExt")))
{
sPhoneExt = reader.GetString(reader.GetOrdinal("PhoneExt"));
}
if (!reader.IsDBNull(reader.GetOrdinal("PositionName")))
{
sPositionName = reader.GetString(reader.GetOrdinal("PositionName"));
}
sec.Items.AddInfoItem("EMail", sEMail);
if (bIsHome && sPhoneExt != null)
{
sec.Items.AddInfoItem("Внутренний телефон", sPhoneExt);
}
else
{
sec.Items.AddInfoItem("Телефон",
(sPhone != null && sPhone.Length > 0 ? sPhone : "") +
(sPhoneExt != null && sPhoneExt.Length > 0 ? "(" + sPhoneExt + ")" : "")
);
}
if (sPositionName != null)
{
sec.Items.AddInfoItem("Должность", sPositionName);
}
return(true);
}
}
return(false);
}
}
