/// <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();
}
}
