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;
}
public List <GoodsMOD> FindAllCondition(GoodsMOD gm)
{
sql = "select * from Goods where goods_name=@goods_name and goods_type_id=@goods_type_id and goods_code=@goods_code and specifications=@specifications and goods_wight=@goods_wight and goods_volume=@goods_volume and goods_note=@goods_note";
SqlParameter[] sp =
{
new SqlParameter("@goods_name", gm.Goods_name),
new SqlParameter("@goods_type_id", gm.Goods_type_id),
new SqlParameter("@goods_code", gm.Goods_code),
new SqlParameter("@specifications", gm.Specifications),
new SqlParameter("@goods_wight", gm.Goods_wight),
new SqlParameter("@goods_volume", gm.Goods_volume),
new SqlParameter("@goods_note", gm.Goods_note),
};
return(GetList(sql, sp));
}
/// <summary>
/// 插入
/// </summary>
/// <param name="gm"></param>
public void Insert(GoodsMOD gm)
{
sql = "insert into Goods values(@goods_name,@goods_type_id,@goods_code,@specifications,@goods_wight,@goods_volume,@goods_note)";
SqlParameter[] sp =
{
new SqlParameter("@goods_name", gm.Goods_name),
new SqlParameter("@goods_type_id", gm.Goods_type_id),
new SqlParameter("@goods_code", gm.Goods_code),
new SqlParameter("@specifications", gm.Specifications),
new SqlParameter("@goods_wight", gm.Goods_wight),
new SqlParameter("@goods_volume", gm.Goods_volume),
new SqlParameter("@goods_note", gm.Goods_note),
};
DBHelper.ExecuteNonQuery(sql, sp);
}
private List <GoodsMOD> GetList(string sql, params SqlParameter[] sp) //Dataset赋值给实体类集合
{
ds = DBHelper.GetDataset(sql, sp);
list.Clear();
foreach (DataRow rows in ds.Tables[0].Rows)
{
GoodsMOD gm = new GoodsMOD();
gm.Id = Int32.Parse(rows[0].ToString());
gm.Goods_name = rows[1].ToString();
gm.Goods_type_id = Int32.Parse(rows[2].ToString());
gm.Goods_code = rows[3].ToString();
gm.Specifications = rows[4].ToString();
gm.Goods_wight = rows[5].ToString();
gm.Goods_volume = rows[6].ToString();
gm.Goods_note = rows[7].ToString();
list.Add(gm);
}
return(list);
}
public int GetId(GoodsMOD gm)
{
sql = "select * from Goods where goods_name=@goods_name and goods_type_id=@goods_type_id and goods_code=@goods_code and specifications=@specifications and goods_wight=@goods_wight and goods_volume=@goods_volume and goods_note=@goods_note";
SqlParameter[] sp =
{
new SqlParameter("@goods_name", gm.Goods_name),
new SqlParameter("@goods_type_id", gm.Goods_type_id),
new SqlParameter("@goods_code", gm.Goods_code),
new SqlParameter("@specifications", gm.Specifications),
new SqlParameter("@goods_wight", gm.Goods_wight),
new SqlParameter("@goods_volume", gm.Goods_volume),
new SqlParameter("@goods_note", gm.Goods_note),
};
list = GetList(sql, sp);
if (list.Count > 0)
{
return(list[0].Id);
}
return(-1);
}
private void SetGoodsinfo() //自动填入物品信息输入框的值
{
if (comb_goods_name.Text != "" && isgive)
{
listgm = gb.ById(Int32.Parse(comb_goods_name.SelectedValue.ToString()));
if (listgm.Count > 0)
{
gm = listgm[0];
gtm = gtb.FindID(gm.Goods_type_id);
if (tree_label.Text == "双击打开下一层")
{
tree_label.Text = gtm.Goods_type;
goods_type_id = gtm.Id;
}
text_goods_code.Text = gm.Goods_code;
text_specifications.Text = gm.Specifications;
text_goods_volume.Text = gm.Goods_volume;
text_goods_wight.Text = gm.Goods_wight;
text_goods_note.Text = gm.Goods_note;
isgive = false;
}
}
}
public List <GoodsMOD> FindAllCondition(GoodsMOD gm)
{
return(gd.FindAllCondition(gm));
}
public int Insert(GoodsMOD gm)
{
gd.Insert(gm);
return(gd.GetId(gm));
}
