/// <summary> /// 获取一条AddNumber类信息 /// </summary> /// <param name="AddNumberID">登录编号</param> /// <returns>一条AddNumber类记录</returns> public AddNumber GetAddNumber(string AddNumberID) { AddNumber addNumber = new AddNumber(); Guide2Mgr g2Mgr = new Guide2Mgr(); GuideMgr gMgr = new GuideMgr(); PersonMgr pMgr = new PersonMgr(); ClientMgr cMgr = new ClientMgr(); string strSQL = "SELECT Top 1 * FROM Sys_AddNumber WHERE AddNumberID = " + AddNumberID; DataTable dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; addNumber.AddNumberID = int.Parse(row["AddNumberID"].ToString()); addNumber.Title = row["Title"].ToString(); addNumber.Content = row["Content"].ToString(); addNumber.IsAudi = row["IsAudi"].ToString(); addNumber.Person = pMgr.GetPerson(row["PersonID"].ToString()); addNumber.Client = cMgr.GetClient(row["ClientID"].ToString()); addNumber.Guide2 = g2Mgr.GetGuide2(row["Guide2ID"].ToString()); addNumber.Guide = gMgr.GetGuide(row["GuideID"].ToString()); addNumber.AddInt = int.Parse(row["AddInt"].ToString()); return(addNumber); } else { return(addNumber); } }
/// <summary> /// 获取一条Rewrite类信息 /// </summary> /// <param name="RewriteID">登录编号</param> /// <returns>一条Rewrite类记录</returns> public Rewrite GetRewrite(string RewriteID) { Rewrite rewrite = new Rewrite(); ClientMgr g2Mgr = new ClientMgr(); PersonMgr pMgr = new PersonMgr(); string strSQL = "SELECT Top 1 * FROM Sys_Rewrite WHERE RewriteID = " + RewriteID; DataTable dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; rewrite.RewriteID = int.Parse(row["RewriteID"].ToString()); rewrite.Title = row["Title"].ToString(); rewrite.Content = row["Content"].ToString(); rewrite.InputDate = DateTime.Parse(row["InputDate"].ToString()); rewrite.Person = pMgr.GetPerson(row["PersonID"].ToString()); rewrite.Client = g2Mgr.GetClient(row["ClientID"].ToString()); rewrite.ReContent = row["ReContent"].ToString(); return(rewrite); } else { return(rewrite); } }
/// <summary> /// 获取一条Asses类信息 /// </summary> /// <param name="AssesID">登录编号</param> /// <returns>一条Asses类记录</returns> public Asses GetAsses(string AssesID) { Asses asses = new Asses(); GuideMgr gMgr = new GuideMgr(); Guide2Mgr g2Mgr = new Guide2Mgr(); PersonMgr pMgr = new PersonMgr(); string strSQL = "SELECT Top 1 * FROM Sys_Asses WHERE AssesID = " + AssesID; DataTable dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; asses.AssesID = int.Parse(row["AssesID"].ToString()); asses.Person = pMgr.GetPerson(row["PersonID"].ToString()); asses.Guide = gMgr.GetGuide(row["GuideID"].ToString()); asses.Guide2 = g2Mgr.GetGuide2(row["Guide2ID"].ToString()); asses.Scale1 = int.Parse(row["Scale1"].ToString()); asses.Scale2 = int.Parse(row["Scale2"].ToString()); asses.Scale3 = int.Parse(row["Scale3"].ToString()); asses.Scale1Name = row["Scale1Name"].ToString(); asses.Scale2Name = row["Scale2Name"].ToString(); asses.Scale3Name = row["Scale3Name"].ToString(); asses.CountNumber = int.Parse(row["CountNumber"].ToString()); asses.Memo = row["Memo"].ToString(); return(asses); } else { return(asses); } }
protected void btnLogin_Click(object sender, ImageClickEventArgs e) { switch (this.lstLoginType.SelectedValue) { case "管理员": AdminMgr aMgr = new AdminMgr(); Admin admin = aMgr.GetAdmin(this.txtLoginName.Text); if (admin.AdminID != "") { if (this.txtPassword.Text == admin.Password) { this.eUserID = admin.AdminID; this.eUserName = admin.AdminName; this.eUserType = "管理员"; Response.Redirect("MainFrame.aspx"); } else { this.SendMessage("密码不正确"); } } else { this.SendMessage("没有找到该教师"); } break; case "教师": ClientMgr pMgr = new ClientMgr(); Client client = pMgr.GetClient(this.txtLoginName.Text); if (client.ClientID != "") { if (this.txtPassword.Text == client.Password) { this.eUserID = client.ClientID; this.eUserName = client.ClientName; this.eUserType = "教师"; Response.Redirect("MainFrame.aspx"); } else { this.SendMessage("密码不正确"); } } else { this.SendMessage("没有找到该教师"); } break; case "学生": PersonMgr cMgr = new PersonMgr(); Person person = cMgr.GetPerson(this.txtLoginName.Text); if (person.PersonID != "") { if (this.txtPassword.Text == person.Password) { this.eUserID = person.PersonID; this.eUserName = person.PersonName; this.eUserType = "学生"; Response.Redirect("MainFrame.aspx"); } else { this.SendMessage("密码不正确"); } } else { this.SendMessage("没有找到该学生"); } break; } }
protected void dgList_ItemDataBound(object sender, DataGridItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { HyperLink hyGuide1 = (HyperLink)e.Item.FindControl("hyGuide1"); HyperLink hyGuide2 = (HyperLink)e.Item.FindControl("hyGuide2"); HyperLink hyGuide3 = (HyperLink)e.Item.FindControl("hyGuide3"); GuideMgr gMgr = new GuideMgr(); Guide guide1 = gMgr.GetGuide("1"); Guide guide2 = gMgr.GetGuide("2"); Guide guide3 = gMgr.GetGuide("3"); hyGuide1.Text = "0"; hyGuide2.Text = "0"; hyGuide3.Text = "0"; PersonMgr mgr = new PersonMgr(); Person person = mgr.GetPerson(e.Item.Cells[0].Text); AssesMgr aMgr = new AssesMgr(); DataTable dt = aMgr.GetAssesNumberList(person.PersonID, 1); foreach (DataRow row in dt.Rows) { hyGuide1.Text = (int.Parse(hyGuide1.Text) + int.Parse(row["Scale1"].ToString())).ToString(); } if (hyGuide1.Text != "0") { if (int.Parse(hyGuide1.Text) > 100) { hyGuide1.Text = "100"; } hyGuide1.Text = (int.Parse(hyGuide1.Text) * guide1.Scale / 100).ToString(); } dt = aMgr.GetAssesNumberList(person.PersonID, 2); foreach (DataRow row in dt.Rows) { hyGuide2.Text = (int.Parse(hyGuide2.Text) + int.Parse(row["Scale1"].ToString())).ToString(); } if (hyGuide2.Text != "0") { if (int.Parse(hyGuide2.Text) > 100) { hyGuide2.Text = "100"; } hyGuide2.Text = (int.Parse(hyGuide2.Text) * guide2.Scale / 100).ToString(); } dt = aMgr.GetAssesNumberList(person.PersonID, 3); foreach (DataRow row in dt.Rows) { hyGuide3.Text = (int.Parse(hyGuide3.Text) + int.Parse(row["Scale1"].ToString())).ToString(); } if (hyGuide3.Text != "0") { if (int.Parse(hyGuide3.Text) > 100) { hyGuide3.Text = "100"; } hyGuide3.Text = (int.Parse(hyGuide3.Text) * guide3.Scale / 100).ToString(); } e.Item.Cells[e.Item.Cells.Count - 1].Text = (int.Parse(hyGuide1.Text) + int.Parse(hyGuide2.Text) + int.Parse(hyGuide3.Text)).ToString(); } }