private void GenerterCarheaderlVData() { if (mCarHeaderVs == null) { mCarHeaderVs = new List <CarHeaderV>(); } if (carNeedRefresh == false) { return; } else { mCarHeaderVs.Clear(); } List <CarHeader> cates = new List <CarHeader>(); String sql = DatabaseOPtionHelper.GetInstance().getSelectSql(DataTabeName.car_header.ToString(), null, null, null, null, CarHeaderEnum.content.ToString() + " asc "); cates = DatabaseOPtionHelper.GetInstance().select <CarHeader>(sql); if (cates.Count > 0) { if (cates == null || cates.Count <= 0) { FillMaterialAlretData(); return; } CarHeader ch = null; String condition = string.Empty; String carsql = string.Empty; for (int i = 0; i < cates.Count; i++) { ch = cates[i]; condition = CarInfoEnum.car_number + " like " + Constract.valueSplit + ch.content + "%" + Constract.valueSplit; sql = DatabaseOPtionHelper.GetInstance().getSelectSql(DataTabeName.car_info.ToString(), null, condition); List <CarInfo> mlist = DatabaseOPtionHelper.GetInstance().select <CarInfo>(sql); if (mlist.Count > 0) { CarHeaderV v = new CarHeaderV() { head = ch, carInfos = mlist }; mCarHeaderVs.Add(v); } } } }
private void AddCarHeader() { String header = mCarInfo.carNumber.Substring(0, 2); String condition = CarHeaderEnum.content.ToString() + "=" + Constract.valueSplit + header + Constract.valueSplit; String sql = DatabaseOPtionHelper.GetInstance().getSelectSqlNoSoftDeleteCondition(DataTabeName.car_header.ToString(), CarHeaderEnum.content.ToString(), condition); List <CarHeader> list = DatabaseOPtionHelper.GetInstance().select <CarHeader>(sql); if (list.Count <= 0) { CarHeader carHeader = new CarHeader() { id = Guid.NewGuid().ToString(), content = header, syncTime = DateTimeHelper.GetTimeStamp() }; DatabaseOPtionHelper.GetInstance().insert(carHeader); } }