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