示例#1
0
    /// <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);
        }
    }
示例#2
0
    /// <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();
    }