public static IEnumerable <SYSTRXDATA <eSysID, eTrxDataType> > ReadSystrxdatas(this DBCtrl db, string model = null)
{
if (model == null)
{
return(db.Read <SYSTRXDATA <eSysID, eTrxDataType> >());
}
else
{
return(db.Read <SYSTRXDATA <eSysID, eTrxDataType> >(new SqlScript()
{
sql = $"SELECT * FROM SYSTRXDATA WHERE MODELNAME IN ('*','{model}')"
}));
}
}
public static TMain ReadSysBaseData <TMain>(this DBCtrl db, eSysID configgroup) where TMain : iSysData <eSysID>, new()
{
TMain vpara = new TMain();
vpara.sysid = configgroup;
vpara.tablename = nameof(SYSBASEDATA <eSysID, eBaseDataType>);
vpara.prefix = "BASE";
SqlScript sql;
if (!typeof(TMain).Name.Contains("Model"))
{
sql = new SqlScript($@"
SELECT *
FROM SYSBASEDATA
WHERE MODELNAME='*' AND SYSID='{configgroup.ToString()}' AND BASEDATATYPE='{typeof(TMain).Name}'");
}
else
{
sql = new SqlScript($@"
SELECT *
FROM SYSBASEDATA A
JOIN SYSBASEDATA B ON B.SYSID='Main' AND B.BASEDATATYPE='SystemParameter' AND B.BASEDATAID='CurrentSelectModeName' AND A.MODELNAME=B.BASEDATAVALUE
WHERE A.SYSID='{configgroup.ToString()}' AND A.BASEDATATYPE='{typeof(TMain).Name}'");
}
IEnumerable <SYSBASEDATA <eSysID, eBaseDataType> > data = db.Read <SYSBASEDATA <eSysID, eBaseDataType> >(sql);
if (data.Count() == 0)
{
return(vpara);
}
data.Read <TMain, eSysID, eBaseDataType>(ref vpara);
return(vpara);
}
public static Dictionary <eSysID, List <eBaseDataType> > dicSysIDBaseDataType(this DBCtrl db)
{
Dictionary <eSysID, List <eBaseDataType> > _dicSysIDBaseDataType = new Dictionary <eSysID, List <eBaseDataType> >();
foreach (eSysID enumType in Enum.GetValues(typeof(eSysID)))
{
_dicSysIDBaseDataType.Add(enumType, new List <eBaseDataType>());
Array ary = Enum.GetValues(typeof(eBaseDataType));
Array.Sort(ary);
foreach (eBaseDataType item in ary)
{
if (db.Read <SYSBASEDATA <eSysID, eBaseDataType> >()
.Where(x => x.SYSID.Equals(enumType))
.Where(x => x.BASEDATATYPE.Equals(item)).Count() > 0)
{
_dicSysIDBaseDataType[enumType].Add(item);
}
}
_dicSysIDBaseDataType[enumType].Sort(
(eBaseDataType x, eBaseDataType y) =>
{
return(string.Compare(x.ToString(), y.ToString(), true));
});
}
return(_dicSysIDBaseDataType);
}
public static List <MODEL> MODELs(this DBCtrl db)
{
return(db.Read <MODEL>().ToList());
}
public static List <PART> parts(this DBCtrl db)
{
return(db.Read <PART>().ToList());
}
public static List <HWSETTING> ReadHWSETTING(this DBCtrl db)
{
return(db.Read <HWSETTING>().ToList());
}
