public void TestSave_Update() { using (new TransactionScope()) using (var dao = new TrendDbContext()) { var beforeCount = dao.Set <MarkSixSpecifiedLocationPurchase>().Count(); var service = new MarkSixPurchaseService(); var addDto = new MarkSixSpecifiedLocationPurchase { Times = "2017001", Odds = 40, Location = 7, PurchaseList = "12:50;36:100" }; service.SaveSpecifiedLocation(addDto); var afterCount = dao.Set <MarkSixSpecifiedLocationPurchase>().Count(); Assert.IsTrue(beforeCount + 1 == afterCount); var purchase = dao.Set <MarkSixSpecifiedLocationPurchase>().OrderByDescending(m => m.Id).FirstOrDefault(); Assert.IsNotNull(purchase); Assert.IsTrue(purchase.Times == addDto.Times); addDto.Id = purchase.Id; addDto.Location = 6; service.SaveSpecifiedLocation(addDto); purchase = dao.Set <MarkSixSpecifiedLocationPurchase>().AsNoTracking().FirstOrDefault(m => m.Id == purchase.Id); Assert.IsTrue(purchase.Location == addDto.Location); } }
private void btnOk_Click(object sender, EventArgs e) { if (MarkSixSpecifiedLocationPurchase == null) { return; } var purchaseNumbers = MarkSixSpecifiedLocationPurchase.Purchases; //OnShowDialogEvent(null); if (purchaseNumbers != null && purchaseNumbers.Count > 0) { var totalAmount = 0; var numberAmountListString = string.Empty; foreach (var number in purchaseNumbers.Keys) { //购买金额文本框 var tb = _textBoxs[number]; var str = tb.Text; if (string.IsNullOrWhiteSpace(str)) { continue; } var amount = 0; if (!int.TryParse(tb.Text, out amount)) { MessageBox.Show("请选择1-7的号码位置!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); tb.Focus(); return; } numberAmountListString += string.Format("{0}:{1};", number, amount); totalAmount += amount; } if (MarkSixSpecifiedLocationPurchase == null) { throw new Exception("对象:MarkSixSpecifiedLocationPurchase为空!"); } if (string.IsNullOrWhiteSpace(numberAmountListString)) { MessageBox.Show("购买清单为空!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var oddsString = tbOdds.Text; var odds = 0; if (!int.TryParse(oddsString, out odds) || odds < 1) { MessageBox.Show("赔率必须为大于0的整数!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } MarkSixSpecifiedLocationPurchase.PurchaseAmount = totalAmount; MarkSixSpecifiedLocationPurchase.PurchaseList = numberAmountListString; MarkSixSpecifiedLocationPurchase.Odds = odds; var purchaseService = new MarkSixPurchaseService(); purchaseService.SaveSpecifiedLocation(MarkSixSpecifiedLocationPurchase); this.DialogResult = DialogResult.OK; this.Close(); } }
private void PurchaseDelete(string id) { if (MessageBox.Show($"你确定删除第{id}条记录吗?", "确认删除", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK) { return; } var service = new MarkSixPurchaseService(); try { var recordId = long.Parse(id); service.RemoveSpecifiedLocation(recordId); Search(); frmMdi.tsslInfo.Text = "删除成功!"; frmMdi.tsslInfo.BackColor = Color.Yellow; } catch (Exception ex) { MessageBox.Show(string.Format("删除Id:{0}的购买记录失败!{1}", id, ex.Message), "删除失败", MessageBoxButtons.OK, MessageBoxIcon.Error); frmMdi.tsslInfo.Text = "删除失败!"; frmMdi.tsslInfo.BackColor = Color.Red; } }
private void tsbExport_Click(object sender, EventArgs e) { using (var saveFileDialog = new SaveFileDialog()) { saveFileDialog.Filter = "Execl 2007files(*.xlsx)|*.xlsx"; saveFileDialog.FilterIndex = 0; saveFileDialog.RestoreDirectory = true; //保存对话框是否记忆上次打开的目录 //saveFileDialog.CreatePrompt = true; saveFileDialog.Title = "导出Excel文件到"; saveFileDialog.FileName = "MarksixPurchaseRecord.xlsx"; if (saveFileDialog.ShowDialog() == DialogResult.OK) { var fileName = saveFileDialog.FileName; var table = Search(); if (table != null) { var service = new MarkSixPurchaseService(); service.Export(table, fileName); frmMdi.tsslInfo.Text = "导出成功!"; frmMdi.tsslInfo.BackColor = Color.Yellow; } } } }
private void PurchaseUpdate(string id) { var service = new MarkSixPurchaseService(); try { var recordId = long.Parse(id); var frm = new frmMarkSixSpecifiedLocationPurchase(); var purchase = service.GetSpecifiedLocationPurchaseById(recordId); if (purchase == null) { throw new Exception(string.Format("错误,购买记录不存在!(Id:{0})", id)); } frm.MarkSixSpecifiedLocationPurchase = purchase; frm.Text = string.Format("编辑 第{0}期第{0}位 购买记录", purchase.Times, purchase.Location); if (frm.ShowDialog() == DialogResult.OK) { Search(); frmMdi.tsslInfo.Text = "修改成功!"; frmMdi.tsslInfo.BackColor = Color.Yellow; } else { frmMdi.tsslInfo.Text = "取消修改"; frmMdi.tsslInfo.BackColor = Color.Yellow; } } catch (Exception ex) { MessageBox.Show(string.Format("修改Id:{0}的购买记录失败!{1}", id, ex.Message), "修改失败", MessageBoxButtons.OK, MessageBoxIcon.Error); frmMdi.tsslInfo.Text = "修改失败!"; frmMdi.tsslInfo.BackColor = Color.Red; } }
private DataTable Search() { //每页数量 var pageSize = 0; int.TryParse(tlscombo.Text, out pageSize); //页码开始数 var pageIndex = 1; int.TryParse(bdnPositionItem.Text, out pageIndex); //开始位置 var startIndex = pageSize * (pageIndex - 1); if (startIndex < 0) { startIndex = 0; } var searchDto = new MarkSixSpecifiedLocationPurchaseSearchDto { StartIndex = startIndex, PageSize = pageSize }; if (tbStartDateTime.Text.Trim().Length > 0) { var strDate = tbStartDateTime.Text.Trim(); DateTime dt; if (DateTime.TryParse(strDate, out dt)) { searchDto.StartDateTime = dt; } } if (tbEndDateTime.Text.Trim().Length > 0) { var strDate = tbEndDateTime.Text.Trim(); DateTime dt; if (DateTime.TryParse(strDate, out dt)) { searchDto.EndDateTime = dt; } } var selectedLocation = cboLocation.SelectedItem as ComboBoxItem <int>; if (selectedLocation != null) { searchDto.Location = selectedLocation.Value; } searchDto.Times = tbTimes.Text; var service = new MarkSixPurchaseService(); try { var rows = service.SearchSpecifiedLocation(searchDto); if (rows.Count == 0) { MessageBox.Show( "没有找到符合条件的数据!", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error ); frmMdi.tsslInfo.Text = "查询内容为空!"; frmMdi.tsslInfo.BackColor = Color.Yellow; //重新绑定数据 var sourceTable = dgvMarksixPurchaseRecordList.DataSource as DataTable; if (sourceTable != null) { sourceTable.Rows.Clear(); dgvMarksixPurchaseRecordList.DataSource = sourceTable; } return(null); } frmMdi.tsslInfo.Text = "查询完成!"; frmMdi.tsslInfo.BackColor = frmMdi.BackColor; var table = rows.ConvertDataTable(properties => { var rowVersionProperty = properties.FirstOrDefault(p => p.Name == nameof(MarkSixSpecifiedLocationPurchase.RowVersion)); if (rowVersionProperty != null) { properties.Remove(rowVersionProperty); } var purchasesProperty = properties.FirstOrDefault(p => p.Name == nameof(MarkSixSpecifiedLocationPurchase.Purchases)); if (purchasesProperty != null) { properties.Remove(purchasesProperty); } var idProperty = properties.FirstOrDefault(p => p.Name == nameof(MarkSixSpecifiedLocationPurchase.Id)); if (idProperty != null) { properties.Remove(idProperty); } //Id列移动到首位 properties.Insert(0, idProperty); }); dgvMarksixPurchaseRecordList.DataSource = table; var pageCount = searchDto.PageCount; bdnCountItem.Text = pageCount.ToString(); if (pageIndex <= 1) { bdnMoveFirstItem.Enabled = false; bdnMovePreviousItem.Enabled = false; } else { bdnMoveFirstItem.Enabled = true; bdnMovePreviousItem.Enabled = true; } if (pageIndex == pageCount) { bdnMoveNextItem.Enabled = false; bdnMoveLastItem.Enabled = false; } else { bdnMoveNextItem.Enabled = true; bdnMoveLastItem.Enabled = true; } return(table); } catch (Exception ex) { MessageBox.Show( "查询发生错误," + ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error ); frmMdi.tsslInfo.Text = "查询失败!"; frmMdi.tsslInfo.BackColor = Color.Yellow; return(null); } }