public bool UpdateKB(KHAM_BENH t)
{
try
{
SqlConnection conn = new SqlConnection(connecDB.connectionStr);
SqlCommand cmd = new SqlCommand("suaKHAM_BENH", 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("@KB_NGAYHENTAIKHAM", SqlDbType.Date);
cmd.Parameters.Add("@KB_TRANGTHAI", SqlDbType.Int);
cmd.Parameters.Add("@KB_KETLUAN", SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@KB_BENHPHU", SqlDbType.NVarChar, 300);
cmd.Parameters.Add("@KB_TRIEUCHUNG", SqlDbType.NVarChar, 300);
cmd.Parameters["@KB_ID"].Value = t.Id_kb;
cmd.Parameters["@KB_NGAYHENTAIKHAM"].Value = t.Ngay_htk;
cmd.Parameters["@KB_TRANGTHAI"].Value = t.Kb_trangthai;
cmd.Parameters["@KB_KETLUAN"].Value = t.Kb_ketluan;
cmd.Parameters["@KB_BENHPHU"].Value = t.Kb_benhphu;
cmd.Parameters["@KB_TRIEUCHUNG"].Value = t.Kb_trieuchung;
conn.Open();
int result = cmd.ExecuteNonQuery();
conn.Close();
return(result > 0);
}
catch
{
return(false);
}
}
public bool InsertKB(KHAM_BENH t)
{
SqlConnection conn = new SqlConnection(connecDB.connectionStr);
SqlCommand cmd = new SqlCommand("themKHAM_BENH", conn);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@mathuoc", SqlDbType.NVarChar, 20);
//cmd.Parameters["@mathuoc"].Value = mt;
cmd.Parameters.Add("@KB_ID", SqlDbType.NVarChar, 15);
cmd.Parameters.Add("@TN_ID", SqlDbType.NVarChar, 15);
cmd.Parameters.Add("@KB_NGAYHENTAIKHAM", SqlDbType.Date);
cmd.Parameters.Add("@KB_NGAY", SqlDbType.Date);
cmd.Parameters.Add("@KB_TRANGTHAI", SqlDbType.Int);
cmd.Parameters.Add("@KB_KETLUAN", SqlDbType.NVarChar, 100);
cmd.Parameters["@KB_ID"].Value = t.Id_kb;
cmd.Parameters["@TN_ID"].Value = t.Id_tn;
cmd.Parameters["@KB_NGAYHENTAIKHAM"].Value = t.Ngay_htk;
cmd.Parameters["@KB_NGAY"].Value = t.Ngay_kb;
cmd.Parameters["@KB_TRANGTHAI"].Value = t.Kb_trangthai;
cmd.Parameters["@KB_KETLUAN"].Value = t.Kb_ketluan;
conn.Open();
int result = cmd.ExecuteNonQuery();
conn.Close();
return(result > 0);
}
