//查询 private void toolStripButton1_Click(object sender, EventArgs e) { Business.Models.QueryModelForDrugPath m = new Business.Models.QueryModelForDrugPath(); m.Id = _id; m.DTT = this.dtpT.Value.AddDays(1).Date; m.DTF = this.dtpF.Value.Date; m.DrugPathQueryType = _type; var c = this.PharmacyDatabaseService.GetDrugPath(m, out msg); this.ListDrugPathAll = c.OrderBy(r => r.batchNumber).ThenBy(r => r.purchaseUnitName).ToList(); this.ListDrugPath = this.GetListPathExpandable(string.Empty, Guid.Empty); this.dataGridView1.DataSource = new BindingCollection <DrugPathExpandable>(this.ListDrugPath); if (this.ListDrugPath.Count > 0) { toolStripStatusLabel2.Text = this.ListDrugPath.First().drugName; toolStripStatusLabel4.Text = this.ListDrugPath.Count.ToString(); toolStripStatusLabel6.Text = this.ListDrugPath.First().cansaleNum.ToString(); toolStripStatusLabel8.Text = this.ListDrugPath.Sum(r => r.saleCount).ToString(); } }
private void Form_HistoryPurchase_Load(object sender, EventArgs e) { if (_type == 2) { Business.Models.QueryModelForDrugPath m = new Business.Models.QueryModelForDrugPath(); m.DTT = this.dtpTo.Value.AddDays(1).Date; m.DTF = this.dtp.Value.Date; m.DrugPathQueryType = 0; m.Id = _id; var c = this.PharmacyDatabaseService.GetDrugPath(m, out msg).OrderByDescending(r => r.saleDate).ToList(); if (!_purchaseUnitID.Equals(Guid.Empty)) { c = c.Where(r => r.purchaseUnitId.Equals(_purchaseUnitID)).ToList(); } foreach (DataGridViewColumn dc in this.dataGridView1.Columns) { if (dc.Index < 7) { dc.Visible = false; } else { dc.Visible = true; } } this.Text = "药品批次销售记录"; this.dataGridView1.DataSource = new BindingCollection <Business.Models.DrugPath>(c); this.PharmacyDatabaseService.WriteLog(AppClientContext.CurrentUser.Id, "成功获取该药品批次历史销售信息"); } else if (_type == 3) { Business.Models.QueryModelForDrugPath m = new Business.Models.QueryModelForDrugPath(); m.DTT = this.dtpTo.Value.AddDays(1).Date; m.DTF = this.dtp.Value.Date; m.DrugPathQueryType = 2; m.Id = _id; var c = this.PharmacyDatabaseService.GetDrugPath(m, out msg).OrderByDescending(r => r.saleDate).ToList(); if (!_purchaseUnitID.Equals(Guid.Empty)) { c = c.Where(r => r.purchaseUnitId.Equals(_purchaseUnitID)).ToList(); } foreach (DataGridViewColumn dc in this.dataGridView1.Columns) { if (dc.Index < 7) { dc.Visible = false; } else { dc.Visible = true; } } this.Text = "药品销售记录"; this.dataGridView1.DataSource = new BindingCollection <Business.Models.DrugPath>(c); this.PharmacyDatabaseService.WriteLog(AppClientContext.CurrentUser.Id, "成功获取历史销售信息"); } else { var c = this.PharmacyDatabaseService.GetPurchaseHistoryByInInventoryPurchaseID(_id, _type, out msg).OrderByDescending(r => r.inInventoryDate).ToList(); this.dataGridView1.DataSource = new BindingCollection <Business.Models.HistoryPurchase>(c); } }