Example #1
0
        public Row_R_Label GetLabelConfigByLabelName(string LabName, OleExec DB)
        {
            string  strSql = $@"select * from R_Label r where r.labelname = '{LabName}'";
            DataSet res    = DB.RunSelect(strSql);

            if (res.Tables[0].Rows.Count > 0)
            {
                Row_R_Label A = (Row_R_Label)NewRow();
                A.loadData(res.Tables[0].Rows[0]);
                return(A);
            }
            return(null);
        }
Example #2
0
        public List <R_Label> GetLabelList(OleExec DB)
        {
            List <R_Label> ret    = new List <R_Label>();
            string         strSql = $@"select * from R_Label";
            DataSet        res    = DB.RunSelect(strSql);

            for (int i = 0; i < res.Tables[0].Rows.Count; i++)
            {
                Row_R_Label A = (Row_R_Label)NewRow();
                A.loadData(res.Tables[0].Rows[i]);
                ret.Add((R_Label)A.GetDataObject());
            }
            return(ret);
        }