private void GetDepartmentRootByDepartmentID(SysContext db, string DeptID, ref hr_Department rootDepartment)
{
hr_Department dept = db.hr_Department.Where(d => d.DeptID == DeptID).SingleOrDefault();
if (dept != null)
{
if (dept.ParentID != "")
{
GetDepartmentRootByDepartmentID(db, dept.ParentID, ref rootDepartment);
}
else
{
rootDepartment = dept;
}
}
}
public ActionResult GetSideBar()
{
using (Panasia.Gemini.FL.Data.Common.SysContext db = new Panasia.Gemini.FL.Data.Common.SysContext())
{
string id = Panasia.Gemini.FL.LoginInfo.EmployeeID;
if (id != null)
{
var sidbar = (from fl_as in db.fl_ApproveState
join form in db.fl_Form on fl_as.FormID equals form.FormID
where
fl_as.EmployeeID.Equals(id)
select new { FormName = form.FormName, FormID = form.FormID, DataForm = form.DataFrom }).Distinct().ToList();
return(Json(sidbar, JsonRequestBehavior.AllowGet));
}
else
{
return(null);
}
}
}
public ActionResult MessagesCount() //消息总数
{
string id = Panasia.Gemini.FL.LoginInfo.UserID;
if (id != null)
{
using (Panasia.Gemini.FL.Data.Common.SysContext db = new Panasia.Gemini.FL.Data.Common.SysContext())
{
db.Database.Connection.Open();
var cmd = db.Database.Connection.CreateCommand();
cmd.CommandText = "select * FROM [dbo].[hr_fl_MessageRemind]('0'," + "'" + id + "'" + ")";
List <UserMessage> ls = new List <UserMessage>();
using (var reader = cmd.ExecuteReader(System.Data.CommandBehavior.SequentialAccess))
{
while (reader.Read())
{
UserMessage um = new UserMessage();
um.MsgTitle = reader["MsgTitle"].ToString();
um.MsgType = reader["MsgType"].ToString();
um.Count = Convert.ToInt32(reader["Count"]);
um.MsgUrl = reader["MsgUrl"].ToString();
ls.Add(um);
}
reader.Close();
}
db.Database.Connection.Close();
foreach (var l in ls)
{
var formid = Convert.ToInt32(l.MsgType);
var dataform = db.fl_Form.Where(f => f.FormID.Equals(formid)).SingleOrDefault().DataFrom;
l.MsgType = dataform;
}
return(Json(ls, JsonRequestBehavior.AllowGet));
}
}
else
{
return(null);
}
}