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