/// <summary>
/// 获取单位及其负责人列表
/// </summary>
/// <returns></returns>
public List<SMSInfo> GetOrgsAndAdminList()
{
// 创建passport.CQGJPassport对象,以实现对Passport数据库的查询
passport.CQGJPassport passportCQGJ = new CQGJ.passport.CQGJPassport();
// 定义并获取具有管理员权限的单位负责人列表
List<passport.User> userOwnRoles = passportCQGJ.GetUserListOwnRole().ToList();
// 定义短信的基本信息,包括接收短信的组织机构,具体接收短信者的个人信息列表
List<SMSInfo> orgsAndItsAdminList = new List<SMSInfo>();
// 构建接收短信机构与其具体负责人的一对一关系,形成orgsAndItsAdminList对象
foreach (var u in userOwnRoles)
{
SMSInfo SMSInfoToDest = new SMSInfo();
passport.User admin = new CQGJ.passport.User();
passport.b01 org = new CQGJ.passport.b01();
string orgCode = passportCQGJ.GetOrgCodeOfUser(u.UserID, true);
passport.b01 b01 = passportCQGJ.GetOrg(orgCode);
SMSInfoToDest.Destination = b01;
SMSInfoToDest.AdminOfOrg = u;
orgsAndItsAdminList.Add(SMSInfoToDest);
}
return orgsAndItsAdminList;
}
/// <summary>
/// 查看班级列表
/// </summary>
public void ClassesList(int id)
{
CQGJClassesListViewData viewData = new CQGJClassesListViewData();
passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport();
string OrgType = HttpContext.Session["OrgType"].ToString();
List<Classes> TempList=null;
if (OrgType.Equals("1"))
{
TempList = (from c in CQGJ.Classes
select c).ToList();
}
if (OrgType.Equals("3"))
{
int OrgID = int.Parse(HttpContext.Session["OrgID"].ToString());
TempList = (from c in CQGJ.Classes
where c.Org.OrgID == OrgID select c).ToList();
}
//取出了所有的列表
//下步是取出实际的列表
viewData.ClassesList = TempList.Skip((id - 1) * 20).Take(20).ToList();
UrlManager urlManager = new DefaultUrlManager(TempList.Count(), 20);
Pager pager = new Pager(urlManager);
viewData.PagerString = pager.PagerString;
RenderView("ClassesList", viewData);
}
/// <summary>
/// 添加班级与单位通知
/// </summary>
public void ClassNotifyAdd()
{
CQGJClassNotifyAddViewData viewData = new CQGJClassNotifyAddViewData();
viewData.NotifyList = (from n in CQGJ.Notify
select n).ToList();
passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport();
viewData.OrgList = cqgj.GetOrglistByType(2).ToList();
string OrgType = HttpContext.Session["OrgType"].ToString();
if (OrgType.Equals("1"))
{
viewData.ClassesList = (from c in CQGJ.Classes
select c).ToList();
}
if (OrgType.Equals("3"))
{
int OrgID = int.Parse(HttpContext.Session["OrgID"].ToString());
viewData.ClassesList = (from c in CQGJ.Classes
where c.Org.OrgID == OrgID
select c).ToList();
}
RenderView("NotifyAdd", viewData);
}
/// <summary>
/// 后台用户登录验证
/// </summary>
public void Login()
{
//如果验证成功
if (GetString("username") != "")
{
passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport();
//string OrgCode = cqgj.ValidateOrg(GetString("username"), Security.MD5Encrypt(GetString("password")));
CQGJ.passport.User user = cqgj.ValidateUser(GetString("username"), Security.MD5Encrypt(GetString("password")));
if (user != null)
{
string orgCode = cqgj.GetOrgCodeOfUser(user.UserID, true);
if (orgCode != "")
{
HttpContext.Session["OrgID"] = ToOrgID(orgCode);
HttpContext.Session["OrgCode"] = orgCode;
HttpContext.Session["UserID"] = ToUserID(user.UserID);
HttpContext.Session["PassportUserID"] = user.UserID;
HttpContext.Session["Username"] = user.Username;
HttpContext.Session["OrgType"] = cqgj.GetOrgType(orgCode);
//从Passport那边获取用户所属角色列表信息
string rolenames = "";
string[] roleList = cqgj.GetRoleList(user.UserID);
for (int i = 0; i < roleList.Length; i++)
{ rolenames += roleList[i] + ","; }
HttpContext.Session["RoleList"] = rolenames;
b01 org = cqgj.GetOrg(orgCode);
HttpContext.Session["Org"] = org;
FormsAuthentication.SetAuthCookie(orgCode, false);
RedirectToAction("index", "admin");
}
else
{
TempData["LoginStatus"] = "false";
}
}
else
{
TempData["LoginStatus"] = "false";
}
}
RenderView("Login");
}
/// <summary>
/// 为教师添加做准备
/// </summary>
public void TeacherPre()
{
//取出所有的相关信息
SchoolAddTeacherViewData viewData = new SchoolAddTeacherViewData() { Schools = new List<b01>() };
passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport();
b01[] arrayB01=cqgj.GetSchoolOrglist();
foreach (var c in arrayB01)
{
viewData.Schools.Add(c);
}
RenderView("AddTeacher", viewData);
}
/// <summary>
/// 编辑学校 更新
/// </summary>
public void SchoolUpdate()
{
try
{
string OrgID = GetString("OrgID");
string OrgExID = GetString("OrgExID");
passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport();
b01 Org = cqgj.GetOrg(OrgID);
b01Expansion OrgEx = cqgj.GetOrgEx(OrgExID);
Org.b0101 = GetString("SchoolName");
//Org.b0117 = GetString("Address");
OrgEx.Mail = GetString("Mail");
OrgEx.Mobile = GetString("Mobile");
OrgEx.Tel = GetString("Tel");
cqgj.SaveOrgChange(Org, OrgEx);
RedirectToAction("SchoolList");
}
catch
{
}
}
public void SchoolSave()
{
string orgcode = GetString("orgcode");
if (GetString("orgcode") != "")
{
passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport();
b01 Org = new b01();
b01Expansion OrgExPansion = new b01Expansion();
string schoolname = GetString("schoolname");
Org.b0101 = schoolname;
Org.b0111 = GetString("orgcode");
//Org.b0117 = GetString("address");
OrgExPansion.Tel = GetString("tel");
OrgExPansion.Mobile = GetString("mobile");
OrgExPansion.Mail = GetString("mail");
//3指代培训机构
OrgExPansion.OrgType = 3;
cqgj.AddOrg(Org, OrgExPansion);
//在Org表中添加代码
}
RedirectToAction("SchoolList");
}
/// <summary>
/// 显示施教机构列表
/// </summary>
public void SchoolList(int? id)
{
SchoolSchoolListViewData viewData = new SchoolSchoolListViewData();
passport.CQGJPassport cqgjp = new CQGJ.passport.CQGJPassport();
var Schools = cqgjp.GetSchoolOrglist();
viewData.Schools = Schools.Skip(20 * (id.Value - 1)).Take(20).ToList();
UrlManager urlManager = new DefaultUrlManager(Schools.Count(), 20);
Pager pager = new Pager(urlManager);
viewData.PagerString = pager.PagerString;
RenderView("SchoolList", viewData);
}
/// <summary>
/// 编辑学校呈现
/// </summary>
/// <param name="id"></param>
public void SchoolEdit()
{
string orgcode = HttpContext.Request.QueryString["id"];
passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport();
SchoolEditSchoolViewData viewData = new SchoolEditSchoolViewData();
viewData.Org = cqgj.GetOrg(orgcode);
viewData.OrgEx = cqgj.GetOrgExStr(orgcode);
RenderView("SchoolEdit", viewData);
}
public void DocAdd(int? id)
{
//首先取得本单位的code 再取上下级别的单位
DocAddViewData viewData = new DocAddViewData() { lsLowerorg2 = new List<b01>(), lsLowerorg4 = new List<b01>(), lsUpperOrg = new List<b01>(), lsWordNo = new List<string>(), ClassType = new Dictionary<string, string>(), Secret = new Dictionary<string, string>(), Emergercy = new Dictionary<string, string>(), DocClass = new Dictionary<string, string>(), DocType = new Dictionary<string, string>() };
//取得所有的公文字号
int orgID = GetOrgID();
viewData.lsWordNo = (from c in CQGJ.DocWord
where c.Org.OrgID == orgID
select c.WordName).ToList();
viewData.YearNo = DateTime.Now.Year.ToString();
int StoredYearNo = Convert.ToInt32((from c in CQGJ.Doc
select c.YearNo).Max());
if (Convert.ToInt32(viewData.YearNo) != StoredYearNo)
{
viewData.TeamNo = "1";
}
else
{
viewData.TeamNo = (Convert.ToInt32((from c in CQGJ.Doc
select c.TeamNo).Max())+1).ToString();
}
viewData.SourceUnit= ((b01)HttpContext.Session["Org"]).b0101.ToString();
//取得本地单位
viewData.localOrg = (b01)(HttpContext.Session["Org"]);
string orgIDstr = orgID.ToString();
viewData.Draft = (from c in CQGJ.Doc
where c.SignMan == orgIDstr && c.Status == (int?)DocStatus.Draft
select c);
////取得下级单位列表
passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport();
string orgCode = viewData.localOrg.b0111;
//可以将本地单位码当成参数输入
string strHtml = "";
if (id == 1)
{
viewData.lsLowerorg2 = cqgjPassport.GetOrglistByType(2).ToList();
viewData.lsLowerorg4 = cqgjPassport.GetOrglistByType(4).ToList();
viewData.lsLowerOrg3 = cqgjPassport.GetOrglistByType(3).ToList();
//CreateAllOwnedOrgHtml(ref strHtml, orgCode);
viewData.Type = 1;
}
else if (id == 2)
{
viewData.lsUpperOrg = cqgjPassport.GetOrglistByType(1).ToList();
viewData.Type = 2;
}
viewData.strHtml = strHtml;
string[] secret = (ConfigurationManager.AppSettings.Get("Secret")).Split(',');
string[] secretdetail = ConfigurationManager.AppSettings.Get("SecretDetail").Split(',');
for (int i = 0; i < secret.Count(); i++)
{
viewData.Secret.Add(secret[i], secretdetail[i]);
}
string[] Emergercy = ConfigurationManager.AppSettings.Get("Emergercy").Split(',');
string[] EmergercyDetail = ConfigurationManager.AppSettings.Get("EmergercyDetail").Split(',');
for (int i = 0; i < Emergercy.Count(); i++)
{
viewData.Emergercy.Add(Emergercy[i], EmergercyDetail[i]);
}
string[] DocClass = ConfigurationManager.AppSettings.Get("DocClass").Split(',');
string[] DocClassDetail = ConfigurationManager.AppSettings.Get("DocClassDetail").Split(',');
for (int i = 0; i < DocClass.Count(); i++)
{
viewData.DocClass.Add(DocClass[i], DocClassDetail[i]);
}
string[] ClassType = ConfigurationManager.AppSettings.Get("ClassType").Split(',');
string[] ClassTypeDetail = ConfigurationManager.AppSettings.Get("ClassTypeDetail").Split(',');
for (int i = 0; i < ClassType.Count(); i++)
{
viewData.ClassType.Add(ClassType[i], ClassTypeDetail[i]);
}
string[] DocType = ConfigurationManager.AppSettings.Get("DocType").Split(',');
string[] DocTypeDetail = ConfigurationManager.AppSettings.Get("DocTypeDetail").Split(',');
for (int i = 0; i < DocType.Count(); i++)
{
viewData.DocType.Add(DocType[i], DocTypeDetail[i]);
}
RenderView("DocAdd", viewData);
}
/// <summary>
/// 查看单位通知列表
/// </summary>
public void OrgNotifyList(string id,int page)
{
CQGJOrgNotifyListViewData viewData = new CQGJOrgNotifyListViewData();
passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport();
List<passport.CQGJPassport> cqgj1 = new List<passport.CQGJPassport>();
string OrgType = HttpContext.Session["OrgType"].ToString();
int OrgID = int.Parse(HttpContext.Session["OrgID"].ToString());
List<Notify> TempList = null;
if (OrgType.Equals("1"))
{
TempList = (from n in CQGJ.Notify
from nm in CQGJ.NotifyMap
from o in CQGJ.Org
where nm.Notify.NotifyID==n.NotifyID && n.NotifyType == 2 && nm.ObjectID==o.OrgID && o.OrgCode==id
select n).ToList();
viewData.NotifyList = TempList.Skip((page - 1) * 20).Take(20).ToList();
UrlManager urlManager = new DefaultUrlManager(TempList.Count(), 20);
Pager pager = new Pager(urlManager);
viewData.PagerString = pager.PagerString;
RenderView("OrgNotifyList", viewData);
}
if(OrgType.Equals("2"))
{
// 取出发给ORG的Notify列表
TempList = (from n in CQGJ.Notify
from nm in CQGJ.NotifyMap
from o in CQGJ.Org
where nm.Notify.NotifyID == n.NotifyID && n.NotifyType == 2 && nm.ObjectID == o.OrgID
select n).AsEnumerable().Distinct().ToList();
viewData.NotifyList = TempList.Skip((page - 1) * 20).Take(20).ToList();
UrlManager urlManager = new DefaultUrlManager(TempList.Count(), 20);
Pager pager = new Pager(urlManager);
viewData.PagerString = pager.PagerString;
RenderView("Org2NotifyList", viewData);
}
}
public void OrgNotifyAdd()
{
CQGJOrgNotifyAddViewData viewData = new CQGJOrgNotifyAddViewData();
viewData.NotifyList = (from n in CQGJ.Notify
select n).ToList();
passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport();
viewData.OrgList = cqgj.GetOrglistByType(2).ToList();
RenderView("OrgNotifyAdd",viewData);
}
/// <summary>
/// 查看单位列表
/// </summary>
public void OrgList(int id)
{
CQGJOrgListViewData viewData = new CQGJOrgListViewData();
passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport();
List<passport.b01> TempList = cqgj.GetOrglistByType(2).ToList();
viewData.OrgList = TempList.Skip((id - 1) * 20).Take(20).ToList();
UrlManager urlManager = new DefaultUrlManager(TempList.Count(), 20);
Pager pager = new Pager(urlManager);
viewData.PagerString = pager.PagerString;
RenderView("OrgList", viewData);
}
/// <summary>
/// 查看班级通知
/// </summary>
/// <param name="id">班级通知ID</param>
public void NotifyEdit(int id)
{
CQGJNotifyEditViewData viewData = new CQGJNotifyEditViewData();
viewData.Notify = (from n in CQGJ.Notify where n.NotifyID == id select n).First();
int? notifyType = viewData.Notify.NotifyType;
passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport();
string OrgType = HttpContext.Session["OrgType"].ToString();
if (notifyType == 1)
{
if (OrgType.Equals("1"))
{
viewData.ClassesList = (from c in CQGJ.Classes
select c).ToList();
// modified by 陈建平 2008.7.14
// 获取所有班级, 若该班级存在ID为id的班级通知,
// 则ClassNotify的MapNotifyMap属性为ID=id的NotifyMap,
// 否则ClassNotifyMap的MapNotifyMap为null
viewData.ClassNotifyList = (from c in CQGJ.Classes
join nm in CQGJ.NotifyMap on c.ClassID equals nm.ObjectID into o
select new ClassNotifyMap { Class = c, NotifyMap = o.Where(n => n.Notify.NotifyID == id).FirstOrDefault() }).ToList();
}
if (OrgType.Equals("3"))
{
int OrgID = int.Parse(HttpContext.Session["OrgID"].ToString());
viewData.ClassesList = (from c in CQGJ.Classes
where c.Org.OrgID == OrgID
select c).ToList();
// modified by 陈建平 2008.7.14
// 获取所有班级, 若该班级存在ID为id的班级通知,
// 则ClassNotify的MapNotifyMap属性为ID=id的NotifyMap,
// 否则ClassNotifyMap的MapNotifyMap为null
viewData.ClassNotifyList = (from c in CQGJ.Classes
join nm in CQGJ.NotifyMap on c.ClassID equals nm.ObjectID into o
where c.Org.OrgID == OrgID
select new ClassNotifyMap { Class = c, NotifyMap = o.Where(n => n.Notify.NotifyID == id).FirstOrDefault() }).ToList();
}
}
else
{
viewData.OrgNotifyMapList = (from o in CQGJ.Org
join nm in CQGJ.NotifyMap on o.OrgID equals nm.ObjectID into a
select new OrgNotifyMap { Org = o, NotifyMap = a.Where(n => n.Notify.NotifyID == id).FirstOrDefault() }).ToList();
}
RenderView("NotifyEdit", viewData);
}
/// <summary>
/// 某个用户的班级信息
/// </summary>
/// <param name="id"></param>
public void Class(int id)
{
IsLogin();
UserClassViewData viewData = new UserClassViewData();
viewData.user = (CQGJ.passport.User)HttpContext.Session["userobject"];
int userID = viewData.user.UserID;
userID = ToUserID(userID); //zhuanhua
//班级通知
viewData.NotifyList = (from n in CQGJ.Notify
from nm in CQGJ.NotifyMap
from c in CQGJ.Classes
from s in CQGJ.Student
where s.Classes == c && s.User.UserID == userID && c.Status == 2
&& nm.ObjectID == s.Classes.ClassID && nm.Notify==n
select n).ToList();
//以往班级
viewData.ClassList = (from c in CQGJ.Classes
from s in CQGJ.Student
where s.Classes == c && s.User.UserID == userID && c.Status == 3 //修改刘涛, status=2为开班中，3为结束
select c).ToList();
//现在班级
viewData.CureentClassesList = (from c in CQGJ.Classes
from s in CQGJ.Student
where s.Classes == c && s.User.UserID == userID //修改刘涛, status=2为开班中，3为结束
select c).ToList();
string str = ConfigurationManager.AppSettings["PhotoUrl"].ToString();
viewData.URL = str;
try
{
//所在班级
foreach (Classes c in viewData.CureentClassesList)
{
if (c.ClassID == id)
{
viewData.Classes = c;
}
}
int ClassID = viewData.Classes.ClassID;
// int TID = viewData.Classes.Teacher
viewData.ClassBBS = (from b in CQGJ.BBS where b.Classes.ClassID == ClassID select b).First();
//viewData.teacher = (from t in CQGJ.Teacher where t.TeacherID == ClassID select b).First();
List<int> ListID = (from s in CQGJ.Student where s.Classes.ClassID == id select s.User.UserID).ToList();
passport.CQGJPassport cqgjp = new CQGJ.passport.CQGJPassport();
viewData.userlist = new List<CQGJ.passport.User>();
for (int i = 0; i < ListID.Count; ++i)
{
ListID[i] = ToPassportUserID(ListID[i]);
CQGJ.passport.User user = cqgjp.GetCQGJUser(ListID[i]);
viewData.userlist.Add(user);
}
viewData.userlist.Remove(viewData.user);
}
catch
{
;
}
try
{
int ClassID = viewData.Classes.ClassID;
viewData.courselist = (from c in CQGJ.Course where c.Classes.ClassID == ClassID select c).ToList();
viewData.learnlist = (from l in CQGJ.LearnGain where l.CourseResult.Course.Classes.ClassID == ClassID && l.CourseResult.Student.User.UserID == userID select l).ToList();
viewData.paperlist = (from p in CQGJ.Paper where p.CourseResult.Course.Classes.ClassID == ClassID && p.CourseResult.Student.User.UserID == userID select p).ToList();
}
catch
{
;
}
if (viewData.ClassBBS != null)
{
int BBSID = viewData.ClassBBS.BBSID;
//班级论坛帖子
viewData.BBSItemList = (from b in CQGJ.BBSItem
orderby b.SubmitTime descending
where b.BBS.BBSID == BBSID && b.ParentID == -1
select b).Take(10).ToList();
}
viewData.user = (CQGJ.passport.User)HttpContext.Session["userobject"];
RenderView("Class", viewData);
}
/// <summary>
/// 前台用户登录验证
/// </summary>
public void UserLogin()
{
//如果验证成功
passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport();
CQGJ.passport.User user = cqgj.ValidateUser(GetString("userName"), Security.MD5Encrypt(GetString("userPass")));
if (user != null)
{
HttpContext.Session["UserID"] = user.UserID;
HttpContext.Session["userName"] = user.Username;
HttpContext.Session["userobject"] = user;
FormsAuthentication.SetAuthCookie(user.Username, false);
RedirectToAction("index", "home");
}
else
{
TempData["LoginStatus"] = "false";
//RedirectToAction("userlogin", "security");
}
RenderView("UserLogin");
}
