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