private void AddConsignmentBill(object obj) { // 直接用 SelectedConsignmentBill if (SelectedConsignmentBill != null && SelectedConsignmentBill.SelectedStatus == 0) { // 后台查询该记录是否被别人操作了 string ownerName = _consignmentService.GetConsignmentBillLockOwner(SelectedConsignmentBill.BillNo, SelectedConsignmentBill.UserId); if (string.IsNullOrEmpty(ownerName)) { // 修改选择状态 if (SelectedConsignmentBill.UndoQuantity == selectedConsignmentBill.CurrencyQuantity) { SelectedConsignmentBill.SelectedStatus = 2; } else { SelectedConsignmentBill.SelectedStatus = 1; } // 添加已选数据,求和 SelectedConsignmentBillLists.Insert(0, SelectedConsignmentBill); SelectedConsignmentSum = SelectedConsignmentBillLists.Where(m => m.SelectedStatus > 0).Sum(m => m.CurrencyQuantity); SelectedConsignmentBillEntry = null; // 同步数据到数据库 _consignmentService.AddConsignmentBill(SelectedConsignmentBill); } else { MessageBox.Show($"【{ownerName}】,请选择其他数据"); } } }
private void InitQueryConSignmentBill() { QuerySignmentBill(null); SelectedConsignmentBillLists.Clear(); _consignmentService.GetUserSelectedConsignmentBill(user.ID).ToList().ForEach(x => SelectedConsignmentBillLists.Add(x)); SelectedConsignmentSum = SelectedConsignmentBillLists.Where(m => m.SelectedStatus > 0).Sum(m => m.CurrencyQuantity); }
private void RemoveConsignmentBill(object obj) { if (SelectedConsignmentBill.SelectedStatus > 0) { //移除数据求和 SelectedConsignmentBillLists.Remove(SelectedConsignmentBillLists.FirstOrDefault(x => x.InterId == SelectedConsignmentBill.InterId)); SelectedConsignmentSum = SelectedConsignmentBillLists.Where(m => m.SelectedStatus > 0).Sum(m => m.CurrencyQuantity); // 修改选择状态 SelectedConsignmentBill.SelectedStatus = 0; // 同步数据到数据库 _consignmentService.DeleteConsignmentBill(SelectedConsignmentBill); } }
private void UnSelectedAllConsignmentBill(object obj) { if (ConsignmentBills.Count == 0) { return; } if (ConsignmentBills.Where(m => m.SelectedStatus > 0).Count() > 0)// 反选 { var bills = ConsignmentBills.Where(m => m.SelectedStatus > 0); if (bills.Count() > 0) { StringBuilder sb = new StringBuilder(); foreach (var item in bills) { SelectedConsignmentBillLists.Remove(SelectedConsignmentBillLists.FirstOrDefault(x => x.InterId == item.InterId)); sb.Append(",'" + item.BillNo + "'"); } _consignmentService.RemoveUserCurrencyOperation(sb.ToString().Substring(1)); SelectedConsignmentSum = SelectedConsignmentBillLists.Where(m => m.SelectedStatus > 0).Sum(m => m.CurrencyQuantity); QuerySignmentBill(null); } } }
private void SelectedAllConsignmentBill(object obj) { if (ConsignmentBills.Count == 0) { return; } if (ConsignmentBills.Where(m => m.SelectedStatus == 0).Count() > 0) { // 查询有没有被锁定的数据 string billNos = "'" + string.Join("','", ConsignmentBills.Select(m => m.BillNo)) + "'"; string lockstring = _consignmentService.GetConsignmentBillLockOwner(user.ID, billNos); bool r = ConsignmentBills.Where(m => m.CurrencyQuantity == 0).Count() > 0; StringBuilder sb = new StringBuilder(); if (string.IsNullOrEmpty(lockstring) || r) { foreach (var item in ConsignmentBills) { if (SelectedConsignmentBillLists.Where(x => x.InterId == item.InterId).Count() == 0) { item.SelectedStatus = item.TotalQuantity == item.CurrencyQuantity ? 2 : 1; SelectedConsignmentBillLists.Add(item); sb.Append(",'" + item.BillNo + "'"); } } _consignmentService.AddUserCurrencyOperation(user.ID, sb.ToString().Substring(1)); SelectedConsignmentSum = SelectedConsignmentBillLists.Where(m => m.SelectedStatus > 0).Sum(m => m.CurrencyQuantity); QuerySignmentBill(null); } else { MessageBox.Show(lockstring + "!\r\n 或者已选数据的当前数量不能为0 ,不能批量选择"); } } }