//查询
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);
}
}
