private void btn_warehousing_Click(object sender, EventArgs e)
{
GoodHistory_Vo vo = new GoodHistory_Vo();
vo.Barcode_No = txt_PaletteNum.Text;
vo.Workorderno = txt_WorkNum.Text;
GoodHistory_Service service = new GoodHistory_Service();
service.UpdateGoodsHistory(vo);
SetGood();
}
public List <GoodHistory_Vo> UpdateGoodsHistory(GoodHistory_Vo item)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "UpdateGoodsHistory";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Barcode_No", item.Barcode_No);
cmd.Parameters.AddWithValue("@Workorderno", item.Workorderno);
cmd.Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
List <GoodHistory_Vo> list = Helper.DataReaderMapToList <GoodHistory_Vo>(reader);
cmd.Connection.Close();
return(list);
}
}
public List <GoodHistory_Vo> UpdateGoodsHistory(GoodHistory_Vo item)
{
GoodHistory_Dac dac = new GoodHistory_Dac();
return(dac.UpdateGoodsHistory(item));
}
