public bool InsertTT(TOA_THUOC t) { try { SqlConnection conn = new SqlConnection(connecDB.connectionStr); SqlCommand cmd = new SqlCommand("themTOA_THUOC", conn); cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add("@mathuoc", SqlDbType.NVarChar, 20); //cmd.Parameters["@mathuoc"].Value = mt; cmd.Parameters.Add("@KB_ID", SqlDbType.NVarChar, 20); cmd.Parameters.Add("@TT_LOIDAN", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@TT_TRANGTHAI", SqlDbType.Int); cmd.Parameters.Add("@TT_NGAY", SqlDbType.DateTime); cmd.Parameters["@KB_ID"].Value = t.Id_kb; cmd.Parameters["@TT_LOIDAN"].Value = t.Tt_loidan; cmd.Parameters["@TT_TRANGTHAI"].Value = t.Tt_trangthai; cmd.Parameters["@TT_NGAY"].Value = t.Tt_ngay; conn.Open(); int result = cmd.ExecuteNonQuery(); conn.Close(); return(result > 0); } catch (SqlException e) { MessageBox.Show(e.ToString()); return(false); } }
public bool InsertTT(TOA_THUOC t) { SqlConnection conn = new SqlConnection(connecDB.connectionStr); SqlCommand cmd = new SqlCommand("themTOA_THUOC", conn); cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add("@mathuoc", SqlDbType.NVarChar, 20); //cmd.Parameters["@mathuoc"].Value = mt; cmd.Parameters.Add("@KB_ID", SqlDbType.NVarChar, 20); cmd.Parameters.Add("@TT_TEN", SqlDbType.NVarChar, 30); cmd.Parameters.Add("@TT_LOIDAN", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@TT_TRANGTHAI", SqlDbType.Int); cmd.Parameters["@KB_ID"].Value = t.Id_kb; cmd.Parameters["@TT_TEN"].Value = t.Tt_ten; cmd.Parameters["@TT_LOIDAN"].Value = t.Tt_loidan; cmd.Parameters["@TT_TRANGTHAI"].Value = t.Tt_trangthai; conn.Open(); int result = cmd.ExecuteNonQuery(); conn.Close(); return(result > 0); }