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