public bool InsertItemIfno(ItemVo item) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = new SqlConnection(ConnectionString); cmd.CommandText = "InsertItemInfo"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.AddWithValue("@Item_Code", item.Item_Code); cmd.Parameters.AddWithValue("@Item_Name", item.Item_Name); cmd.Parameters.AddWithValue("@Item_Name_Eng", item.Item_Name_Eng); cmd.Parameters.AddWithValue("@Item_Name_Eng_Alias", item.Item_Name_Eng_Alias); cmd.Parameters.AddWithValue("@Item_Type", item.Item_Type); cmd.Parameters.AddWithValue("@Item_Spec", item.Item_Spec); cmd.Parameters.AddWithValue("@Item_Unit", item.Item_Unit); // cmd.Parameters.AddWithValue("@Item_Stock", item.Item_Stock); cmd.Parameters.AddWithValue("@RollingUPH", item.RollingUPH); cmd.Parameters.AddWithValue("@SteelUPH", item.SteelUPH); cmd.Parameters.AddWithValue("@IronUPH", item.IronUPH); cmd.Parameters.AddWithValue("@PackageUPH", item.PackageUPH); cmd.Parameters.AddWithValue("@Remark", item.Remark); int Checked = cmd.ExecuteNonQuery(); cmd.Connection.Close(); if (Checked == 0) { return(false); } return(true); } }
public bool InsertItemInfo(ItemVo vo) { ItemDAC dac = new ItemDAC(); return(dac.InsertItemIfno(vo)); }