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)); }