public static List <string> getDefaultDevices()
{
var defaultDeviceist = new List <string> {
"全部", "图书", "电脑", "元器件", "开发工具"
};
var newDeviceList = KyMySql.queryDistinctDevice();
newDeviceList.ForEach(str =>
{
var isNew = true;
defaultDeviceist.ForEach(strDefault =>
{
if (str.Equals(strDefault))
{
isNew = false;
}
});
if (isNew)
{
defaultDeviceist.Add(str);
}
});
return(defaultDeviceist);
}
/// <summary>
/// 查询借出或归还情况表
/// </summary>
/// <param name="facility">包含用户名，设备类别</param>
/// <returns></returns>
public DataTable queryDeviceInputOutputLog(Facility facility)
{
switch (facility.status)
{
case DeviceStatus.LOAN:
return(KyMySql.queryStorageLimitUser(facility.category, facility.ownUser, MySqlConsts.TABLE_LOG_LOAN));
case DeviceStatus.RETURN:
return(KyMySql.queryStorageLimitUser(facility.category, facility.ownUser, MySqlConsts.TABLE_LOG_RETURN));
case DeviceStatus.INPUT:
return(KyMySql.queryStorageLimitUser(facility.category, facility.ownUser, MySqlConsts.TABLE_LOG_INPUT));
case DeviceStatus.OUTPUT:
return(KyMySql.queryStorageLimitUser(facility.category, facility.ownUser, MySqlConsts.TABLE_LOG_OUTPUT));
}
throw new Exception("查询借出或归还情况表异常，设置有误");
}
public static List <string> queryUserNameAll()
{
return(KyMySql.queryUserNameAll());
}
/// <summary>
/// 查询库存情况表
/// </summary>
/// <param name="facility">包含用户名，设备类别</param>
/// <returns></returns>
public static DataTable queryStorageLimitUser(Facility facility)
{
return(KyMySql.queryStorageLimitUser(facility.category, facility.ownUser, MySqlConsts.TABLE_STATUS_REPERTORY));
}
