private void btnPrint_Click(object sender, EventArgs e)
{
DataSet dy = new DataSet();
dy.Tables.Add(SSP.MainTable.Copy());
MyDLL.TakeOver(dy);
}
private void button2_Click(object sender, EventArgs e)
{
if (dataGridView1.RowCount <= 0)
{
MessageBox.Show("没有要打印的内容");
return;
}
/////////////////////////////////////////////////////打印模块
System.Data.DataTable dt = new System.Data.DataTable();
DataRow dr;
//设置列表头
foreach (DataGridViewColumn headerCell in dataGridView1.Columns)
{
dt.Columns.Add(headerCell.HeaderText);
}
foreach (DataGridViewRow item in dataGridView1.Rows)
{
dr = dt.NewRow();
for (int i = 0; i < dt.Columns.Count; i++)
{
dr[i] = item.Cells[i].Value;
}
dt.Rows.Add(dr);
}
DataSet dy = new DataSet();
dy.Tables.Add(dt);
MyDLL.TakeOver(dy);
//////////////////////////////////////////////////////
}
private void button3_Click(object sender, EventArgs e)
{//入库按钮事件处理
if (dataGridView1.RowCount > 0)
{
insert_inlib(); //添加入库记录
update_lib(); // 修改库存
if (MessageBox.Show("入库完成，是否需要打印？", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
/////////////////////////////////////////////////////打印模块
datato3();
System.Data.DataTable dt = new System.Data.DataTable();
DataRow dr;
//设置列表头
foreach (DataGridViewColumn headerCell in dataGridView3.Columns)
{
dt.Columns.Add(headerCell.HeaderText);
}
foreach (DataGridViewRow item in dataGridView3.Rows)
{
dr = dt.NewRow();
for (int i = 0; i < dt.Columns.Count; i++)
{
dr[i] = item.Cells[i].Value;
}
dt.Rows.Add(dr);
}
DataSet dy = new DataSet();
dy.Tables.Add(dt);
MyDLL.TakeOver(dy);
}
dataGridView3.Rows.Clear(); //打印完成后清空表格中数据
dataGridView1.Rows.Clear();
//////////////////////////////////////////////////////
}
else
{
MessageBox.Show("待入库药品为空！");
}
}
private void button1_Click(object sender, EventArgs e)
{
System.Data.DataTable dt = new System.Data.DataTable();
DataRow dr;
//设置列表头
foreach (DataGridViewColumn headerCell in dataGridView1.Columns)
{
dt.Columns.Add(headerCell.HeaderText);
}
foreach (DataGridViewRow item in dataGridView1.Rows)
{
dr = dt.NewRow();
for (int i = 0; i < dt.Columns.Count; i++)
{
dr[i] = item.Cells[i].Value.ToString();
}
dt.Rows.Add(dr);
}
DataSet dy = new DataSet();
dy.Tables.Add(dt);
MyDLL.TakeOver(dy);
}
private void button3_Click(object sender, EventArgs e)
{
int dadan = 0;
bool flag = false;
int count = dataGridView1.Rows.Count;
double sum = 0;//每一行的总金
DialogResult MsgBoxResult;
MsgBoxResult = MessageBox.Show("你确定出库吗？", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2);
if (MsgBoxResult == DialogResult.Yes) //确认出库;
{
string nowtime = dateTimePicker1.Value.ToString();
MsgBoxResult = MessageBox.Show("系统当前的时间是" + nowtime, "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2);
if (MsgBoxResult == DialogResult.No)
{
nowtime = Interaction.InputBox("请输入时间格式为" + nowtime);
}
MsgBoxResult = MessageBox.Show("是否打印出库单", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2);
if (MsgBoxResult == DialogResult.Yes)
{
dadan = 1;
flag = true;
}
if (flag)
{
//需要打印出库单，开始打印出库单。
//出库单内容，药名，规格，数量，平均单价，金额合计
for (int i = 0; i < count - 1; ++i)
{
sum = Convert.ToDouble(dataGridView1.Rows[i].Cells["Column12"].Value);
sumJ += sum;
dataGridView3.Rows.Add(dataGridView1.Rows[i].Cells["Column2"].Value, dataGridView1.Rows[i].Cells["Column3"].Value, dataGridView1.Rows[i].Cells["Column5"].Value, dataGridView1.Rows[i].Cells["Column10"].Value, dataGridView1.Rows[i].Cells["Column12"].Value);
}
dataGridView3.Rows.Add(null, null, null, null, sumJ);
//打印
System.Data.DataTable dt = new System.Data.DataTable();
DataRow dr;
foreach (DataGridViewColumn headerCell in dataGridView3.Columns)
{
dt.Columns.Add(headerCell.HeaderText);
}
foreach (DataGridViewRow item in dataGridView3.Rows)
{
dr = dt.NewRow();
for (int i = 0; i < dt.Columns.Count; i++)
{
dr[i] = item.Cells[i].Value;
}
dt.Rows.Add(dr);
}
DataSet dy = new DataSet();
dy.Tables.Add(dt);
MyDLL.TakeOver(dy);
}
// DB db = new DB();
db.close();
if (db.connect())
{
shijian = nowtime;
for (int i = 0; i < count - 1; ++i)
{
// MessageBox.Show((string)dataGridView1.Rows[i].Cells["Column5"].Value);
string shu = (string)dataGridView1.Rows[i].Cells["Column5"].Value;
shuliang = System.Convert.ToDouble(shu);
keshi = (String)dataGridView1.Rows[i].Cells["Column8"].Value;
yaohao = (String)dataGridView1.Rows[i].Cells["Column1"].Value;
jinjia = (Double)dataGridView1.Rows[i].Cells["Column10"].Value;
// yaokujingshou= (String)dataGridView1.Rows[i].Cells["Column4"].Value;
keshijingshou = (String)dataGridView1.Rows[i].Cells["Column9"].Value;
//yaofangjingshou = null;
// string shou = (string)dataGridView1.Rows[i].Cells["Column11"].Value;
shoujia = (Double)dataGridView1.Rows[i].Cells["Column11"].Value;
yaofangshangzhang = 1;
yaokujingshou = "zhang";
string str = "insert into 出库记录(科室,药号,数量,进价,日期,药库经手,科室经手,药房上账,售价,是否打单) values('" + keshi + "','" + yaohao + "'," + shuliang + "," + jinjia + ",'" + shijian + "','" + yaokujingshou + "','" + keshijingshou + "'," + yaofangshangzhang + "," + shoujia + "," + dadan + ")";
string sql = "update 药库库存 set 本期出库 =本期出库 +" + shuliang + " where 药号='" + yaohao + "'";
/* string sql2 = null;
* if(keshi.Equals("门诊"))
* {
* sql2="update 药房库存 set 门诊领药 ="+shuliang;
* }
* if(keshi.Equals("病房"))
* {
* sql2 = "update 药房库存 set 药房领药 =" + shuliang;
* }
* if(keshi.Equals("门诊"))
* {
* sql2 = "update 药房库存 set 科室领药 =" + shuliang;
* }*/
if (db.change(sql))
{
MessageBox.Show("update success" + sql);
}
// MessageBox.Show(str);
if (db.change(str) == false)
{
return;
}
}
}
dataGridView3.Rows.Clear();
dataGridView1.Rows.Clear();
sumJ = 0;
db.close();
return;
}
}
