public addDrug()
{
InitializeComponent();
Win32Utility.SetCueText(name, "输入药品名");
Win32Utility.SetCueText(specification, "选择规格");
Win32Utility.SetCueText(unit, "选择记录单位");
Win32Utility.SetCueText(bid, "输入药品进价");
Win32Utility.SetCueText(price, "输入药品售价");
Win32Utility.SetCueText(packing, "选择包装数量");
Win32Utility.SetCueText(approval, "输入批准文号");
specification.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
unit.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
commDao info = new commDao();
List <Specification> specificationList = info.loadSpecification();
for (int i = 0; i < specificationList.Count; i++)
{
specification.Items.Add(specificationList[i].getName());
}
List <Unit> unitList = info.loadUnit();
for (int i = 0; i < unitList.Count; i++)
{
unit.Items.Add(unitList[i].getName());
}
List <String> packingList = info.loadPacking();
for (int i = 0; i < packingList.Count; i++)
{
packing.Items.Add(packingList[i]);
}
}
public updateDrug(Commodity commodity, int row)
{
InitializeComponent();
this.row = row;
id = commodity.getId();
name.Text = commodity.getName();
specification.Text = commodity.getSpecification();
unit.Text = commodity.getUnit();
price.Text = commodity.getPrice();
bid.Text = commodity.getBid();
packing.Text = commodity.getPacking();
approval.Text = commodity.getApproval();
commDao info = new commDao();
List <Specification> specificationList = info.loadSpecification();
for (int i = 0; i < specificationList.Count; i++)
{
specification.Items.Add(specificationList[i].getName());
}
List <Unit> unitList = info.loadUnit();
for (int i = 0; i < unitList.Count; i++)
{
unit.Items.Add(unitList[i].getName());
}
List <String> packingList = info.loadPacking();
for (int i = 0; i < packingList.Count; i++)
{
packing.Items.Add(packingList[i]);
}
}
private void btn_Click(object sender, EventArgs e)
{
Commodity commodity = new Commodity();
commodity.setId(id);
commodity.setName(name.Text);
commodity.setSpecification(specification.Text);
commodity.setUnit(unit.Text);
commodity.setApproval(approval.Text);
commodity.setBid(bid.Text);
commodity.setPacking(packing.Text);
commodity.setPrice(price.Text);
commDao info = new commDao();
info.verification(commodity);
if (info.updateCommodity(commodity))
{
MessageBox.Show("修改成功!");
}
else
{
MessageBox.Show("修改失败!");
}
// this.Close();
}
public queryDrug()
{
InitializeComponent();
commDao info = new commDao();
Commodity commodity = null;
this.pageDeal(commodity, Convert.ToInt32(pageNo.Text));
}
private void dgv_MouseDown(object sender, MouseEventArgs e)
{
commDao info = new commDao();
if (e.Button == MouseButtons.Left)
{
DataGridView.HitTestInfo hit = dgv.HitTest(e.X, e.Y);
if (hit.Type == DataGridViewHitTestType.Cell)
{
clickedCell = dgv.Rows[hit.RowIndex].Cells[hit.ColumnIndex];
if (clickedCell.ColumnIndex == 9)
{
Commodity commodity = new Commodity();
commodity.setId(Convert.ToInt32(dgv.Rows[clickedCell.RowIndex].Cells[0].Value));
commodity.setName(dgv.Rows[clickedCell.RowIndex].Cells[1].Value.ToString());
commodity.setSpecification(dgv.Rows[clickedCell.RowIndex].Cells[2].Value.ToString());
commodity.setBid(dgv.Rows[clickedCell.RowIndex].Cells[3].Value.ToString());
commodity.setPrice(dgv.Rows[clickedCell.RowIndex].Cells[4].Value.ToString());
commodity.setUnit(dgv.Rows[clickedCell.RowIndex].Cells[5].Value.ToString());
commodity.setPacking(dgv.Rows[clickedCell.RowIndex].Cells[6].Value.ToString());
commodity.setNum(dgv.Rows[clickedCell.RowIndex].Cells[7].Value.ToString());
commodity.setApproval(dgv.Rows[clickedCell.RowIndex].Cells[8].Value.ToString());
updateDrug u = new updateDrug(commodity, clickedCell.RowIndex);
u.ShowDialog();
List <Commodity> list = info.getCommBySelect(info.getSql(commodity.getId()));
dgv.Rows[clickedCell.RowIndex].Cells[0].Value = list[0].getId().ToString();
dgv.Rows[clickedCell.RowIndex].Cells[1].Value = list[0].getName();
dgv.Rows[clickedCell.RowIndex].Cells[2].Value = list[0].getSpecification();
dgv.Rows[clickedCell.RowIndex].Cells[3].Value = list[0].getBid();
dgv.Rows[clickedCell.RowIndex].Cells[4].Value = list[0].getPrice();
dgv.Rows[clickedCell.RowIndex].Cells[5].Value = list[0].getUnit();
dgv.Rows[clickedCell.RowIndex].Cells[6].Value = list[0].getPacking();
dgv.Rows[clickedCell.RowIndex].Cells[7].Value = list[0].getNum();
dgv.Rows[clickedCell.RowIndex].Cells[8].Value = list[0].getApproval();
}
if (clickedCell.ColumnIndex == 10)
{
if (MessageBox.Show("是否删除？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (info.DeleteCommodity(Convert.ToInt32(dgv.Rows[clickedCell.RowIndex].Cells[0].Value)))
{
MessageBox.Show("删除成功!");
}
else
{
MessageBox.Show("删除失败!");
}
this.pageDeal(this.getCommodity(), Convert.ToInt32(pageNo.Text));
}
}
}
}
}
private void pageDeal(Commodity commodity, int pageNo1)
{
commDao info = new commDao();
if (info.getCount(info.getSql(commodity)) != 0)
{
Paging page = new Paging(info.getCount(info.getSql(commodity)), pageCount0, pageNo1);
//MessageBox.Show(info.getSql(commodity));
//MessageBox.Show(info.getCount(info.getSql(commodity)).ToString());
if (pageNo1 <= 1)
{
lastPage.Enabled = false;
pageNo1 = 1;
}
else
{
lastPage.Enabled = true;
}
if (pageNo1 >= page.getPageNum())
{
nextPage.Enabled = false;
pageNo1 = page.getPageNum();
}
else
{
nextPage.Enabled = true;
}
if (page.getPageNum() == 1)
{
lastPage.Enabled = false;
nextPage.Enabled = false;
}
//更新控件
pageNo.Text = pageNo1.ToString();
noTbx.Text = pageNo1.ToString();
countTbx.Text = pageCount0.ToString();
pageNum.Text = page.getPageNum().ToString();
Paging page1 = new Paging(info.getCount(info.getSql(commodity)), pageCount0, pageNo1);
List <Commodity> list = info.getCommBySelect(info.getSql(commodity, page1.getRecordStart(), pageCount0));
info.showDgv(dgv, list);
}
else
{
dgv.Rows.Clear();
pageNo.Text = "1";
noTbx.Text = "1";
countTbx.Text = "1";
pageNum.Text = "1";
lastPage.Enabled = false;
nextPage.Enabled = false;
}
}
public void re()
{
specification.Items.Clear();
unit.Items.Clear();
commDao info = new commDao();
List <Specification> specificationList = info.loadSpecification();
for (int i = 0; i < specificationList.Count; i++)
{
specification.Items.Add(specificationList[i].getName());
}
List <Unit> unitList = info.loadUnit();
for (int i = 0; i < unitList.Count; i++)
{
unit.Items.Add(unitList[i].getName());
}
}
private void addbtn_Click(object sender, EventArgs e)
{
Commodity commodity = new Commodity();
try
{
commodity.setName(name.Text);
commodity.setBid(bid.Text);
commodity.setPrice(price.Text);
commodity.setPacking(packing.Text);
commodity.setSpecification(specification.Text);
commodity.setUnit(unit.Text);
commodity.setApproval(approval.Text);
}
catch { }
commDao info = new commDao();
if (info.verification(commodity))
{
if (info.saveCommodity(commodity))
{
MessageBox.Show("添加成功！");
name.Text = "";
bid.Text = "";
price.Text = "";
packing.Text = "";
specification.Text = "";
unit.Text = "";
approval.Text = "";
}
else
{
MessageBox.Show("添加失败!");
}
}
}
