private void RefreshList() { carInfos = carDal.GetCarEnable(StaticData.storeLocal.StoreId); if (carInfos != null) { Cursor = Cursors.WaitCursor; lvCarList.Items.Clear(); lvCarList.BeginUpdate(); for (int i = 0; i < carInfos.Count; i++) { lvCarList.Items.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems[1].Text = carInfos[i].CarId.ToString(); lvCarList.Items[i].SubItems[2].Text = carInfos[i].CarPlateNumber; lvCarList.Items[i].SubItems[3].Text = carInfos[i].CarType; lvCarList.Items[i].SubItems[4].Text = carInfos[i].Color; StoreInfo storeTemp = storeDal.StoreSelectById(carInfos[i].StoreId); lvCarList.Items[i].SubItems[5].Text = storeTemp.StoreName; } lvCarList.EndUpdate(); Cursor = Cursors.Default; } }
/// <summary> /// 载入设备和店铺信息 /// </summary> private void LoadDeviceAndStore() { DeviceInfo deviceInfo = new DeviceInfo(); string localMac = otherHelper.getMacAddrLocal(); deviceInfo.DeviceMac = localMac; DeviceIDLabel.Text = "设备号:" + localMac; // 查看数据库里有没有这个设备,没有则添加 deviceInfo = deviceDal.SelectByMac(deviceInfo); if (deviceInfo == null) { // 插入新的设备信息 deviceInfo = new DeviceInfo(); deviceInfo.DeviceMac = localMac; bool b = deviceDal.InsertDevice(deviceInfo); if (!b) { deviceInfo.DeviceId = 0; deviceInfo.StoreId = 0; MessageBox.Show("无法添加设备到数据库!", "警告"); } else { deviceInfo = deviceDal.SelectByMac(deviceInfo); } } StaticData.deviceLocal = deviceInfo; StoreInfo storeInfo; if (StaticData.deviceLocal.StoreId != 0) { storeInfo = storeDal.StoreSelectById(StaticData.deviceLocal.StoreId); } else { storeInfo = new StoreInfo(); storeInfo.StoreName = "上海电机学院分店"; storeInfo.StoreAddress = "上海浦东新区水华路300号"; } StaticData.storeLocal = storeInfo; storeNameLabel.Text = "所属店铺:" + StaticData.storeLocal.StoreName; storeAddrLabel.Text = "店铺地址:" + StaticData.storeLocal.StoreAddress; }
private void buttonUpdateStore_Click(object sender, EventArgs e) { if (lvStoreList.SelectedItems.Count > 0) { int storeId = Convert.ToInt32(lvStoreList.SelectedItems[0].SubItems[1].Text); StoreInfo storeTemp = storeDal.StoreSelectById(storeId); UpdateStoreForm updateStoreForm = new UpdateStoreForm(storeTemp); updateStoreForm.ShowDialog(); } else { MessageBox.Show("请先选择要修改的店铺"); } }
/// <summary> /// 刷新列表 /// </summary> private void RefreshList() { Cursor = Cursors.WaitCursor; lvCarList.Items.Clear(); lvCarList.BeginUpdate(); List <CarInfo> carInfos = new List <CarInfo>(); if (cbSelectType.Text == "全部车辆") { carInfos = carDal.GetCarList(); } else if (cbSelectType.Text == "当前店铺") { carInfos = carDal.GetCarByStoreId(StaticData.storeLocal.StoreId); } //else if (select_type == "当前用户") //{ // if (StaticData.userLocal != null) // { // carInfos = carDal.GetCarByUserId(StaticData.userLocal.UserId); // } //} for (int i = 0; i < carInfos.Count; i++) { lvCarList.Items.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems.Add(""); lvCarList.Items[i].SubItems[1].Text = carInfos[i].CarId.ToString(); lvCarList.Items[i].SubItems[2].Text = carInfos[i].CarPlateNumber; lvCarList.Items[i].SubItems[3].Text = carInfos[i].CarType; lvCarList.Items[i].SubItems[4].Text = carInfos[i].Color; StoreInfo storeTemp = storeDal.StoreSelectById(carInfos[i].StoreId); lvCarList.Items[i].SubItems[5].Text = storeTemp.StoreName; lvCarList.Items[i].SubItems[6].Text = carInfos[i].UserId.ToString(); lvCarList.Items[i].SubItems[7].Text = carInfos[i].Status.ToString(); } lvCarList.EndUpdate(); Cursor = Cursors.Default; }
private void btnSelectStore_Click(object sender, EventArgs e) { if (lvStoreList.SelectedItems.Count > 0) { int storeId = Convert.ToInt32(lvStoreList.SelectedItems[0].SubItems[1].Text); StoreInfo storeTemp = storeDal.StoreSelectById(storeId); StaticData.storeLocal = storeTemp; if (StaticData.adminLocal != null) { StaticData.deviceLocal.StoreId = storeId; deviceDal.UpdateDevice(StaticData.deviceLocal); } this.Close(); } else { MessageBox.Show("请先选择店铺"); } }