/// <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); } }
/// <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); } }
private void initGuide2() { Guide2Mgr mgr = new Guide2Mgr(); this.lstGuide2ID.DataSource = mgr.GetGuide2List(this.lstGuideID.SelectedValue); this.lstGuide2ID.DataTextField = "Guide2Name"; this.lstGuide2ID.DataValueField = "Guide2ID"; this.lstGuide2ID.DataBind(); }