private void PutInventoryprint_Load(object sender, EventArgs e)
{
bm = bb.FindById(id)[0]; //清单
gm = gb.ById(bm.Goods_id)[0]; //物品
wnm = wnb.FindById(bm.Client_id)[0]; //仓库
cm = cb.FindId(bm.Client_id)[0]; //客户
gtm = gtb.FindID(gm.Goods_type_id); //物品类型
mm = mb.FindId(bm.Manager_id)[0]; //管理员
otm = otb.FindById(bm.Operation_type_id)[0];
goods_name_text.Text = gm.Goods_name;
goods_amount_text.Text = bm.Goods_amount.ToString();
goods_code_text.Text = gm.Goods_code;
goods_note_text.Text = gm.Goods_note;
goods_price_text.Text = bm.Goods_price.ToString();
goods_type_text.Text = gtm.Goods_type;
goods_volume_text.Text = gm.Goods_volume;
goods_wight_text.Text = gm.Goods_wight;
warehouse_text.Text = wnm.Warehouse_name;
client_text.Text = cm.Client_name;
specifications_text.Text = gm.Specifications;
type_id_text.Text = otm.Operation_type;
expiration_date_text.Text = bm.Expiration_date;
manufacture_date_text.Text = bm.Manufacture_date;
lot_number_text.Text = bm.Lot_number;
bill_note_text.Text = bm.Bill_note;
operation_name_text.Text = mm.Manager_name;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="bm"></param>
public void Insert(BillMOD bm)
{
sql = "insert into Bill values(@goods_id,@goods_amount,@goods_price,@manufacture_date,@expiration_date,@operation_type_id,@warehouse_id,@lot_number,@client_id,@operation_time,@manager_id,@bill_note)";
SqlParameter[] sp =
{
new SqlParameter("@goods_id", bm.Goods_id),
new SqlParameter("@goods_amount", bm.Goods_amount),
new SqlParameter("@goods_price", bm.Goods_price),
new SqlParameter("@manufacture_date", bm.Manufacture_date),
new SqlParameter("@expiration_date", bm.Expiration_date),
new SqlParameter("@operation_type_id", bm.Operation_type_id),
new SqlParameter("@warehouse_id", bm.Warehouse_id),
new SqlParameter("@lot_number", bm.Lot_number),
new SqlParameter("@client_id", bm.Client_id),
new SqlParameter("@operation_time", bm.Operation_time),
new SqlParameter("@manager_id", bm.Manager_id),
new SqlParameter("@bill_note", bm.Bill_note),
};
DBHelper.ExecuteNonQuery(sql, sp);
}
private List <BillMOD> GetList(string sql, params SqlParameter[] sp) //Dataset赋值给实体类集合
{
ds = DBHelper.GetDataset(sql, sp);
list.Clear();
foreach (DataRow rows in ds.Tables[0].Rows)
{
BillMOD bm = new BillMOD();
bm.Id = Int32.Parse(rows[0].ToString());
bm.Goods_id = Int32.Parse(rows[1].ToString());
bm.Goods_amount = Int32.Parse(rows[2].ToString());
bm.Goods_price = double.Parse(rows[3].ToString());
bm.Manufacture_date = rows[4].ToString();
bm.Expiration_date = rows[5].ToString();
bm.Operation_type_id = Int32.Parse(rows[6].ToString());
bm.Warehouse_id = Int32.Parse(rows[7].ToString());
bm.Lot_number = rows[8].ToString();
bm.Client_id = Int32.Parse(rows[9].ToString());
bm.Operation_time = rows[10].ToString();
bm.Manager_id = Int32.Parse(rows[11].ToString());
bm.Bill_note = rows[12].ToString();
list.Add(bm);
}
return(list);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="bm"></param>
public void Insert(BillMOD bm)
{
bd.Insert(bm);
}
