public EquipmentCollection GetAllEquipments() { EquipmentCollection equipments = null; if (this.TryConnection()) { DatabaseParameters keyParameters = new DatabaseParameters(); DataTable table = this.QueryData(keyParameters, this.DataStructrure.Tables.MasterEquipment.ActualTableName); if (table == null) { return(equipments); } equipments = new EquipmentCollection(); foreach (DataRow row in table.Rows) { EquipmentObj obj2 = new EquipmentObj(row[this.DataStructrure.Tables.MasterEquipment.EquipmentID.ActualFieldName].ToString()) { Description = row[this.DataStructrure.Tables.MasterEquipment.EquipmentDescription.ActualFieldName].ToString(), EquipmentObject = row[this.DataStructrure.Tables.MasterEquipment.EquipmentObject.ActualFieldName].ToString(), EquipmentSNR = row[this.DataStructrure.Tables.MasterEquipment.Equipmentsnr.ActualFieldName].ToString(), EquipmentLocation = row[this.DataStructrure.Tables.MasterEquipment.EquipmentLocation.ActualFieldName].ToString(), EquipmentProfileID = row[this.DataStructrure.Tables.MasterEquipment.EquipmentProfile.ActualFieldName].ToString() }; equipments.Add(obj2); } } return(equipments); }
public static EquipmentCollection GetEquipmentCollection(string deptId, string equipmentCode, string equipmentName, string equipmentType) { EquipmentCollection equipments = new EquipmentCollection(); string sqlWhere = ""; sqlWhere = "(State=1)"; if (deptId.ToString() != "") { sqlWhere = sqlWhere + " and (LocateDeptID = " + deptId + ") "; } if (equipmentCode.Trim() != "") { sqlWhere = sqlWhere + " and (EquipmentManualCode like '%" + equipmentCode.Trim() + "%') "; } if (equipmentName.Trim() != "") { sqlWhere = sqlWhere + " and (EquipmentName like '%" + equipmentName.Trim() + "%') "; } if (equipmentType.Trim() != "") { sqlWhere = sqlWhere + " and (EquipmentType='" + equipmentType + "') "; } using (DataTable table = publicDbOpClass.GetPageData(sqlWhere, "Ent_Ept_Equipments", "NoteSequenceID desc")) { for (int i = 0; i < table.Rows.Count; i++) { equipments.Add(GetEquipmentInfoFromDataRow(table.Rows[i])); } } return(equipments); }
private EquipmentCollection _getEquipments(string sql, int pPageIndex, int pPageSize) { EquipmentCollection retobjs = new EquipmentCollection(); SqlDataReader sdr = null; Equipment obj = null; m_db.RunSql(sql, out sdr); if (null == sdr) { return(null); } int _curRecPos = 0; //计算页记录/// long _startpos = 0; long _endpos = 0; if (pPageIndex > -1) { _startpos = pPageIndex * pPageSize; _endpos = _startpos + pPageSize; } while (sdr.Read()) { if (_curRecPos > _endpos) { break; } if (_curRecPos >= _startpos && _curRecPos < _endpos) { obj = this._buildEquipment(ref sdr); if (null != obj) { retobjs.Add(obj); } } _curRecPos++; } sdr.Close(); if (retobjs.Count > 0) { return(retobjs); } else { return(null); } }
private EquipmentCollection _getEquipments(string sql) { EquipmentCollection retobjs = new EquipmentCollection(); SqlDataReader sdr = null; m_db.RunSql(sql, out sdr); if (null == sdr) { return(null); } while (sdr.Read()) { retobjs.Add(this._buildEquipment(ref sdr)); } sdr.Close(); return(retobjs); }
public EquipmentCollection GetAllEquipmentProfiles() { EquipmentCollection equipments = null; if (this.TryConnection()) { DataTable table = base.CurDBEngine.SelectQuery("SELECT DISTINCT " + this.DataStructrure.Tables.MasterEquipment.EquipmentProfile.ActualFieldName + " FROM " + this.DataStructrure.Tables.MasterEquipment.ActualTableName); if (table == null) { return(equipments); } equipments = new EquipmentCollection(); foreach (DataRow row in table.Rows) { EquipmentObj obj2 = new EquipmentObj(row[this.DataStructrure.Tables.MasterEquipment.EquipmentProfile.ActualFieldName].ToString()) { EquipmentSNR = row[this.DataStructrure.Tables.MasterEquipment.EquipmentProfile.ActualFieldName].ToString(), EquipmentProfileID = row[this.DataStructrure.Tables.MasterEquipment.EquipmentProfile.ActualFieldName].ToString() }; equipments.Add(obj2); } } return(equipments); }