c#窗体代码中调用类库中的一个类使 lblist.Text=lblist

Question

类库中的方法如下

    public List<DataContract.ClinicInCharge.Records_Moneys> Querydgvlist(string months)//
        {
            string sql = string.Empty, err = string.Empty;
            DataTable dt = new DataTable();
            sql = string.Format(@"
                            SELECT a.months, b.dept_code ,b.dept_name ,
                                    c.user_code , isnull(c.user_name,username) as user_name,a.moneys
                                    ,a.userid,a.deptid,a.id,a.RecordUser,a.RecordTime,a.iscw
                                FROM {0}  a 
                                inner join {1} b on a.deptid=b.deptid
                                left outer join {2} c on c.userid=a.userid                           
                                where a.months='{3}'                      
                                ", TableName, Tables.tbDeptList, Tables.tbuser, months);
            dt = SqlHelper.QueryFromDatabase(ThisConn.sCono, sql, out err);
            string lblist = "上报明细：" + dt.Rows.Count.ToString() + "行, 人数：" + dt.Rows.Count.ToString() + ",科室总奖金：" + DataConverter.ToDecimal(dt.Compute("sum(moneys)", "")).ToString("") + "元";
            return DataConverter.DataTableToIList<DataContract.ClinicInCharge.Records_Moneys>(dt).ToList();
        }

要怎么做？

Answer 1

通过dal调用相关的数值