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="mm"></param>
public void Insert(ManagerMOD mm)
{
sql = "insert into Manager values(@manager_username,@manager_password,@manager_name)";
SqlParameter[] sp =
{
new SqlParameter("@manager_username", mm.Manager_username),
new SqlParameter("@manager_password", mm.Manager_password),
new SqlParameter("@manager_name", mm.Manager_name)
};
DBHelper.ExecuteNonQuery(sql, sp);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="mm"></param>
public int Update(ManagerMOD mm)
{
sql = " UPDATE Manager SET manager_username=@manager_username,manager_password=@manager_password,manager_name=@manager_name where id=@id";
SqlParameter[] sp =
{
new SqlParameter("@id", mm.Id),
new SqlParameter("@manager_name", mm.Manager_name),
new SqlParameter("@manager_password", mm.Manager_password),
new SqlParameter("@manager_username", mm.Manager_username)
};
return(DBHelper.ExecuteNonQuery(sql, sp));
}
/// <summary>
/// 下拉列表选择事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void com_manager_id_SelectionChangeCommitted(object sender, EventArgs e)
{
mb = new ManagerBLL();
list = mb.FindId((int)com_manager_id.SelectedValue);
if (list.Count > 0)
{
mm = list[0];
text_manager_name.Text = mm.Manager_name;
text_manager_passowrd.Text = mm.Manager_password;
text_manager_username.Text = mm.Manager_username;
}
}
/// <summary>
/// 获取List集合
/// </summary>
/// <param name="sql"></param>
/// <param name="sp"></param>
/// <returns></returns>
private List <ManagerMOD> GetList(string sql, params SqlParameter[] sp) //Dataset赋值给实体类集合
{
ds = DBHelper.GetDataset(sql, sp);
list.Clear();
foreach (DataRow rows in ds.Tables[0].Rows)
{
ManagerMOD mm = new ManagerMOD();
mm.Id = Int32.Parse(rows[0].ToString());
mm.Manager_username = rows[1].ToString();
mm.Manager_password = rows[2].ToString();
mm.Manager_name = rows[3].ToString();
list.Add(mm);
}
return(list);
}
/// <summary>
/// 插入数据
/// </summary>
public void Insert(ManagerMOD mm)
{
md.Insert(mm);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="mm"></param>
public int Update(ManagerMOD mm)
{
return(md.Update(mm));
}
