public bool baocaotonghop_xoa(DOT_baocaotonghop bc) { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("sp_delete_baocaotonghop", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@mabcth", bc.mabcth)); cmd.ExecuteNonQuery(); } return(true); }
public int baocaotonghop_them(DOT_baocaotonghop bc) { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("sp_insert_baocaotonghop", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@matv", bc.matv)); cmd.Parameters.Add(new SqlParameter("@mada", bc.mada)); cmd.Parameters.Add(new SqlParameter("@tondong", bc.tondong)); cmd.Parameters.Add(new SqlParameter("@ngayht", bc.ngayht)); cmd.Parameters.Add(new SqlParameter("@dexuat", bc.dexuat)); return(Convert.ToInt32(cmd.ExecuteScalar())); } }
public bool baocaotonghop_sua(DOT_baocaotonghop bc) { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("sp_update_baocaotonghop", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@mabcth", bc.mabcth)); cmd.Parameters.Add(new SqlParameter("@matv", bc.matv)); cmd.Parameters.Add(new SqlParameter("@mada", bc.mada)); cmd.Parameters.Add(new SqlParameter("@tondong", bc.tondong)); cmd.Parameters.Add(new SqlParameter("@ngayht", bc.ngayht)); cmd.Parameters.Add(new SqlParameter("@dexuat", bc.dexuat)); cmd.ExecuteNonQuery(); } return(true); }